Convert Santander UK statements to Excel and CSV
To convert a Santander UK statement to Excel or CSV, upload the PDF, scan or photo to statement.work and export each transaction with date, description, signed amount and running balance. Small reward or cashback credits come out as their own rows so they don't get counted as income.
Not affiliated with Santander UK. statement.work is an independent tool. Santander UK is a trademark of its owner and is named here only to describe the statements this page is about.
About Santander UK statements
Santander UK is the UK banking subsidiary of Spain’s Banco Santander and one of the larger UK high-street banks, with personal and business customers. Some of its accounts pay cashback or rewards on certain bills or spending, which show up as small credits on the statement.
What the statements typically contain
- Account details (sort code and account number) and the statement period.
- Opening and closing balances.
- A transaction list with date, description, money in, money out and balance.
- Fees, interest and any reward or cashback credits.
Statement design varies by account type and over time; check your own documents.
Common conversion problems
- Small credits that aren’t income. Cashback, rewards and refunds are credits but not sales. Without a category they inflate income totals.
- Bill payments and their rewards. A direct debit and a later cashback credit relate to the same bill but appear separately; categories help connect them.
- Two amount columns. Money in and money out become a single signed amount in the export.
- Interest lines. Interest paid or charged is a separate category and easy to overlook.
How to convert it
- Download the statement PDF, or use a scan or photo.
- Upload it to statement.work.
- Review the transactions and categories, especially small credits.
- Export to Excel or CSV.
- Check the closing balance against the statement.
Categories that keep totals honest
Separating cashback, refunds and transfers from real income is a large part of getting categories right, especially for small businesses using one account for everything. Similar UK statements: NatWest and Nationwide.
Questions
Should cashback on my statement count as income?
Usually cashback and reward payments are categorized separately from sales or other income. How they're treated for tax depends on your situation, so check with your accountant.
Can I convert Santander business statements?
Yes. Business and personal statements both convert to the same columns.
Is statement.work affiliated with Santander?
No. statement.work is independent and is not affiliated with or endorsed by Santander UK or Banco Santander.