Intesa Sanpaolo Statement to Excel Converter

Every Intesa Sanpaolo estratto conto prints the giacenza media of the previous year in a dedicated box, just after the movement detail — Intesa's FAQ points customers there when they need the figure for the ISEE. It is a single figure per account and year, not a movement.

FlowParse converts the movements and proves them against the saldo iniziale and saldo finale; the giacenza media is a separate figure you read from the statement as Intesa printed it. When the ISEE needs both the year-end balance and the average balance, keep the converted movements for the first and the statement itself for the second.

A bilancio, a dichiarazione dei redditi or a mutuo application often needs a full year, sometimes several accounts. Smart Merge takes up to 100 Intesa Sanpaolo PDFs and builds one workbook with every movement in date order, the source file on every row, and a check that each statement's saldo finale is the next one's saldo iniziale.

Statements from UniCredit, BPER, Banco BPM or Monte dei Paschi can be merged into the same workbook, matched column by column, for a company or household that banks in more than one place.

Italian firms and their commercialisti commonly keep the books in TeamSystem, Zucchetti or Danea, which import bank movements from a file. FlowParse exports a CSV with data contabile, data valuta, description and signed amount that fits a bank import, plus an Excel file for checking first. For a group that reports abroad, the same statement goes to QuickBooks, Xero, DATEV or Sage.

Because the full description is kept — counterparty, causale, CRO or TRN reference where the statement prints it — each line can still be matched to its fattura after the import.

An estratto conto downloaded from ARCHIVIO – DOCUMENTI in internet banking, or from ARCHIVIO – DOCUMENTI e PAGAMENTI in the app, carries real text — FlowParse reads it directly and every amount is what the bank printed. When the statements come from a client, ask for those PDFs rather than scans or photos of a printout; those can be converted through OCR, but a text PDF leaves nothing to interpret.

Upload each statement as one file so the proof can run from saldo iniziale to saldo finale. For a closed account, find the statements with Ricerca avanzata in the Archivio before the relationship ends entirely, and convert them together with the rest of the year.

Number formats come first: 1.234,56 with a dot for thousands and a comma for decimals is text in an English-locale spreadsheet, and 03/04 is easily read as March 4th. FlowParse reads figures and dates the Italian way and writes real numbers and dates. Second, the out and in columns: pasted by hand they collapse into one column of positive numbers, so a payment looks like a deposit. FlowParse signs each amount by its column.

Third, the description: a SEPA bonifico with the ordering party, the causale and a reference can run over several lines and, copied by hand, becomes several rows. FlowParse keeps one movement per row, and the balance proof confirms that nothing was split or dropped.

A commercialista takes on a self-employed client who needs the last two years' movements reconciled for a tax review. The movement list only reaches back 13 months, so the client downloads the estratti conto for both years from the Archivio and sends them as PDFs. The figures here are an illustration, not a real client's.

Uploaded together, the statements become one workbook in date order. Each is proved against its saldo iniziale and saldo finale, and each closing balance matches the next opening balance, so no period is missing. The commercialista filters the descriptions for the client's main customers, totals the incoming bonifici per year, and imports the CSV into the accounting system — work that would otherwise have meant retyping two years of movements.

Before you rely on converted Intesa Sanpaolo statements, check four things. Coverage: every statement in the period, each saldo finale matching the next saldo iniziale — Smart Merge flags any break. Dates: the data contabile is the one the balance follows; keep the data valuta for interest and for movements around the year end.

The reconciled mark: every statement proved against its own balances before you use the totals. And keep the PDFs: the converted file is a working copy and the estratto conto is the document of record — for the ISEE, the giacenza media is read from the statement itself, not from a sum of the movements.

The estratto conto of a current account is the main one: movements between a saldo iniziale and a saldo finale, which FlowParse turns into rows and proves. Statements for business accounts have the same shape and convert the same way, as do statements of closed accounts found through Ricerca avanzata.

Other documents in the Archivio serve other purposes. The documento di sintesi summarises the account's conditions and costs; the rendiconto del deposito titoli lists securities, not movements; a contabile documents a single online operation. Keep them alongside the statements — convert the estratti conto.