Santander is one of the UK's Big Four banks by current accounts, and their 1|2|3 account — which pays cashback on household bills — is one of the most popular current accounts in the country. Those cashback payments create unique conversion challenges that generic converters don't handle well.
Santander Statement Format
Santander uses a two-column debit/credit layout with separate Payments and Receipts columns:
- Date: DD/MM/YYYY
- Description: Full merchant/payee name
- Payments: Money out (debits) in a dedicated column
- Receipts: Money in (credits) in a dedicated column
- Balance: Running balance
Common Santander Conversion Issues
1. 1|2|3 Account Cashback
The Santander 1|2|3 account pays cashback on household bills (Council Tax, energy, water, broadband, mobile, TV). These cashback payments appear as small credit entries — typically £1-£5 each — that can be confused with refunds or income. They need to be categorised correctly (cashback/reward, not income).
2. International Transaction Truncation
Santander international transactions show truncated merchant names with country codes appended (e.g., "AMAZON LU" for Amazon Luxembourg). The truncation can make reconciliation harder — the merchant name in your books may not match the truncated version in the statement.
3. Statement Header Analytics
Santander includes account analytics in the statement header — spending summaries, income breakdowns, and cashback totals. These are useful for client conversations but can interfere with automated table detection during PDF conversion.
4. Business Account Charges
Santander business accounts include a separate charges schedule page that lists account fees. This needs to be processed separately from the main transaction table.
Cashback tip: Santander 1|2|3 cashback is paid monthly and appears as "123 CASHBACK" in the statement. Create a dedicated category for cashback in your chart of accounts rather than mixing it with general income — this makes it easier to track and explain to clients.
Convert Santander Statements Cleanly
Upload a Santander PDF, get a clean Excel. Cashback entries identified, international descriptions handled.
Try Free Now →Last updated: 8 May 2026. Santander is a trademark of Santander UK plc.