Convert First Direct Bank Statement to Excel — Complete UK Guide (2026)

It's 10pm. You're finalising a client's quarterly bookkeeping, the First Direct statement PDF is open, and Excel just turned your transaction list into a jumble of cryptic codes. "BP 482917" sits where the payee name should be. The DD MMM YYYY dates won't sort properly. And you've been on the First Direct help page for ten minutes trying to find a CSV export that doesn't exist for this account type.

If this is your Wednesday night, you're in good company. First Direct — consistently voted the UK's best bank for customer service — has over 1.5 million customers, many of them professionals and small business owners. Its statement format is clean, modern, and minimalist. But that very minimalism is what trips up spreadsheet conversions: the metadata that generic converters rely on simply isn't there.

This guide walks through every method to convert a First Direct bank statement to Excel, from manual workarounds that sort-of-work to the one-click approach that actually gets you home before midnight. Whether you're working with sole accounts, joint accounts, or Regular Saver statements, we've covered it.

If you need a quick fix right now, skip to Method 1: BankScan AI — it handles all the formatting problems below in under 30 seconds.

Why First Direct Statements Break Standard Converters

Before we look at solutions, let's unpack what makes First Direct's format uniquely problematic. First Direct is a division of HSBC UK Bank plc — its statements follow the HSBC family layout, but with a deliberate stripped-back design that creates three specific conversion headaches:

1. Minimalist Metadata — The Converters' Achilles Heel

Standard HSBC statements include branch sort codes, full transaction references, and multiple columns of metadata. First Direct removes most of this. The statement shows you what you need as a customer — date, description, money in, money out, balance — and nothing else. The problem: generic PDF-to-Excel converters scan for the rich metadata they expect from bank statements. When it's missing, they misalign columns, merge fields that should be separate, or simply fail to identify the statement as a bank document at all.

2. Abbreviated Telephone Banking Transaction Codes

This is the one that drives bookkeepers up the wall. First Direct started as a telephone-only bank, and its transaction references still reflect that heritage. Instead of full merchant names like "TESCO STORES 2847 LONDON GB," you get codes like "BP 482917" or "DR 29381." BP stands for bill payment, DR for direct debit, CR for credit, SO for standing order. These codes are perfectly readable once you know the system — but they don't help you categorise a transaction as "office supplies" or "utilities" when you're preparing a VAT return. Generic converters paste these codes into the description field, leaving you to manually decode and rename every entry.

3. DD MMM YYYY Date Format with Clean Sans-Serif Typography

First Direct uses dates in the format "14 Jun 2026" — a three-letter month abbreviation with spaces that Excel often misreads as text rather than a date value. When Excel doesn't recognise these as dates, sorting and filtering break. The PDFs use a clean sans-serif typeface (distinct from HSBC's standard serif font), which matters because OCR tools trained on serif bank statement fonts can produce garbled date recognition on First Direct's modern typography.

Stop decoding telephone banking codes at 10pm. Every minute you spend deciphering "BP 482917" is a minute you're not billing a client — or getting the sleep you need before tomorrow's month-end close. Let's look at the methods that actually work.

Method 1: Convert First Direct Statements with BankScan AI (Recommended)

BankScan AI is built specifically for UK bank statement conversion. It's trained on the statement formats of over 40 UK banks — including First Direct's minimalist HSBC-family layout — so it knows exactly how to handle the abbreviated transaction codes, DD MMM YYYY dates, and missing metadata that break generic tools.

Here's how it works:

1. Upload your First Direct statement — Drag your PDF (digital or scanned) onto the BankScan AI dashboard. You can upload multiple statements at once — useful if you're processing several months of client statements in one go.
2. Watch it process — The AI identifies First Direct's specific minimalist layout within seconds, correctly parses DD MMM YYYY dates, places transaction type codes into a dedicated column, and preserves full descriptions in the description field.
3. Download your clean file — Export as Excel (.xlsx), CSV, or Google Sheets. The output is a clean, correctly-dated spreadsheet ready for your accounting software or working papers.

Best for: Bookkeepers and accountants who handle First Direct client statements regularly. If you process more than two First Direct statements a month, the time saved on date parsing and code decoding alone pays for the subscription.

Method 2: First Direct Online Banking CSV Export

First Direct online banking does offer a CSV export option for current accounts. Log in at firstdirect.com, navigate to your statement view, and look for the "Export" or "Download transactions" link — typically offering CSV format for the date range you've selected.

The catch? First Direct's CSV exports inherit the same quirks as the PDFs. Transaction descriptions come through as abbreviated telephone banking codes — "BP 482917" rather than a merchant name. The DD MMM YYYY date columns need reformatting before QuickBooks or Xero will accept them. And the column layout doesn't match the default import mapping that most accounting software expects.

If your First Direct online banking does offer CSV export, here's how to make the most of it:

1. Log in to First Direct online banking at firstdirect.com and select the account.
2. Choose your date range and click "Export transactions" or "Download."
3. Select CSV format. Download the file to your computer.
4. Open in Excel and: reformat date columns to DD/MM/YYYY, check transaction codes haven't overwritten descriptions, and reorder columns to match your accounting software's expected import layout.

Best for: Individual First Direct account holders doing occasional personal bookkeeping. Not ideal for accountants processing client statements, as the per-statement cleanup time adds up quickly.

Method 3: Manual Copy-Paste into Excel

The free option — and the one that has accountants questioning their life choices at 11pm. Open the First Direct PDF, select the transaction table, copy, paste into Excel. Then spend the next half hour: converting text dates to date values, decoding transaction type codes into readable descriptions, and verifying that the running balance column hasn't crept into your money-in figures.

For scanned First Direct statements — older PDFs that are just images with no selectable text layer — this method simply does not work. You cannot select and copy text from an image.

Best for: One-off, short digital statements (under 30 transactions) when you have time and patience. Not a realistic option for regular bookkeeping work.

Method 4: Adobe Acrobat Export to Excel

If you already subscribe to Adobe Acrobat Pro (£15.17/month), its "Export PDF to Spreadsheet" feature does a reasonable job with straightforward PDFs. But First Direct's minimalist layout works against it: the missing metadata means Acrobat often can't distinguish between the transaction description and the transaction type code, merging them into a single cell. DD MMM YYYY dates frequently export as text rather than date values.

You'll end up with about 70% of the work done — but the remaining 30% (decoding transaction codes, fixing date formats, re-splitting merged columns) is the slow, fiddly part that burns just as much time as starting from scratch.

Best for: Existing Adobe subscribers who handle First Direct conversions infrequently and can tolerate a clean-up step.

Method 5: Free Online PDF-to-Excel Converters

Smallpdf, ILovePDF, and similar tools offer generic PDF-to-Excel conversion. They extract whatever table structure they detect, but they have no awareness of bank statement layouts — let alone First Direct's specific minimalist format. Expect misaligned columns, merged fields, and dates stored as text.

Best for: We don't recommend this for client work or business accounts. Personal use only — and even then, be aware of where your financial data ends up.

First Direct Conversion Methods: At a Glance

First Direct Statement Types: What You're Working With

Sole Current Accounts (1st Account)

First Direct's flagship current account. Statements are typically 2–5 pages with 15–40 transactions per month. These are the most straightforward First Direct statements to convert — which still means they're more complex than most high-street bank statements due to the abbreviated transaction codes and minimalist layout. The 1st Account statements show the standard columns: date (DD MMM YYYY), description (with embedded transaction type codes), money in, money out, and running balance.

Joint Current Accounts

Joint account statements follow the same format as sole accounts — no additional complexity. However, if your client runs a small business through a joint First Direct account, the transaction volume tends to be higher and the mix of personal and business spending makes categorisation more time-consuming. The abbreviated codes are particularly frustrating here because "BP 482917" gives you no clue whether it's a business expense or personal spending.

Regular Saver Accounts

First Direct's Regular Saver account pays a competitive fixed interest rate. Statements are typically shorter — a handful of monthly standing order deposits and an annual interest payment. These are straightforward to convert but easy to overlook during year-end bookkeeping. If your client has a Regular Saver alongside their current account, make sure you're capturing the interest earned for their tax return.

App-Downloaded Statements

First Direct's award-winning mobile app lets you download statements directly to your phone as PDFs. These app-generated PDFs use the same minimalist layout as online banking downloads but are sometimes rendered with different page dimensions optimised for mobile viewing. When opened on a desktop, the mobile-optimised layout can cause generic converters to misinterpret column widths and page breaks.

Scanned and Archived Statements

Older First Direct statements — particularly those from before the mobile app era — may exist only as paper copies. If your client has been filing paper statements and needs them digitised for a mortgage application or tax enquiry, these need OCR (optical character recognition). Standard copy-paste simply won't work on image-based PDFs. BankScan AI includes OCR processing that recognises First Direct's specific layout — including historical statement formats — so even scanned paper produces clean spreadsheets.

Which Output Format Should You Choose?

Excel (.xlsx)

Best for reviewing, categorising, and annotating transactions. If you're preparing working papers, creating pivot tables to analyse spending by category, or sharing files with colleagues who use Microsoft Office, Excel is the right choice. Use BankScan AI's First Direct to Excel converter to get clean, correctly-formatted output.

CSV (.csv)

The universal interchange format. CSV imports into virtually any accounting software — Xero, QuickBooks, Sage, FreeAgent — without column mapping issues. If your end goal is getting First Direct transactions into bookkeeping software, CSV is usually the safest choice. Note that CSV strips all formatting, so any conditional formatting or colour-coding you've applied will be lost.

Google Sheets

Ideal for collaborative work. If your team needs to review First Direct transactions together, or if Google Workspace is your primary office suite, exporting to Google Sheets saves the extra upload step. BankScan AI supports direct Google Sheets export, so you can go from First Direct PDF to a shared Sheet in one step.

Real-World Use Cases

Monthly Client Bookkeeping

If you're an accountant or bookkeeper with clients who bank with First Direct — and given their market share among UK professionals, you almost certainly do — statement conversion is a recurring monthly task. A slow manual process doesn't just cost you time at the keyboard; it delays every client's month-end close, pushes reconciliation into the following week, and eats into the hours you could spend on advisory work. Using a purpose-built converter turns a 20-minute per-statement chore into a 30-second upload. Over a year of monthly statements for five First Direct clients, that's roughly 20 hours saved — the equivalent of two and a half working days returned to your practice.

Self Assessment Tax Return Preparation

When a self-employed client sends you 12 months of First Direct statements in January — three weeks before the SA deadline — you need clean, categorisable data fast. Having every transaction in a single-row Excel format, with transaction type codes separated from descriptions and dates recognised as proper date values, means you can sort, filter, and subtotal by category in minutes. No missed interest from the Regular Saver. No "BP" codes that need manual decoding. Just clean data ready for the SA103.

Mortgage and Loan Applications

First Direct is popular among mortgage applicants precisely because of its customer service reputation. Lenders typically want three to six months of statements. Providing a neatly formatted Excel version alongside the original PDFs demonstrates financial organisation and helps underwriters quickly identify regular income, standing orders, and spending patterns. Some brokers specifically request Excel format because it lets them annotate and explain individual transactions before submission.

Importing into Accounting Software

Whether you use Xero, QuickBooks, Sage, or FreeAgent, getting First Direct data into your accounting package accurately is the foundation of every reconciliation. Using a converter that outputs platform-ready CSV with correctly mapped columns means you skip the trial-and-error of manual column mapping. We've written dedicated guides for importing into Xero, QuickBooks, Sage, and FreeAgent if you need platform-specific help.

Bulk Processing for Accounting Practices

For firms managing 30–200+ clients, some of whom bank with First Direct, batch processing is essential. BankScan AI's batch conversion lets you upload an entire folder of client statements and receive back a matching folder of clean Excel files — no per-statement babysitting required. For practices where First Direct is a minority holding but the statements still need processing alongside Barclays, HSBC, and NatWest statements, a single tool that handles all formats eliminates the need for multiple converters.

Frequently Asked Questions

Can I export First Direct statements to Excel directly?

First Direct online banking offers CSV downloads for current accounts. Log in at firstdirect.com, navigate to your statement view, and use the "Export" or "Download transactions" option. However, the CSV export inherits First Direct's DD MMM YYYY date format (which Excel often stores as text) and abbreviated telephone banking transaction codes ("BP 482917" rather than full merchant names). The column order also differs from what Xero and QuickBooks expect by default. For clean, bookkeeping-ready Excel output from any First Direct statement — digital PDF, CSV export, or app download — use a purpose-built converter like BankScan AI that handles First Direct's formatting quirks automatically.

Why do First Direct PDF statements paste as scrambled data in Excel?

Three reasons, all specific to First Direct's minimalist HSBC-family design: (1) Missing metadata — First Direct strips out the branch codes, full transaction references, and header detail that generic converters depend on to identify columns. The result is misaligned data across incorrect columns. (2) Abbreviated transaction codes — telephone banking references like "BP 482917" or "DR 29381" paste as cryptic short strings that give you no clue about the actual merchant or payee. (3) DD MMM YYYY dates — the three-letter month format with spaces (e.g. "14 Jun 2026") is often stored as text by Excel rather than recognised as a date, breaking any sorting or filtering you try to apply. A bank-specific converter that understands First Direct's layout avoids all three problems.

How do I handle First Direct transaction type codes?

You have three options: (1) Manual decoding — keep a cheat sheet of First Direct codes (BP = bill payment, DR = direct debit, CR = credit, SO = standing order, FP = faster payment, DD = direct debit) and manually rename or annotate each transaction. Works for short statements but becomes exhausting beyond 20–30 entries. (2) Find & Replace in Excel — after pasting, use Excel's Find & Replace to swap common codes for readable labels, then cross-reference the remaining unknowns against your client's known payees. (3) Use an AI converter — BankScan AI automatically detects First Direct's transaction type codes, places them in a dedicated column, and preserves the full transaction description (including any merchant details that appear alongside the code) in the description field. For anyone processing First Direct statements regularly, option 3 eliminates the decoding step entirely.

Does BankScan AI work with First Direct joint account statements?

Yes. BankScan AI handles all First Direct account types — sole current accounts (1st Account), joint current accounts, and Regular Saver accounts. Joint account statements follow the same minimalist HSBC-family format as sole accounts with no additional parsing complexity. Business-adjacent spending through a joint account (common among freelancers and sole traders who use First Direct) is processed with the same accuracy. BankScan AI's AI models are trained on First Direct's specific statement layouts, so they correctly extract every column and transaction regardless of account type.

Is First Direct's statement format the same as HSBC's?

First Direct is a division of HSBC UK Bank plc, and its statement format shares DNA with HSBC's — but there are important differences that matter for conversion. First Direct uses a more minimalist layout: simplified headers, no branch sort codes, and abbreviated telephone banking transaction references that HSBC statements don't use. The date format is the same DD MMM YYYY, but First Direct's PDFs use a clean sans-serif typeface that differs from HSBC's standard serif font — which affects OCR accuracy. While most HSBC business statements run 20–50+ pages with extensive metadata, First Direct statements are typically shorter and cleaner. But the missing metadata is precisely what generic converters rely on to identify and map columns. This means tools that perform well on HSBC can still produce garbled output on First Direct's stripped-back format. Use a converter — like BankScan AI — that's been specifically trained on both the HSBC and First Direct variant layouts.

Last updated: 14 June 2026. BankScan AI supports 40+ UK bank formats — read our UK bank statement formats guide or browse all blog posts for UK accountants and bookkeepers.