| 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/19.0/account_statement_import_sheet_file |
| 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 | Víctor Martínez, OCA-git-bot, oca-ci, Andrii9090-tecnativa, roger |
| WEBSITE | |
| WEBSITE | https://github.com/OCA/bank-statement-import |
| LAST TRACKING UPDATE | |
| LAST TRACKING UPDATE | 2026-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 - 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. |
| XML ID | Name | Model | Type | Status |
|---|---|---|---|---|
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 |
default_sheet_mapping_id
Many2one → account.statement.import.sheet.mapping
comodel_name='account.statement.import.sheet.mapping'
No public methods.
sheet_mapping_id
Many2one → account.statement.import.sheet.mapping
comodel_name='account.statement.import.sheet.mapping'
default=<expr>
string='Sheet mapping'
No public methods.
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'
onchange_decimal_separator(self)
onchange_thousands_separator(self)
No new fields.
Public methods (2)parse(self, data_file, mapping, filename)
parse_header_csv(self, rows, mapping)
| 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/18.0/account_statement_import_sheet_file |
| VERSION | |
| VERSION | 1.1.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 | Pedro M. Baeza, Jacques-Etienne Baudoux, Víctor Martínez, Weblate, OCA-git-bot, oca-ci |
| WEBSITE | |
| WEBSITE | https://github.com/OCA/bank-statement-import |
| LAST TRACKING UPDATE | |
| LAST TRACKING UPDATE | 2026-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 - 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. |
| XML ID | Name | Model | Type | Status |
|---|---|---|---|---|
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 |
default_sheet_mapping_id
Many2one → account.statement.import.sheet.mapping
comodel_name='account.statement.import.sheet.mapping'
No public methods.
sheet_mapping_id
Many2one → account.statement.import.sheet.mapping
comodel_name='account.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"
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'
onchange_decimal_separator(self)
onchange_thousands_separator(self)
No new fields.
Public methods (2)parse(self, data_file, mapping, filename)
parse_header(self, csv_or_xlsx, mapping)
| 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/17.0/account_statement_import_sheet_file |
| VERSION | |
| VERSION | 1.2.0 |
| 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 | Pedro M. Baeza, Víctor Martínez, Weblate, OCA-git-bot, oca-ci, Rocío Vega, Alessio Renda |
| WEBSITE | |
| WEBSITE | https://github.com/OCA/bank-statement-import |
| LAST TRACKING UPDATE | |
| LAST TRACKING UPDATE | 2026-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 - 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. |
| XML ID | Name | Model | Type | Status |
|---|---|---|---|---|
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 |
default_sheet_mapping_id
Many2one → account.statement.import.sheet.mapping
comodel_name='account.statement.import.sheet.mapping'
No public methods.
sheet_mapping_id
Many2one → account.statement.import.sheet.mapping
comodel_name='account.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"
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'
onchange_decimal_separator(self)
onchange_thousands_separator(self)
No new fields.
Public methods (2)parse(self, data_file, mapping, filename)
parse_header(self, csv_or_xlsx, mapping)
| 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/16.0/account_statement_import_sheet_file |
| VERSION | |
| VERSION | 1.3.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 | Alexis 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 | |
| WEBSITE | https://github.com/OCA/bank-statement-import |
| LAST TRACKING UPDATE | |
| LAST TRACKING UPDATE | 2026-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 - 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_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 |
default_sheet_mapping_id
Many2one → account.statement.import.sheet.mapping
comodel_name='account.statement.import.sheet.mapping'
No public methods.
sheet_mapping_id
Many2one → account.statement.import.sheet.mapping
comodel_name='account.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"
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'
onchange_decimal_separator(self)
onchange_thousands_separator(self)
No new fields.
Public methods (2)parse(self, data_file, mapping, filename)
parse_header(self, csv_or_xlsx, mapping)