United Kingdom bank statements

UK Bank Statements to Excel, CSV & Xero | AI Bank Statement

UK banks give you PDF statements, and each has its own export with its own limits. This guide covers what HMRC expects you to keep, how Making Tax Digital treats imported data, and the import rules for Xero, QuickBooks and FreeAgent, with a guide for each major bank.

Last updated 14 October 2026

At a glance

Currency
Pound sterling (GBP, £)
Date order
Day, month, year (e.g. 15/01/2026)
Keep records (self-employed)
At least 5 years after the 31 January deadline for the tax year
Keep records (limited companies)
6 years from the end of the last financial year they relate to
Common accounting software
Xero, QuickBooks, FreeAgent, Sage

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:

BankPDF statements onlineBuilt-in export
BarclaysUp to 7 years (Online Statements)CSV, for a date range
HSBC UKUp to 6 yearsExcel or CSV, from a transaction search
Lloyds BankAt least 10 years in the appCSV/QIF for business; 12-month midata for personal
NatWestUp to 7 yearsTransaction search export, including Excel
Santander UKe-documents in Mobile and Online BankingExcel, Quicken, PDF or Microsoft Money; 600 transactions per personal download
NationwideLast 36 months online; closed-account history can cover final 5 yearsmidata download for current-account transactions
HalifaxUp to 7 years in Online Banking; at least 10 years in the appTransaction search by description, amount, date and type
MonzoDate range you choosePDF, CSV or QIF
Starling BankMonthly PDFs with a True Copy stampCSV 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 incomeMust 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

Xero

  • 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.

QuickBooks

  • 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

  1. Upload your PDF statements, including scans of paper statements. Batch upload handles a year of monthly statements at once.
  2. Pick the output: Excel, CSV, JSON, Xero CSV, or QuickBooks 3- or 4-column CSV.
  3. 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.

United Kingdom bank guides

BarclaysTrusted by professionals to process Barclays, London statements securely and efficientlyHalifaxHow to download Halifax statements, search transactions, and convert Halifax PDF statements to Excel, CSV, Xero or QuickBooks for bookkeeping.HSBC UKHow to download HSBC UK statements as PDF, export transactions to Excel or CSV, and convert HSBC PDF statements to Excel, CSV, Xero or QuickBooks.Lloyds BankHow to download Lloyds Bank statements as PDF in Internet Banking and the app, what export options exist, and how to convert Lloyds PDF statements to Excel, CSV, Xero or QuickBooks.MonzoHow to download Monzo statements as PDF, CSV or QIF, when you'll still be working from a Monzo PDF, and how to convert Monzo PDF statements to Excel, CSV, Xero or QuickBooks.NationwideHow to download Nationwide statements, use midata transaction downloads, and convert Nationwide PDF statements to Excel, CSV, Xero or QuickBooks.NatWestHow to download NatWest statements as PDF, export transactions to Excel, get statements older than 7 years, and convert NatWest PDF statements to Excel, CSV, Xero or QuickBooks.Santander UKHow to download Santander UK statements and transaction exports, why the 600-transaction limit matters, and how to convert Santander PDFs to Excel, CSV, Xero or QuickBooks.Starling BankStarling changed its statements in August 2026: monthly PDFs with a True Copy stamp, and CSV only for the last 12 months. How to get each, and how to convert Starling PDF statements to Excel, CSV or Xero.

Choose your output format

Frequently asked questions

How long do I need to keep bank statements in the UK?

HMRC says self-employed people must keep records for at least 5 years after the 31 January submission deadline for the tax year, and lists bank statements as records to keep. Limited companies must keep records for 6 years from the end of the last financial year they relate to, and VAT records must be kept for at least 6 years.

Does Making Tax Digital let me import a bank statement CSV?

Yes. HMRC lists CSV importing and exporting as an acceptable digital link. What it doesn't allow is copying and pasting records between software. You still need to keep the original records, such as bank statements.

Who has to use Making Tax Digital for Income Tax?

Sole traders and landlords with qualifying income over £50,000 from 6 April 2026, over £30,000 from 6 April 2027, and over £20,000 from 6 April 2028, based on HMRC's published thresholds.

What date format should a CSV use for Xero, QuickBooks or FreeAgent?

QuickBooks UK recommends dd/mm/yyyy and FreeAgent requires it. Xero accepts several formats including DD/MM/YYYY, and asks you to confirm the format if a date is ambiguous.

Which UK banks can I convert statements from?

Any UK bank or building society that gives you a PDF statement. The guides below cover Barclays, HSBC UK, Lloyds, NatWest, Santander UK, Nationwide, Halifax, Monzo and Starling.

Life's too short to retype a bank statement.

Upload one and see for yourself. Plans from $12 a month.

Secure checkout · instant access · files deleted right after processing