Skip to content
stmtai

Convert Santander statement PDFs to Excel, Xero and CSV.
Xero, QuickBooks Online, Excel files from the PDF.

Santander UK issues its e-Document statements as plain PDFs with no password. Santander's 'Download transactions' option on the account page will give you Microsoft Excel, Quicken (QIF), PDF or Microsoft Money for a date range, and personal current accounts can also pull a midata CSV of the last twelve months.

Drop your Santander statement here

PDF, scan or photo. Up to 12 files at a time.

Not ready to upload your own? See a sample result

5 pages free, no account. Amounts stay in GBP.

Last updated

How to download a Santander statement as a PDF

  1. Log on to Santander Online Banking and click 'Statements and documents' in the top navigation.
  2. Choose the account and the statement period from the list of e-Documents.
  3. Click the document to open it, then use the download icon to save the PDF.
  4. In the Mobile Banking app: tap 'Mailbox' in the top right, then 'Statements and documents', open the statement and tap the download arrow in the corner to save it.

Then drop the file above; several months of Santander statements at once come back as one workbook.

Is the Santander PDF password-protected?

Santander UK issues its e-Document statements as plain PDFs with no password. They no longer carry a watermark either, which used to confuse some lenders.

What Santander statements look like

Date, Description, Money in, Money out, Balance, with card purchases showing the merchant, location and a "ON dd-mm-yyyy" posting note.

Santander UK statements put the monthly summary on the first page and then a 'Your transactions' table headed Date, Description, Money in, Money out, Balance, with a running balance on every row. Card purchases are written as the merchant and town followed by 'ON dd-mm-yyyy', the date the card was actually used. Dates in the Date column are day and month in words, such as 14th Feb. Statement periods rarely run calendar months; they start on the day the account was opened, so a statement may cover the 18th to the 17th. Savings account statements come once a year and are a single long table.

Why not use Santander's own export?

Santander's 'Download transactions' option on the account page will give you Microsoft Excel, Quicken (QIF), PDF or Microsoft Money for a date range, and personal current accounts can also pull a midata CSV of the last twelve months. Downloads are capped at 600 transactions per file, so a busy business account needs the range split. The transaction download is a list, not the statement: there is no statement opening balance and the running balance shown on screen does not always come through. Online Banking shows seven years of activity, but the e-Document PDFs are what you convert when you need a period that ties back to the printed closing balance.

Where Santander statements trip up converters

  • The "ON date" inside descriptions is the purchase date; the row date is the posting date and is what is used for balances.

Which software Santander customers import into

Santander customers most often import into Xero, QuickBooks Online, Excel.

Santander questions

What is the 'ON 12-03-2026' text in my Santander card payment descriptions?

That is the date the card was used at the shop or website. The Date column shows when Santander posted it, which can be a couple of days later and is the date the balance moves. stmtai uses the posting date for the row and leaves the ON date in the description so you still have both.

My Santander statement runs from the 18th to the 17th. Can I get calendar months instead?

Not from the PDF, because the statement period is fixed to your account opening date unless you ask Santander to change it. You can convert consecutive statements and then filter the combined sheet by month in Excel, which is what most bookkeepers do. The running balance stays intact across the join because each statement ends where the next begins.

How do I convert a Santander statement PDF to Excel?

Download it from Santander using the steps above, drop it here, and in about 10 to 40 seconds you get the table, the balance check and the Excel, CSV, QuickBooks, Xero and Tally XML downloads. The first 5 pages are free with no account.

How many Santander statements can I convert at once?

Up to 12 files at a time, 60 pages each. A year of monthly statements comes back as one Excel workbook with an Overview sheet showing which months balanced, a sheet per month with a Category column, and a Categories sheet totalling the year by category.

Other banks in United Kingdom

All banks and formats · See a sample result