Import Santander statements into Sage

Sage's bank import wants a clean CSV with unambiguous dates and signed amounts — exactly what a converted Santander statement produces.

Convert the statement first

1. Upload the Santander PDF to the converter — current accounts, savings or business.
2. The money-out/money-in columns become one signed amount column, verified row by row against the running balance and the statement's printed totals.
3. Download the CSV export.

Import into Sage

1. In Sage Business Cloud Accounting, open Banking, select the account, and choose the import/upload statement option.
2. Select the CSV. Our column layout is date, description, amount, balance — map those three fields when prompted (the balance column is for your reference).
3. Confirm, then match and categorise as usual.

Santander-specific notes

• Dates arrive ISO (YYYY-MM-DD), which Sage reads unambiguously regardless of your region settings — no 03/04 vs 04/03 guessing.
• Business statements with card takings and supplier payments keep full references for Sage's matching.

Reconciling

The statement reconciled against its own printed balances before export, so Sage's imported period will tie out to the statement's closing figure. Work month by month for catch-up years — convert and import in date order.