Convert TSB Bank Statement to Excel
TSB current account statements use a Date / Payment type / Details / Money out / Money in / Balance layout with type codes similar to its former Lloyds sibling (DEB, DD, SO, FPI, TFR). Since the 2018 platform migration TSB statements have their own rendering quirks, including tight column spacing on busy pages — the converter rebuilds rows from text position rather than relying on spacing, which is exactly the failure mode of copy-paste with TSB PDFs.
Download statements from TSB Internet Banking (account → Statements → download PDF) or the mobile app; several years are retained. All processing happens locally in your browser. Each row’s amount is validated against the balance column, and anything that fails to reconcile is flagged in the preview and exported to the Warnings sheet — so a squeezed column never becomes a silent error in your accounts.
Drop your TSB 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
TSB statement FAQ
Where are PDF statements in TSB Internet Banking?
Log in, select the account, open Statements, choose the statement period, and download as PDF. The TSB app provides the same statement archive.
What do TSB’s payment-type codes become in the spreadsheet?
They are kept at the start of the Description cell (DEB for card, DD for Direct Debit, FPI for inbound Faster Payment, etc.), giving you an instant filter key in Excel.
My TSB statement columns look cramped — will extraction cope?
Yes. Rows are reconstructed from each text fragment’s coordinates, not visual spacing, and the balance check independently verifies every amount — cramped layouts get flagged if anything misreads.