PDF2TEXT
Try a statement free

Convert Barclays bank statements to Excel or CSV

Barclays shows Online Statements as PDFs and keeps them viewable for up to seven years while the account is open. That's useful history, but it isn't a spreadsheet. This page is for sole traders, landlords and bookkeepers who need those transactions in Excel, CSV or accounting software, whether for Self Assessment, a mortgage broker or a quarter's reconciliation.

Private workspace. HTTPS upload. No credit card needed.

$9 for 25 pages, one-off, no subscription. See pricing

98% of numbers correct on 82 hand-checked pages How we measure

How to get your Barclays statement into Excel

  1. Download the PDF statement from Barclays online banking

    • Log in to Barclays Online Banking or the Barclays app.
    • Online, go to 'My Barclays documents' under your profile; in the app, tap 'Help/More', then choose 'Statements'.
    • Choose the statement you need; Online Statements are displayed as PDFs.
    • Save the statement for the period you need as a PDF.
    Go to Barclays Online Banking

  2. Upload it here

    Scans and phone photos work too.

  3. Download Excel, CSV, or QuickBooks and Xero CSV

    Check the rows against the statement, then export.

Sample result

Your Barclays statement in Excel

Made-up sample rows, not a real statement.

sample-statement-2026-01.xlsx Jan 2026 · GBP
Sample bank statement rows with made-up data, amounts in GBP
Date Debit Credit Balance
2026-01-02 Salary - Example Employer Ltd 2,500.00 3,500.00
2026-01-05 Card payment - Sample Grocery Co 120.00 3,380.00
2026-01-09 Rent - Placeholder Properties 1,200.00 2,180.00
2026-01-14 Transfer from savings 300.00 2,480.00
2026-01-20 Utility bill - Demo Energy Co 80.00 2,400.00
2026-01-27 Card payment - Fictional Coffee Co 15.00 2,385.00

Statement notes

What to know about Barclays statements

The 'At a glance' box

The first page carries an 'At a glance' summary right next to the transactions. Copy-paste merges its totals into the transaction columns, which is how a monthly total ends up looking like a payment. The conversion keeps that summary out of the rows, so only real transactions reach your spreadsheet.

Dates without a year

Transaction dates can appear as day and month only, such as '15 Mar'. The year is taken from the statement period and every date is written as YYYY-MM-DD. A statement running from December into January gets both years right, which matters when income is split across tax years.

DR means overdrawn

Barclays' own list of abbreviations includes DDR for Direct Debit, STO for standing order, BGC for bank giro credit and BBP for bill payment. DR is the one to watch: it marks a debit balance, meaning the account was overdrawn at that point. When you review the converted file, check that those balances read as negative numbers.

Seven years open, five years closed

Online Statements can be viewed for up to seven years while the account stays open. If you've closed an account but still bank with Barclays, its statements remain available for up to five years. Save the PDFs you'll need before they drop out of that window.

Output and review

From Barclays PDF to your books

Accounting tip

Xero can't import a PDF statement, but it does take CSV, and the Xero-ready file already has the single signed Amount column Xero expects, income positive and spending negative. Import it into the matching bank account in Xero, and only bring in months your bank feed doesn't already cover.

  • Checked before export

    Opening balance plus transactions is checked against the closing balance. Duplicate or missing periods are flagged.

  • Export formats

    Excel, CSV, JSON, or QuickBooks and Xero CSV.

  • Private workspace

    HTTPS uploads, kept private until you ask support to delete them.

FAQ

Barclays statement questions

My client gets Barclays statements quarterly. Does that change anything?
No. Customers can choose weekly, monthly, quarterly, six-monthly or yearly statements, so the periods vary from one client to the next. The converter reads each statement's own period and, across a batch, flags any gap or overlap, whatever the frequency.
Will the 'At a glance' figures end up in my spreadsheet?
No. That summary sits beside the transactions on the first page and is the usual reason copy-paste goes wrong. It's left out of the transaction rows, so what you get is dates, descriptions, signed amounts and balances.
Why do some Barclays dates have no year?
The date column can show just the day and month, with the year given by the statement period at the top. The converter fills in the year from that period, so '15 Mar' on a statement for March 2025 becomes 2025-03-15 in your file.
Can I import converted Barclays rows into QuickBooks or Xero?
Yes. Review the rows, then export a QuickBooks or Xero CSV.

Convert your Barclays statement to Excel

Private workspace. HTTPS upload. No credit card needed.

More Bank Statement Converters

View all 98 bank pages

pdf2text is independent and not affiliated with or endorsed by Barclays.