Convert First Direct Bank Statement to Excel
First Direct statements follow the HSBC house style: Date, Payment type and details, Paid out, Paid in and Balance. Tidy on paper, awkward to retype — several transactions on the same day share a single balance line and the date isn’t repeated on every row, so copying into a spreadsheet means filling down missing dates, unpicking merged detail lines and deciding by eye whether each figure is a debit or a credit. One slip and your cashbook stops agreeing with the bank. SheetMyBank reads the PDF and rebuilds proper ledger rows: every entry gets its own date, outgoings and receipts land in separate columns, and the balance is carried through intact.
In the app, pick the account on the balances screen, then tap the three dots (iPhone) and ‘View Statements’, or the + icon (Android) and ‘Statements’; Online Banking keeps a ‘statements’ link at the top right of the transactions page. Up to six years of PDFs sit there ready to fetch. Drop one into SheetMyBank and parsing happens entirely on your own computer — the file never travels to a server — while the tool confirms each running balance follows arithmetically from the one before, then hands you the Excel file.
Drop your First Direct statement here (PDF or photo)
Processed entirely on this device — nothing is uploaded. Scans and photos are read with on-device OCR (beta).
Free for your first 5 pages each month · Processed on your device · Balance-verified output
First Direct statement FAQ
How do I download a First Direct statement from the app?
Select the account on the balances screen. On iPhone, tap the three dots in the top right and choose ‘View Statements’; on Android, tap the + icon at the bottom right and choose ‘Statements’. The download icon then lets you email or print the PDF.
How far back do First Direct statements go online?
You can reach up to six years of statements and transactions through both the app and Online Banking by selecting the account and downloading the statement PDFs. For anything beyond that six-year window you would need to ask First Direct for copies directly.
Will the converted spreadsheet keep Paid out and Paid in separate?
Yes. The converter maps each figure to its own debit or credit column rather than collapsing them into one signed amount, repeats the date on every row, and carries the balance across — so SUM checks and bank reconciliations work straight away in Excel.