Santander España Statement to Excel Converter

To get it online, Santander says to look in your personal area for Descargar extracto mensual, or a similar option, and follow the steps. Holders of the account and people authorised to operate it can request the extracto.

Download one per month, or a range of months, into a folder per account. Upload the folder and Smart Merge puts the extractos in order, checking that each closing saldo runs into the next opening saldo.

For businesses, Santander's FAQ points to Banca Online de Empresas: Tesorería, then Cuentas corrientes y de crédito, choose the account, then Movimientos, where you can consult, filter and download.

Companies with several accounts get one extracto per account. Smart Merge keeps the account on every row, and transfers between your own accounts pair up and can be filtered out, leaving the real income and costs.

The fecha de operación is when the movement happened; the fecha valor is when it takes effect for interest — Santander's glossary calls it the date the operation becomes effective. For the books, the operation date matters; for checking interest or an overdraft charge, the value date does.

FlowParse keeps both in separate columns. Sort by operation date for the ledger; by value date when checking a descubierto charge against the days the account was actually overdrawn.

The opening saldo plus every signed operation must equal the closing saldo. FlowParse checks that on every Santander extracto, and checks each row against the saldo printed after it. A cargo read as an abono, or an operation lost at a page break, fails at the row where it happened.

Extractos that pass are marked reconciled; anything else is shown in the preview with the difference before you download.

For an IRPF return, a modelo 303 quarter, an Impuesto de Sociedades or a mortgage application, Smart Merge takes up to 100 Santander PDFs and builds one workbook with every operation in date order, the account and source on every row, and a check that each closing saldo is the next opening saldo.

Extractos from BBVA, CaixaBank, Sabadell or Bankinter can be merged into the same workbook, matched column by column.

Spanish gestorías and small businesses commonly work in A3, Contasol, Holded or Sage. FlowParse exports a CSV with both dates, concepto and signed amount for a bank import, and an Excel file for review first. For an international group, the same extractos go to QuickBooks or Xero.

Because the concepto is kept whole — the receipt issuer, the transfer reference, the Bizum sender — each operation can be matched to its invoice after import.

1.234,56 with a dot for thousands and a decimal comma is text in an English-locale spreadsheet, and 03/04 is the 3rd of April. A recibo with a long reference, or a card payment abroad with its exchange rate, wraps over two lines and becomes two rows.

FlowParse writes real signed numbers and unambiguous dates and keeps one operation per row; the saldo proof confirms nothing was split or dropped.

A teacher in Sevilla rents out a flat, with the rent paid into a Santander account that also pays the community fees, IBI, insurance and the mortgage. Their gestoría needs the year for the rendimientos del capital inmobiliario. The figures here are an illustration, not a real person's.

The owner downloads twelve monthly extractos and uploads them. FlowParse returns one table, each extracto proved from saldo to saldo. Filtering conceptos shows the twelve rents, the comunidad, the IBI receipt, the insurance and the mortgage instalments; the CSV goes to the gestoría, and the PDFs stay in the year's folder.

Coverage: each closing saldo equal to the next opening saldo, per account. Dates: operation date for the books, fecha valor for interest. Archive: extractos saved before they pass two years. Reconciled: every extracto proved before its totals are used.

And keep the PDFs. The extracto is the document of record for Hacienda, a bank or a court; the spreadsheet is the working copy.

Monthly extractos for current, savings and business accounts list operations between two saldos and convert the same way. Card statements convert as purchases and payments.

Receipt duplicates, certificates and letters are single documents. Keep them with the file; convert the extractos.

This page is about Banco Santander in Spain: euro accounts, bancosantander.es, the App Santander. Santander also operates in the UK, Poland, Mexico, Brazil, Argentina and Chile, each with its own statements, language and layout.

Each has its own FlowParse converter page. If you hold accounts in more than one country, Smart Merge can put them in one workbook with the currency and account on every row, so euros, pounds and pesos are never added together by mistake.

With movements online for two years, the habit that matters is saving: when each month's extracto is ready, download the PDF into a folder named by account and year. It takes a minute.

That folder outlasts the two-year window, avoids a branch visit for older months, and is ready for FlowParse. At year end, one upload gives you a proved table instead of an evening of retyping.