Bank Statement Conversion for UK Limited Companies — Complete Guide 2026

It's 10pm. The CT600 deadline is three days away. You're staring at four different company bank accounts — trading, savings, deposit, and a foreign currency account — each with a PDF statement from a different bank in a different format. Your accountant emailed asking for "the transactions in Excel, please" three days ago and you've been putting it off because you know it's going to take hours. Again.

If you're a UK limited company director, company secretary, or the accountant for one, this scenario isn't hypothetical. It plays out every month, and especially every corporation tax season. Limited companies are different from sole traders in one critical way: you're almost never dealing with just one bank account. And the moment you have two or more accounts — each with its own bank format, its own quirks, and its own reconciliation requirements — the complexity doesn't double. It multiplies.

This guide covers everything you need to convert limited company bank statements to clean, usable Excel — from single-account setups to the multi-account, multi-bank reality most limited companies actually face. If you need a working solution right now, skip to Method 1: BankScan AI — it processes every UK bank format and handles multiple accounts in one batch.

Stop wasting billable hours manually typing company bank statements into Excel. Every hour you spend copying and pasting is an hour you're not growing your business, seeing your family, or sleeping. And if you're an accountant, it's an hour you can't bill to higher-value work.

Why Limited Company Statements Are Different (and Harder)

If you've ever converted a personal bank statement to Excel and thought "that wasn't too bad," then tried the same with a limited company — you already know they're different beasts. Here's what makes company statements uniquely difficult:

1. Multiple Accounts, Multiple Banks, Multiple Formats

A typical UK limited company runs at least two accounts: a trading current account where day-to-day business happens, and a savings or deposit account for tax reserves and retained profits. Many also have a foreign currency account, a director's loan account, and sometimes a dedicated VAT account. Each account may be with a different bank — HSBC for the trading account, Barclays for savings, Wise for foreign currency — and each bank's PDF format is different. What works for converting your HSBC business statement will not work for your Barclays savings statement. You either learn multiple conversion methods or find one tool that handles them all.

2. Director Transactions Need Special Handling

Every payment between the company and its directors — salary, dividends, expense reimbursements, director's loans — has tax implications. A dividend payment needs to be tracked for the dividend voucher and CT600. A director's loan withdrawal triggers s455 corporation tax if not repaid within nine months of the year-end. Manual conversion makes it dangerously easy to miss these transactions or mislabel them, creating a compliance headache your accountant will charge you to untangle.

3. Longer Statements with More Transaction Complexity

Limited company statements are typically longer than personal ones — 20 to 80+ pages is not unusual for a busy month, especially for businesses with significant supplier payments, customer receipts, and payroll runs. Each page adds to the conversion time. And company transactions often include VAT (which needs to be separated for your VAT return), inter-account transfers (which need to be identified and netted out), and batch payments (where one debit covers multiple supplier invoices).

4. Statutory Record-Keeping Requirements

Under the Companies Act 2006, limited companies must retain accounting records — including bank statements — for at least six years. You can't just convert and discard the originals. But having clean Excel versions alongside your PDF archives gives you searchable, analysable data that makes audit preparation, tax enquiries, and due diligence immeasurably easier. The conversion isn't a replacement for the original — it's the working copy that makes the original usable.

Method 1: Convert Company Statements with BankScan AI (Recommended)

BankScan AI was built for this exact scenario. It's trained on the statement formats of 16+ UK banks — from HSBC's multi-line descriptions to Barclays' invisible characters to Monzo's clean-but-cryptic CSV exports — and handles them all through a single upload flow. For limited companies, the bulk upload feature is the game-changer: drop every account statement into one batch and get consistent Excel output across all of them.

1. Upload all company statements at once — Drag every PDF (trading account, savings, deposit, foreign currency) onto the BankScan AI dashboard. The AI auto-detects which bank each statement came from and applies the correct parsing rules.
2. Let the AI handle the format differences — HSBC's grouped dates get filled down. Barclays' invisible characters get stripped. Lloyds' multi-column layouts get normalised. Every statement comes out in the same clean five-column format regardless of the source bank.
3. Download as a unified workbook — Export all accounts to a single Excel file with separate tabs per account, or individual CSVs for importing into Xero, QuickBooks, Sage, or FreeAgent.

Best for: Limited company directors processing monthly statements across multiple accounts. Accountants managing multiple limited company clients. Anyone who values their evenings and doesn't want to learn four different bank conversion methods.

Method 2: Online Banking CSV Exports (One Bank at a Time)

Most UK business bank accounts offer CSV transaction exports through their online banking platform. Log in, select your date range, hit export. In theory, this is the path of least resistance. In practice, you're dealing with three problems:

Problem 1: CSV quality varies wildly by bank. HSBC's CSV may have multi-line descriptions wrapping across rows. Barclays' CSV may include invisible non-breaking space characters that break Excel's number formatting. Lloyds' CSV may put debits and credits in the same column using positive/negative notation that your accounting software doesn't recognise. Each bank's CSV needs its own cleanup routine — and if your company banks with three different providers, you're maintaining three different cleanup processes.

Problem 2: Not every account offers CSV. Business savings accounts, deposit accounts, and foreign currency accounts often restrict exports to PDF-only. You might get a clean CSV from your trading account and a 40-page PDF from your savings account — forcing you into a mixed-method workflow.

Problem 3: CSV exports don't flag company-specific needs. A raw CSV won't tell you which transactions are director-related, which are inter-account transfers, or which include VAT. You still need to manually review and annotate every line for your accountant or CT600 preparation.

Best for: Single-account limited companies that bank with a provider offering reliable CSV exports. Falls apart the moment you add a second account or a second bank.

Method 3: Accounting Software Bank Feeds

Xero, QuickBooks, Sage, and FreeAgent all offer direct bank feeds via Open Banking. When they work, they're excellent — transactions flow automatically into your accounting software with no manual conversion. But bank feeds aren't a complete solution for limited companies:

• Not all banks support Open Banking feeds. Some business accounts, particularly with smaller or specialist banks, don't offer direct feeds. You're back to manual conversion for those accounts.
• Feeds don't cover historical statements. If your accountant needs the last 12 months of transactions and you've only just connected the feed, you still need to convert the historical statements manually.
• Feed categorisation is basic. Bank feeds auto-categorise transactions, but they won't flag director's loan movements, inter-account transfers, or VAT-bearing transactions with the precision your CT600 needs.
• Multiple accounts mean multiple feed setups. Each account needs its own feed configuration. For a company with trading, savings, and foreign currency accounts, that's three setups to maintain and three feeds to monitor for disconnections.

For a longer discussion, read our guides to importing bank statements into Xero, QuickBooks, Sage, and FreeAgent.

Best for: Day-to-day transaction capture once feeds are set up. Doesn't replace the need for periodic bulk statement conversion — especially at year-end.

Method 4: Manual Copy-Paste

We won't spend long on this because, honestly, if your limited company has more than one bank account and more than 50 transactions a month, manual copy-paste is a false economy. In the time it takes to manually convert one 30-page business statement, you could batch-process every company account through an automated tool and have the evening back.

The maths is brutal: a 40-page business statement with 300 transactions takes roughly 45–60 minutes to manually copy, paste, clean up, and verify. A company with two such statements per month is losing 20–24 hours a year — per account. At the average UK accountant's hourly rate of £40–£80, that's £800–£1,920 of billable time vanishing into data entry every year.

Best for: One-off, very short statements (under 20 transactions) when all other options are unavailable. Not a viable strategy for ongoing company bookkeeping.

Conversion Methods: At a Glance

Handling Multi-Account Reconciliations

Multi-account reconciliation is the part most conversion guides skip — and it's the part that causes the biggest headaches for limited companies. When money moves between company accounts (trading to savings, savings to foreign currency, director's loan account back to trading), you need to track those movements or your books won't balance.

Step 1: Convert All Accounts to a Uniform Format

Start by converting every company bank statement to the same output format. Whether you use BankScan AI, CSV exports, or another method, the key is consistency: all accounts should produce the same columns (date, description, money in, money out, balance) in the same order. This is where using one tool for all accounts pays off — BankScan AI normalises every UK bank's format to the same five-column layout automatically.

Step 2: Identify Inter-Account Transfers

Scan all converted statements for transfers between company accounts. These are the transactions that appear as a debit in one account and a credit in another. Flag them. They need to be excluded from your income/expense totals because they're not real income or real expenses — they're just money moving between pots. Missing this step inflates both your income and your expenses, giving you and your accountant a distorted picture of the company's actual performance.

Step 3: Separate Director Transactions

Create a separate tab or filter for all transactions involving directors: salary payments, dividend withdrawals, expense reimbursements, and director's loan account movements. This isn't just good practice — it's essential for your CT600 corporation tax return. Your accountant needs to see these transactions clearly separated from the company's trading activity to calculate the correct corporation tax position.

Step 4: Verify the Consolidated Balance

Add up the closing balances across all accounts. This is your company's total cash position. Cross-reference it against your previous month-end figure and your accounting software's balance sheet. If the numbers don't tie, you've either missed an inter-account transfer or a transaction didn't convert correctly.

Preparing Bank Statements for Corporation Tax (CT600)

Corporation tax preparation is where clean bank statement conversion pays for itself. The CT600 requires you to report your company's profits — and those profits are calculated from your transactions. Messy data at the statement level means messy calculations at the CT600 level, which means either more accountant time (higher fees) or errors (HMRC enquiries).

Here's what your accountant actually needs from your converted statements:

1. Complete transaction data from every company account — trading, savings, deposit, foreign currency, director's loan account. No gaps, no missing pages, no "I'll get that statement later" omissions.
2. Director transactions clearly flagged — salary, dividends, expense reimbursements, and loan account movements all identified and separated from trading activity.
3. Inter-account transfers netted out — so your accountant doesn't accidentally treat a transfer to savings as an expense.
4. VAT-bearing transactions identifiable — so your accountant can reconcile against your VAT returns and ensure the corporation tax computation uses net figures.
5. Large or unusual transactions explained — any payment over £1,000 that isn't self-explanatory from the payee name should have a brief note. Your accountant will ask about it anyway; save them the email.

Providing this as a structured Excel file rather than a stack of PDFs is one of the single most valuable things you can do for your accountant — and for your year-end bill. For a practical guide to year-end preparation, read our year-end bank statement processing guide.

Common Problems (and How to Fix Them)

"My company banks with three different providers and they all export differently"

This is the most common complaint we hear from limited company directors and their accountants. The fix: use a single conversion tool that handles all UK bank formats. BankScan AI is trained on 16+ UK bank statement layouts — HSBC, Barclays, Lloyds, NatWest, Santander, Monzo, Starling, Revolut, Tide, Nationwide, Halifax, TSB, Metro Bank, Chase UK, Virgin Money, Co-operative Bank, Bank of Scotland, and First Direct — so you upload everything through one interface and get consistent output regardless of the source.

"I can't tell which payments are director-related and which are trading"

After conversion, sort your transactions by payee/description column and filter for: your own name, "salary," "dividend," "DLA," or any reference code your payroll provider or accountant uses. Create a separate tab for these transactions. If the payee description is unclear (some banks use cryptic reference codes), cross-reference against your payroll records or dividend vouchers. A clean converted spreadsheet makes this filtering take minutes rather than the hour-plus it takes when hunting through PDF pages.

"Inter-account transfers are inflating my totals"

This is the classic limited company bookkeeping error. You transferred £5,000 from trading to savings — it appears as a £5,000 debit in one account and a £5,000 credit in another. If you don't net these out, your totals show an extra £5,000 in both income and expenses that doesn't actually exist. After conversion, use Excel's conditional formatting or a simple SUMIF to identify matching amounts that appear in both accounts. Flag them as "Inter-account transfer" and exclude them from your P&L calculations.

"My foreign currency account statements are in euros — Excel doesn't handle the conversion"

Foreign currency accounts add another layer of complexity. You either need to convert at each transaction date's spot rate (accurate but time-consuming) or use a period-average rate (simpler but less precise). After extracting the transaction data to Excel, add a column for the GBP equivalent and apply the appropriate rate. For most UK limited companies, the period-average rate published by HMRC is acceptable for corporation tax purposes, but check with your accountant. For deeper guidance, see our multi-currency bank statement handling guide.

Frequently Asked Questions

Why are limited company bank statements harder to convert than personal ones?

Limited companies rarely have just one bank account. A typical setup includes a trading current account, a savings account, and sometimes a foreign currency account or director's loan account — each potentially with a different bank and each producing statements in its own format. Company statements are also longer (20–80+ pages versus a personal account's 2–6 pages), include VAT-bearing transactions that need separation, and require director transaction tracking for CT600 compliance. The multi-account, multi-bank reality means you're not solving one conversion problem — you're solving several, all at the same time, under time pressure.

How do I reconcile multiple company bank accounts for corporation tax?

Start by converting every account's statements to a uniform format. Use one tool that handles all your banks consistently — BankScan AI normalises 16+ UK bank formats to the same clean five-column layout. Then: (1) identify and net out inter-account transfers, (2) separate director transactions (salary, dividends, DLA movements), (3) flag VAT-bearing transactions for your VAT return reconciliation, and (4) verify the consolidated balance across all accounts matches your accounting software. The key is consistency — when every account outputs the same format, the reconciliation becomes a structured process rather than a detective hunt. See also our reconciliation speed guide and 7 reconciliation tips for UK bookkeepers.

What's the best way to handle director's loan account transactions in bank statements?

Director's loan account transactions need careful tracking because of the s455 CTA 2010 corporation tax charge — if a loan to a director isn't repaid within nine months of the year-end, the company pays 33.75% tax on the outstanding amount (reclaimable when the loan is repaid). After converting your statements to Excel, filter by payee for the director's personal account, sort by description for salary/dividend reference codes, and create a separate DLA tab. Every transaction flowing between company and director — in either direction — should be recorded there. For accountants, having this pre-separated saves significant time during CT600 preparation. For companies using BankScan AI, the exported Excel makes this filtering and separation straightforward across all accounts simultaneously. Related reading: our director's loan account bank statement guide.

Can BankScan AI handle multiple company bank accounts at once?

Yes — and this is where it earns its keep for limited companies. The bulk upload feature accepts statements from every company account in a single batch. Drag in the HSBC trading account PDF, the Barclays savings PDF, the Wise foreign currency statement, and the Monzo deposit account PDF all at once. BankScan AI detects each bank's format automatically, applies the correct parsing rules, and outputs everything to a single Excel workbook with separate tabs per account — or individual CSVs for importing into your accounting software. Accountants managing multiple limited company clients can process dozens of statements in minutes rather than hours. For deep dives on specific banks, see our guides on HSBC, Barclays, Lloyds, and all UK bank formats.

How do I prepare limited company bank statements for my accountant?

Most accountants don't want a pile of PDFs — they want clean, organised data. Convert every company statement to Excel, group by account (separate tabs or clearly labelled files), and flag: director transactions, inter-account transfers, VAT-bearing items, and any unusual payments over £1,000. Providing this as structured Excel rather than raw PDFs typically cuts bookkeeping time by 50–70%, which directly reduces your accounting fees. BankScan AI's bulk conversion makes this preparation step take minutes — upload all accounts, download one organised workbook, send it to your accountant. For the full year-end workflow, read our year-end bank statement processing guide.

What bank statement format do Companies House and HMRC require?

Neither requires a specific file format — they require accurate, complete records. Companies House expects you to retain original bank statements as part of your statutory records under the Companies Act 2006 (s386), for at least six years. HMRC requires accurate transaction data for corporation tax (CT600) and VAT returns. Converting statements to Excel doesn't replace the originals — it creates a working copy for analysis, categorisation, and tax computation. Best practice: retain original PDFs for the statutory period, use Excel versions for day-to-day bookkeeping and tax preparation. The Excel version is your working tool; the PDF archive is your compliance evidence. See also our guides on MTD compliance and HMRC audit preparation.

Last updated: 29 July 2026. BankScan AI supports 16+ UK bank formats — browse our complete UK bank statement formats guide or explore all blog posts for UK accountants, bookkeepers, and limited company directors.