Convert Barclays Bank Statement to Excel
Barclays current account statements use the classic UK layout: Date, Description, Money out, Money in, and Balance. That two-column money format defeats converters built around a single signed amount — this one detects which column each figure occupies and assigns Debit or Credit accordingly, then confirms the sign against the balance movement on the same row. Dates are read as DD/MM, so 04/03 stays 4 March rather than becoming 3 April.
Download statements from the Barclays app (tap the account → Statements) or Online Banking under Statements & documents; Barclays keeps several years available as PDFs. Everything below runs in your browser — relevant if you are handling statements under a client engagement letter, since the data never leaves your machine. Rows that fail balance reconciliation are flagged for review and listed on a separate Warnings sheet in the Excel file.
Drop your Barclays statement here (PDF or photo)
Processed entirely on this device — nothing is uploaded. Scans and photos are read with on-device OCR (beta).
Free for your first 5 pages each month · Processed on your device · Balance-verified output
Barclays statement FAQ
How do I download a Barclays statement as a PDF?
In the Barclays app, open the account, tap Statements, choose the period, and download. In Online Banking it is under Statements and documents. Both produce the same PDF layout.
Are Barclays’ Money out / Money in columns preserved?
Yes — Money out maps to the Debit column and Money in to Credit, and each is verified against the Balance column’s movement, so a misread column would be flagged rather than silently exported.
Will UK date formats import into Excel correctly?
Dates are parsed as DD/MM and written in ISO format (YYYY-MM-DD), which Excel interprets unambiguously regardless of your regional settings — no more 12 swapped months.