Mark J Cox | Home automation | Open Source Software | Security

Mark J Cox

EGG has a UK credit card managed online. Although you can get your statements in HTML format Egg don't give any export ability. Back in 1999 I wrote a simple converter in Perl that takes the HTML from the EGG statement page and convert it into QIF (for import into things like Microsoft Money). Using something like Money 2000 or 2001 will let it automatically reconcile the statement and match transactions. In May 2000 I updated it to output OFX format, a much better format as it can transfer other information about the account such as balances. The same script deals with Egg, Egg Money, Cahoot, and American Express credit card statements and can output QIF or OFX format.

2ofx.pl (working June 2006)

To use the script:

Log onto the egg web site, and select the statement you want to convert
In your browser save the current page to a file. You sometimes need to do "view source" and save that version. You'll end up with a file, lets say egg.html
Make sure you have a perl interpreter on your system. If you're using Linux or other Unix you'll most likely have perl installed. If you're using Windows you'll need to get Perl from someone like ActiveState and figure out the command line stuff
Run
```
perl 2ofx.pl egg.html > egg.qif
```
Use "Import" in Microsoft Money to load in egg.qif

Created: 01 Mar 2001