United Kingdom · Bank statement converter
Convert a First Direct statement to Excel, CSV & JSON
Drop your bank statement here
PDF statements (scans coming soon) · browse files
1 page free per day · Files are deleted right after conversion
First Direct statements follow the HSBC layout with payment-type codes and daily balances. Conversions preserve the codes as part of the description so regular payments are easy to filter and categorize in Excel.
Verified against the balance
Every row is reconciled against the statement's running balance, so a misread digit is flagged, not silently wrong.
Encrypted, then deleted
Your file is processed over an encrypted connection and the original PDF is deleted the moment conversion finishes.
QuickBooks & Xero ready
Export import-ready QuickBooks (QBO) and Xero files with stable IDs, alongside Excel, CSV, and JSON.
Updated July 24, 2026
How to convert a First Direct statement
- 1
Upload your statement
Drag the First Direct PDF into the converter above, or browse to it. Scans, phone photos, and password-protected files all work.
- 2
AI reads every transaction
Dates, descriptions, and amounts are extracted page by page, then cross-checked against the statement's running balance.
- 3
Review and download
Anything that doesn't reconcile is flagged for a quick fix, then you export to Excel, CSV, QuickBooks, Xero, or JSON.
How to download your First Direct statement
- Sign in to first direct online banking or the app.
- Select the account (1st Account or a savings account), then open “Statements”.
- Choose the statement period you need.
- Download or print it to PDF; first direct also posts paper statements on request.
First Direct statement formats and where they trip up converters
first direct 1st Account
An HSBC-style statement with two-letter payment-type codes and a running daily balance.
YOUR TRANSACTIONS
Two-letter codes (CR credit, DR debit, BP bill payment, SO standing order) precede each line; a daily balance is printed.
Every line is prefixed with a two-letter payment-type code — BP, DR, CR, SO, TFR — that copy-paste often strips or merges into the description.
The code is kept as part of the description, so you can still filter by payment type once it's in Excel.
first direct shares HSBC's dense layout, where long merchant and reference text wraps across lines.
Wrapped lines are collapsed back into a single transaction, and every row is checked against the printed daily balance.
Standing orders and Direct Debits repeat monthly with near-identical text, which is easy to double-key by hand.
Each is extracted as its own row with its code and reference, so regular payments are easy to spot and categorize.
Supported First Direct accounts
- 1st Account
- Regular Saver Account
- Savings Account
- Cash ISA
What the export looks like
Every row rebuilt in date order and checked against the running balance. A green check means it reconciles; an amber flag means it needs a quick look before export.
| Date | Description | Amount | Balance | Check |
|---|---|---|---|---|
| 03/03 | CR Salary — ACME LTD | +2,400.00 | 3,110.20 | Reconciles |
| 03/03 | BP Rent — FLAT12 | -950.00 | 2,160.20 | Reconciles |
| 05/03 | DR Tesco Stores, London | -24.10 | 2,136.10 | Reconciles |
| 08/03 | SO Gym Membership | -32.00 | 2,104.10 | Reconciles |
| 14/03 | DD long merchant ref (wrapped) | -58.40 | 2,045.70 | Needs review |
Frequently asked questions
How do I convert a first direct statement to Excel?
In first direct online banking or the app, open the account, go to Statements, choose a period, and download the PDF. Drop it into the converter above and download the result as Excel, CSV, QuickBooks, Xero, or JSON. Your first page each day is free, no account needed.
What are the two-letter codes on my first direct statement?
They're payment-type codes — CR (credit), DR (debit), BP (bill payment), SO (standing order), TFR (transfer). The converter keeps the code as part of the description, so you can filter by payment type in your spreadsheet.
first direct is part of HSBC. Does it convert the same way?
Yes. first direct statements use HSBC's layout with the same payment-type codes and daily balance, so they convert with the same reliable running-balance check. See the HSBC guide for the parent format.
Does the daily balance get verified?
Yes. first direct prints a running daily balance, so each extracted row is checked against it and anything that doesn't reconcile is flagged for review before you export.
Does it work with the Regular Saver and savings statements?
Yes. Savings account statements use the same layout with the same codes and balance, and every row is verified before export.
Can I import a converted first direct statement into QuickBooks or Xero?
Yes. Alongside Excel and CSV, the converter exports QuickBooks (QBO) and Xero files with stable transaction IDs, so re-importing an updated statement won't create duplicates.
More United Kingdom banks
Browse all banksParseBank is an independent tool and is not affiliated with, endorsed by, or connected to First Direct (HSBC Group). All trademarks, product names, and logos belong to their respective owners.