Barclays Bank Statement Converter — PDF to Excel & CSV

How to Convert a Barclays Statement PDF to Excel

How to Download Barclays Statements in CSV Format

If you want to get your Barclays transactions directly as a CSV file (without converting a PDF), Barclays Online Banking has a built-in export feature. Here is the exact process for each platform:

Barclays Online Banking (Desktop)

1. Log in at bank.barclays.co.uk using your surname, membership number and passcode
2. From the account overview, click on the account you want (e.g. Barclays Current Account)
3. In the left sidebar, click Statements & Documents
4. Select the date range you need (up to 3 months maximum for CSV export)
5. Click Export or Download transactions
6. From the format dropdown, select CSV
7. Click Download — the file saves to your Downloads folder

Barclays Mobile App

The Barclays mobile app does not support CSV export. You can view and share transactions as PDF only. To get CSV format from older statements on mobile, download the PDF from the app and then upload it to our converter.

Barclaycard Online

1. Log in at barclaycard.co.uk
2. Click My Barclaycard in the top navigation
3. Click Statements
4. Select the statement period you need
5. Click Download and choose CSV from the format options

Barclays CSV Statement — Column Format Explained

When you download a Barclays CSV statement directly from online banking, it has a specific six-column format. Here is what each column contains:

Notice that the Barclays CSV has no Balance column and uses a single Amount column (negative/positive). Our PDF converter produces separate Debit and Credit columns plus a Balance column, which is what Xero, Sage and QuickBooks expect for bank imports.

Barclays Transaction Codes — What the Prefixes Mean

Every Barclays transaction has a 2–5 letter prefix in the description (visible in both PDF and CSV statements). These codes tell you the payment method used. Here is the complete list:

Barclays Business Banking — Download Statements to Excel

Barclays Business Banking statements have the same PDF format as personal accounts, and our converter handles them identically. However, there are a few things specific to business accounts to be aware of:

Downloading Barclays Business Statements

1. Log in to Barclays Business Online Banking at business.barclays.co.uk
2. Select your business current account from the accounts list
3. Click Statements in the account menu
4. Select the statement period and click View or Download PDF
5. Save the PDF, then upload it to our converter above

What Barclays Business Statements Include

• Business current account transactions with sort code and account number
• Merchant receipts (FPI/BGC) and supplier payments (FPO/BACS/CHAPS)
• Business debit card transactions (VIS prefix)
• Direct Debits for VAT, PAYE, Corporation Tax
• Business savings account transactions if held with Barclays
• Overdraft usage and interest charges (CHG prefix)

Common Business Uses

Import Barclays Statement into Xero, Sage, QuickBooks

Once you have converted your Barclays PDF to CSV or Excel, importing into accounting software is straightforward. Here are the exact steps for each platform:

Import into Xero

1. Convert your Barclays PDF to CSV using the converter above — select CSV format on download
2. In Xero, go to Accounting → Bank Accounts
3. Click on your bank account (or add it if not already connected)
4. Click Import a Statement
5. Select your CSV file and click Next
6. Map the columns: Date, Description, Amount (or Spent/Received if using split columns)
7. Click Import — transactions appear in your Xero bank feed for reconciliation

Import into Sage (Sage 50 / Sage Accounting)

1. Convert your Barclays PDF to CSV format using our converter
2. In Sage Accounting, go to Banking → your bank account → Import Transactions
3. Click Import from File and select your CSV
4. Map the date format (Barclays uses DD/MM/YYYY), description, and amount columns
5. Click Import to bring transactions into Sage for matching

For Sage 50, export as OFX format from our converter and use File → Import → Bank Transactions → select your OFX file.

Import into QuickBooks Online

1. Convert your Barclays PDF to CSV using our converter
2. In QuickBooks Online, go to Banking → Upload from File
3. Select your CSV file and click Next
4. Select the bank account to link the transactions to
5. Map Date, Description, and Amount columns as prompted
6. Click Next then Yes to import — transactions appear in your For Review queue

Import into QuickBooks Desktop

1. Convert your Barclays PDF to QBO format using our converter (select QBO as output format)
2. In QuickBooks Desktop, go to File → Utilities → Import → Web Connect Files
3. Select your downloaded QBO file
4. Choose Use an existing QuickBooks account and select your bank
5. Click Continue — transactions are imported to the Online Banking Centre

HMRC Self-Assessment — Using Barclays Statements

If you are self-employed, a sole trader, or a landlord, your Barclays bank statements are the foundation of your HMRC self-assessment tax return. Here is how to use converted statements effectively:

What HMRC Expects

HMRC does not require you to submit bank statements directly with your self-assessment return (filed online via Self Assessment tax return, SA100). However, you must keep bank statements as supporting records for at least 5 years after the 31 January submission deadline. If HMRC opens an enquiry, they can request full statements going back to the relevant tax year.

How to Filter Business Transactions from Your Barclays Statement

1. Convert your Barclays PDF statements for the full tax year (6 April to 5 April) using our converter
2. Open the Excel file — you will have Date, Description, Debit, Credit, Balance columns
3. Use Excel AutoFilter (Data → Filter) to filter by description keywords (e.g. filter by "BGC" for all income, "DD" for all direct debit expenses)
4. Create a separate sheet for business income (all BGC and FPI credits from clients/customers)
5. Create a sheet for business expenses (DD, SO, FPO, VIS transactions that are business-related)
6. Total each column — these figures feed directly into the SA103 (Self-Employment) or SA105 (UK Property) supplementary pages

Self-Assessment Key Dates

What Your Accountant Needs from Barclays Statements

• Full 12 months of statements for the tax year (April to April), not just calendar year
• Business and personal accounts if business expenses run through personal accounts
• An Excel version is faster for accountants to work with than PDF — provide both
• Highlight any large unusual credits (e.g. property sale proceeds, loan drawdowns) that are not taxable income
• Flag any Barclays business savings interest (INT prefix) as this is taxable

Supported Barclays Account Types

Personal Accounts

Business Accounts

Barclaycard Credit Cards

Barclays PDF vs Barclays CSV Export — What's the Difference?

Barclays Online Banking offers a CSV export, but it has limitations:

How to Download Barclays Statement as PDF

Common Uses for Barclays Statement Conversion

• UK mortgage application: Most UK lenders require 3 months of Barclays statements — export to Excel for clean review
• Self-assessment tax return: Filter business income and expenses from your Barclays current account for HMRC
• Xero or Sage import: Convert to CSV and upload to Xero Manual Bank Statement or Sage Bank Import
• QuickBooks Desktop: Convert to QBO and import via File → Utilities → Import → Web Connect Files
• Annual spending review: Combine 12 months of Barclays PDFs into one Excel file for annual budget analysis
• Universal Credit application: DWP may request recent bank statements — Excel format is easy to share

What the Conversion Looks Like

Here is a real example of how raw PDF bank statement text is transformed into a clean, structured Excel file:

Every column — Date, Description, Debit, Credit, Balance — is extracted and separated automatically. Dates standardised to YYYY-MM-DD. Pound signs removed. Ready for Excel pivot tables, Xero import, QuickBooks, or HMRC self-assessment records.

Frequently Asked Questions