Two ways to get Barclays transactions out
Barclays gives you two different things, and they solve different problems:
| PDF statement | CSV transaction export | |
|---|---|---|
| What it is | The official statement for a statement period | A download of the transaction list on screen |
| Where | Online Banking and the Barclays app | Online Banking |
| History | Up to 7 years (Online Statements) | The date range you search |
| Best for | Accountants, mortgage and visa applications, year-end, audits | Quick checks of the last few weeks |
| Spreadsheet-ready? | No, it's a PDF | Yes, but not in a statement layout |
If a CSV of transactions is all you need, use it. If you need the official statement for a period, with its opening and closing balances, or a file your accountant will accept as matching what the bank issued, start from the PDF.
How to download a Barclays PDF statement
In Online Banking
- Log in to Barclays Online Banking.
- Open your profile and go to My Barclays documents.
- Select the statement you need, then download it as a PDF.
In the Barclays app
- Open the app and tap Help/More.
- Choose Statements.
- Select the statement and download or share the PDF.
If you receive Online Statements, they stay available for up to 7 years while the account is open. For a closed account, they stay available for up to 5 years as long as you still bank with Barclays. That usually covers what an accountant or a year-end needs without ordering paper copies.
How to export Barclays transactions as CSV
- Log in to Online Banking and select the account.
- Open the account's transactions and set the date range you need.
- Use the export option and choose CSV.
Why the CSV often isn't enough
- It's a transaction list, not a statement. Accountants, lenders and auditors usually want the official statement.
- It doesn't line up with statement periods. The export covers whatever date range you searched, not the statement period with its opening and closing balances, which makes reconciliation harder.
- It's one account at a time. Bookkeepers handling several accounts or clients repeat the process for each one.
Converting a Barclays PDF statement
Copying a Barclays PDF into Excel by hand, or pasting it straight in, usually breaks: descriptions wrap onto two lines, money in and money out collapse into one column, and the balance column misaligns.
AI Bank Statement reads the statement the way it is laid out:
- Upload one or several Barclays PDF statements. Batch upload handles a year of monthly statements at once.
- Pick the output: Excel, CSV, JSON, Xero CSV, or QuickBooks 3- or 4-column CSV.
- Download a file with one transaction per row: date, description, money out, money in and balance in separate columns.
UK conventions are kept: dates are read day-first, amounts stay in pounds, and the running balance column lets you check each row against the statement.
Getting Barclays data into Xero or QuickBooks
If Barclays isn't connected to your accounting software through a bank feed, or the feed is missing a period, import the converted statement instead:
- Xero: choose Xero CSV, then import it as a bank statement for the matching Barclays account.
- QuickBooks: choose the 3- or 4-column CSV that matches your QuickBooks import settings, then upload it from file.
This is also how bookkeepers fill gaps when a bank feed breaks or a client only sends PDFs.
Barclaycard statements
Barclaycard is managed separately from Barclays current accounts, with its own online servicing and app. Its statements are credit card statements, and they convert the same way with the credit card statement converter: upload the PDF and choose your output.