Bank Statement Kit logo Bank Statement Kit Convert PDF
Barclays

Convert your Barclays statement to CSV or Excel

Upload your Barclays statement and get a clean, structured spreadsheet in seconds.

Upload your Barclays PDF PDF up to 20MB or 50 pages

First conversion free · No sign-up needed · PDF never stored

Balance-checked

Every conversion is reconciled against the statement's own printed totals.

Processed in memory

Your PDF is parsed and discarded. It is never written to disk.

Up to 50 pages

Handles multi-month statements up to 50 pages or 20MB per upload.

How it works

  1. STEP 1

    Upload the PDF

    Drop in the statement. Password-protected files are unlocked with the password you supply.

  2. STEP 2

    Rows are extracted

    Dates, descriptions, amounts and running balance are read into the seven standard columns.

  3. STEP 3

    Download the CSV

    Open it in Excel, Google Sheets, QuickBooks or Xero.

Built for the quirks of Barclays statements

A Barclays statement prints five columns — Date, Description, Money out, Money in and Balance — and two of its habits catch converters out. Money out and Money in are separate columns rather than one signed figure, so the direction of every payment lives in horizontal position alone; lose the column geometry and a year of spending reads as income. And there is no separate reference or transaction-type column: the payment type and the payee reference both sit inside Description, which is why that field runs long and wraps onto a second line under a narrow column. The Balance column is the other trap, because Barclays prints it only against the last transaction of each day rather than on every row.

What the output looks like

Seven standard columns VERIFIED
DateNarrationReferenceValue DateDebitCreditBalance
01/04/2025Opening balance01/04/202512,480.00
03/04/2025Card payment - groceryREF4482103/04/202564.2012,415.80
07/04/2025Salary creditREF4490307/04/20253,200.0015,615.80
12/04/2025Standing order - rentREF4501012/04/2025950.0014,665.80

Illustrative rows. Every conversion is checked so that opening + credits − debits = closing.

Your statement stays yours

Never stored

The PDF is processed in memory and discarded when the conversion finishes.

Proven, not guessed

Output is labelled VERIFIED, DISCREPANCY or FAILED so you know what you got.

30-day history

Past conversions are kept for 30 days and you can delete them at any time.

Scans handled

Scanned or photographed statements fall back to OCR automatically.

Questions

Barclays lets me export transactions already — why convert the PDF?

Because the export only covers what you can still see when you are logged in. Statements you were emailed or saved years ago, an account you have since closed, a joint account you no longer hold, or a PDF a client sent you all arrive as documents rather than data. Converting the PDF is the path when there is no live export to run.

Does this handle Barclaycard statements too?

Yes — a Barclaycard credit card statement is a PDF and goes through the same upload. The layout differs from a current account: purchases, payments and interest are grouped rather than run as one ledger, and there is no running account balance, so verification falls back to the statement's printed totals.

How do I know nothing was dropped from my Barclays statement?

Every conversion is reconciled against the figures Barclays itself printed. Because the Balance column appears only on the last transaction of each day, the check runs against those end-of-day balances and against the opening and closing balances for the period, rather than expecting a balance on every row. The result is labelled VERIFIED, DISCREPANCY or FAILED, and a DISCREPANCY points at the day where the numbers stop agreeing so you can check it yourself.

Try it on your next statement

Your first conversion is free — no account needed. Pro is /month for high-volume, month-end work.

Convert your Barclays statement

Prefer the long version? Read the full Barclays statement to CSV guide, including Barclays's own export options.

Convert another bank's statement

HSBCStatement to CSV →Lloyds BankStatement to CSV →NatWestStatement to CSV →All banksBrowse every supported bank →