Barclays PDF to Excel: Money In, Money Out, sort codes
Barclays only sends statements as PDFs. If you need the rows in Excel for a tax return, a landlord-income spreadsheet, or your accountant, the PDF has to be converted. Here is the workflow for Barclays current accounts and Barclaycard, with the UK quirks handled.
Why this is annoying (the manual way)
Open the PDF, select a few rows, paste into Excel. The sort code "20-00-00" and account number from the header drop into the first data row. Money In and Money Out columns merge into one cell. The per-line running balance, which Barclays prints on every row, gets pulled into the wrong column on rows that wrap. For a 12-page statement, cleanup takes 15 to 20 minutes plus a reconcile check.
The 30-second method with Bank2XL
Bank2XL is a Chrome extension. One drag, one click.
- Install Bank2XL from the Chrome Web Store at bank2xl.app
- Download the PDF from Barclays Online Banking or the Barclaycard portal
- Click the toolbar icon
- Drag the statement onto the drop zone
- Click "Convert to Excel" and download the .xlsx or .csv
Free during beta: 10 statements a day, no signup. A Barclays current-account PDF converts in 25 to 45 seconds.
What about Barclays format quirks
Barclays statements have UK conventions that throw off generic tools:
- Dates are DD/MM/YYYY. A US-built converter reads 03/12/2026 as 12 March. Bank2XL detects the UK locale from the sort code and parses dates correctly.
- The header has a sort code (XX-XX-XX) plus an 8-digit account number, different from US routing + account format. Both go into account metadata.
- Money In and Money Out appear as separate columns instead of a signed Amount. Bank2XL maps these to debit and credit so the same template works for UK and US output.
- Every transaction row carries a running Balance, not just the opening and closing pair. Bank2XL keeps that value per row so the printed and extracted figures match.
- Barclaycard credit-card statements have a different layout from current accounts (separate Payments and Transactions sections, reverse-polarity balance). Bank2XL detects the statement type and switches logic.
When to use the alternatives
- Manual copy-paste. Fine for one statement. A year of monthlies for self-assessment is a different story.
- Adobe Acrobat Pro Export to Excel. Works on current accounts most of the time. Barclaycard layouts confuse the table detection.
- Template-based converters. Accurate on the exact Barclays layout they were tuned for. Barclaycard refreshed its statement design in 2024 and template tools needed updates. We work without per-bank rules, so layout changes do not break extraction.
FAQ
Is the upload secure? My statement has my sort code and account number. The PDF goes to the extraction backend over HTTPS. We process files in memory, auto-delete within 24 hours, and you can opt out in Settings. Details at /data-retention.html. Account numbers are masked in the output by default, and we do not train AI on your content or share it.
Does it work for Barclaycard statements? Yes. Barclaycard uses a different layout from current accounts. Bank2XL detects which it is and applies the right logic, including reverse-polarity balance for cards.
Can it feed into Xero or QuickBooks? Output is .xlsx or .csv with date, description, debit, and credit columns, matching the import templates for both. See our separate guide on importing into Xero and QuickBooks.
Get started
Install Bank2XL from the Chrome Web Store at bank2xl.app. Free during beta: 10 statements a day, no signup. Drop a Barclays PDF, click Convert, get a clean Excel file with DD/MM dates and Money In/Money Out preserved.
Skip the manual cleanup — try Bank2XL free
Drop a PDF, get a clean Excel back. 10 statements per day during beta, no signup, no credit card.