Bank Statement TXT/CSV Import (Base)

account_statement_import_sheet_file
REPOSITORY
REPOSITORYOCA/bank-statement-import
GIT
GIThttps://github.com/OCA/bank-statement-import.git
GIT FOLDER
GIT FOLDERhttps://github.com/OCA/bank-statement-import/tree/19.0/account_statement_import_sheet_file
VERSION
VERSION 2.0.1
CATEGORY
CATEGORYAccounting
LICENSE
LICENSEAGPL-3
APPLICATION
APPLICATIONNo
AUTO-INSTALLABLE
AUTO-INSTALLABLENo
AUTHORS
AUTHORSOdoo Community Association (OCA), ForgeFlow, CorporateHub
MAINTAINERS
MAINTAINERSOdoo Community Association (OCA), ForgeFlow, CorporateHub
COMMITTERS
COMMITTERSVíctor Martínez, OCA-git-bot, oca-ci, Andrii9090-tecnativa, roger
WEBSITE
WEBSITEhttps://github.com/OCA/bank-statement-import
LAST TRACKING UPDATE
LAST TRACKING UPDATE2026-07-06 19:40:49
ODOO DEPENDENCIES
ODOO DEPENDENCIES OCA/account-reconcile:
    - account_statement_base
OCA/bank-statement-import:
    - account_statement_import_file
    - account_statement_import_base
odoo/odoo:
    - account
    - base_setup
    - base
    - web
    - onboarding
    - product
    - mail
    - bus
    - web_tour
    - html_editor
    - uom
    - analytic
    - portal
    - http_routing
    - auth_signup
    - digest
    - resource
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES Not have
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES Not have
DESCRIPTION
DESCRIPTION
This module is the base for a system for importing sheet-like files, 
and includes the direct support for TXT/CSV. 
Other formats like XLS, XLSX will be added by additional modules.

Code Analysis

Views touched (4)
XML IDNameModelTypeStatus
account_statement_import_form account.statement.import account.statement.import xpath Inherits account_statement_import_file.account_statement_import_form
account_statement_import_sheet_mapping_form account.statement.import.sheet.mapping.form account.statement.import.sheet.mapping list New
account_statement_import_sheet_mapping_tree account.statement.import.sheet.mapping.tree account.statement.import.sheet.mapping form New
view_account_journal_form_n43 account.journal xpath Inherits account.view_account_journal_form
Models touched (4)

New fields (1)
  • default_sheet_mapping_id Many2one → account.statement.import.sheet.mapping
    comodel_name='account.statement.import.sheet.mapping'
Public methods (0)

No public methods.

New fields (1)
  • sheet_mapping_id Many2one → account.statement.import.sheet.mapping
    comodel_name='account.statement.import.sheet.mapping' default=<expr> string='Sheet mapping'
Public methods (0)

No public methods.

New fields (33)
  • amount_column Char
    help="Amount of transaction in journal's currency"
  • amount_column Char
    help='Used if amount type is "Simple value" or "Absolute value"\nAmount of transaction in journal\'s currency\nSome statement formats use credit/debit columns' string='Amount column'
  • amount_credit_column Char
    help="Credit amount of transaction in journal's currency" string='Credit amount column'
  • amount_debit_column Char
    help="Debit amount of transaction in journal's currency" string='Debit amount column'
  • amount_inverse_sign Boolean
    help='In some cases such as in credit card statements the amounts are expressed in the inverse sign. By setting this flag during the upload the amounts will be inverted in sign.' string='Inverse sign of amount'
  • amount_type Selection
    default='simple_value' help='Simple value: use igned amount in amount column\nAbsolute Value: use a same column for debit and credit\n(absolute value + indicate sign)\nDistinct Credit/debit Column: use a distinct column for debit and credit' required=True selection=[('simple_value', 'Simple value'), ('absolute_value', 'Absolute value'), ('distinct_credit_debit', 'Distinct Credit/debit Column')] string='Amount type'
  • balance_column Char
    help="Balance after transaction in journal's currency"
  • bank_account_column Char
    help="Partner's bank account"
  • bank_name_column Char
    help="Partner's bank"
  • credit_value Char
    default='C' help="Value of debit/credit column that indicates if it's a credit"
  • currency_column Char
    help='In case statement is multi-currency, column to get currency of transaction from'
  • debit_credit_column Char
    help='Used if amount type is "Absolute value"\nSome statement formats use absolute amount value and indicate sign\nof the transaction by specifying if it was a debit or a credit one' string='Debit/credit column'
  • debit_value Char
    default='D' help="Value of debit/credit column that indicates if it's a debit"
  • delimiter Selection
    default='comma' selection=[('dot', 'dot (.)'), ('comma', 'comma (,)'), ('semicolon', 'semicolon (;)'), ('tab', 'tab'), ('space', 'space'), ('n/a', 'N/A')]
  • description_column Char
  • file_encoding Selection
    default='utf-8' selection=[('utf-8', 'UTF-8'), ('utf-8-sig', 'UTF-8 (with BOM)'), ('utf-16', 'UTF-16'), ('utf-16-sig', 'UTF-16 (with BOM)'), ('windows-1252', 'Western (Windows-1252)'), ('iso-8859-1', 'Western (Latin-1 / ISO 8859-1)'), ('iso-8859-2', 'Central European (Latin-2 / ISO 8859-2)'), ('iso-8859-4', 'Baltic (Latin-4 / ISO 8859-4)'), ('big5', 'Traditional Chinese (big5)'), ('gb18030', 'Unified Chinese (gb18030)'), ('shift_jis', 'Japanese (Shift JIS)'), ('windows-1251', 'Cyrillic (Windows-1251)'), ('koi8_r', 'Cyrillic (KOI8-R)'), ('koi8_u', 'Cyrillic (KOI8-U)')] string='Encoding'
  • float_decimal_sep Selection
    default='comma' help="When the separator is 'none', the value will be shifted according to the currency decimals. For example, 12345 will be converted to 123.45" selection=[('dot', 'dot (.)'), ('comma', 'comma (,)'), ('none', 'none')] string='Decimals Separator'
  • float_thousands_sep Selection
    default='dot' selection=[('dot', 'dot (.)'), ('comma', 'comma (,)'), ('quote', "quote (')"), ('none', 'none')] string='Thousands Separator'
  • footer_lines_skip_count Integer
    default='0' help='Set the Footer lines number.Used in some csv/xlsx file that integrate meta data inlast lines.' string='Footer lines skip count'
  • header_lines_skip_count Integer
    default='0' help='Set the Header lines number.' string='Header lines skip count'
  • name Char
    required=True
  • no_header Boolean
    help='When this occurs please indicate the column number in the Columns section instead of the column name, considering that the first column is 0' string='File does not contain header line'
  • notes_column Char
  • offset_column Integer
    default=0 help='Columns to ignore before starting to parse'
  • original_amount_column Char
    help='In case statement provides original currency for transactions with automatic currency conversion, column to get original transaction amount in original transaction currency from'
  • original_currency_column Char
    help='In case statement provides original currency for transactions with automatic currency conversion, column to get original currency of transaction from'
  • partner_name_column Char
  • quotechar Char
    default='"' size=1 string='Text qualifier'
  • reference_column Char
  • skip_empty_lines Boolean
    default=True help='Allows to skip empty lines'
  • timestamp_column Char
    required=True
  • timestamp_format Char
    required=True
  • transaction_id_column Char
    string='Unique transaction ID column'
Public methods (2)
  • onchange_decimal_separator(self)
    @api.onchange('float_decimal_sep')
  • onchange_thousands_separator(self)
    @api.onchange('float_thousands_sep')

New fields (0)

No new fields.

Public methods (2)
  • parse(self, data_file, mapping, filename)
    @api.model
    Parse an uploaded sheet file into account statement import data. :param bytes data_file: Uploaded file content. :param recordset mapping: Sheet mapping used to read columns and formats. :param str filename: Original upload filename :return: Tuple with currency code, account number, and statement values. :rtype: tuple(str, str, list[dict])
  • parse_header_csv(self, rows, mapping)
    @api.model
    Return the CSV header row after applying configured skips and offset.
REPOSITORY
REPOSITORYOCA/bank-statement-import
GIT
GIThttps://github.com/OCA/bank-statement-import.git
GIT FOLDER
GIT FOLDERhttps://github.com/OCA/bank-statement-import/tree/18.0/account_statement_import_sheet_file
VERSION
VERSION 1.1.1
CATEGORY
CATEGORYAccounting
LICENSE
LICENSEAGPL-3
APPLICATION
APPLICATIONNo
AUTO-INSTALLABLE
AUTO-INSTALLABLENo
AUTHORS
AUTHORSOdoo Community Association (OCA), ForgeFlow, CorporateHub
MAINTAINERS
MAINTAINERSOdoo Community Association (OCA), ForgeFlow, CorporateHub
COMMITTERS
COMMITTERSPedro M. Baeza, Jacques-Etienne Baudoux, Víctor Martínez, Weblate, OCA-git-bot, oca-ci
WEBSITE
WEBSITEhttps://github.com/OCA/bank-statement-import
LAST TRACKING UPDATE
LAST TRACKING UPDATE2026-07-06 19:30:14
ODOO DEPENDENCIES
ODOO DEPENDENCIES OCA/account-reconcile:
    - account_statement_base
OCA/bank-statement-import:
    - account_statement_import_file
    - account_statement_import_base
odoo/odoo:
    - account
    - base_setup
    - base
    - web
    - onboarding
    - product
    - mail
    - bus
    - web_tour
    - html_editor
    - 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
This module allows you to import any TXT/CSV or XLSX file in Odoo as
bank statements.

Code Analysis

Views touched (4)
XML IDNameModelTypeStatus
account_statement_import_form account.statement.import account.statement.import xpath Inherits account_statement_import_file.account_statement_import_form
account_statement_import_sheet_mapping_form account.statement.import.sheet.mapping.form account.statement.import.sheet.mapping list New
account_statement_import_sheet_mapping_tree account.statement.import.sheet.mapping.tree account.statement.import.sheet.mapping form New
view_account_journal_form_n43 account.journal xpath Inherits account.view_account_journal_form
Models touched (4)

New fields (1)
  • default_sheet_mapping_id Many2one → account.statement.import.sheet.mapping
    comodel_name='account.statement.import.sheet.mapping'
Public methods (0)

No public methods.

New fields (1)
  • sheet_mapping_id Many2one → account.statement.import.sheet.mapping
    comodel_name='account.statement.import.sheet.mapping' default=_get_default_mapping_id string='Sheet mapping'
Public methods (0)

No public methods.

New fields (33)
  • amount_column Char
    help="Amount of transaction in journal's currency"
  • amount_column Char
    help='Used if amount type is "Simple value" or "Absolute value"\nAmount of transaction in journal\'s currency\nSome statement formats use credit/debit columns' string='Amount column'
  • amount_credit_column Char
    help="Credit amount of transaction in journal's currency" string='Credit amount column'
  • amount_debit_column Char
    help="Debit amount of transaction in journal's currency" string='Debit amount column'
  • amount_inverse_sign Boolean
    help='In some cases such as in credit card statements the amounts are expressed in the inverse sign. By setting this flag during the upload the amounts will be inverted in sign.' string='Inverse sign of amount'
  • amount_type Selection
    default='simple_value' help='Simple value: use igned amount in amount column\nAbsolute Value: use a same column for debit and credit\n(absolute value + indicate sign)\nDistinct Credit/debit Column: use a distinct column for debit and credit' required=True selection=[('simple_value', 'Simple value'), ('absolute_value', 'Absolute value'), ('distinct_credit_debit', 'Distinct Credit/debit Column')] string='Amount type'
  • balance_column Char
    help="Balance after transaction in journal's currency"
  • bank_account_column Char
    help="Partner's bank account"
  • bank_name_column Char
    help="Partner's bank"
  • credit_value Char
    default='C' help="Value of debit/credit column that indicates if it's a credit"
  • currency_column Char
    help='In case statement is multi-currency, column to get currency of transaction from'
  • debit_credit_column Char
    help='Used if amount type is "Absolute value"\nSome statement formats use absolute amount value and indicate sign\nof the transaction by specifying if it was a debit or a credit one' string='Debit/credit column'
  • debit_value Char
    default='D' help="Value of debit/credit column that indicates if it's a debit"
  • delimiter Selection
    default='comma' selection=[('dot', 'dot (.)'), ('comma', 'comma (,)'), ('semicolon', 'semicolon (;)'), ('tab', 'tab'), ('space', 'space'), ('n/a', 'N/A')]
  • description_column Char
  • file_encoding Selection
    default='utf-8' selection=[('utf-8', 'UTF-8'), ('utf-8-sig', 'UTF-8 (with BOM)'), ('utf-16', 'UTF-16'), ('utf-16-sig', 'UTF-16 (with BOM)'), ('windows-1252', 'Western (Windows-1252)'), ('iso-8859-1', 'Western (Latin-1 / ISO 8859-1)'), ('iso-8859-2', 'Central European (Latin-2 / ISO 8859-2)'), ('iso-8859-4', 'Baltic (Latin-4 / ISO 8859-4)'), ('big5', 'Traditional Chinese (big5)'), ('gb18030', 'Unified Chinese (gb18030)'), ('shift_jis', 'Japanese (Shift JIS)'), ('windows-1251', 'Cyrillic (Windows-1251)'), ('koi8_r', 'Cyrillic (KOI8-R)'), ('koi8_u', 'Cyrillic (KOI8-U)')] string='Encoding'
  • float_decimal_sep Selection
    default='comma' help="When the separator is 'none', the value will be shifted according to the currency decimals. For example, 12345 will be converted to 123.45" selection=[('dot', 'dot (.)'), ('comma', 'comma (,)'), ('none', 'none')] string='Decimals Separator'
  • float_thousands_sep Selection
    default='dot' selection=[('dot', 'dot (.)'), ('comma', 'comma (,)'), ('quote', "quote (')"), ('none', 'none')] string='Thousands Separator'
  • footer_lines_skip_count Integer
    default='0' help='Set the Footer lines number.Used in some csv/xlsx file that integrate meta data inlast lines.' string='Footer lines skip count'
  • header_lines_skip_count Integer
    default='0' help='Set the Header lines number.' string='Header lines skip count'
  • name Char
    required=True
  • no_header Boolean
    help='When this occurs please indicate the column number in the Columns section instead of the column name, considering that the first column is 0' string='File does not contain header line'
  • notes_column Char
  • offset_column Integer
    default=0 help='Columns to ignore before starting to parse'
  • original_amount_column Char
    help='In case statement provides original currency for transactions with automatic currency conversion, column to get original transaction amount in original transaction currency from'
  • original_currency_column Char
    help='In case statement provides original currency for transactions with automatic currency conversion, column to get original currency of transaction from'
  • partner_name_column Char
  • quotechar Char
    default='"' size=1 string='Text qualifier'
  • reference_column Char
  • skip_empty_lines Boolean
    default=True help='Allows to skip empty lines'
  • timestamp_column Char
    required=True
  • timestamp_format Char
    required=True
  • transaction_id_column Char
    string='Unique transaction ID column'
Public methods (2)
  • onchange_decimal_separator(self)
    @api.onchange('float_decimal_sep')
  • onchange_thousands_separator(self)
    @api.onchange('float_thousands_sep')

New fields (0)

No new fields.

Public methods (2)
  • parse(self, data_file, mapping, filename)
    @api.model
  • parse_header(self, csv_or_xlsx, mapping)
    @api.model
REPOSITORY
REPOSITORYOCA/bank-statement-import
GIT
GIThttps://github.com/OCA/bank-statement-import.git
GIT FOLDER
GIT FOLDERhttps://github.com/OCA/bank-statement-import/tree/17.0/account_statement_import_sheet_file
VERSION
VERSION 1.2.0
CATEGORY
CATEGORYAccounting
LICENSE
LICENSEAGPL-3
APPLICATION
APPLICATIONNo
AUTO-INSTALLABLE
AUTO-INSTALLABLENo
AUTHORS
AUTHORSOdoo Community Association (OCA), ForgeFlow, CorporateHub
MAINTAINERS
MAINTAINERSOdoo Community Association (OCA), ForgeFlow, CorporateHub
COMMITTERS
COMMITTERSPedro M. Baeza, Víctor Martínez, Weblate, OCA-git-bot, oca-ci, Rocío Vega, Alessio Renda
WEBSITE
WEBSITEhttps://github.com/OCA/bank-statement-import
LAST TRACKING UPDATE
LAST TRACKING UPDATE2026-07-06 19:20:07
ODOO DEPENDENCIES
ODOO DEPENDENCIES OCA/account-reconcile:
    - account_statement_base
OCA/bank-statement-import:
    - account_statement_import_file
    - account_statement_import_base
odoo/odoo:
    - account
    - base_setup
    - base
    - web
    - onboarding
    - product
    - mail
    - bus
    - web_tour
    - uom
    - analytic
    - portal
    - web_editor
    - http_routing
    - auth_signup
    - digest
    - resource
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES chardet
xlrd
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES Not have
DESCRIPTION
DESCRIPTION
This module allows you to import any TXT/CSV or XLSX file in Odoo as
bank statements.

Code Analysis

Views touched (4)
XML IDNameModelTypeStatus
account_statement_import_form account.statement.import account.statement.import xpath Inherits account_statement_import_file.account_statement_import_form
account_statement_import_sheet_mapping_form account.statement.import.sheet.mapping.form account.statement.import.sheet.mapping tree New
account_statement_import_sheet_mapping_tree account.statement.import.sheet.mapping.tree account.statement.import.sheet.mapping form New
view_account_journal_form_n43 account.journal xpath Inherits account.view_account_journal_form
Models touched (4)

New fields (1)
  • default_sheet_mapping_id Many2one → account.statement.import.sheet.mapping
    comodel_name='account.statement.import.sheet.mapping'
Public methods (0)

No public methods.

New fields (1)
  • sheet_mapping_id Many2one → account.statement.import.sheet.mapping
    comodel_name='account.statement.import.sheet.mapping' default=_get_default_mapping_id string='Sheet mapping'
Public methods (0)

No public methods.

New fields (33)
  • amount_column Char
    help="Amount of transaction in journal's currency"
  • amount_column Char
    help='Used if amount type is "Simple value" or "Absolute value"\nAmount of transaction in journal\'s currency\nSome statement formats use credit/debit columns' string='Amount column'
  • amount_credit_column Char
    help="Credit amount of transaction in journal's currency" string='Credit amount column'
  • amount_debit_column Char
    help="Debit amount of transaction in journal's currency" string='Debit amount column'
  • amount_inverse_sign Boolean
    help='In some cases such as in credit card statements the amounts are expressed in the inverse sign. By setting this flag during the upload the amounts will be inverted in sign.' string='Inverse sign of amount'
  • amount_type Selection
    default='simple_value' help='Simple value: use igned amount in amount column\nAbsolute Value: use a same column for debit and credit\n(absolute value + indicate sign)\nDistinct Credit/debit Column: use a distinct column for debit and credit' required=True selection=[('simple_value', 'Simple value'), ('absolute_value', 'Absolute value'), ('distinct_credit_debit', 'Distinct Credit/debit Column')] string='Amount type'
  • balance_column Char
    help="Balance after transaction in journal's currency"
  • bank_account_column Char
    help="Partner's bank account"
  • bank_name_column Char
    help="Partner's bank"
  • credit_value Char
    default='C' help="Value of debit/credit column that indicates if it's a credit"
  • currency_column Char
    help='In case statement is multi-currency, column to get currency of transaction from'
  • debit_credit_column Char
    help='Used if amount type is "Absolute value"\nSome statement formats use absolute amount value and indicate sign\nof the transaction by specifying if it was a debit or a credit one' string='Debit/credit column'
  • debit_value Char
    default='D' help="Value of debit/credit column that indicates if it's a debit"
  • delimiter Selection
    default='comma' selection=[('dot', 'dot (.)'), ('comma', 'comma (,)'), ('semicolon', 'semicolon (;)'), ('tab', 'tab'), ('space', 'space'), ('n/a', 'N/A')]
  • description_column Char
  • file_encoding Selection
    default='utf-8' selection=[('utf-8', 'UTF-8'), ('utf-8-sig', 'UTF-8 (with BOM)'), ('utf-16', 'UTF-16'), ('utf-16-sig', 'UTF-16 (with BOM)'), ('windows-1252', 'Western (Windows-1252)'), ('iso-8859-1', 'Western (Latin-1 / ISO 8859-1)'), ('iso-8859-2', 'Central European (Latin-2 / ISO 8859-2)'), ('iso-8859-4', 'Baltic (Latin-4 / ISO 8859-4)'), ('big5', 'Traditional Chinese (big5)'), ('gb18030', 'Unified Chinese (gb18030)'), ('shift_jis', 'Japanese (Shift JIS)'), ('windows-1251', 'Cyrillic (Windows-1251)'), ('koi8_r', 'Cyrillic (KOI8-R)'), ('koi8_u', 'Cyrillic (KOI8-U)')] string='Encoding'
  • float_decimal_sep Selection
    default='comma' selection=[('dot', 'dot (.)'), ('comma', 'comma (,)'), ('none', 'none')] string='Decimals Separator'
  • float_thousands_sep Selection
    default='dot' selection=[('dot', 'dot (.)'), ('comma', 'comma (,)'), ('quote', "quote (')"), ('none', 'none')] string='Thousands Separator'
  • footer_lines_skip_count Integer
    default='0' help='Set the Footer lines number.Used in some csv/xlsx file that integrate meta data inlast lines.' string='Footer lines skip count'
  • header_lines_skip_count Integer
    default='0' help='Set the Header lines number.' string='Header lines skip count'
  • name Char
    required=True
  • no_header Boolean
    help='When this occurs please indicate the column number in the Columns section instead of the column name, considering that the first column is 0' string='File does not contain header line'
  • notes_column Char
  • offset_column Integer
    default=0 help='Columns to ignore before starting to parse'
  • original_amount_column Char
    help='In case statement provides original currency for transactions with automatic currency conversion, column to get original transaction amount in original transaction currency from'
  • original_currency_column Char
    help='In case statement provides original currency for transactions with automatic currency conversion, column to get original currency of transaction from'
  • partner_name_column Char
  • quotechar Char
    default='"' size=1 string='Text qualifier'
  • reference_column Char
  • skip_empty_lines Boolean
    default=True help='Allows to skip empty lines'
  • timestamp_column Char
    required=True
  • timestamp_format Char
    required=True
  • transaction_id_column Char
    string='Unique transaction ID column'
Public methods (2)
  • onchange_decimal_separator(self)
    @api.onchange('float_decimal_sep')
  • onchange_thousands_separator(self)
    @api.onchange('float_thousands_sep')

New fields (0)

No new fields.

Public methods (2)
  • parse(self, data_file, mapping, filename)
    @api.model
  • parse_header(self, csv_or_xlsx, mapping)
    @api.model
REPOSITORY
REPOSITORYOCA/bank-statement-import
GIT
GIThttps://github.com/OCA/bank-statement-import.git
GIT FOLDER
GIT FOLDERhttps://github.com/OCA/bank-statement-import/tree/16.0/account_statement_import_sheet_file
VERSION
VERSION 1.3.1
CATEGORY
CATEGORYAccounting
LICENSE
LICENSEAGPL-3
APPLICATION
APPLICATIONNo
AUTO-INSTALLABLE
AUTO-INSTALLABLENo
AUTHORS
AUTHORSOdoo Community Association (OCA), ForgeFlow, CorporateHub
MAINTAINERS
MAINTAINERSOdoo Community Association (OCA), ForgeFlow, CorporateHub
COMMITTERS
COMMITTERSAlexis de Lattre, Carlos Lopez, Jordi Ballester Alomar, Víctor Martínez, Luis Felipe Miléo, Weblate, OCA-git-bot, oca-ci, Luis Rodriguez, Alessio Renda
WEBSITE
WEBSITEhttps://github.com/OCA/bank-statement-import
LAST TRACKING UPDATE
LAST TRACKING UPDATE2026-07-06 00:53:50
ODOO DEPENDENCIES
ODOO DEPENDENCIES OCA/account-reconcile:
    - account_statement_base
OCA/bank-statement-import:
    - account_statement_import_file
    - account_statement_import_base
odoo/odoo:
    - account
    - base_setup
    - base
    - web
    - product
    - mail
    - bus
    - web_tour
    - uom
    - analytic
    - portal
    - web_editor
    - http_routing
    - auth_signup
    - digest
    - resource
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES chardet
xlrd
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES Not have
DESCRIPTION
DESCRIPTION

Code Analysis

Views touched (4)
XML IDNameModelTypeStatus
account_statement_import_form account.statement.import account.statement.import xpath Inherits account_statement_import_file.account_statement_import_form
account_statement_import_sheet_mapping_form account.statement.import.sheet.mapping.form account.statement.import.sheet.mapping tree New
account_statement_import_sheet_mapping_tree account.statement.import.sheet.mapping.tree account.statement.import.sheet.mapping form New
view_account_journal_form_n43 account.journal xpath Inherits account.view_account_journal_form
Models touched (4)

New fields (1)
  • default_sheet_mapping_id Many2one → account.statement.import.sheet.mapping
    comodel_name='account.statement.import.sheet.mapping'
Public methods (0)

No public methods.

New fields (1)
  • sheet_mapping_id Many2one → account.statement.import.sheet.mapping
    comodel_name='account.statement.import.sheet.mapping' default=_get_default_mapping_id string='Sheet mapping'
Public methods (0)

No public methods.

New fields (33)
  • amount_column Char
    help="Amount of transaction in journal's currency"
  • amount_column Char
    help='Used if amount type is "Simple value" or "Absolute value"\nAmount of transaction in journal\'s currency\nSome statement formats use credit/debit columns' string='Amount column'
  • amount_credit_column Char
    help="Credit amount of transaction in journal's currency" string='Credit amount column'
  • amount_debit_column Char
    help="Debit amount of transaction in journal's currency" string='Debit amount column'
  • amount_inverse_sign Boolean
    help='In some cases such as in credit card statements the amounts are expressed in the inverse sign. By setting this flag during the upload the amounts will be inverted in sign.' string='Inverse sign of amount'
  • amount_type Selection
    default='simple_value' help='Simple value: use igned amount in amount column\nAbsolute Value: use a same column for debit and credit\n(absolute value + indicate sign)\nDistinct Credit/debit Column: use a distinct column for debit and credit' required=True selection=[('simple_value', 'Simple value'), ('absolute_value', 'Absolute value'), ('distinct_credit_debit', 'Distinct Credit/debit Column')] string='Amount type'
  • balance_column Char
    help="Balance after transaction in journal's currency"
  • bank_account_column Char
    help="Partner's bank account"
  • bank_name_column Char
    help="Partner's bank"
  • credit_value Char
    default='C' help="Value of debit/credit column that indicates if it's a credit"
  • currency_column Char
    help='In case statement is multi-currency, column to get currency of transaction from'
  • debit_credit_column Char
    help='Used if amount type is "Absolute value"\nSome statement formats use absolute amount value and indicate sign\nof the transaction by specifying if it was a debit or a credit one' string='Debit/credit column'
  • debit_value Char
    default='D' help="Value of debit/credit column that indicates if it's a debit"
  • delimiter Selection
    default='comma' selection=[('dot', 'dot (.)'), ('comma', 'comma (,)'), ('semicolon', 'semicolon (;)'), ('tab', 'tab'), ('space', 'space'), ('n/a', 'N/A')]
  • description_column Char
  • file_encoding Selection
    default='utf-8' selection=[('utf-8', 'UTF-8'), ('utf-8-sig', 'UTF-8 (with BOM)'), ('utf-16', 'UTF-16'), ('utf-16-sig', 'UTF-16 (with BOM)'), ('windows-1252', 'Western (Windows-1252)'), ('iso-8859-1', 'Western (Latin-1 / ISO 8859-1)'), ('iso-8859-2', 'Central European (Latin-2 / ISO 8859-2)'), ('iso-8859-4', 'Baltic (Latin-4 / ISO 8859-4)'), ('big5', 'Traditional Chinese (big5)'), ('gb18030', 'Unified Chinese (gb18030)'), ('shift_jis', 'Japanese (Shift JIS)'), ('windows-1251', 'Cyrillic (Windows-1251)'), ('koi8_r', 'Cyrillic (KOI8-R)'), ('koi8_u', 'Cyrillic (KOI8-U)')] string='Encoding'
  • float_decimal_sep Selection
    default='comma' selection=[('dot', 'dot (.)'), ('comma', 'comma (,)'), ('none', 'none')] string='Decimals Separator'
  • float_thousands_sep Selection
    default='dot' selection=[('dot', 'dot (.)'), ('comma', 'comma (,)'), ('quote', "quote (')"), ('none', 'none')] string='Thousands Separator'
  • footer_lines_skip_count Integer
    default='0' help='Set the Footer lines number.Used in some csv/xlsx file that integrate meta data inlast lines.' string='Footer lines skip count'
  • header_lines_skip_count Integer
    default='0' help='Set the Header lines number.' string='Header lines skip count'
  • name Char
    required=True
  • no_header Boolean
    help='When this occurs please indicate the column number in the Columns section instead of the column name, considering that the first column is 0' string='File does not contain header line'
  • notes_column Char
  • offset_column Integer
    default=0 help='Horizontal spaces to ignore before starting to parse'
  • original_amount_column Char
    help='In case statement provides original currency for transactions with automatic currency conversion, column to get original transaction amount in original transaction currency from'
  • original_currency_column Char
    help='In case statement provides original currency for transactions with automatic currency conversion, column to get original currency of transaction from'
  • partner_name_column Char
  • quotechar Char
    default='"' size=1 string='Text qualifier'
  • reference_column Char
  • skip_empty_lines Boolean
    default=False help='Allows to skip empty lines'
  • timestamp_column Char
    required=True
  • timestamp_format Char
    required=True
  • transaction_id_column Char
    string='Unique transaction ID column'
Public methods (2)
  • onchange_decimal_separator(self)
    @api.onchange('float_decimal_sep')
  • onchange_thousands_separator(self)
    @api.onchange('float_thousands_sep')

New fields (0)

No new fields.

Public methods (2)
  • parse(self, data_file, mapping, filename)
    @api.model
  • parse_header(self, csv_or_xlsx, mapping)
    @api.model