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
- 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.
| Bank | Barclays Bank UK PLC |
|---|---|
| Country | United Kingdom |
| Currency | GBP |
| Typical date format | DD MMM |
| Statements supported | Current account, Savings, Business current account, Barclaycard credit card |
| Export to | Excel, CSV, Xero, QuickBooks, FreeAgent, Sage, OFX, QIF, JSON |
How to download your Barclays statement as a PDF
- Sign in to Barclays Online Banking or the Barclays app.
- Select the current or savings account you need.
- Open the statements area for that account (Barclaycard credit card statements are managed separately).
- 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
- PDF statement to Excel: every method compared
- Import Barclays transactions into QuickBooks
- Import Barclays statements into Xero
- Reconcile a bank statement in Excel
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.
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.
Other banks in United Kingdom
Convert your Barclays statement now
Free, unlimited and private. No signup, no upload, no catch.
Choose PDF statements