| REPOSITORY | |
|---|---|
| REPOSITORY | OCA/bank-statement-import |
| GIT | |
| GIT | https://github.com/OCA/bank-statement-import.git |
| GIT FOLDER | |
| GIT FOLDER | https://github.com/OCA/bank-statement-import/tree/13.0/account_bank_statement_import_txt_xlsx |
| VERSION | |
| VERSION | 2.0.1 |
| CATEGORY | |
| CATEGORY | Accounting |
| LICENSE | |
| LICENSE | AGPL-3 |
| APPLICATION | |
| APPLICATION | No |
| AUTO-INSTALLABLE | |
| AUTO-INSTALLABLE | No |
| AUTHORS | |
| AUTHORS | Odoo Community Association (OCA), ForgeFlow, CorporateHub |
| MAINTAINERS | |
| MAINTAINERS | Odoo Community Association (OCA), ForgeFlow, CorporateHub |
| COMMITTERS | |
| COMMITTERS | mreficent, Alexey Pelykh, Jordi Ballester Alomar, OCA Transbot, oca-travis, Weblate, OCA-git-bot, oca-ci, Héctor Villarreal Ortega |
| WEBSITE | |
| WEBSITE | https://github.com/OCA/bank-statement-import |
| LAST TRACKING UPDATE | |
| LAST TRACKING UPDATE | 2026-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 - 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 | |
| XML ID | Name | Model | Type | Status |
|---|---|---|---|---|
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 |
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'
No public methods.
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'
onchange_decimal_separator(self)
onchange_thousands_separator(self)
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'
import_mapping(self)
statement_columns(self)
No new fields.
Public methods (2)parse(self, data_file, mapping, filename)
parse_header(self, data_file, encoding, csv_options)
default_sheet_mapping_id
Many2one → account.bank.statement.import.sheet.mapping
comodel_name='account.bank.statement.import.sheet.mapping'
No public methods.
| REPOSITORY | |
|---|---|
| REPOSITORY | OCA/bank-statement-import |
| GIT | |
| GIT | https://github.com/OCA/bank-statement-import.git |
| GIT FOLDER | |
| GIT FOLDER | https://github.com/OCA/bank-statement-import/tree/12.0/account_bank_statement_import_txt_xlsx |
| VERSION | |
| VERSION | 2.0.6 |
| CATEGORY | |
| CATEGORY | Accounting |
| LICENSE | |
| LICENSE | AGPL-3 |
| APPLICATION | |
| APPLICATION | No |
| AUTO-INSTALLABLE | |
| AUTO-INSTALLABLE | No |
| AUTHORS | |
| AUTHORS | Odoo Community Association (OCA), ForgeFlow, CorporateHub |
| MAINTAINERS | |
| MAINTAINERS | Odoo Community Association (OCA), ForgeFlow, CorporateHub |
| COMMITTERS | |
| COMMITTERS | GitHub, Alexey Pelykh, Jordi Ballester Alomar, OCA Transbot, oca-travis, Weblate, OCA-git-bot, Héctor Villarreal Ortega, Mateu Griful |
| WEBSITE | |
| WEBSITE | https://github.com/OCA/bank-statement-import |
| LAST TRACKING UPDATE | |
| LAST TRACKING UPDATE | 2026-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 - bus - web_tour - uom - analytic - portal - http_routing - digest |
| PYTHON DEPENDENCIES | |
| PYTHON DEPENDENCIES |
xlrd |
| SYSTEM DEPENDENCIES | |
| SYSTEM DEPENDENCIES | Not have |
| DESCRIPTION | |
| DESCRIPTION | |
| XML ID | Name | Model | Type | Status |
|---|---|---|---|---|
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 |
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'
No public methods.
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'
onchange_decimal_separator(self)
onchange_thousands_separator(self)
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'
import_mapping(self)
statement_columns(self)
No new fields.
Public methods (2)parse(self, mapping, data_file, filename)
parse_header(self, data_file, encoding, csv_options)
default_sheet_mapping_id
Many2one → account.bank.statement.import.sheet.mapping
comodel_name='account.bank.statement.import.sheet.mapping'
No public methods.