How to Convert Barclays Statements to CSV or Excel

Why Convert Barclays Statements?

Barclays is one of the UK's 'Big Four' banks, with over 20 million UK customers and a comprehensive range of current accounts, savings products, and Barclaycard credit cards. Barclays' monthly PDF statements are used by millions of UK taxpayers, small business owners, and accountants for bookkeeping, VAT returns, and HMRC Self Assessment. Barclays statements have a distinctive format with transaction codes and reference numbers that can make manual spreadsheet entry confusing. BankRead's AI parser understands Barclays' specific UK statement layout and pulls out clean, structured transaction data.

Understanding the Barclays Statement Format

Barclays current account statements use a portrait PDF with transactions listed in a table showing Date, Description (including payment type and reference), Money Out, Money In, and Balance. The header shows the sort code, account number, and statement period. Barclaycard credit card statements display an account summary followed by transaction details with Date, Description, and Amount. Barclays business account statements follow the same general layout with additional reference numbers. All amounts are in GBP (£).

How to Convert with BankRead

Follow these steps to convert your Barclays PDF statement to CSV or Excel:

1. Download your statement, export a spreadsheet, or take a photo — Get the PDF from your Barclays online banking portal (see steps below), export transactions as CSV or Excel, or snap a photo of a paper statement with your phone.
2. Upload to BankRead — Drag and drop the PDF, CSV, Excel, or image on your BankRead dashboard. On mobile, tap "Take Photo" to capture directly with your camera.
3. AI processes your statement — BankRead's AI reads every transaction from text PDFs, spreadsheets, scanned documents, or photos — extracting dates, descriptions, and amounts, then categorizing automatically.
4. Review the extracted data — Check the transaction table on screen to verify the data looks correct. AI categorization is applied automatically.
5. Export to CSV or Excel — Click the export button to download your clean, structured data as a CSV or Excel file.

How to Download Your Barclays Statement PDF

1. Log in to Barclays Online Banking at barclays.co.uk or open the Barclays app.
2. Select the account from your accounts overview.
3. Go to 'Statements' or 'Manage statements' in the account options.
4. Select the statement period you want to download.
5. Click 'Download PDF' to save the statement to your device.

What Data Gets Extracted

BankRead extracts the following fields from your Barclays statement:

• Transaction date (DD/MM/YYYY format)
• Description / payee and reference (e.g., 'CARD PAYMENT TO TESCO STORES 1234')
• Money out amount (debits, card payments, standing orders)
• Money in amount (salary, credits, refunds)
• Running balance (£)
• AI-assigned category (e.g., Supermarkets, Transport, Salary, Dining)

Export Options

Once your Barclays statement is processed, you can export the data in two formats:

• CSV (Comma-Separated Values) — Ideal for importing into accounting software like QuickBooks, Xero, Wave, or FreshBooks. Compatible with virtually any spreadsheet application including Google Sheets.
• Excel (.xlsx) — Ready-made spreadsheet with formatted columns and headers. Great for custom analysis, pivot tables, VLOOKUP formulas, or sharing with your accountant.

Tips for Barclays Statements

• Barclays statements use 'Money Out' and 'Money In' column headers — BankRead maps these to standard Debit and Credit columns in the export.
• Barclaycard statements are supported alongside current account and savings statements.
• Barclays Pingit and Barclays Transfer transactions include reference details in the description — these are preserved in the output.
• Multi-page statements are handled in a single upload. Business accounts with high volumes may span 5+ pages.
• Barclays Premier and Wealth account statements follow the same format as standard current accounts.

Common Issues and Solutions

• Barclays card payment descriptions often include merchant category codes or truncated names. BankRead's AI uses the available description text to assign meaningful categories.
• Barclays statements may include a 'Summary of Interest' section at the end of the statement — this is not duplicated as individual transactions.
• Barclaycard statements with balance transfer promotional rates show the transfer as a single transaction. Interest breakdowns are in the summary section, not the transaction list.

Frequently Asked Questions