United Kingdom banks
How United Kingdom statements are laid out
UK statements usually show dates as a day and abbreviated month (for example '14 Mar'), with the year often printed only in the statement period or where it changes. Outgoings and receipts sit in separate 'Paid out' and 'Paid in' (or 'Money out' and 'Money in') columns beside a running balance, and short codes such as DD (direct debit), SO (standing order), FPI/FPO (faster payment in/out) and CHQ often prefix the description. An overdrawn balance is typically flagged with 'OD' or a minus sign.
| On the statement | In your export |
|---|---|
| Date | Date |
| Payment type | Reference |
| Description | Description |
| Paid out | Debit (and negative Amount) |
| Paid in | Credit (and positive Amount) |
| Money out | Debit (and negative Amount) |
| Money in | Credit (and positive Amount) |
| Balance | Balance |
Using the data in accounting software
Popular tools here include Xero, QuickBooks, Sage and FreeAgent. Most accept CSV, and many accept OFX. See the step-by-step pages for Xero and QuickBooks.
Frequently asked questions
Which United Kingdom banks does the converter support?
It reads the transaction table directly, so it works with digital PDF statements from most banks in United Kingdom, including Barclays, first direct, Halifax and HSBC UK. Unusual layouts can be corrected in the preview before export.
Does it understand DD/MM/YYYY dates and £1,234.56 amounts?
Yes. The converter detects the date order and decimal separator from the statement itself. Exports default to DD/MM/YYYY on this page, and you can switch to any other format before downloading.
Can I import the result into Xero and QuickBooks?
Yes. Export CSV or OFX, both of which are accepted by most accounting packages used in United Kingdom, or Excel if you want to review and edit the data first.
Are my statements uploaded anywhere?
No. Conversion runs entirely in your web browser. The PDF and any password you enter stay on your device and are discarded when you close the page.