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

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.

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

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

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

Before

15/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
DateDescriptionDebitCredit
15/08/2026BGC SALARY CREDITS CORP—£3,450.00
18/08/2026DD BRITISH GAS ENERGY£145.20—
20/08/2026TFL TRAVEL CHARGE LONDON£8.90—

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.

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.

Finlyzers vs Manual Entry vs Generic PDF Converters

FeatureFinlyzersManual entryGeneric converter
Time for a 10-page statementTypically seconds45–60 minutesMinutes, plus cleanup
Debit & credit columnsSplit automaticallyManual sortingMerged / single column
Balance checkAutomaticCalculatorNone
Password-protected PDFsSupportedManual unlockUsually fails
Scanned PDFs & photosOCR includedRetype by handLimited
Export formatsXLSX, CSV, QBO, OFX, QIF, PDFExcel onlyBasic 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