On the Santander website or app, select the account, filter the dates and download the transactions as Excel; then upload the file to Aurio from Accounts. Aurio recognises the table (transaction date, description and amount in euros) and shows you a review before saving. Santander lets you download up to two years of transactions.
How to download your Santander statement
- On the web, go to “Acceso clientes” and select the account. In the app, open your Posición Global and select the account.
- Filter by the dates you need (in the app, from “Filtros”).
- Tap “Descargar” and choose Excel.
- In Aurio, go to Accounts → Import, choose the destination account and upload the file as it is.
Online banking menus change from time to time. If you cannot find an option, check the official Santander help.
Which format to choose for Aurio
Recommended format: Excel (XLS). Formats Santander offers: Excel (XLS), PDF.
The Santander Excel file has a couple of information rows before the table (FECHA OPERACIÓN, FECHA VALOR, CONCEPTO, IMPORTE EUR, SALDO). Aurio skips them, uses the transaction date, the description and the signed amount, and ignores the running balance.
We tested this format with a synthetic sample file (no real data) that mirrors the columns of the Santander statement. If Santander changes its file layout and something looks off, the review will show you before anything is saved.
What Aurio does when you import
- Before anything is saved you get a review of every transaction: date, amount and description, so you can fix whatever needs fixing.
- If you upload a period you already imported, repeated transactions are flagged as duplicates in the review.
- Each transaction is categorised automatically: first with your rules and Aurio's, then, if needed, with AI on tokenised data, never with your name or IBAN.
- If the file does not say which amounts are spending and which are income, Aurio warns you instead of silently guessing.
- You do not need to connect your bank or give us your credentials: you download the file and decide what to upload.
Already have an account? Import your statement in Accounts.
Which period should you download first?
Start with one completed month from a single Santander account. Compare it with online banking without mixing accounts or dates that still contain pending entries. For a longer period, check that the download covers the whole interval: a bank may display a single results page even when you select a wider range. The file name does not prove that every row is present. Keep the original download and use the official help if you cannot find the export.
How do you check amounts, signs and balances?
In the review, find one incoming payment and one outgoing payment you recognise, then check their dates and amounts. A debit should reduce the balance; a credit should increase it. A Balance column contains the running account total, rather than the amount of each transaction. For example, a €25 debit and a €975 balance describe €25 leaving the account. If amounts appear multiplied by one hundred, signs are reversed or columns are shifted, stop and check the format before saving.
How should you handle transfers and cash withdrawals?
Moving money between your own accounts does not mean you spent that amount. Review both sides of a transfer so they do not become new income and consumer spending. A cash withdrawal also does not explain how you later used the cash: record those purchases if you want to analyse them by category. Do not change a bank amount to make a category total fit. Check classification against the transaction and keep the movement of money separate from its eventual use.
What if this statement overlaps an earlier import?
Check the start and end dates before uploading another file. Aurio looks for duplicates, but that does not replace checking the period, account and proposed rows. Two purchases for the same amount on the same day can be separate transactions; the same transaction exported with different wording may also look different. Compare the review with the last period you saved. If you switch from Excel to PDF, pay particular attention to descriptions and the number of rows before accepting anything.
What can you do if the file is read incorrectly?
Try the recommended format first: Excel (XLS). Renaming a PDF with an Excel extension does not convert its contents. Download the file again from Santander and avoid rearranging columns or deleting headers before your first attempt. If the problem persists, describe the format and error message when asking for help; do not post the complete statement, credentials or account details. After saving, open the destination account and check the stored transactions against the original file before treating the import as finished.
Frequently asked questions
How much history can I download from Santander?
According to Santander’s help, online banking shows transactions up to two years old; for earlier periods it refers you to a branch.
Can I download it from the app?
Yes. Santander describes the same process in the app: Posición Global → account → Filtros → Descargar. You can then upload the file to Aurio from your phone or computer.
Do I need to connect my Santander account to Aurio?
No. You download the file from Santander and upload it to Aurio: no bank connection and no credentials.
Santander is a trademark of its owner. Aurio has no commercial relationship with Santander: this guide is an independent tutorial to help you export your own data.
