Banks

Convert TSB Bank Statements to Excel

Convert TSB statement PDFs to Excel and CSV, with each reference kept in its transaction's row and every balance checked. 15 pages free.

Drop your statement here PDF up to 25 MB. Scans and photos saved as PDF, and password-protected PDFs, work too.

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

  1. Drop the PDF in the box on this page, and we show you its first page converted.
  2. 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.
  3. 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.

Other banks

We convert other banks' statements too. See every bank page.

Convert your own statement.

We read every row, check every balance, and give you a file for your spreadsheet or your books.