Santander gives you two different downloads
Santander UK provides transaction exports and PDF statements. They are useful for different jobs.
| Transaction download | PDF statement | |
|---|---|---|
| What it is | A list of transactions for a selected range | The official statement for a period |
| Formats stated by Santander | Microsoft Excel, Quicken, Adobe Acrobat PDF, Microsoft Money | PDF/e-document |
| Limits | 600 transactions per personal download; 3,000 on business accounts | Best for statement periods and records |
| Best for | Recent analysis or a clean export if it covers the full period | Accountants, audits, year-end and missing export ranges |
If the export covers the full period and imports cleanly, use it. If it hits the transaction limit, does not match statement periods, or the client only has PDFs, convert the PDF statements instead.
How to download Santander UK transactions
Santander's public help says you can download detailed transactions by choosing whether you want a date range or everything since the last download, then picking a file format such as Microsoft Excel and clicking Download.
Two limits matter:
- Personal accounts: 600 transactions per download.
- Business accounts: 3,000 transactions per download.
If the period has more transactions than the limit, Santander says you may need to limit the date range and perform more than one download. For bookkeepers, this is where mistakes creep in: one missing date range can leave a gap in the ledger.
How to download Santander UK statements as PDFs
Santander's paper-free statement pages say documents are available in Mobile and Online Banking, and a PDF can be downloaded and printed. For bookkeeping work, ask the client for the official PDF statement for each month or statement period.
Use the PDF when:
- the export limit is hit
- you need opening and closing balances
- you need the statement period, not an arbitrary search range
- the client sends e-documents rather than export files
- an accountant, auditor or lender asks for the official statement
Converting a Santander UK PDF statement
A Santander PDF statement usually needs the same cleanup as other UK bank PDFs: wrapped descriptions, separate money-in and money-out columns, and running balances that need to stay aligned.
Workflow:
- Upload the Santander PDF statement.
- Use OCR mode if the file is scanned or image-based.
- Choose Excel, CSV, JSON, Xero CSV or QuickBooks CSV.
- Download one transaction per row.
- Check the opening balance, closing balance and a few sample transactions against the PDF.
Dates should stay UK day-first, and amounts should stay in pounds.
Santander UK to Xero, QuickBooks or FreeAgent
For Xero or QuickBooks, a generic Excel file is often not enough. Use the accounting-software output directly:
- Xero CSV: use when importing statement lines into Xero.
- QuickBooks CSV: choose 3-column or 4-column based on your QuickBooks import setup.
- FreeAgent: use CSV and check that the final layout matches FreeAgent's import rules before upload.
Bookkeepers should keep the original Santander PDF with the client records and use the converted file as the working copy.
Santander UK checklist for bookkeepers
Before importing Santander statement data:
- check whether the native export hit the 600-transaction limit
- check the period matches the client's bookkeeping period
- keep PDF statements as source records
- confirm UK date order after opening in Excel
- check debit and credit signs before import
- watch for transfers between Santander accounts
- avoid overlapping a converted file with an existing bank feed