Occasionally I will be writing this year about progress on Simpleform’s transparent books.

Last week I learned how to retrieve and parse my bank account’s transactions. They’re in a format called OFX which sounds awful but is actually pretty straightforward. If you ignore 95% of it, in the end it is a list of transactions identified by GUIDs which I am stuffing in a MySQL database.

My goal is first to collect it, then clean it up locally by adding better descriptions and categories, and then push reports to a server that we can all see.

I will share this code.