What statement periods are supported?

Barclays Online Banking gives access to up to 7 years of historic statements. The converter accepts any single PDF up to 100 pages, which covers 12+ months of typical personal-account activity or 4–6 months of a high-volume Barclays Business account.

How are credits versus debits represented in the CSV?

Barclays PDFs use Money Out and Money In columns; the CSV mirrors them as two unsigned positive columns. Barclaycard credit-card statements use a single signed Amount column (purchases positive, payments negative) — both schemas are output exactly as Barclays formats them so the totals match the PDF.

How do I map this CSV into Xero, QuickBooks, or Sage?

Xero: Bank Accounts → Import Statement → Generic CSV, map Money Out → Spent, Money In → Received. QuickBooks: select 'Three-column CSV'. For Barclaycard import, map the Amount column directly and tick 'Multiply credits by -1' if your software treats credits as positive.

Does this handle Barclays Business Premium Account statements?

Yes — the layout is the same as standard Barclays Business Banking, just with a different page header that's stripped automatically.

What about old Woolwich or Standard Life Bank PDFs migrated to Barclays?

Statements issued under the Barclays brand work. Pre-migration legacy formats are not officially supported but typically extract cleanly via the generic PDF-to-CSV tool.

Convert Barclays PDF Statements to CSV

Barclays UK statements come as PDFs with a distinctive Money In / Money Out two-column layout and a separate balance column on the right. This converter is tuned for that exact format — Barclays personal current account, Barclays Premier, Barclays Business Banking, and Barclaycard — and produces a CSV that imports straight into Xero, QuickBooks, Sage, or FreeAgent without manual cleanup.

Tuned for the Barclays statement layout

Barclays uses one of the cleaner statement designs of the UK high-street banks, but the PDF still confuses generic extractors. Transaction descriptions often wrap across two lines, the date column is left blank for same-day transactions, and BACS, Faster Payment, and CHAPS references are appended to the description rather than separated. This tool re-stitches multi-line descriptions, fills forward the missing date for same-day rows, and keeps payment-method tags intact so VAT and supplier matching stays accurate downstream.

Barclays Premier and Wealth statements use the same underlying layout with extra branding panels and a relationship manager footer — both are stripped automatically. Barclaycard statements are handled separately: the converter detects the credit-card schema (transaction date, posting date, description, amount, foreign currency amount where present) and outputs a CSV with FX rate and original currency preserved as extra columns when relevant.

Real Barclays use cases this tool handles well

Bookkeepers reconciling Barclays Business accounts in Xero use this whenever the bank feed misses a few days, which still happens periodically with Barclays' Open Banking connection. A monthly PDF download plus a 30-second conversion fills the gap with no risk of duplicating transactions, because Xero deduplicates on date plus amount plus description.

Sole traders and contractors use the Barclaycard converter for expense reports — Barclaycard's web export is limited to recent months, but the PDFs go back years. Convert, filter for business expenses in Excel, and you've got a finished expense claim or a Self Assessment audit trail.

Property landlords with multiple Barclays accounts (one per property is a common setup) batch-convert all of them into separate CSVs, then concatenate in Excel for a unified annual rent-and-expenses ledger.

CSV schema and accounting-software compatibility

Output columns: Date (DD/MM/YYYY), Description, Money Out, Money In, Balance. For Barclaycard statements an extra Foreign Currency Amount and Foreign Currency columns are added when the underlying transactions include FX. The header row matches Xero's expected statement-import format exactly, so you can skip the column-mapping step. QuickBooks Online users should select 'Three-column CSV' on import.

How it works

Upload Barclays PDF — Personal, Premier, Business, or Barclaycard
Extract Transactions — Date, payee, money in/out, balance
Download CSV — Drag straight into your accounting tool

Key benefits

Built for Barclays personal current account layout
Handles Barclays Business Banking statements
Supports Barclaycard credit card PDFs
Money In and Money Out columns separated cleanly
Running balance preserved for audit
Files auto-deleted after 1 hour

Common use cases

Bookkeeping for Barclays business customers
Reconciling Barclaycard expenses
Preparing Self Assessment returns

Frequently asked questions

What statement periods are supported?: Barclays Online Banking gives access to up to 7 years of historic statements. The converter accepts any single PDF up to 100 pages, which covers 12+ months of typical personal-account activity or 4–6 months of a high-volume Barclays Business account.
How are credits versus debits represented in the CSV?: Barclays PDFs use Money Out and Money In columns; the CSV mirrors them as two unsigned positive columns. Barclaycard credit-card statements use a single signed Amount column (purchases positive, payments negative) — both schemas are output exactly as Barclays formats them so the totals match the PDF.
How do I map this CSV into Xero, QuickBooks, or Sage?: Xero: Bank Accounts → Import Statement → Generic CSV, map Money Out → Spent, Money In → Received. QuickBooks: select 'Three-column CSV'. For Barclaycard import, map the Amount column directly and tick 'Multiply credits by -1' if your software treats credits as positive.
Does this handle Barclays Business Premium Account statements?: Yes — the layout is the same as standard Barclays Business Banking, just with a different page header that's stripped automatically.
What about old Woolwich or Standard Life Bank PDFs migrated to Barclays?: Statements issued under the Barclays brand work. Pre-migration legacy formats are not officially supported but typically extract cleanly via the generic PDF-to-CSV tool.