I’ve recently become the treasurer of Manchester Friends of the Earth, a local environmental campaigning group that I’ve been involved with sporadically since I was at university. We’ve moved our accounts to an online platform (Sage One), which allows importing of bank statements and thus saves the treasurer a lot of work.
Unfortunately, Sage One accepts statements in Quicken Interchange Format (QIF) or Open Financial Exchange (OFX) whereas our bank provides statements in Comma-separated values (CSV), so we needed some way of converting between them. A search turned up a few possibilities, but most of them were web services or suspicious software hosted on sites with lots of adverts.
Looking at the two formats, I saw that QIF was far simpler than OFX, so I fired up the trusty language that is Perl and put together a conversion script, building on top of Text::CSV which took care of processing the input data. In the hope that this will be useful to others, I’ve put the code on GitHub under the unimaginative name of csv2qif. Please do open an issue or pull request if there’s a feature you would like added, and I welcome submissions of CSV column mappings for banks as each one uses a slightly different order.