What's the maximum statement period I can convert?

Santander Online Banking provides up to 7 years of historic statements. The converter accepts up to 100 pages per upload — enough for a full year of an active 1|2|3 account or 4–6 months of a busy Santander Business account.

How are credits and debits handled in the CSV?

Santander UK PDFs use a single Amount column with positive numbers for credits and negative numbers for debits. The CSV preserves this signed format and adds an explicit credit/debit Type tag so accounting software that expects split Money In / Money Out columns can be fed via a one-formula Excel split.

How do I import the CSV into Xero or QuickBooks?

Xero Manual Statement Import handles Santander's signed Amount column natively — map Date → Date, Description → Description, Amount → Amount. QuickBooks Online: choose 'Two-column CSV' and map Amount as the signed value. Sage and FreeAgent both auto-detect the schema.

Does this work with Santander Corporate Banking eStatements?

Santander Corporate Banking already offers MT940 and CSV exports — use those if available. PDF eStatements work with this tool but the layout occasionally varies; let us know if you hit a parsing issue.

Are joint-account and 1|2|3 cashback statements handled correctly?

Yes. Joint accounts use the same layout as single-name accounts. 1|2|3 cashback line items are preserved as their own rows tagged 'CASHBACK' so they reconcile against the originating Direct Debits and are easy to total per month or per category.

Convert Santander PDF Statements to CSV

Santander UK statements — Personal, 1|2|3, Business, and Corporate — come as PDFs that don't drop neatly into Excel or Xero. This converter parses every Santander UK statement format, preserves the 1|2|3 cashback annotations, and outputs a CSV ready for accounting software, mortgage affordability checks, and tax-return preparation.

Designed for Santander UK statement quirks

Santander UK statements use a single Amount column with positive numbers for credits and negative numbers for debits, plus a separate Balance column. Generic PDF extractors often lose the negative sign or miscategorise credits, producing a CSV that won't reconcile. This converter reads Santander's amount column reliably and explicitly tags each row as a credit or a debit so your accounting software interprets it correctly.

1|2|3 World account statements add cashback line items at the end of each month, marked '1|2|3 CASHBACK'. These are preserved as their own rows so they reconcile against the headline credit and so cashback per month is easy to total in a pivot table. Santander Business Banking statements include a sort-code page header on every page plus an end-of-month summary block — both are stripped so they don't appear as bogus transactions in the output.

Practical Santander use cases

Santander Business customers use this for monthly Xero reconciliation. Santander's Open Banking feed has improved but still drops connections more often than competitors, so a fallback PDF-to-CSV workflow is part of many bookkeepers' standard kit.

1|2|3 personal account holders use the converter for personal-finance tracking — exporting a year of statements to CSV, then pivoting in Excel to analyse cashback earned by category (energy, council tax, mobile, etc.) and confirm whether the monthly fee is paying off.

Mortgage and remortgage applications regularly require three to six months of Santander current account PDFs in spreadsheet form for the broker's affordability template. The CSV output drops in directly with no remapping.

Self Assessment preparation: sole traders and landlords with Santander business or rental-receipt accounts convert 12 months of PDFs in one batch and pivot by category to populate the SA103 / SA105 schedules.

Output schema

Columns: Date (DD/MM/YYYY), Description, Amount (signed), Balance. An optional Type column tags Direct Debits, standing orders, Faster Payments, card purchases, and 1|2|3 cashback. The CSV imports directly into Xero (Manual Statement Import), QuickBooks Online (Three-column CSV), Sage Business Cloud, and FreeAgent.

How it works

Upload Santander PDF — Personal, 1|2|3, or Business
Extract Transactions — Dates, descriptions, amounts captured
Download CSV — Import to your accounting platform

Key benefits

Handles Santander UK personal current account format
Works with Santander Business Banking statements
Supports 1|2|3 cashback annotations
UK date format (DD/MM/YYYY) preserved
Multi-page statements processed in one upload
Files purged after 1 hour — no persistence

Common use cases

Santander business reconciliation
Cashback tracking from 1|2|3 accounts
Tax return preparation

Frequently asked questions

What's the maximum statement period I can convert?: Santander Online Banking provides up to 7 years of historic statements. The converter accepts up to 100 pages per upload — enough for a full year of an active 1|2|3 account or 4–6 months of a busy Santander Business account.
How are credits and debits handled in the CSV?: Santander UK PDFs use a single Amount column with positive numbers for credits and negative numbers for debits. The CSV preserves this signed format and adds an explicit credit/debit Type tag so accounting software that expects split Money In / Money Out columns can be fed via a one-formula Excel split.
How do I import the CSV into Xero or QuickBooks?: Xero Manual Statement Import handles Santander's signed Amount column natively — map Date → Date, Description → Description, Amount → Amount. QuickBooks Online: choose 'Two-column CSV' and map Amount as the signed value. Sage and FreeAgent both auto-detect the schema.
Does this work with Santander Corporate Banking eStatements?: Santander Corporate Banking already offers MT940 and CSV exports — use those if available. PDF eStatements work with this tool but the layout occasionally varies; let us know if you hit a parsing issue.
Are joint-account and 1|2|3 cashback statements handled correctly?: Yes. Joint accounts use the same layout as single-name accounts. 1|2|3 cashback line items are preserved as their own rows tagged 'CASHBACK' so they reconcile against the originating Direct Debits and are easy to total per month or per category.