Home › Countries › United Kingdom › TSB Bank statement converter
Based in Edinburgh, United Kingdom, TSB Bank provides statements to its customers as PDF documents in online banking. Convert TSB Bank statement PDFs to Excel, CSV or an accounting format — with a reconciliation check on every conversion.
For building schedules and workings that cite the statement line by line.
For importing into software and workflows that take a plain file.
For any workflow that asks for a 'bank statement file' rather than a spreadsheet.
For bookkeepers standardizing client statements into one import shape.
Statements from United Kingdom banks print dates as day/month/year — 03/04/2026 means 3 April 2026 and amounts with a comma for thousands and a point for decimals (1,234.56) — the converter's locale-aware reader handles that layout, and then the reconciliation check proves the result: the extracted transactions must add up to the balances printed on the statement itself, or the conversion is flagged.
Reconciliation is what separates conversion from copying. Once the TSB Bank transactions are extracted, the converter replays them: opening balance plus each row in turn must reproduce every printed running balance and land exactly on the closing figure. A dropped row, a duplicated row or a misread digit breaks the chain and is flagged at the row where it breaks, with the expected and printed balances shown side by side.
Before converting, spend thirty seconds on the TSB Bank document itself: confirm the period matches the month you are closing, note the opening and closing balances, and scan for the period's largest transactions. The closing zone carries the balances and any fees or interest summaries; it is the closing zone the reconciliation check answers to, and the first place to look when a conversion is flagged.
In United Kingdom, bookkeepers commonly work in Xero, Sage, QuickBooks and FreeAgent; the Excel and CSV exports from this converter are the files those tools import, and the Xero export is laid out for direct import where the tool accepts it.
Download all twelve periods first and convert them as one batch, then work through the reconciliation results month by month in order. Fix flagged months before importing anything: it is far easier to resolve a difference against twelve tidy statements than inside a year of mixed postings.
Month-end in a spreadsheet: Excel. Feeding the ledger: your accounting tool's own format. A year of catch-up for an adviser: Excel per statement plus a combined view. Migrating between finance apps: OFX or CSV. The hub exists so the choice is one click from the same verified conversion — pick by destination, and re-download in another shape whenever the job changes.
These are the general steps most banks follow for statement downloads; exact menu labels vary by bank and change over time.
Tip: keep the downloaded PDFs in a folder named by account and month. A tidy folder makes batch conversion and later review almost mechanical.
Save the statement as a PDF from TSB Bank online banking, add it to the converter above, and take the an Excel (.xlsx) workbook it produces. Extraction, column normalization and the reconciliation check all happen before the download is offered.
Expect day/month/year — 03/04/2026 means 3 April 2026 dates and amounts with a comma for thousands and a point for decimals (1,234.56) on a TSB Bank statement. The reader is locale-aware, so those conventions are handled rather than misread, and the output columns come out in the standard layout regardless.
Where the statement prints opening and closing (or running) balances, the converter adds up the extracted transactions and compares the result with the statement itself. If the numbers do not tie, the conversion is flagged and the mismatched rows are marked — a failed check is never shown as a success.
Yes — it is one of the strongest checks available. The converter walks the extracted amounts against the printed running balance row by row, so a single dropped or duplicated transaction is pinpointed instead of merely suspected.
Convert them separately and import only one version of the overlap. Banks occasionally reissue a corrected statement for a period; the later issue supersedes the earlier, and importing both would double the shared days.
Yes. Download each month as its own PDF and upload them together — batch mode converts them in one run and, in Excel, adds a combined sheet. Each statement is still reconciled separately, because balances are per statement.
Yes. Credit-card statements use a Previous Balance / New Balance layout, which the converter reads as well; purchases are positive and payments are negative, and the same totals check applies.
Date, Description, Amount, Debit, Credit and Balance — the same normalized columns for every bank, so a TSB Bank file and a file from any other bank in United Kingdom can be imported and reviewed the same way.
No. Uploaded files and generated exports are stored only briefly to complete the download and are automatically deleted within 15 minutes.
Your first conversion is free — no card, no sign-up — and every result is checked against the statement itself before you download it.