How to Convert a Santander UK PDF Bank Statement to Excel (2026)

- Date — formatted as Excel dates in DD/MM/YYYY (sortable, filterable)

- Description — full transaction description (Direct Debits, Faster Payments, Standing Orders, BACS)

- Amount — negative for debits, positive for credits

- Balance — running balance after each transaction

- Currency — GBP (or EUR for some business accounts)

Santander 1|2|3 Current Account cashback section: The 1|2|3 Current Account includes a unique cashback summary section showing interest tiers (1%, 2%, 3%) earned on household bills. pdftoxlsx detects this section and places it on a separate Cashback sheet, keeping the main transaction ledger clean and import-ready.

Santander Everyday vs Select layout differences: Everyday and Select Current Accounts use slightly different header designs and account summary layouts. pdftoxlsx detects both templates automatically and extracts transactions identically — the header differences do not affect data extraction.

Santander credit card statements (separate layout with APR info): Santander credit card PDFs use a different column structure from current-account statements, with separate sections for Purchases, Payments, minimum payment due, and APR information. pdftoxlsx consolidates these into a single Amount column so the ledger matches the card balance exactly.

Santander Business multi-account statements: If you manage multiple business accounts under a single Santander Business login, the PDF may combine several accounts into one document with separate sections per account. pdftoxlsx splits these into separate sheets (one per account) so you can import each to the correct ledger.

Scanned statements from older branches: Some older Santander UK statements or branch-printed PDFs are image-based. pdftoxlsx runs OCR on these; accuracy averages 99%+ on scans at 200 DPI or higher. Re-scan at 300 DPI if you see column drift.

Santander Mortgage payment references appearing in transaction list: Mortgage payments from linked Santander accounts often show long reference numbers and mortgage account details in the transaction description. pdftoxlsx preserves the full reference in the Description column so you can match payments to your mortgage account.

Direct Debit and Standing Order long descriptions wrapping to multiple lines: Santander statements frequently have long descriptions for Direct Debits and Standing Orders that wrap across two or three lines in the PDF. pdftoxlsx merges these wrapped lines into a single Description cell without losing any text.

International payments with IBAN/BIC details spanning multiple lines: Inbound and outbound international transfers include IBAN, BIC/SWIFT codes, beneficiary details, and reference numbers that span multiple lines. pdftoxlsx collapses these into one row, placing the payment reference in the Description and extra details in a Notes column.

Santander joint account statements: Both account-holder names are preserved in the statement header and written to a Metadata sheet; the transaction ledger is single-flow and includes all transactions from both holders. Joint accounts sometimes show different address lines for each holder — pdftoxlsx captures both.

Santander e-statements vs paper statement scans: E-statements downloaded directly from online.santander.co.uk are native PDFs with selectable text — these convert with 99.1% accuracy. Paper statements that have been scanned produce image-based PDFs; pdftoxlsx applies OCR automatically and accuracy depends on scan quality (300 DPI recommended).