How UK banks give you your statements
Every UK bank gives you official statements as PDFs. Most also offer some kind of spreadsheet export, but each one has its own limits:
| Bank | PDF statements online | Built-in export |
|---|---|---|
| Barclays | Up to 7 years (Online Statements) | CSV, for a date range |
| HSBC UK | Up to 6 years | Excel or CSV, from a transaction search |
| Lloyds Bank | At least 10 years in the app | CSV/QIF for business; 12-month midata for personal |
| NatWest | Up to 7 years | Transaction search export, including Excel |
| Santander UK | e-documents in Mobile and Online Banking | Excel, Quicken, PDF or Microsoft Money; 600 transactions per personal download |
| Nationwide | Last 36 months online; closed-account history can cover final 5 years | midata download for current-account transactions |
| Halifax | Up to 7 years in Online Banking; at least 10 years in the app | Transaction search by description, amount, date and type |
| Monzo | Date range you choose | PDF, CSV or QIF |
| Starling Bank | Monthly PDFs with a True Copy stamp | CSV summary, last 12 months only |
The exports are transaction lists, not statements. They don't carry the statement period with its opening and closing balances, they often have date-range limits, and they're no help when all you have is the PDF, which is the usual situation for accountants and bookkeepers working with clients.
What HMRC expects you to keep
- Self-employed and sole traders: keep records for at least 5 years after the 31 January submission deadline for the relevant tax year. HMRC lists bank statements among the records to keep.
- Limited companies: keep records for 6 years from the end of the last company financial year they relate to, or longer in some cases. HMRC can fine a company £3,000 for not keeping accounting records.
- VAT: keep VAT records for at least 6 years.
Making Tax Digital and bank statements
Making Tax Digital for Income Tax applies to sole traders and landlords registered for Self Assessment, based on qualifying income:
| Qualifying income | Must use MTD from |
|---|---|
| Over £50,000 (2024 to 2025 tax year) | 6 April 2026 |
| Over £30,000 (2025 to 2026 tax year) | 6 April 2027 |
| Over £20,000 (2026 to 2027 tax year) | 6 April 2028 |
Under MTD you keep digital records of income and expenses, each with an amount, a date and a category. Two rules matter when your data starts in a bank statement:
- Importing a CSV counts as a digital link. HMRC lists "CSV importing and exporting" as acceptable.
- Copy and paste doesn't. Moving records between software by copying and pasting isn't allowed.
So converting a PDF statement to CSV and importing it into your MTD software fits the rules, while retyping or pasting from the PDF doesn't. You still need to keep the original statements. VAT-registered businesses follow the same digital-link rules under Making Tax Digital for VAT.
Importing into UK accounting software
- Only the date and amount are required, but descriptions make reconciling easier.
- Income and expenses go in one amount column, with expenses negative.
- Accepts DD/MM/YYYY among other date formats, and asks you to confirm when a date is ambiguous.
- Accepts a 3-column (date, description, amount) or 4-column (date, description, credit, debit) CSV.
- Recommends dd/mm/yyyy dates. Upload from Bank transactions › Link account › Upload from file.
FreeAgent
- Accepts OFX, QIF or CSV.
- A CSV must have exactly three columns in order (date as dd/mm/yyyy, amount with payments out negative, description), with no header row, no commas in the amount and each description on one line.
AI Bank Statement converts a UK PDF statement straight to Xero CSV or a QuickBooks 3- or 4-column CSV, with dates kept day-first and amounts in pounds. For FreeAgent, use the CSV output and check it matches FreeAgent's three-column layout before uploading.
Converting a UK bank statement
- Upload your PDF statements, including scans of paper statements. Batch upload handles a year of monthly statements at once.
- Pick the output: Excel, CSV, JSON, Xero CSV, or QuickBooks 3- or 4-column CSV.
- Download one transaction per row, ready to review, reconcile or import.
Credit card statements, including Barclaycard, convert the same way with the credit card statement converter.