Thursday, May 18. 2006
Online banking HTML output to QIF, ... Posted by Jeremy Coates in Linux at 12:02
Firstly I checked with the bank - "At the moment, we can't transfer account information to popular accounting packages or spreadsheets. Although we haven't got a definite date for introducing this facility, it has been scheduled for inclusion in our Online service and we'll let you know as soon as it's available."
I'm not the sort of person to be foiled by that sort of response so embarked upon working out a reliable import routine - especially as the online statement is just an HTML table which can be imported into most spreadsheets with ease.
Grisbi supports the QIF format for importing data as well as a few others, so that was my target format. I came across a macro for Open Office Calc (there's also a similar macro for Excel) that exports to the QIF format. So I tried a simple save of the transaction history of my online statement as an html file. This I then opened into oocalc and the transactions were imported, a few row and column deletes later to clean up the un-needed elements and I wa