pdftoexcel

Convert your Barclays statement to Excel

Barclays Bank Account, Premier, Barclaycard, and Business Banking statements. Drop a PDF and get back a verified XLSX, CSV, or QBO in seconds.

How the Barclays conversion works

  1. 1. Drop your Barclays Bank UK PDF — monthly statement or a combined multi-month export, up to 25 MB. Password-protected PDFs work too.
  2. 2. Parse & reconcile — every transaction is extracted and the sum is checked against ending balance minus beginning balance within $0.01.
  3. 3. Download XLSX, CSV, or QBO — one click each, or batch up to 10 statements and download them as a single ZIP.

What a Barclays statement PDF looks like

Sections in the PDF
Your account summary · Payments in · Payments out · Charges · Daily balances
Transaction date format
DD MMM YY
Products we've parsed
Barclays Bank Account, Barclays Premier Account, Barclays Wealth, Rainy Day Saver / Everyday Saver, Barclaycard Platinum / Rewards / Avios, Barclays Business Banking

Barclays UK current-account statements use a two-block signed layout (Payments in / Payments out) with a daily-balance summary at the end. The parser merges the two blocks into one date-sorted stream and cross-checks the reconstructed running balance against each printed daily balance. UK-standard DD MMM YY date format (e.g. 15 Mar 24) is normalised to ISO on export.

Barclaycard credit-card statements close on a cycle date with Purchases / Payments and credits / Interest sections. These flow through the LLM path; each cycle reconciles against the printed new balance. GBP is preserved as the currency tag so the QBO exporter doesn't accidentally convert.

Business banking statements share the personal layout with an added Fees section — the same pipeline parses them without a separate extractor.

Supported Barclays statement types

We handle checking, savings, credit-card, and business PDFs from Barclays Bank UK.

  • checking
  • savings
  • credit-card
  • business

Frequently asked questions

Does it handle UK DD/MM date format correctly?
Yes. Barclays prints dates as 'DD MMM YY' (e.g. 15 Mar 24) — the parser normalises to ISO YYYY-MM-DD on export, so your spreadsheet sorts chronologically even across the UK tax-year boundary.
Will it convert Barclaycard credit-card PDFs?
Yes. Barclaycard statements (Platinum, Rewards, Avios) use the standard cycle-based layout — the LLM pass extracts merchant + category per row, and reconciliation against the printed new balance gives a Verified / failed signal per cycle.
What about Barclays Business Banking statements?
Yes. The business layout matches personal current accounts closely, with an added Fees section for service charges. The same pipeline handles both — no separate extractor needed.
Are GBP amounts preserved correctly?
Yes. Currency is detected from the statement header (usually 'GBP') and carried through to the XLSX / CSV / QBO export. No accidental conversion to USD happens anywhere in the pipeline.

Other banks we convert