How to Convert a Barclays Statement to Excel, Xero or QuickBooks

Barclays Online Banking and the app show recent activity, and Open Banking feeds pull it into Xero or QuickBooks — until the feed drops, the account is closed, or you need a prior year that the feed never covered. Then you're left with PDF statements. Here's how to convert a Barclays statement PDF into Excel, CSV, or a Xero/QuickBooks-ready file, scanned copies included.

Get your Barclays statement PDF

1. Sign in at barclays.co.uk (or the Barclays app).
2. Open the account and go to Statements / Documents.
3. Choose the statement period and download the PDF. Barclays keeps several years of statements online.

Barclays Business accounts work the same way.

Convert it

1. Open Convert Bank Statements and drop the Barclays PDF in.
2. Every transaction is extracted automatically — no template setup.
3. Check the balance badge: Balanced means opening balance + money in − money out equals the printed closing balance.
4. Export as Excel, CSV, OFX, or QuickBooks .QBO and import into Xero, Sage, or QuickBooks.

Barclays-specific tips

• Open Banking gaps are the whole point. Feeds cover recent activity only; anything older, or a lapsed connection, is PDF-only — exactly the catch-up scenario this is built for.
• Dates as DD/MM/YYYY. UK statements and UK Xero/Sage expect day-first dates; the export keeps them consistent so the import doesn't shift every transaction.
• Barclaycard credit-card statements convert with correct charge/payment polarity.
• Scanned or photographed statements work too; the balance check catches OCR misreads. See the scanned statement guide.

Is it accurate?

Every account is reconciled the way a bookkeeper would check it. If a row breaks the math, it's flagged for review instead of silently exported. Details on our security page.

FAQ

Does this work for Barclaycard statements? Yes — Barclays current accounts, savings, business accounts, and Barclaycard, digital or scanned.

Which format for Xero? OFX imports with the least mapping; CSV works with a one-time column map.

Is my data safe? Your PDF is never stored and never used to train AI. See our Privacy Policy.

How much does it cost? 15 free pages on sign-up. Page packs start at $12 and never expire. See pricing.

Convert a Barclays statement now →

Related guides

• Convert an HSBC statement
• Import a bank statement PDF into Xero
• Import a bank statement into Sage
• Convert a scanned bank statement (OCR)

---

Not affiliated with or endorsed by Barclays. Barclays and Barclaycard are trademarks of Barclays Bank PLC. Xero is a trademark of Xero Limited; QuickBooks of Intuit Inc.