UK
Upload a Santander statement PDF and every transaction comes back as clean rows — date, description, money in, money out and the running balance — with the closing figure checked before you download. Export to Excel, CSV, or an import file for Xero, QuickBooks or Zoho.
A Santander PDF reads clearly, but that's the problem: the payment-type label and the payee sit together in one description column, and a plain copy-paste smears them across the money columns.
What a Santander statement looks like
Santander lays a current-account statement out like this:
Column | What's in it |
|---|---|
Date | The day the transaction was applied |
Description | The payment type label plus the payee |
Money in | Credits |
Money out | Debits |
Balance | Running balance after the transaction |
The detail worth knowing is the payment-type label at the start of each description. Santander names how the money moved — a card payment, Direct Debit, standing order, bill payment or a Faster Payment in or out. That label is genuinely useful once it's in a spreadsheet, because it lets you group every Direct Debit or card spend in one filter. But because it's crammed into the description column, a rough PDF export tends to push it into the money column or split the line in two. The converter keeps the label and the payee together, on the right row.
Santander also carries well-known accounts like the 1|2|3 current account, where cashback and interest lines appear alongside ordinary spending — those stay on their own rows rather than being merged into a nearby payment.
Where to download your Santander statement
- Online Banking: log in at santander.co.uk, choose the account, open Statements and documents, pick the period and download the PDF.
- Santander app: tap the account, go to Statements, choose a month and save the PDF.
A statement downloaded this way is a digital PDF with selectable text, so the conversion is exact. If you only have a scan or a photo of a paper statement, the converter reads it with OCR — that just takes a little longer.
Getting the numbers where you need them
- Excel or Google Sheets — a clean `.xlsx` or CSV, one row per transaction, ready to total and filter.
- Xero or QuickBooks — an import-ready bank file so the lines arrive as statement entries to reconcile.
- Tally, Zoho and others — the same data in each one's format.
Before you download, the maths is checked: opening balance, plus money in, minus money out, has to reach the closing balance. On a multi-page Santander statement, that check is what catches a single line dropped between pages.
Common snags with Santander statements
- Payment label runs into the amount. The converter keeps the type label with the payee instead of letting it bleed into the money columns.
- Cashback and interest lines. On a 1|2|3 account these stay on their own rows, not merged into a payment.
- Business accounts. Santander business current-account statements use the same layout, so the same conversion works.
Frequently asked questions
Can I convert a Santander statement to Excel for free?keyboard_arrow_down
Yes. Upload the PDF and get a clean Excel or CSV back free to start, with the running balance checked so the import lines up.
What do the labels like Direct Debit and Faster Payment mean?keyboard_arrow_down
They describe how the money moved — a card payment, Direct Debit, standing order, bill payment or a Faster Payment in or out. The converter keeps each label attached to the right transaction so you can filter by type later.
Does it handle Santander business statements?keyboard_arrow_down
Yes. Business current-account statements share the same Money in / Money out / Balance layout, so the conversion is identical.
Will it read a scanned Santander statement?keyboard_arrow_down
Yes, with OCR. A PDF downloaded from Online Banking will convert faster and cleaner than a scan.
