Skip to content

Latest commit

 

History

History
14 lines (9 loc) · 1.26 KB

File metadata and controls

14 lines (9 loc) · 1.26 KB

Bank statement import definitions for KNAB bank

This Statement Sheet definition is intended to be used with the OCA account_statement_import_txt_xlsx module.

Use "Zoeken en downloaden", select your desired period and "Bij- en afschrijvingen". Click "Zoeken". Then select Excel format to download. The downloaded file contains an extraneaous record "KNAB EXPORT" when downloading in CSV format, so this record must be removed prior to import if you prefer to use CSV format.

Last I checked, KNAB did not include previous and current balance in the download. Therefore, it is essential that you verify the balance with your KNAB statement before posting to make sure you didn't miss any transactions. Unfortunately, the only format offered by KNAB that does include the balance is the MT940 format, for which no importer is available in OCA for Odoo 14. The list does include unique identifiers, so duplicate items will be silently discarded by the import routine.

Production notes

The Statement Sheet Definition has been created and tested in the Odoo 14 user interface to the account_statement_import_txt_xlsx module. It was then exported to an XML file using the xr-export-statement-sheet-mapping.py script.