Convert Barclays statements to Excel & CSV

Turn Barclays Bank UK PLC PDF statements into clean spreadsheets or accounting imports in seconds. The conversion runs on your device, so your Barclays statement is never uploaded.

Drop Barclays bank statement PDFs here

or choose files · multiple files OK · scanned PDFs & photos supported

Select PDF statements
  • 🔒 Never uploaded
  • ∞ Free & unlimited
  • ✓ Balance-checked
Online·Preparing offline mode…·
  • Your PDF never leaves your device
  • Unlimited pages, no signup
  • Works offline
  • Every row balance-checked

Barclays statement format at a glance

Date, Description, Money out, Money in and Balance columns, with the date usually printed only once for each day's group of transactions.

BankBarclays Bank UK PLC
Country United Kingdom
CurrencyGBP
Typical date formatDD MMM
Statements supportedCurrent account, Savings, Business current account, Barclaycard credit card
Export toExcel, CSV, Xero, QuickBooks, FreeAgent, Sage, OFX, QIF, JSON

How to download your Barclays statement as a PDF

  1. Sign in to Barclays Online Banking or the Barclays app.
  2. Select the current or savings account you need.
  3. Open the statements area for that account (Barclaycard credit card statements are managed separately).
  4. Choose the statement month and download the PDF, rather than printing the transactions screen.

Menu names change from time to time. If you can’t find statements, search your online banking help for “e-statements”.

Tips for converting Barclays statements

  • Barclays statements typically group rows by day, so only the first payment of each day carries a date. Before exporting, confirm in the preview that every row has a date — a blank date will make most accounting imports fail.
  • Card payment descriptions often include an 'On DD MMM' fragment showing when you actually paid, which can be a day or two earlier than the posting date in the Date column. Keep it in the description if you need the true spend date.
  • Barclaycard statements are a separate PDF with their own credit card layout. Convert them on their own and post them to a credit card account in your books, not to the current account.
  • Running several Barclays accounts? Batch-convert the statements with one sheet per file so savings interest and current account spending stay apart.

Helpful guides

How the conversion stays accurate

When your Barclays statement prints a running balance, pdf2statement replays every transaction against it and compares opening balance + money in − money out with the closing balance. Rows that don’t reconcile are highlighted before you export, which catches the classic problems of manual copy-paste: missed lines, merged descriptions and flipped signs.

FAQ

Barclays statement conversion FAQ

Why do some rows in my Barclays statement have no date?

Barclays prints the date once per day and leaves it blank for later transactions on the same day. That date applies to every row until the next date appears, so it needs to be filled down before the data goes into Excel, QuickBooks or Xero.

Can I convert a Barclaycard statement as well as my current account?

Yes. A Barclaycard PDF converts the same way, but remember it is a credit card statement: purchases increase what you owe and payments reduce it. Import it into a credit card account rather than your bank account.

My converted Barclays statement doesn't reconcile. What should I look at?

Start with the highlighted rows. The usual culprits are a description that wrapped across a page break, or a balance line that was read as a transaction. Compare those rows with the PDF and fix them in the preview before exporting.

Is it safe to convert my Barclays statement here?

Yes. Your Barclays PDF is converted inside your own browser and never uploaded, so pdf2statement never receives your account number, balances or transactions. You can confirm this by converting with your internet connection switched off.

Can I convert Barclays credit card statements too?

Yes. Credit card statements are detected automatically. Purchases become money out and payments or refunds money in, and you can export a credit card OFX/QBO for accounting software.

Convert your Barclays statement now

Free, unlimited and private. No signup, no upload, no catch.

Choose PDF statements