Bank Statement TXT/CSV/XLSX Import

This module adds a flexible way to bring bank statements into Odoo when the bank does not provide a standard format. Instead of a fixed file layout, you create a "Sheet Mapping" that tells Odoo how to read your file.

In a mapping you choose the file encoding, the column delimiter, the text qualifier, the date format, and the thousands and decimal separators. You then say which column contains the date, the amount (or separate debit and credit amounts), the balance, the currency, the description, the reference, the transaction ID, the partner name and the partner's bank details. If the file has no header line, you can enter column numbers instead of names, and you can skip empty lines or ignore leading rows and columns.

Mappings are managed under Accounting > Statement Sheet Mappings. On a bank journal you can set a default mapping, which is then pre-filled when you import a statement. A guided wizard also lets you upload a file, preview its columns and build a mapping step by step.

When importing, Odoo reads the file, sorts transactions by date, and fills the statement's opening and closing balances when a balance column is provided. If the closing balance is missing, it is computed from the opening balance plus the transaction amounts. Transactions keep their unique ID, reference, notes and partner information.