UK · Barclays statements · Free up to 10 pages
Barclays Bank Statement to Excel Converter
Convert Barclays current account and business statement PDFs into Excel or CSV, with Money out and Money in kept in separate columns and UK day-month dates handled correctly.
Drop your bank statement here, or browse
PDF, scanned PNG / JPG / TIFF · up to 50 MB
Choose Barclays Bank Statement- Encrypted upload (HTTPS)
- Auto-deleted in 24h
- Never used for AI training
- Debits, credits & balances in separate columns
- Running balance checked against your statement
- Scanned and password-protected PDFs supported
Export to
- Excel
- CSV
- QuickBooks
- Xero
- Quicken
11–30 pages: free preview, $10 to download · 30+ pages: free account. See pricing
Built for accountants, bookkeepers, small businesses & analysts
- Free per statement, no signup
- 10 pages
- Free per statement, no signup
- Per statement with a free account
- 200 pages
- Per statement with a free account
- XLSX, CSV, QBO, OFX, QIF & PDF
- 6 formats
- XLSX, CSV, QBO, OFX, QIF & PDF
- Until guest uploads are deleted
- 24 hours
- Until guest uploads are deleted
How to Convert Barclays Bank Statements to Excel
Three steps, about a minute. Works with digital PDFs, scanned statements and phone photos.
- Step 1
Download the PDF from Barclays
In Online Banking or the Barclays app, open the account's statements and download the period you need as a PDF.
- Step 2
Upload it here
Money in and Money out are read into separate columns, UK dates are interpreted correctly and the running balance is checked.
- Step 3
Download Excel, CSV or OFX
Use the spreadsheet for your records, or download OFX or CSV for Xero, FreeAgent, QuickBooks or Sage.
Before & After: Your Barclays Bank Statement Data
Messy Barclays Bank Statement text becomes clean, verified Excel output.
Copy-paste from a PDF
Before15/08/2026 BGC SALARY CREDITS CORP 3450.00 7820.40
18/08/2026 DD BRITISH GAS ENERGY 145.20 7675.20
20/08/2026 TFL TRAVEL CHARGE LONDON 8.90 7666.30
Amounts and balances merged into one line, no debit/credit split, nothing verified.
Finlyzers output
Balances verified| Date | Description | Debit | Credit | Balance |
|---|---|---|---|---|
| 15/08/2026 | BGC SALARY CREDITS CORP | — | £3,450.00 | £7,820.40 |
| 18/08/2026 | DD BRITISH GAS ENERGY | £145.20 | — | £7,675.20 |
| 20/08/2026 | TFL TRAVEL CHARGE LONDON | £8.90 | — | £7,666.30 |
Separate debit and credit columns, clean descriptions, running balance reconciled.
Built for Barclays Bank Statements
Understands real statement layouts, not just generic PDF tables.
Money In and Money Out
Barclays' separate Money out and Money in columns are preserved as numeric Debit and Credit columns.
UK Date Order
Day-month dates are read as UK dates, so 03/04 is 3 April rather than 4 March.
Page-Break Balances Handled
Brought forward and carried forward lines are balances, not transactions. If one were counted by mistake, the balance check would flag it.
GBP Amounts Cleaned
Pound signs and thousands separators are removed so amounts can be totalled straight away.
Export Barclays Statements to Other Formats
Each export uses the headers your software expects, so imports work the first time.
Excel (.xlsx)
Sort, filter and total transactions in Excel or Google Sheets
CSV (.csv)
Plain-text rows for accounting imports, budgeting apps and scripts
QuickBooks (.qbo)
Web Connect file for QuickBooks Online and Desktop
OFX (.ofx)
Statement import for Xero, GnuCash and other OFX apps
Quicken (.qif)
Records for Quicken, Moneydance and older desktop software
Converting Barclays Statements to Excel
Barclays statements list transactions with separate Money out and Money in columns, a running Balance, and descriptions that often wrap onto a second line for card payments and direct debits. Copying them into a spreadsheet tends to merge those columns, and US-style software can swap the day and month. Finlyzers keeps the columns separate and reads dates the UK way.
How a Barclays Statement Is Laid Out
- Header: account name, sort code, account number and statement period.
- Summary: start balance, money in, money out and end balance for the period.
- Transaction table: Date, Description, Money out, Money in and Balance.
- Page breaks: many UK statements repeat the balance at the top and bottom of each page as brought forward and carried forward lines. These are balances, not transactions. They are excluded from the transaction list, and the running balance check would flag one that slipped in.
Reading UK Statement Descriptions
UK statements use short codes in transaction descriptions. The exact wording varies by bank, but common ones include:
- DD: Direct Debit, such as utilities or council tax.
- SO: Standing Order, a fixed regular payment you set up.
- BGC: Bank Giro Credit, often salary or other incoming credits.
- FPI / FPO: Faster Payment in and out.
- CHQ or TFR: cheque or transfer.
Keeping these codes in the description column makes it easy to filter by payment type in Excel.
Built for UK Bookkeeping
- Money out and Money in stay as separate numeric columns.
- Multi-page and annual statements are processed with the balance checked page to page.
- Accounting imports: download OFX or CSV for Xero, FreeAgent, QuickBooks or Sage.
- Common uses: Self Assessment records, landlord income and expenses, mortgage applications and month-end reconciliation for limited companies.
Converting a Barclaycard or other card statement? Use the credit card converter. For paper statements, try the scanned statement converter. Banking elsewhere in the UK? See the guides for HSBC, Lloyds, NatWest and Santander.
Updated . Finlyzers is an independent tool and is not affiliated with or endorsed by Barclays. Statement layouts described here can change; always check the converted figures against your statement.
Is It Safe to Upload My Barclays Bank Statement?
Financial documents deserve better than a generic file converter.
Encrypted in transit
Every upload travels over HTTPS (TLS) to our servers and processing service.
Auto-deleted in 24 hours
Guest uploads and their results are deleted automatically 24 hours after upload.
Passwords never stored
Protected PDFs are unlocked for processing only.
Never used for AI training
Your statements are not shared or used to train models.
Related Converters
View all convertersFinlyzers vs Manual Entry vs Generic PDF Converters
| Feature | Finlyzers | Manual entry | Generic converter |
|---|---|---|---|
| Time for a 10-page statement | Typically seconds | 45–60 minutes | Minutes, plus cleanup |
| Debit & credit columns | Split automatically | Manual sorting | Merged / single column |
| Balance check | Automatic | Calculator | None |
| Password-protected PDFs | Supported | Manual unlock | Usually fails |
| Scanned PDFs & photos | OCR included | Retype by hand | Limited |
| Export formats | XLSX, CSV, QBO, OFX, QIF, PDF | Excel only | Basic CSV |
Barclays Bank Statement to Excel Converter FAQ
Common questions about converting Barclays Bank Statements.
Where do I find Barclays statements?
Sign in to Barclays Online Banking or the Barclays app, choose the account and open its statements section. Select the period and download the PDF. Menu names can differ slightly between personal and business banking.
Can I import a Barclays statement into Xero?
Yes. Download the OFX file from the same upload, then in Xero open the bank account, choose Manage Account and Import a Statement. CSV works too if you prefer to map columns yourself.
Does it work with Barclays business accounts?
Yes. Business current account statements use the same Money out, Money in and Balance layout, and multi-page or annual statements are processed in one upload.
Will the dates import correctly into UK software?
Dates are read in UK day-month order. When you import the CSV, make sure your software is set to day-month as well, which is the default in most UK editions.
Ready to Convert Your Barclays Bank Statement?
Upload a PDF and download clean transactions in seconds. Statements up to 10 pages are free.
PDF, scans & photos Excel, CSV, QBO, OFX, QIF Auto-deleted in 24h