Skip to content

driehuis/account_statement_import_txt_xlsx_bank_knab

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

6 Commits
 
 
 
 
 
 

Repository files navigation

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.

About

Odoo bank statement import definition for KNAB bank

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages