Bank Statement Analyser — Free Online Tool for UK & International Users

What a Bank Statement Analyser Does

A bank statement analyser reads a PDF bank statement and converts the transaction data into a structured, searchable, calculable format. The fundamental problem it solves is that a PDF is a visual document — it is designed for display and printing, not for computation. You cannot sort a PDF by amount, filter transactions by merchant, calculate your total spending on direct debits, or chart your monthly balance trend directly from the PDF. An analyser unlocks all of this by converting the visual data into structured data.

More specifically, a bank statement analyser does the following:

• Identifies the transaction table within the PDF, separating it from headers, footers, account details, and summary information.
• Extracts each individual transaction into a separate row, including date, description, debit amount, credit amount, and running balance.
• Handles multi-line transaction descriptions — where a single payment spans two or more rows in the original PDF — and merges them into one clean row.
• Identifies transaction types: direct debits, standing orders, Faster Payments (FPS), BACS credits, CHAPS transfers, ATM withdrawals, card payments, and interest charges.
• Outputs the structured data in a format (typically Excel or CSV) that allows filtering, sorting, calculation, and charting.

Analyser vs Converter: Understanding the Difference

People sometimes use the terms "bank statement analyser" and "bank statement converter" interchangeably, but they describe subtly different emphases. A converter focuses on format translation — turning a PDF into an Excel or CSV file. An analyser additionally attempts to interpret what the data means: categorising transactions, identifying income vs expenditure, flagging standing orders, and in some cases producing summary statistics.

Bank Statement Engine performs both functions. The conversion step produces the structured Excel file; the analytical step comes from working with that Excel file to identify patterns, calculate totals, and draw conclusions from the data. You can use the Excel output directly in Microsoft Excel or Google Sheets with built-in functions (SUMIF, AVERAGEIF, pivot tables) to perform whatever analysis your situation requires.

UK Banks Supported — Complete Coverage

Bank Statement Engine fully supports all major UK high street banks, digital challenger banks, and building societies. Below is detailed coverage information for each bank.

High Street Banks

Digital and Challenger Banks

Specialist and Premium Banks

For any bank not listed above, the analyser will attempt automatic format detection based on the PDF structure. The vast majority of UK bank statement PDFs use recognisable formats that the system can process correctly even without a specific template.

What the Analyser Extracts From Your Statement

The Excel output from the analyser includes the following data for each transaction:

Income Transactions

Salary credits, employer payments, freelance income, pension credits, benefit payments, interest received, dividends, rental income, and any other credits to the account are extracted and clearly marked as credits. The description field preserves the full transaction reference, which typically includes the payer's name and a payment reference. For BACS salary payments, the employer's name appears in the description; for Faster Payments, the sender's name and reference are preserved.

Regular Outgoings: Direct Debits

Direct debits appear in UK bank statements with a distinctive prefix — typically "DD" or the originator's name followed by a reference number. The analyser identifies these and groups them as direct debits in the transaction type column. Common direct debits include mortgage or rent payments, utility bills (gas, electricity, water), broadband and mobile phone contracts, insurance premiums, gym memberships, streaming services, and loan or credit card repayments.

In Excel, filtering the transaction type column for "Direct Debit" immediately shows all your committed regular outgoings — an essential view for mortgage affordability assessments and personal budgeting alike.

Regular Outgoings: Standing Orders

Standing orders differ from direct debits in that they are initiated by you (the account holder) rather than the payee. Common uses include regular transfers to savings accounts, monthly contributions to ISAs, rent payments to landlords who do not use direct debits, and contributions to family members. UK bank statements typically label these as "SO" in the description. The analyser captures these with the full reference, making it easy to verify all standing orders are still active and for the correct amounts.

Card Payments

Point-of-sale card payments, online purchases, and contactless transactions appear with the merchant name and sometimes a location code. The description format varies by bank: Barclays typically shows "VIS" or "MC" before the merchant name; Lloyds shows the payment type (Visa Debit); NatWest shows the card last four digits. All of these are preserved in the description column in Excel, allowing you to filter for specific merchants or categories.

Faster Payments and BACS Transfers

FPS (Faster Payments Service) transactions are same-day or near-instant bank-to-bank transfers. BACS transfers typically take 2–3 working days. Both appear in UK bank statements, and the description usually includes the sending bank's reference. The analyser extracts the full reference text, which often includes the sender's name and their own reference number.

ATM Withdrawals

Cash machine withdrawals are identified by "ATM", "CASH", or the ATM operator's name in the description. For security reasons, UK banks typically show the town or postcode but not the exact address of the cash machine. The analyser captures the full description as it appears in the statement.

Interest Charges and Fees

Bank charges (monthly account fees, overdraft interest, returned payment charges) and interest credits are captured as separate rows. This is particularly useful for business account holders who need to track bank charges as a legitimate business expense, and for individuals reviewing whether their overdraft usage is costing more than they realised.

How UK Bank Statements Differ from Other Countries

UK bank statements have several formatting and content features that are specific to the British banking system:

Sort Code and Account Number

UK accounts are identified by a 6-digit sort code (formatted as XX-XX-XX) and an 8-digit account number. These appear in the statement header and sometimes in transaction descriptions. The analyser preserves this information in the output metadata rather than mixing it with transaction data.

Transaction Type Codes

UK bank statements use specific codes that do not appear in US or European statements: FPS (Faster Payments), BACS (Bankers' Automated Clearing Services), CHAPS (Clearing House Automated Payment System), SO (Standing Order), DD (Direct Debit), BGC (Bank Giro Credit), TFR (Transfer). These codes are highly useful for categorisation and are preserved in the transaction type column of the Excel output.

Currency

UK statements are denominated in GBP (£). Where international transactions or currency conversions appear, the original currency and conversion rate may appear in the description field. The analyser treats all amounts as GBP unless the description indicates otherwise.

Reference Fields

UK Faster Payments and BACS transfers include a reference field that is set by the sender. This reference can be up to 18 characters and often contains structured information such as an invoice number, a customer reference, or a personal message. This reference appears in the transaction description in UK bank statements and is captured in full by the analyser.

How to Download Your Statement from Major UK Banks

Use Cases for UK Users

HMRC Self-Assessment Tax Return

For self-employed individuals, sole traders, and landlords, the January self-assessment deadline requires calculating total income and allowable expenses for the preceding tax year (6 April to 5 April). Bank statement analysis is an efficient way to verify these figures. By converting 12 months of statements to Excel, you can use SUMIF to total all credits from business clients, filter for specific expense categories (fuel, accommodation, subscriptions, professional fees), and cross-check these figures against your invoices and receipts. The structured Excel data also serves as a useful backup record in the event of an HMRC enquiry.

Mortgage Application

UK mortgage lenders typically request the last 3 to 6 months of bank statements as part of their affordability assessment. Lenders look for evidence of regular salary credits, stable outgoings, no gambling transactions, no returned direct debits, and a spending pattern consistent with the declared income. Converting your statements to Excel before your mortgage appointment allows you to review your statements from the lender's perspective and identify any transactions that might prompt questions — so you can prepare explanations in advance.

Universal Credit Application

When applying for Universal Credit, claimants may be asked to provide bank statements as evidence of their income and savings. Statements showing regular income can affect the amount of Universal Credit received (earnings reduce the standard allowance on a taper rate). Having your statements in Excel format makes it easier to calculate monthly income totals and understand how your earnings will affect your UC calculation.

Business Accounting and VAT Returns

For small business owners, sole traders, and limited company directors, converting business bank statements to Excel is a foundational step in bookkeeping. The Excel output can be used to identify VAT-eligible purchases, reconcile sales against bank credits, prepare Making Tax Digital (MTD)-compliant records, and feed into accounting software such as Xero, QuickBooks, or Sage through CSV import.

Benefit Claim Reviews

Various UK benefits (Housing Benefit, Tax Credits, Council Tax Reduction) require applicants to provide financial evidence. Bank statements are commonly requested. Analysing these in Excel before submission helps ensure the information presented is accurate and consistent with other documentation provided in the claim.

Debt Management and Financial Counselling

Debt advisors and financial counsellors at organisations such as Citizens Advice, StepChange, and National Debtline often ask clients to provide a full picture of their income and outgoings. A client's bank statement in Excel format makes this process far more efficient — the advisor can quickly see total direct debits, identify priority debts (mortgage, council tax, utilities), and calculate the surplus or deficit for a debt management plan.

Output Formats Available

The analyser outputs your structured bank statement data in the following formats:

• Excel (.xlsx): The default format. Compatible with Microsoft Excel, LibreOffice Calc, Google Sheets, and Apple Numbers. Best for personal review, analysis, and self-assessment preparation.
• CSV: Compatible with any software that accepts tabular data, including Xero, QuickBooks, Sage, and custom database imports. Best for importing into accounting software.
• OFX: Open Financial Exchange format, accepted by many accounting platforms including Sage, GnuCash, and some versions of QuickBooks UK.
• QBO: QuickBooks-format OFX, accepted by QuickBooks Online and QuickBooks Desktop UK editions.
• QIF: Legacy Quicken format for older accounting applications.

Frequently Asked Questions