Santander Bank Statement to Excel & CSV

Profile review and source checks

Reviewed 2026-10-19. Santander UK, United Kingdom: layout notes reviewed; not a conversion test of every statement or a bank endorsement. Confirm the period and headers.

Synthetic GBP example for Santander UK: opening 1,000.00 + receipt 100.00 - payment 100.00 = closing 1,000.00. Omitting both rows still balances.

What does a Santander statement PDF look like?

Printed structure: PDF with Date, Description, Money out (£), Money in (£), Balance (£)

Date notation: DD/MM/YYYY. Money notation: £ GBP. Observed statement size: 3–8 pages.

What fields does Santander UK print on each transaction row?

Check these Santander UK layout details against your PDF:

• Santander checkpoint 1: Card payment merchant names truncated to 22 characters — expanded where possible via reference lookup
• Santander checkpoint 2: 123 Cashback rebate posted as a single monthly credit line at statement close
• Santander checkpoint 3: Direct Debit originator name appears with originator reference number in brackets
• Santander checkpoint 4: Joint account statements list both account holders in header block — preserved for tax apportionment

Checkpoint for Santander UK

Before importing GBP values, review this source feature: Card payment merchant names truncated to 22 characters — expanded where possible via reference lookup. Keep the DD/MM/YYYY date column and original narration together while comparing the 3–8 pages with the PDF.

Reviewing Santander UK output

Compare DD/MM/YYYY dates, GBP signs and page boundaries with the Santander UK PDF. Check the first and final transactions; reconciliation alone cannot prove completeness.

Santander UK export and review resources

• Import Santander statement into QuickBooks
• UK bank statement converter hub

For data handling, read our security policy and privacy policy. For download restrictions, see source review and reconciliation limits.