Spreadsheet Accounting Formulas

spreadsheet_account
REPOSITORY
REPOSITORYodoo/odoo
GIT
GIThttps://github.com/odoo/odoo.git
GIT FOLDER
GIT FOLDERhttps://github.com/odoo/odoo/tree/19.0/spreadsheet_account
VERSION
VERSION 1.0
CATEGORY
CATEGORYAccounting
LICENSE
LICENSELGPL-3
APPLICATION
APPLICATIONNo
AUTO-INSTALLABLE
AUTO-INSTALLABLEYes
AUTHORS
AUTHORSOdoo S.A.
MAINTAINERS
MAINTAINERSOdoo S.A.
COMMITTERS
COMMITTERSOdoo Translation Bot, Julien Castiaux, Julien Mougenot, Tiffany Chang (tic), Pierre Rousseau, Gorash, Mathieu Duckerts-Antoine, Louis Wicket (wil), Antoine Boonen, Dylan Kiss (dyki), hupo-odoo, rmbh-odoo, Lucas Lefèvre (lul), Rémi Rahir (rar), Krzysztof Magusiak (krma), dhrp-odoo, ELCO
WEBSITE
WEBSITE
LAST TRACKING UPDATE
LAST TRACKING UPDATE2026-07-06 01:51:47
ODOO DEPENDENCIES
ODOO DEPENDENCIES odoo/odoo:
    - spreadsheet
    - bus
    - base
    - web
    - portal
    - html_editor
    - http_routing
    - mail
    - base_setup
    - web_tour
    - auth_signup
    - account
    - onboarding
    - product
    - uom
    - analytic
    - digest
    - resource
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES Not have
DESCRIPTION
DESCRIPTION
Spreadsheet Accounting formulas

Code Analysis

Views touched (0)

No views found for this module.

Models touched (2)

New fields (0)

No new fields.

Public methods (6)
  • get_account_group(self, account_types)
    @api.model
  • spreadsheet_fetch_balance_tag(self, args_list)
    @api.model
    Fetch data for ODOO.BALANCE.TAG formulas The input list looks like this:: [{ account_tag_ids: str[] date_range: { range_type: "year" year: int }, company_id: int include_unposted: bool }]
  • spreadsheet_fetch_debit_credit(self, args_list)
    @api.readonly@api.model
    Fetch data for ODOO.CREDIT, ODOO.DEBIT and ODOO.BALANCE formulas The input list looks like this:: [{ date_range: { range_type: "year" year: int }, company_id: int codes: str[] include_unposted: bool }]
  • spreadsheet_fetch_partner_balance(self, args_list)
    @api.model
    Fetch data for ODOO.PARTNER.BALANCE formulas The input list looks like this:: [{ date_range: { range_type: "year" year: int }, company_id: int codes: str[] include_unposted: bool partner_ids: int[] }]
  • spreadsheet_fetch_residual_amount(self, args_list)
    @api.readonly@api.model
    Fetch data for ODOO.RESUDUAL formulas The input list looks like this:: [{ date_range: { range_type: "year" year: int }, company_id: int codes: str[] include_unposted: bool }]
  • spreadsheet_move_line_action(self, args)
    @api.readonly@api.model

New fields (0)

No new fields.

Public methods (1)
  • get_fiscal_dates(self, payload)
    @api.readonly@api.model
REPOSITORY
REPOSITORYodoo/odoo
GIT
GIThttps://github.com/odoo/odoo.git
GIT FOLDER
GIT FOLDERhttps://github.com/odoo/odoo/tree/18.0/spreadsheet_account
VERSION
VERSION 1.0
CATEGORY
CATEGORYAccounting
LICENSE
LICENSELGPL-3
APPLICATION
APPLICATIONNo
AUTO-INSTALLABLE
AUTO-INSTALLABLEYes
AUTHORS
AUTHORS
MAINTAINERS
MAINTAINERS
COMMITTERS
COMMITTERSOdoo Translation Bot, Odoo Online, Julien Mougenot, Tiffany Chang (tic), Rémy Voet (ryv), Pierre Rousseau, Gorash, william-andre, Gauthier Wala (gawa), Antoine Dupuis (andu), Antoine Boonen, Dylan Kiss (dyki), Adrien Minne (adrm), Louis (wil), rmbh-odoo, Lucas Lefèvre (lul), Rémi Rahir (rar), uso-odoo, dhrp-odoo
WEBSITE
WEBSITE
LAST TRACKING UPDATE
LAST TRACKING UPDATE2026-07-06 01:26:00
ODOO DEPENDENCIES
ODOO DEPENDENCIES odoo/odoo:
    - spreadsheet
    - bus
    - base
    - web
    - portal
    - web_editor
    - html_editor
    - http_routing
    - mail
    - base_setup
    - web_tour
    - auth_signup
    - account
    - onboarding
    - product
    - uom
    - analytic
    - digest
    - resource
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES Not have
DESCRIPTION
DESCRIPTION
Spreadsheet Accounting formulas

Code Analysis

Views touched (0)

No views found for this module.

Models touched (2)

New fields (0)

No new fields.

Public methods (5)
  • get_account_group(self, account_types)
    @api.model
  • spreadsheet_fetch_debit_credit(self, args_list)
    @api.model
    Fetch data for ODOO.CREDIT, ODOO.DEBIT and ODOO.BALANCE formulas The input list looks like this: [{ date_range: { range_type: "year" year: int }, company_id: int codes: str[] include_unposted: bool }]
  • spreadsheet_fetch_partner_balance(self, args_list)
    @api.model
    Fetch data for ODOO.PARTNER.BALANCE formulas The input list looks like this: [{ date_range: { range_type: "year" year: int }, company_id: int codes: str[] include_unposted: bool partner_ids: int[] }]
  • spreadsheet_fetch_residual_amount(self, args_list)
    @api.model
    Fetch data for ODOO.RESUDUAL formulas The input list looks like this: [{ date_range: { range_type: "year" year: int }, company_id: int codes: str[] include_unposted: bool }]
  • spreadsheet_move_line_action(self, args)
    @api.model

New fields (0)

No new fields.

Public methods (1)
  • get_fiscal_dates(self, payload)
    @api.model
REPOSITORY
REPOSITORYodoo/odoo
GIT
GIThttps://github.com/odoo/odoo.git
GIT FOLDER
GIT FOLDERhttps://github.com/odoo/odoo/tree/17.0/spreadsheet_account
VERSION
VERSION 1.0
CATEGORY
CATEGORYAccounting
LICENSE
LICENSELGPL-3
APPLICATION
APPLICATIONNo
AUTO-INSTALLABLE
AUTO-INSTALLABLEYes
AUTHORS
AUTHORS
MAINTAINERS
MAINTAINERS
COMMITTERS
COMMITTERSRaphael Collet, Odoo Translation Bot, Martin Trigaux, qdp-odoo, Odoo Online, Laurent Smet, Jorge Pinna Puissant, Rémi Rahir, Lucas Lefèvre, Tiffany Chang (tic), Rémy Voet (ryv), niyasraphy, Dylan Kiss (dyki), Benjamin Hanquin (beha), Adrien Minne (adrm), Louis (wil), rmbh-odoo, Lucas Lefèvre (lul), Rémi Rahir (rar), Pierre Pulinckx (pipu), uso-odoo, Rmi Rahir (rar), dhrp-odoo
WEBSITE
WEBSITE
LAST TRACKING UPDATE
LAST TRACKING UPDATE2026-07-06 01:02:11
ODOO DEPENDENCIES
ODOO DEPENDENCIES odoo/odoo:
    - spreadsheet
    - bus
    - base
    - web
    - portal
    - web_editor
    - http_routing
    - mail
    - base_setup
    - web_tour
    - auth_signup
    - account
    - onboarding
    - product
    - uom
    - analytic
    - digest
    - resource
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES Not have
DESCRIPTION
DESCRIPTION
Spreadsheet Accounting formulas

Code Analysis

Views touched (0)

No views found for this module.

Models touched (2)

New fields (0)

No new fields.

Public methods (3)
  • get_account_group(self, account_types)
    @api.model
  • spreadsheet_fetch_debit_credit(self, args_list)
    @api.model
    Fetch data for ODOO.CREDIT, ODOO.DEBIT and ODOO.BALANCE formulas The input list looks like this: [{ date_range: { range_type: "year" year: int }, company_id: int codes: str[] include_unposted: bool }]
  • spreadsheet_move_line_action(self, args)
    @api.model

New fields (0)

No new fields.

Public methods (1)
  • get_fiscal_dates(self, payload)
    @api.model
REPOSITORY
REPOSITORYodoo/odoo
GIT
GIThttps://github.com/odoo/odoo.git
GIT FOLDER
GIT FOLDERhttps://github.com/odoo/odoo/tree/16.0/spreadsheet_account
VERSION
VERSION 1.0
CATEGORY
CATEGORYAccounting
LICENSE
LICENSELGPL-3
APPLICATION
APPLICATIONNo
AUTO-INSTALLABLE
AUTO-INSTALLABLEYes
AUTHORS
AUTHORS
MAINTAINERS
MAINTAINERS
COMMITTERS
COMMITTERSOdoo Translation Bot, Martin Trigaux, qdp-odoo, Laurent Smet, Lucas Lefèvre, Benjamin Hanquin (beha), Adrien Minne (adrm), Martin Trigaux (mat), Lucas Lefèvre (lul), Rémi Rahir (rar), uso-odoo
WEBSITE
WEBSITE
LAST TRACKING UPDATE
LAST TRACKING UPDATE2026-07-06 00:40:55
ODOO DEPENDENCIES
ODOO DEPENDENCIES odoo/odoo:
    - spreadsheet
    - bus
    - base
    - web
    - account
    - base_setup
    - product
    - mail
    - web_tour
    - uom
    - analytic
    - portal
    - web_editor
    - http_routing
    - auth_signup
    - digest
    - resource
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES Not have
DESCRIPTION
DESCRIPTION
Spreadsheet Accounting formulas

Code Analysis

Views touched (0)

No views found for this module.

Models touched (2)

New fields (0)

No new fields.

Public methods (3)
  • get_account_group(self, account_types)
    @api.model
  • spreadsheet_fetch_debit_credit(self, args_list)
    @api.model
    Fetch data for ODOO.CREDIT, ODOO.DEBIT and ODOO.BALANCE formulas The input list looks like this: [{ date_range: { range_type: "year" year: int }, company_id: int codes: str[] include_unposted: bool }]
  • spreadsheet_move_line_action(self, args)
    @api.model

New fields (0)

No new fields.

Public methods (1)
  • get_fiscal_dates(self, payload)
    @api.model