Bank Statement XLSX (HTML) Import
Automatically detect and parse an XLSX file when it is a HTML file.
auto_awesome What this module does
AI-generated from the code · Odoo 18.0Lets you import bank statements from files that look like XLSX but are actually HTML tables, using the same column mapping screens as other spreadsheet imports.
This module extends the bank statement import feature so that files which are really HTML pages containing a table can be read as if they were spreadsheets. When you import a statement file, Odoo first checks whether the content starts with an HTML tag; if it does, the table rows are converted into rows of data and then processed with the normal spreadsheet import rules.
You configure how the file is read in the Statement Sheet Mappings menu, found under the Accounting menu. There you create a mapping that tells Odoo which column holds the date, the amount, the description, the partner, the bank account, and so on. You can also set the file encoding, the decimal and thousands separators, the date format, whether the file has a header, and how many lines to skip at the top or bottom.
On a bank journal, in the advanced settings, you can choose a default statement import map so that imports for that journal use the right settings automatically. On the bank statement import screen, a new field lets you pick the mapping to use for TXT, CSV, or XLSX files.
The module works together with the spreadsheet import module and does not add new database models; it only adds a new parsing step and the mapping screens.
Depends on
Menus it adds
Models and fields (1)
- account.statement.import.sheet.parser · extends an existing model
Text generated by AI (DeepSeek) from reading the Odoo 18.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 18.0
Confirmed on 2026-11-03 in branch 18.0 of OCA/bank-statement-import.
terminal Installation and usage
No verified informationInstallation 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.