Account Bank Statement Import TXT/CSV/XLSX

This module extends the standard bank statement import so you can bring in files that are not in the usual bank formats, such as TXT, CSV or XLSX spreadsheets.

You create a 'Statement Sheet Mapping' where you describe the file: encoding, delimiter, text qualifier, decimal and thousands separators, date format, and which column holds each piece of information (date, amount, balance, description, reference, partner name, bank account, etc.). A sample mapping is provided. Mappings are managed from the Accounting menu under 'Statement Sheet Mappings'.

When importing a statement, you pick the mapping to use. You can also set a default mapping on each bank journal, so the right mapping is pre-selected automatically. A step-by-step wizard helps you build a new mapping: upload a file, choose options, then pick columns from the detected header.

During import the module reads the file, sorts transactions by date, computes the opening and closing balances when a balance column is given, handles debit/credit columns, multi-currency amounts, and unique transaction IDs. If the file does not provide a closing balance, it is calculated from the statement lines. It works on account.bank.statement.import, account.journal and the new mapping and parser models.