Barclays bank statement to Excel or CSV
Barclays keeps your statements as PDFs in Online Banking and the Barclays app, with an archive going back to July 2013 for most customers. Here's how to find and save them, how to read the transaction codes, and how to convert a statement into a spreadsheet that ties back to the balance.
How to download a Barclays statement
In Online Banking, select Manage accounts, then Statements and documents (Barclays). Barclays' paperless page also describes finding statements under your profile in My Barclays documents, then selecting a document to view, download or print (Barclays). To save, select the PDF icon in the toolbar or use the File menu.
In the Barclays app, tap Help/More on the home page, then Statements, and select a document to view, download or print. Business customers can select Statements from the home page (Barclays).
How far back: Barclays automatically uploaded electronic copies of statements from July 2013. If you registered for Online Statements before then, your archive starts from the date you registered (Barclays). You can view online statements while still receiving paper ones (Barclays).
Barclays reminds you that if you save a statement to your device, you should make sure no one else can access it.
Reading a Barclays statement: the abbreviations
Barclays' own list of common statement abbreviations (Barclays):
| Code | Meaning |
|---|---|
| BBP | Bill payment |
| BGC | Bank giro credit |
| CHAPS | Clearing House Automated Payment System (same-day transfer) |
| CRE | Credit payment |
| DDR | Direct Debit |
| DR | Debit balance (overdrawn) |
| REM | Remittance (a cheque credited that wasn't paid in at your branch or bank) |
| REV | Reversal (a standing order or Direct Debit recalled) |
| STO | Standing order |
| UNP | Unpaid |
Two of these matter more than the rest for conversion:
- DR next to a balance means the account is overdrawn. In a spreadsheet that balance must be negative. A converter that drops the "DR" turns an overdraft into a positive balance and every subsequent running-balance check will fail.
- REV and UNP rows reverse an earlier payment. They're real transactions; keep them, or your totals won't reconcile.
Common pitfalls converting Barclays statements
- Losing the DR marker on overdrawn balances (see above).
- Dates without a year. UK statements commonly print day and month; take the year from the statement period, and watch statements that span December–January.
- Day-first dates. 03/04 is 3 April. If you import a CSV into software set to US dates, every date with a day of 12 or less is silently swapped. Choose DD/MM when the import asks (Xero guide).
- Wrapped descriptions and "balance brought forward" lines at page breaks. Merge the first, delete the second.
- Multiple accounts. Download and convert each account's statement separately so each reconciles to its own balance.
Converting a Barclays statement with Footed
Footed opens the PDF in your browser and sends only the extracted text for parsing, processed in memory and not stored. It treats DR balances as negative and reconciles the result: opening balance + extracted transactions = closing balance, and every row against the printed running balance where there is one. Any row that disagrees is highlighted before you download Excel, CSV or OFX.
FAQ
How far back can I get Barclays statements online? To July 2013 for most customers, or from the date you registered for Online Statements if that was earlier (Barclays).
What software do I need to open a Barclays statement? A PDF viewer; Barclays mentions Adobe Reader as a free option (Barclays).
What does DDR mean on my Barclays statement? Direct Debit. STO is a standing order and BGC a bank giro credit (Barclays).
Can I use a converted Barclays statement for a mortgage? Send the bank's original PDF to the lender; use the spreadsheet for your own review (mortgage guide).
Convert your Barclays statement. Footed keeps the PDF in your browser, handles DR balances correctly, and reconciles every row. Free for 5 pages a day.
Published 2026-10-07.