Convert TSB statements to Excel and CSV
To convert TSB statements to Excel or CSV, upload the PDFs, scans or photos to statement.work and export each transaction with date, description, signed amount and running balance. Statements in older and newer designs come out in the same columns.
Not affiliated with TSB. statement.work is an independent tool. TSB is a trademark of its owner and is named here only to describe the statements this page is about.
About TSB statements
TSB Bank is a UK high-street bank with personal and business customers. It was part of Lloyds Banking Group until it was separated as a standalone bank in 2013, so long-standing customers’ records can span more than one statement design.
What the statements typically contain
- Account details (sort code and account number) and the statement period.
- An opening or brought-forward balance.
- A transaction table with date, description, money out, money in and balance.
- Day-first dates, with fees and interest shown in the transaction list or summarized.
Formats vary over time and by account; check your own statements.
Common conversion problems
- Different designs across years. A run of statements may not look the same from start to finish. Template-based tools need re-mapping each time; statement.work doesn’t.
- Missing months. When records are gathered from several sources, gaps are common. The balance chain between statements finds them.
- Brought-forward balances on each page are not transactions.
- Dates printed once per day need filling down to every row.
How to convert it
- Collect all statements for the period, whatever their design.
- Upload them to statement.work.
- Review the transactions; every row has its own date and a signed amount.
- Export to Excel or CSV and sort by date.
- Check the balance chain across statements.
Completeness checks
Catch-up work lives or dies on completeness. The reconciliation guide shows how to check balances between statements quickly, and bank statement formats explained covers why layouts change. Statements from Lloyds and Nationwide convert to the same columns.
Questions
How do I make sure I have every statement for a year?
Check that each statement's opening balance equals the previous statement's closing balance, and that the statement periods join up with no gaps.
Do older TSB statements convert?
Yes. statement.work reads the document rather than using a template, so older and newer statement designs convert to the same columns.
Is statement.work affiliated with TSB?
No. statement.work is independent and is not affiliated with or endorsed by TSB Bank.