Tax season started and I am busy with reconciliation as many other micro entrepreneurs. I created free opensource solution to automate bookkeeping tasks such as exporting transactions from bank and payment system APIs to CAMT054, JSON or CSV (to be able to import them to free tools like Zoho Books).
All banking systems have different output formats while integrations with many of bookkeeping software are not always free if exists at all. Importing them to bookkeping system is real pain, especially because of timezones (exports are often CSVs without TZ information in dates), different export periods (i.e. you are not always allowed to export transactions for 1 year or for specific range, for example 1 year + 1 day to match timezone difference), mess of exported filenames (from where and from which range this export.xlsx in my Downloads?).
This solution aims to eliminate manual work of matching different CSV schemas, which often leads to errors. It extracts all transactions for a given period and saves them in logically named files using the industry standard ISO20022 (camt054.xml), CSV for wide support of accounting systems and JSON - for further integrations if needed.
I plan to add some tests, maybe timezone conversions, maybe Docker or nice UI. I'm asking for comments - what do you want from such tool?
reply