UK bank statements to Excel — in seconds
Built for HSBC UK, Barclays, Lloyds, NatWest, Santander UK, Monzo, and Starling. Faster Payments, BACS, CHAPS, and HMRC entries stay distinct — and self-assessment becomes a copy-paste.
Kashfbank reads PDF statements from HSBC UK, Barclays, Lloyds, NatWest, Santander UK, and the digital challengers Monzo, Starling, and Revolut. UK statements are among the cleanest globally for automated parsing — the FCA's Open Banking mandate since 2018 means transaction categories are largely machine-readable from major providers, and PSD2 compliance has driven strong standardization.
Bank of England (BoE) + Financial Conduct Authority (FCA) + PRA
Income tax 20–45%; National Insurance 8–12%; 20% VAT (reduced 5% for certain goods); self-assessment deadline Jan 31; Corporation Tax 25% for profits over £250K.
Apr 6 – Apr 5 (personal tax year); Jan–Dec (corporate)
Supported Banks in United Kingdom
Faster Payments, BACS, CHAPS, and Direct Debit — kept distinct
UK statements distinguish between BACS (the rail for salary and recurring credits, three-day settlement), Faster Payments (instant transfers, the dominant P2P rail), CHAPS (high-value same-day transfers), and Direct Debit (pre-authorized recurring debits). Each appears with its own descriptor in your PDF — and each survives the conversion as its own row. You can filter BACS CR for payroll, FPS for transfers, or DIRECT DEBIT for subscriptions in Excel without manual cleanup.
Salary entries from a BACS credit show 'BACS CREDIT EMPLOYER NAME' with the employer reference. Self-employed income often arrives as Faster Payments from business accounts. Kashfbank preserves the sender name and reference on both, so 12 months of income deposits pull as a clean table for an HMRC self-assessment filing or a mortgage application.
HMRC self-assessment, 20% VAT, and the £90K threshold
HMRC self-assessment requires freelancers and the self-employed to reconcile every income deposit — Faster Payments, BACS, PayPal, Revolut, Stripe payouts — by 31 January each year. Kashfbank's Excel output gives you a categorized monthly view across 12 statements: date, amount, sender/merchant, transaction type, debit/credit. That is what a UK accountant asks for first, and it is what HMRC expects to see if they raise a query.
VAT at 20% applies once your business crosses the £90,000 annual registration threshold (raised from £85,000 in April 2024). Once you are registered, every output VAT line and every input VAT line on a business statement matters. The CSV preserves descriptors so you can split the VAT-eligible rows in a working file. HMRC SAAS entries — self-assessment tax payments to HMRC — stay tagged so you can pull tax payments for the year with one filter.
Common Merchant Labels
| Label | Meaning |
|---|---|
| BACS CR | BACS direct credit (salary/payroll) |
| FPS | Faster Payment Scheme transfer |
| DIRECT DEBIT | Pre-authorized recurring debit |
| HMRC SAAS | Self-assessment tax payment to HMRC |
Regulatory Notes
FCA Open Banking mandate (since 2018) means all major UK banks offer standardized API access. PSD2 compliance drives strong transaction data standardization. UK statements are among the cleanest globally for automated parsing.
Frequently Asked Questions
Which UK banks does Kashfbank support?
Every major UK bank we have tested against: HSBC UK, Barclays, Lloyds, NatWest, Santander UK, Halifax, TSB, and the digital challengers Monzo, Starling, and Revolut. If your bank issues a text-layer PDF statement, we can read it.
Will Faster Payments and BACS stay distinct in the output?
Yes. BACS CR (salary, three-day settlement), FPS (Faster Payments, instant), CHAPS (high-value same-day), and DIRECT DEBIT each appear as their own row with the bank's original descriptor. You can filter each independently in Excel.
Is the output usable for HMRC self-assessment?
It gives you the raw rows your accountant asks for first: date, amount, sender or merchant name, transaction type, debit/credit. You or your accountant still categorize business versus personal income and expenses. Spot-check totals against the source PDF before submitting your return.
Does it work with Monzo, Starling, and Revolut exports?
Yes. The challenger banks issue near-perfect text-layer PDFs from their apps, and Kashfbank reads them with the same accuracy as the high-street banks. Revolut multi-currency statements work too — each currency stays in its own column.
Convert United Kingdom Bank Statements
Upload your PDF and get Excel in seconds
Convert a UK statement10 free credits on signup
Common Payment Apps
Salary Conventions
Salary via BACS, appearing as 'BACS CREDIT EMPLOYER NAME' on the last working day of the month. Self-employed income often shows as Faster Payments from business accounts.