Convert TSB bank statements to Excel or CSV
TSB statements are PDF documents in your Digital Inbox, in Internet Banking and the app. If you need the transactions in Excel or your accounting software, for Self Assessment, a mortgage application or monthly bookkeeping, upload the PDFs here. This page explains how its transaction codes and short dates come through, and how paper and PDF statements mix.
Page 1 free, no sign-up to see it; just an email to download. The whole document is one payment: $3 up to 5 pages, $9 up to 25, priced by page count above that. No subscription.
98% of numbers correct on 82 hand-checked pages How we measure
How to get your TSB statement into Excel
-
Download the PDF statement from TSB online banking
- Log on to TSB Internet Banking or the TSB app.
- In the app, tap the profile icon, then 'Inbox'; in Internet Banking, click 'Your Inbox' on the top right-hand side.
- Find the statement and tap the download icon to save the PDF.
- Save the statement for the period you need as a PDF.
-
Upload it here
Scans and phone photos work too.
-
Download Excel, CSV, or QuickBooks and Xero CSV
Check the rows against the statement, then export.
Sample result
Your TSB statement in Excel
Made-up sample rows, not a real statement.
| Date | Description | Debit | Credit | Balance |
|---|---|---|---|---|
| 2026-01-02 Salary - Example Employer Ltd | Salary - Example Employer Ltd | 2,500.00 | 3,500.00 | |
| 2026-01-05 Card payment - Sample Grocery Co | Card payment - Sample Grocery Co | 120.00 | 3,380.00 | |
| 2026-01-09 Rent - Placeholder Properties | Rent - Placeholder Properties | 1,200.00 | 2,180.00 | |
| 2026-01-14 Transfer from savings | Transfer from savings | 300.00 | 2,480.00 | |
| 2026-01-20 Utility bill - Demo Energy Co | Utility bill - Demo Energy Co | 80.00 | 2,400.00 | |
| 2026-01-27 Card payment - Fictional Coffee Co | Card payment - Fictional Coffee Co | 15.00 | 2,385.00 |
Statement notes
What to know about TSB statements
Statements live in the Inbox
Statements go to the Digital Inbox rather than sitting under the account, and TSB says it will never alter or delete items there. That makes the Inbox a dependable archive: download the PDFs you need and upload a year at a time, with missing or overlapping months flagged.
Paper and PDF look the same
TSB says paperless documents are PDFs that look exactly like the paper versions. If you're combining older posted statements with recent downloads, scan the paper ones flat and upload them together; the layout is identical, so both come out in the same columns.
Codes in the narrative
The narrative column carries transaction codes such as B/O, DD and FPI. They aren't self-explanatory, but they're useful for sorting, so they stay with the narrative in each row. That lets you check every line against the statement and filter by code in Excel.
Two-digit years
Dates printed as DD/MM/YY are expanded to full YYYY-MM-DD dates using the statement period. That removes the century guess some spreadsheets make and keeps a file mixing several years in the right order.
Output and review
From TSB PDF to your books
Accounting tip
In QuickBooks Online, upload the QuickBooks-ready CSV and match its Date, Description and Amount columns when asked. Because the TSB codes stay in the description, rows such as DD and FPI are easy to pick out when you categorise transactions.
-
Checked before export
Opening balance plus transactions is checked against the closing balance. Duplicate or missing periods are flagged.
-
Export formats
Excel, CSV, JSON, or QuickBooks and Xero CSV.
-
Private workspace
HTTPS uploads, kept private until you ask support to delete them.
FAQ
TSB statement questions
Where do I find TSB statements to convert?
Will codes like B/O and FPI stay in the file?
Can I import converted TSB rows into QuickBooks or Xero?
Convert your TSB statement to Excel
Page 1 free, no sign-up to see it; just an email to download. The whole document is one payment: $3 up to 5 pages, $9 up to 25, priced by page count above that. No subscription.
More Bank Statement Converters
pdf2text is independent and not affiliated with or endorsed by TSB.