Bank Statement XLSX Import
This module allows you to import any XLSX file in Odoo as bank statements.
auto_awesome What this module does
AI-generated from the code · Odoo 19.0This module lets you import bank statements directly from XLSX (Excel) files into Odoo's accounting. It adds XLSX as a supported file format for the existing bank statement import wizard.
This module extends the bank statement import feature so that Excel XLSX files can be used as a source for bank statements, in addition to the formats already supported by the base module.
When you use the bank statement import wizard and upload a file, Odoo now recognises the standard XLSX MIME type and routes it to the XLSX parser. The parser reads the active sheet of the workbook, applies the column mapping you configured (header row, skipped header lines, skipped footer lines, column offset), and converts each row into a statement line.
- Header handling: if the mapping says there is no header, no header row is read; otherwise the header row is taken after the configured number of skipped lines and after the column offset.
- Date handling: date cells found in the file are formatted using the timestamp format defined in the mapping, so they can be interpreted correctly.
- Row range: data rows are read between the header and the footer, respecting the configured skip counts.
Everything else — the import wizard, the mapping configuration, and the creation of statement lines — comes from the parent module account_statement_import_sheet_file. This module only adds the XLSX-specific reading logic on the model account.statement.import.sheet.parser.
Depends on
Models and fields (1)
- account.statement.import.sheet.parser · extends an existing model
Text generated by AI (DeepSeek) from reading the Odoo 19.0 code on GitHub; it may contain mistakes, so check the code before deciding. View the code on GitHub
Availability by version
Reviewed: 2026-11-03Confirmation status: 1 confirmed, 8 with no information of 9 versions.
Sources · Odoo 19.0
Confirmed on 2026-11-03 in branch 19.0 of OCA/bank-statement-import.
terminal Installation and usage
OCA documentation · Odoo 19.0Configuration
Source · Odoo 19.0To create TXT/CSV/XLSX statement sheet columns mapping:
- Open Invoicing \> Configuration \> Accounting \> Statement Sheet Mappings
- Create mapping(s) according to your online banking software statement format
Usage
Source · Odoo 19.0To use this module, you need to:
- Get statement in XLSX from your online banking software
- Go to Odoo and and import the statement file, selecting corresponding format
No verified information in OCA: Installation.
Installation instructions, the distribution package, dependencies and configuration steps are not shown because they have not yet been verified in the module documentation for any version.
Data imported from GitHub: this sheet reflects the latest catalog review, not a live lookup. Always check the module documentation and staging before installing in production.