From Sabadell online banking, open your account balances and transactions, filter the period and download them as Excel; then upload the file to Aurio from Accounts. Aurio skips the query header rows, finds the table and reads the date, description and amount. You review everything before saving.
How to download your Banco Sabadell statement
- Log in to Sabadell online banking from a computer.
- Open the account balances and statements section and filter the transactions for the period you need.
- Use the download icon for the transactions 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 Banco Sabadell help.
Which format to choose for Aurio
Recommended format: Excel (XLS). Formats Banco Sabadell offers: Excel (XLS), PDF.
The Sabadell Excel file starts with the query details (account, holder, dates) followed by the table: F. Operativa, Concepto, F. Valor, Importe, Saldo, Referencia 1 and Referencia 2. Aurio skips the query header, uses the value date, the description and the signed amount (also when it is written as “-45,60 EUR”).
We tested this format with a synthetic sample file (no real data) that mirrors the columns of the Banco Sabadell statement. If Banco Sabadell 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 Banco Sabadell 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 Banco Sabadell 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
What about the Referencia 1 and Referencia 2 columns?
Aurio does not need them: the description comes from Concepto. The references are not imported as the description.
What if my online banking offers Norma 43?
Aurio also reads Norma 43 (cuaderno 43) files. For a personal account, the Excel file is the most direct route.
Do I need to connect my Sabadell account to Aurio?
No. You download the Excel file from Sabadell online banking and upload it: no bank connection and no credentials.
Banco Sabadell is a trademark of its owner. Aurio has no commercial relationship with Banco Sabadell: this guide is an independent tutorial to help you export your own data.
