Bank Statement TXT/CSV Import (Base)

This module adds a flexible way to bring bank statement files in TXT or CSV format into Odoo. Instead of a fixed format, you create a "Statement Sheet Mapping" that tells Odoo how to read your file.

• In Accounting, a new menu "Statement Sheet Mappings" lets you create and manage these mappings. On each mapping you choose the file encoding, the column delimiter, the text qualifier, the date format, and the number separators (thousands and decimals).
• You then name the columns that contain the transaction date, amount, balance, currency, description, notes, reference, partner name, bank name and bank account. You can also skip header or footer lines, ignore empty lines, and offset leading columns.
• Three amount styles are supported: a single signed amount, an absolute amount with a separate debit/credit indicator column, or separate debit and credit amount columns. A validation prevents saving a mapping that is missing the columns required by the chosen style.
• On a bank journal you can set a default mapping, which is automatically pre-filled when you import a statement. The import screen shows a "TXT/CSV/XLSX mapping" field where you can pick a different mapping for a one-off import.
• During import, the file is decoded, parsed, sorted by date, and converted into statement lines. If the file has no balance column, Odoo computes the closing balance from the opening balance plus the imported amounts.