Two files, two different jobs
Barclays keeps your official monthly statements as PDFs. That is the document to hand over when someone needs proof of income or address. Separately, Online Banking can export the raw transaction list as a data file — and Barclays is one of the few UK banks that gives you three accounting formats rather than one: CSV, OFX and QIF.
If the goal is to work out where the money actually goes, the transaction export is what you want, not the PDF.
Export your transactions from Online Banking
- Log in to Online Banking in a desktop browser. The export does not exist in the Barclays app.
- Next to the account, select Show recent transactions.
- Scroll to the very bottom of the list and click View all transactions.
- Set a start date and an end date, then click Search.
- Scroll to the bottom again and click Export All.
- Choose CSV, OFX or QIF, then download.
The link is genuinely easy to miss — it sits under the transaction table rather than beside it, which is why a fair number of Barclays customers conclude the bank has no CSV export at all.
Limits worth knowing before you start
The export window covers recent activity: a few months at a time in practice, not years. For anything older, the statement archive holds electronic copies going back to July 2013, under Manage accounts then Statements and documents.
One quirk catches people out. Barclays CSV files often write the date as 15 Dec, with no year at all. If your export straddles a year boundary, fix the dates before importing the file anywhere that will sort on them.
Banking only on your phone? Then the PDF statement is your route: the app has no export option, so you will need a desktop browser at least once.
Among other UK accounts the process is quite different — Monzo and Starling both put a CSV export inside the app itself.
Once you have the CSV, the useful move is reading several months in one pass rather than month by month. Recurring charges hide well in a single statement — a subscription you stopped using, a trial that quietly renewed, a price that crept up twice in a year — and they stand out almost immediately when the months are read together.
