How to Convert UK Bank Statements to CSV and Excel (2026 Guide)

Why Convert UK Bank Statements to CSV?

UK banks — Barclays, HSBC, Lloyds, NatWest, and the growing number of digital banks like Wise, Monzo, and Starling — provide statements as PDF files. Converting to CSV enables:

• Import into Xero, FreeAgent, or Sage for bank reconciliation
• Making Tax Digital (MTD) compliance with digital record-keeping
• Self Assessment preparation for HMRC
• VAT return preparation with categorised transactions
• Management reporting and cash flow analysis in Excel

Understanding UK Bank Statement Formats

Date Formats

UK banks use DD/MM/YYYY or DD MMM YYYY date formats (e.g., "15/01/2026" or "15 Jan 2026"). This is the opposite of the US MM/DD/YYYY format, which is why generic tools often misinterpret UK dates. StatementKit correctly recognises UK date formats and standardises them.

Currency and Amount Formatting

UK statements use the pound sign (£) for GBP amounts, with commas as thousands separators and a period for decimals (e.g., £1,234.56). Some statements use separate Paid In / Paid Out columns, while others use a single Amount column with positive/negative values.

UK Transaction Types

• Faster Payments — Real-time bank transfers (replaced CHAPS for most personal transfers)
• Direct Debits — Recurring automated payments for bills, subscriptions, council tax
• Standing Orders — Fixed recurring payments set up by the account holder
• BACS — Salary payments, government benefits (Universal Credit, pension)
• Contactless / Card payments — Debit card purchases
• Open Banking transfers — Payments initiated through third-party apps

Bank-by-Bank Format Guide

Barclays

Barclays statements include Date, Description, Money Out, Money In, and Balance columns. Barclays Online Banking provides PDF downloads from the Statements section. The format is clean and tabular.

HSBC UK

HSBC statements show Date, Payment Type, Description, Paid Out, Paid In, and Balance. HSBC online banking offers PDF downloads. HSBC's multi-line descriptions can be tricky for basic converters, but StatementKit handles them correctly.

Lloyds Banking Group (Lloyds, Halifax, Bank of Scotland)

Lloyds group statements use Date, Description, Type, Money In, Money Out, and Balance. Internet Banking provides statement downloads. All three brands (Lloyds, Halifax, Bank of Scotland) use a similar format.

NatWest / RBS

NatWest statements include Date, Description, Type, Value, Balance. NatWest Online Banking provides PDF downloads. The format includes transaction type codes (DD for Direct Debit, SO for Standing Order, etc.).

Wise (formerly TransferWise)

Wise generates per-currency statement PDFs from its multi-currency account. Statements include Date, Description, Amount, Running Balance, and currency information. See our Wise conversion guide for specific details.

Digital Banks (Monzo, Starling, Revolut)

These newer banks provide clean PDF statements with standard columns. Monzo includes detailed merchant categories, Starling provides both GBP and EUR statements, and Revolut generates multi-currency statements similar to Wise.

Step-by-Step: Convert Any UK Bank Statement

1. Download your PDF statement from your bank's online banking or mobile app.
2. Upload to StatementKit — sign up for free and upload the PDF file.
3. Review the extracted transactions — verify dates, amounts, and descriptions.
4. Download as CSV or Excel — choose the format for your needs.
5. Import into your accounting software — upload to Xero, FreeAgent, Sage, or QuickBooks.

Importing Into UK Accounting Software

Importing into Xero

Xero is the most popular cloud accounting software in the UK:

1. Go to Accounting > Bank Accounts
2. Select your bank account
3. Click Import a Statement
4. Upload the CSV from StatementKit
5. Map columns and confirm the import

Importing into FreeAgent

FreeAgent is popular with UK freelancers, contractors, and sole traders:

1. Go to Banking
2. Select your bank account
3. Click Upload a Bank Statement
4. Upload the CSV file and map the columns
5. FreeAgent will attempt to auto-categorise transactions

Importing into Sage

Sage is widely used by UK accountants:

1. Go to Banking > Import Statement
2. Select the bank account
3. Upload the CSV file
4. Map the date, description, and amount columns
5. Import and categorise

HMRC and Making Tax Digital

Making Tax Digital (MTD)

HMRC's Making Tax Digital programme requires businesses to maintain digital records. Converting bank statements to CSV and importing them into MTD-compatible software (Xero, FreeAgent, Sage, QuickBooks) is one of the simplest ways to maintain compliant records.

Self Assessment

For sole traders and individuals with Self Assessment obligations, structured bank data makes it easy to:

• Separate business income from personal transactions
• Identify and categorise allowable business expenses
• Track mileage and travel expenses
• Prepare your SA103 (Self-Employment) supplementary pages

VAT Returns

VAT-registered businesses need to track output VAT (on sales) and input VAT (on purchases). StatementKit's automatic transaction categorisation helps identify VAT-relevant transactions for your quarterly VAT return.

Tips for UK Users

• Tax year runs 6 April to 5 April — download statements covering this period for Self Assessment.
• Check DD/MM vs MM/DD dates — after conversion, verify that "03/04/2026" is correctly interpreted as 3 April (UK format), not 4 March (US format).
• Building societies count too — Nationwide, Skipton, Leeds, Yorkshire, and Coventry building societies are all supported.
• Digital bank statements — Monzo, Starling, and Revolut PDFs work the same as high street bank statements in StatementKit.
• Multi-currency accounts — if you use Wise or Revolut for multiple currencies, download and convert each currency's statement separately.

Related Resources

• UK Bank Statement Converter — our dedicated tool page for UK banks
• Wise Statement Converter — specific guide for Wise multi-currency accounts
• How to Reconcile Bank Statements in Xero
• Bank Statement to CSV — general conversion guide