QIF Converter
Convert your online bank statements into QIF files for use in your favourite money application.
Instructions
- Log in to your online banking as usual.
- Select the transactions you want to convert (don't include the headers).
- Copy.
- Paste into the textarea above.
- Select the format of the statement and date. Some statements have an account balance on the end but you don't need to worry about that. There are a few examples below if you need a bit more in the way of explanation.
- Hit preview to see how it's going to come out.
- In the preview you should see American style dates (24/12/09, for example) and negative numbers for withdrawls.
- If everything looks okay hit convert.
- Wesabe users in Firefox should see the upload to Wesabe button, as per usual.
Examples
| Bank | Example statement | Transaction Format | Date Format |
|---|---|---|---|
| Egg |
14 Jul 2009 Card Deposit 100.00 100.00
|
Date Description Out In | 20 Dec 2009 |
| Sainsbury's Bank |
14/07/2009 Card Deposit 100.00 100.00
|
Date Description Out In | 20/12/2009 |
| Sainsbury's Bank * |
14/07/2009 NET INTEREST INT 100.00 100.00
|
Date Description Type Out In | 20/12/2009 |
* Not a typo: Sainsbury's Bank really do have two separate formats for their statements depending on what type of account you have!