Convert a Barclays statement
Turn a digital Barclays statement into an import-ready spreadsheet in seconds, checked against its own balances before you rely on it. The file stays on your device from drop to download.
ukbankconv is independent software and is not affiliated with, endorsed by, or connected to Barclays Bank UK PLC.
Certified for this layout
barclays-personal-classic · parser v1.0.0 · certified 16 July 2026
- Digital personal current-account statements downloaded from Barclays online banking or the app
- Multi-page statements with repeated column headers
- Start balance and End balance summary rows
- Wrapped payee descriptions across up to three lines
- Negative (overdrawn) balances
Refused, with a reason
These cases produce an unsupported message, never guessed rows.
- Scanned or photographed statements (no reliable text layer)
- Password-protected PDFs
- Barclaycard and business statement layouts (not yet certified)
- Statements printed before the current column layout
Current certification results
- Exact row recall
- 100.00%
- Amount accuracy
- 100.00%
- Date accuracy
- 100.00%
- False verified
- 0 of 48
Measured through the full pipeline on a synthetic corpus replicating the Barclays digital layout, including corrupted fixtures that must never verify. Methodology and all numbers on the accuracy page.
What the export contains
The statement’s columns (Date, Description, Money out £, Money in £, Balance £) become Date, Description, Money out, Money in, Amount, and Balance. CSV exports offer generic accounting, Xero, and FreeAgent presets with UK or ISO dates; Excel exports use real currency and date cells with a frozen header, filters, and an optional Conversion checks sheet recording exactly which checks passed.
Checks performed: every printed running balance transition, opening plus credits minus debits against the closing balance, declared statement totals where printed, and per-row direction consistency.
Known failure modes
- Statement exported as an image
- Some third-party tools re-save statements as scanned images. The converter reports these as having no text layer; download the original PDF from Barclays instead.
- Summary boxes misread as rows
- The At a glance totals are parsed as declared totals and checked against the rows, never emitted as transactions. If Barclays changes that box, reconciliation catches the drift.
Barclays questions
Verified on this page always means the deterministic checks passed on your statement, in your browser. It is never a marketing badge.