How to Convert Barclays UK Bank Statement to Excel

How Barclays UK statements are structured

Barclays UK personal current account statements use Date, Payment type, Description, Money out, Money in, and Balance columns — six columns where most banks use five. The Payment type column contains two or three-character codes: FPO (Faster Payment Out), FPI (Faster Payment In), DD (Direct Debit), SO (Standing Order), BGC (Bank Giro Credit), CHQ (Cheque), ATM, VIS (Visa debit card). These codes are enormously useful for categorizing transactions but they add a sixth column that most generic converters either ignore (merging payment type into the description) or misread (treating it as a separate transaction column that shifts all subsequent values). Barclays Faster Payment descriptions are among the longest in UK banking. An outbound Faster Payment entry reads: the recipient name, followed by their Sort Code in nn-nn-nn format, followed by their account number, followed by any payment reference the sender included. A typical entry like 'JOHN SMITH 20-00-00 12345678 RENT OCT' can reach 50-60 characters. Standing order and Direct Debit descriptions add a mandate reference number and originator ID. These long descriptions wrap to continuation lines in the PDF, and the continuation line has the Payment type column blank — causing converters to create a phantom row with a blank payment type and no amount. Barclays prints the account's opening balance for the page at the top of every continuation page, formatted as a row with the date of the last transaction from the previous page, the text 'Balance brought forward', and the balance amount. This row appears in exactly the same position and format as a real transaction. Converters that do not detect the 'Balance brought forward' description pull it in as a credit transaction equal to the running balance — typically the largest single 'transaction' in the export. Barclays Platinum and Premier account statements add a Relationship Summary block on the first page showing all linked products (savings accounts, ISAs, mortgages) with their current balances. This multi-row summary table contains account numbers and balance figures that converters extract as transaction amounts. CleanStmt identifies the six-column Barclays layout, maps the payment type code to its own column in the Excel output, reconstructs wrapped descriptions, excludes balance-brought-forward rows, and filters the Relationship Summary from Premier account PDFs.

Compare with similar statement converters

Browsing alternatives in the same category helps teams choose the right conversion workflow for each statement source.

Related conversion use cases

• Convert PDF Statements to Excel for Bank Reconciliation
• Convert Bank Statements to QuickBooks-Ready CSV
• Convert Scanned Invoices to QuickBooks CSV
• Scanning Invoices into QuickBooks Without Manual Entry
• Scan Receipts to Excel — Turn Any Receipt into a Spreadsheet
• Convert Invoice PDFs to Excel — Extract Line Items Automatically
• Convert Credit Card Statements to Excel
• Convert Bank Statement PDF to OFX — Import into Quicken & Accounting Software
• Convert Bank Statement PDF to IIF — Import into QuickBooks Desktop
• Convert PDF Bank Statement to Excel
• Convert Bank Statement to Google Sheets
• Angus Cheng Bank Statement Converter Alternative
• Bank Statement to Tally Prime Converter
• CSV Bank Statement — Clean Format for Accounting Tools
• Convert Multiple Bank Statements to Excel — Batch Processing
• Bank Statement Excel Converter — Clean Spreadsheet Output
• Bank Statement CSV Format — Standard Structure Explained
• Bank Statement to CSV Converter — Free Online Tool
• Bank Statement to PDF Converter — Searchable PDF from Scans
• Convert Bank Statement to Excel — Free Instant Conversion