OdooWiki OCA HUB

Bank Statement XLSX Import

account_statement_import_sheet_file_xlsx folder_open OCA/bank-statement-import open_in_new
Accounting License: AGPL-3

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.0

This 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.

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-03
Confirmed (verified in repository and branch) Estimated (unverified) No information

Confirmation 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.0

To 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

To 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.

info

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.