16th May 2010
Download OFX statement from smile.co.uk
I’ve been waiting for mint.com to become usable in the UK for what feels like forever. I guess that it doesn’t work here yet because many UK banks ask different questions when you login, making it difficult to write automatic login scripts. So I’ve been using my own spreadsheet creation which is okay but I thought I’d try Wesabe.com as offers automatic tagging for reoccurring transaction and creates graphs on the fly (Everybody needs more graphs in their lives).
Unlike Mint, Wesabe doesn’t work only by syncing with a bank account, it also allows you to manually upload bank statements. To do this your bank needs to offer a downloadable statement (OFX , QIF, QFX, or OFC). My problem was that my bank (smile.co.uk) doesn’t offer this functionality so I built a Greasemonkey userscript that reads the printable statement and creates a .OFX
How to download .OFX from smile.co.uk
Greasemonkey is a firefox add-on that allows you to use javascript to add functionality to websites or customise how they look.
With Greasemonkey installed you can then download my userscript here or over here).
You may need to amend the script so that it works for you. Smile uses a number of different servers. Your bank account might run on a different server to mine therefore you’ll need to use Greasemonkey to add your sever to the list.
Now when you go to the printable statement page a window will pop up (you may need to “allow pop-ups for smile.co.uk”) with a bunch of text in it. You’ll need to save it as .OXF (copy it into a text editor and ensure that you change the file extension).
Alternatively
You can try Chris B’s Greasemonkey script. I couldn’t get it to work but it might work for you.
Improvements
I’d like to make a few improvements to the script:
- Create a downloadable file rather than open a new window. (any hints on how I can do this?) The Wesabe Firefox plugin adds a link to the download dialogue that allows you to send OFX files directly to Wesabe.com,
- neater code,
- include download button like on Chris B’s script to the live current statement page so that you don’t have to wait till a full statement before you send it to Wesabe.
- make it work on other bank websites
- create the same thing for/with Jetpack
However, I’m afraid I don’t see myself doing this any time soon.
