We turn your TSB statement PDF into a spreadsheet with the columns the statement prints, and we check every balance on the way.
What a TSB statement looks like
- A TSB statement has six columns: Date, Payment type, Details, Money Out (£), Money In (£) and Balance (£).
- The Payment type column spells the kind of payment out in words, such as FASTER PAYMENT, DIRECT DEBIT, DIRECT CREDIT, CASH WITHDRAWAL or DEPOSIT OF CASH. Some rows leave it blank.
- The details often run onto a second line, such as a payment reference. We keep that line in the same row, in the Details cell, so each transaction is one row.
- Every transaction has its own date, written like 16 Dec 20, and its own balance.
What your spreadsheet looks like
| Date | Payment type | Details | Money Out (£) | Money In (£) | Balance (£) | Ledger |
|---|---|---|---|---|---|---|
| 16 Dec 20 | FASTER PAYMENT | A FRIEND REFERENCE: GIFT | 50.00 | 1,050.00 | ok | |
| 17 Dec 20 | CAFE 1234 GB 5678 | 3.40 | 1,046.60 | ok | ||
| 17 Dec 20 | DIRECT DEBIT | ENERGY CO REF 998877 | 64.00 | 982.60 | ok | |
| 18 Dec 20 | CASH WITHDRAWAL | HIGH STREET | 40.00 | 942.60 | ok |
The rows above are an example, not a real statement.
How we test it
We test against three TSB statements, one of them a scan that we read with OCR: 114 transactions in all. 112 of them balance against the row before. The Ledger column flags the other 2, both in one statement, so you know which rows to check.
Convert a TSB statement
- Drop the PDF in the box on this page, and we show you its first page converted.
- Sign up with your email address to download it. You do not need a card. Your free trial converts up to 5 pages of a statement, 15 pages in all.
- To convert every page, choose a plan on the pricing page.
To bring the transactions into your books, download the file for your accounting software from your list of statements, then import it into Xero, QuickBooks or FreeAgent. You get this file on the free trial and on the Standard and Plus plans. Lite gives Excel and CSV.
Once the statement is in your account, we delete the PDF when its conversion finishes. If you drop it in and do not sign in, we delete it too. Our privacy policy says what we keep, and for how long.
Read next
- Bank Statement Codes: What DD, BGC, FPI and the Rest Mean
- Why a Converted Bank Statement Does Not Balance
Other banks
- Convert ANZ Bank Statements to Excel
- Convert Commonwealth Bank (CommBank) Statements to Excel
- Convert ICICI Bank Statements to Excel
- Convert Metro Bank Statements to Excel
- Convert Monzo Bank Statements to Excel
- Convert Nationwide Bank Statements to Excel
- Convert HSBC Bank Statements to Excel
- Convert Lloyds Bank Statements to Excel
- Convert NatWest Bank Statements to Excel
- Convert Santander Bank Statements to Excel
- Convert Virgin Money Bank Statements to Excel
We convert other banks' statements too. See every bank page.