UniCredit Statement to Excel Converter

The two documents sit side by side in Documenti On Line and are easy to confuse. The estratto conto lists the movements between an opening and a closing balance: this is the one for bookkeeping, a tax return or a bank reconciliation. The estratto conto scalare is the interest computation — balances by value date, the numbers the bank used to calculate interest and charges for the period.

Convert the estratto conto. FlowParse proves it against its own balances, so a movement list that adds up is the confirmation that you picked the right document. Keep the scalare for checking interest, and the documento di sintesi for the account's conditions.

A bilancio, a dichiarazione dei redditi or a mutuo application usually needs a full year, often from more than one account. Smart Merge takes up to 100 UniCredit PDFs and builds one workbook with every movement in date order, the source file on every row, and a check that each statement's closing balance is the next one's opening balance.

Statements from Intesa Sanpaolo, BPER, Banco BPM or Monte dei Paschi can be merged into the same workbook, matched column by column, for a company or household with accounts at more than one bank.

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 whole description is kept — ordering party, causale, the reference of an SDD mandate — each line can still be matched to its fattura after the import.

An estratto conto downloaded from Documenti On Line 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 opening to closing balance, and for a year upload them together. If an account is being closed, save its statements from Documenti On Line first — UniCredit's terms for online-only accounts say the final estratto conto is then sent on paper.

Italian 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 turn into one column of positive numbers, so a debit looks like a credit. FlowParse signs each amount by its column.

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

A couple applying for a mutuo is asked for the last six months of statements from both their UniCredit accounts. They download the statements from Documenti On Line and want to see, before the bank does, what the statements say about income and regular outgoings. The figures here are an illustration, not a real family's.

Uploaded together, the statements become one workbook in date order with the account on every row. Each statement is proved against its own balances, and each closing balance matches the next opening balance, so nothing is missing. Filtering the descriptions shows the two salaries, the rent, a car loan instalment and the quarterly charges — the same picture the bank's analyst will see, ready before the meeting.

Before you rely on converted UniCredit statements, check four things. The document: the estratto conto, not the scalare or the documento di sintesi. Coverage: every statement in the period, each closing balance matching the next opening balance — Smart Merge flags any break. Dates: the data contabile is the one the balance follows; keep the data valuta for interest.

Finally, the reconciled mark: every statement proved against its own balances before you use the totals. And keep the PDFs from Documenti On Line — the converted file is a working copy, the estratto conto is the document of record.

The estratto conto of a current account — personal or business — is the main one: movements between an opening and a closing balance, which FlowParse turns into rows and proves. Credit card statements convert as a list of purchases and payments against the previous and new balance.

The estratto conto scalare, the documento di sintesi and the contabile of a single bonifico serve other purposes: an interest computation, the account's conditions, and proof of one payment. They are references, not inputs for a bank reconciliation. Keep them with the statements; convert the estratti conto.