Account Bank Statement Import TXT/CSV/XLSX

account_bank_statement_import_txt_xlsx
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/13.0/account_bank_statement_import_txt_xlsx
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
COMMITTERSmreficent, Alexey Pelykh, Jordi Ballester Alomar, OCA Transbot, oca-travis, Weblate, OCA-git-bot, oca-ci, Héctor Villarreal Ortega
WEBSITE
WEBSITEhttps://github.com/OCA/bank-statement-import
LAST TRACKING UPDATE
LAST TRACKING UPDATE2026-07-06 00:34:15
ODOO DEPENDENCIES
ODOO DEPENDENCIES OCA/server-ux:
    - multi_step_wizard
OCA/web:
    - web_widget_dropdown_dynamic
odoo/odoo:
    - account_bank_statement_import
    - 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 (5)
XML IDNameModelTypeStatus
account_bank_statement_import_sheet_mapping_form account.bank.statement.import.sheet.mapping.form account.bank.statement.import.sheet.mapping tree New
account_bank_statement_import_sheet_mapping_tree account.bank.statement.import.sheet.mapping.tree account.bank.statement.import.sheet.mapping form New
account_bank_statement_import_sheet_mapping_wizard_form account.bank.statement.import.sheet.mapping.wizard.form account.bank.statement.import.sheet.mapping.wizard xpath Inherits multi_step_wizard.multi_step_wizard_form
account_bank_statement_import_view account.bank.statement.import account.bank.statement.import xpath Inherits account_bank_statement_import.account_bank_statement_import_view
view_account_journal_form_n43 account.journal xpath Inherits account.view_account_journal_form
Models touched (5)

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

No public methods.

New fields (24)
  • amount_column Char
    help="Amount of transaction in journal's currency" required=True string='Amount column'
  • balance_column Char
    help="Balance after transaction in journal's currency" string='Balance column'
  • bank_account_column Char
    help="Partner's bank account" string='Bank Account column'
  • bank_name_column Char
    help="Partner's bank" string='Bank Name column'
  • credit_value Char
    default='C' help="Value of debit/credit column that indicates if it's a credit" string='Credit value'
  • currency_column Char
    help='In case statement is multi-currency, column to get currency of transaction from' string='Currency column'
  • debit_credit_column Char
    help='Some statement formats use absolute amount value and indicate signof 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" string='Debit value'
  • delimiter Selection
    default='comma' selection=[('dot', 'dot (.)'), ('comma', 'comma (,)'), ('semicolon', 'semicolon (;)'), ('tab', 'tab'), ('space', 'space'), ('n/a', 'N/A')] string='Delimiter'
  • description_column Char
    string='Description column'
  • 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 (,)'), ('none', 'none')] string='Thousands Separator'
  • 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' args: 'File does not contain header line'
  • notes_column Char
    string='Notes column'
  • 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' string='Original amount column'
  • 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' string='Original currency column'
  • partner_name_column Char
    string='Partner Name column'
  • quotechar Char
    default='"' size=1 string='Text qualifier'
  • reference_column Char
    string='Reference column'
  • timestamp_column Char
    required=True string='Timestamp column'
  • timestamp_format Char
    required=True string='Timestamp Format'
  • 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 (21)
  • amount_column Char
    help="Amount of transaction in journal's currency" string='Amount column'
  • attachment_ids Many2many → ir.attachment
    comodel_name='ir.attachment' relation='account_bank_statement_import_sheet_mapping_wiz_attachment_rel' required=True string='Files'
  • balance_column Char
    help="Balance after transaction in journal's currency" string='Balance column'
  • bank_account_column Char
    help="Partner's bank account" string='Bank Account column'
  • bank_name_column Char
    help="Partner's bank" string='Bank Name column'
  • credit_value Char
    default='C' help="Value of debit/credit column that indicates if it's a credit" string='Credit value'
  • currency_column Char
    help='In case statement is multi-currency, column to get currency of transaction from' string='Currency column'
  • debit_credit_column Char
    help='Some statement formats use absolute amount value and indicate signof 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" string='Debit value'
  • delimiter Selection
    selection=<expr> string='Delimiter'
  • description_column Char
    string='Description column'
  • file_encoding Selection
    selection=<expr> string='Encoding'
  • header Char
  • notes_column Char
    string='Notes column'
  • 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' string='Original amount column'
  • 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' string='Original currency column'
  • partner_name_column Char
    string='Partner Name column'
  • quotechar Char
    size=1 string='Text qualifier'
  • reference_column Char
    string='Reference column'
  • timestamp_column Char
    string='Timestamp column'
  • transaction_id_column Char
    string='Unique transaction ID column'
Public methods (2)
  • import_mapping(self)
  • statement_columns(self)
    @api.model

New fields (0)

No new fields.

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

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

No public methods.

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/12.0/account_bank_statement_import_txt_xlsx
VERSION
VERSION 2.0.6
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
COMMITTERSGitHub, Alexey Pelykh, Jordi Ballester Alomar, OCA Transbot, oca-travis, Weblate, OCA-git-bot, Héctor Villarreal Ortega, Mateu Griful
WEBSITE
WEBSITEhttps://github.com/OCA/bank-statement-import
LAST TRACKING UPDATE
LAST TRACKING UPDATE2026-07-06 00:29:20
ODOO DEPENDENCIES
ODOO DEPENDENCIES OCA/server-ux:
    - multi_step_wizard
OCA/web:
    - web_widget_dropdown_dynamic
odoo/odoo:
    - account_bank_statement_import
    - account
    - base_setup
    - base
    - web
    - product
    - decimal_precision
    - mail
    - bus
    - web_tour
    - uom
    - analytic
    - portal
    - http_routing
    - digest
PYTHON DEPENDENCIES
PYTHON DEPENDENCIES xlrd
SYSTEM DEPENDENCIES
SYSTEM DEPENDENCIES Not have
DESCRIPTION
DESCRIPTION

Code Analysis

Views touched (5)
XML IDNameModelTypeStatus
account_bank_statement_import_sheet_mapping_form account.bank.statement.import.sheet.mapping.form account.bank.statement.import.sheet.mapping tree New
account_bank_statement_import_sheet_mapping_tree account.bank.statement.import.sheet.mapping.tree account.bank.statement.import.sheet.mapping form New
account_bank_statement_import_sheet_mapping_wizard_form account.bank.statement.import.sheet.mapping.wizard.form account.bank.statement.import.sheet.mapping.wizard xpath Inherits multi_step_wizard.multi_step_wizard_form
account_bank_statement_import_view account.bank.statement.import account.bank.statement.import xpath Inherits account_bank_statement_import.account_bank_statement_import_view
view_account_journal_form_n43 account.journal xpath Inherits account.view_account_journal_form
Models touched (5)

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

No public methods.

New fields (23)
  • amount_column Char
    help="Amount of transaction in journal's currency" required=True string='Amount column'
  • balance_column Char
    help="Balance after transaction in journal's currency" string='Balance column'
  • bank_account_column Char
    help="Partner's bank account" string='Bank Account column'
  • bank_name_column Char
    help="Partner's bank" string='Bank Name column'
  • credit_value Char
    default='C' help="Value of debit/credit column that indicates if it's a credit" string='Credit value'
  • currency_column Char
    help='In case statement is multi-currency, column to get currency of transaction from' string='Currency column'
  • debit_credit_column Char
    help='Some statement formats use absolute amount value and indicate signof 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" string='Debit value'
  • delimiter Selection
    default='comma' selection=[('dot', 'dot (.)'), ('comma', 'comma (,)'), ('semicolon', 'semicolon (;)'), ('tab', 'tab'), ('space', 'space'), ('n/a', 'N/A')] string='Delimiter'
  • description_column Char
    string='Description column'
  • 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 (,)'), ('none', 'none')] string='Thousands Separator'
  • name Char
    required=True
  • notes_column Char
    string='Notes column'
  • 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' string='Original amount column'
  • 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' string='Original currency column'
  • partner_name_column Char
    string='Partner Name column'
  • quotechar Char
    default='"' size=1 string='Text qualifier'
  • reference_column Char
    string='Reference column'
  • timestamp_column Char
    required=True string='Timestamp column'
  • timestamp_format Char
    required=True string='Timestamp Format'
  • 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 (22)
  • amount_column Char
    help="Amount of transaction in journal's currency" string='Amount column'
  • balance_column Char
    help="Balance after transaction in journal's currency" string='Balance column'
  • bank_account_column Char
    help="Partner's bank account" string='Bank Account column'
  • bank_name_column Char
    help="Partner's bank" string='Bank Name column'
  • credit_value Char
    default='C' help="Value of debit/credit column that indicates if it's a credit" string='Credit value'
  • currency_column Char
    help='In case statement is multi-currency, column to get currency of transaction from' string='Currency column'
  • data_file Binary
    required=True string='Bank Statement File'
  • debit_credit_column Char
    help='Some statement formats use absolute amount value and indicate signof 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" string='Debit value'
  • delimiter Selection
    selection=<expr> string='Delimiter'
  • description_column Char
    string='Description column'
  • file_encoding Selection
    selection=<expr> string='Encoding'
  • filename Char
  • header Char
  • notes_column Char
    string='Notes column'
  • 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' string='Original amount column'
  • 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' string='Original currency column'
  • partner_name_column Char
    string='Partner Name column'
  • quotechar Char
    size=1 string='Text qualifier'
  • reference_column Char
    string='Reference column'
  • timestamp_column Char
    string='Timestamp column'
  • transaction_id_column Char
    string='Unique transaction ID column'
Public methods (2)
  • import_mapping(self)
    @api.multi
  • statement_columns(self)
    @api.model

New fields (0)

No new fields.

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

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

No public methods.