Co-op online HTML bank statements to OFX

Getting your statement data out of the Co-operative Bank's online banking system in a usable form was pretty hard. You could save the HTML of a statement page, but that's about it. I use Xero for my company, Constituent Parts. It will import OFX formatted files which some banks will export for you. To get Co-operative Bank data into Xero you either need to enter the data by hand, or somehow convert it to OFX. Luke Redpath (who's great, by the way) wrote a Greasemonkey script to scrape Smile/Co-op HTML and generate OFX. It works for Current Accounts, but doesn't work with Credit Card statements, which have a slightly (but significantly) different format. So, I've written a Ruby-based screen scraper which will work with Current Accounts and Credit Cards. You can find it over on GitHub: It's called Co-op to OFX.

• 10.7.2009, 19.19
• File under: Co-op to OFX, Ruby, OFX, Data portability, Screen scraping