When you convert Banco BPM bank statement PDF to CSV for QuickBooks, you turn an Italian bank statement into rows that QuickBooks Online can import and reconcile. Banco BPM, one of Italy's largest banks, issues statements through its YouWeb online banking and mobile app, and those PDFs read well but cannot be imported. The conversion has to handle Italian descriptions, euro amounts with comma decimals, day-first dates, and SEPA transfer references, all without losing a single row. Done carefully, it replaces an evening of manual entry with a ten-minute import and review.
Italian statements have their own quirks. Bonifico entries carry long reference strings, card purchases show the merchant and the posting date separately, and fees appear under names that do not translate neatly. This guide covers the full workflow: downloading the right document, converting it, normalizing the formats, importing into QuickBooks Online, and reconciling in euros.
Download the full Banco BPM statement PDF
Sign in to Banco BPM YouWeb or the app, open the account, and go to the statements or documents area. Choose the account and the period, then download the PDF statement, not a printout of the on-screen list. The PDF carries the opening balance, every posted transaction, interest, fees, and the closing balance, while the on-screen list can truncate descriptions and hide older pages. Download each account separately if you hold more than one, and name files by account and month.
Before converting, open the PDF and verify the opening balance against the prior statement's closing balance. A mismatch means you have the wrong period or a missing page. Also note the statement currency and the IBAN shown on the document, so you can confirm later that the CSV you import belongs to the same account. For background on the bank, see our Banco BPM bank page. For the general conversion method, see our guide on how to convert a bank statement PDF to Excel.
Convert the PDF and normalize Italian formats
Upload the PDF to a converter and check the CSV column by column. The two essential normalizations are dates and decimals: change DD/MM/YYYY dates to MM/DD/YYYY for QuickBooks, and change comma decimals to point decimals, so 2.400,75 becomes 2400.75. Sort the rows by date after the change, and confirm the running balance still moves sensibly from row to row. A date or decimal error usually shows up as a wild jump in the balance.
Keep SEPA references intact. Bonifico descriptions often include a purpose or invoice reference that your accountant needs later, and truncating them makes matching payments to invoices much harder. If a description is very long, keep the full text in the CSV description and shorten only the display name inside QuickBooks. Add a category note column for recurring items like rent, utilities, and payroll taxes, so the review step goes faster.
Import the CSV into QuickBooks Online
In QuickBooks Online, go to Transactions, then Bank transactions, select the account for your Banco BPM activity, and import the CSV. Map Date, Description, and Amount, then study the preview before confirming. The preview catches the classic errors: dates in the wrong month, amounts inflated by a surviving comma decimal, and rows merged because a description contained a line break. Fix problems in the CSV and re-import; patching them one by one inside QuickBooks wastes the time the conversion saved.
After import, review the suggested matches with care. QuickBooks matches on payee names and amounts, and Italian merchant names may differ from the vendor names in your books. Merge duplicates, rename vendors where needed, and create bank rules for the payments you make every month. A careful first month builds rules that make each following month nearly automatic.
Reconcile in euros and close the month
Reconcile against the statement closing balance in euros. If your QuickBooks file reports in US dollars, keep the Banco BPM account in euros and apply the month-end exchange rate only in your reporting, not inside the account itself. Reconciling in the statement currency keeps the balance check exact and keeps exchange gains or losses visible as their own lines.
At month end, compare the CSV row count with the PDF transaction count and confirm the closing balance matches. Small differences usually come from a fee line dropped in conversion, a card transaction that posted in the next period, or a SEPA transfer recorded on a different date. Keep the PDF, the CSV, and a note of the exchange rate together each month. Our guide on how to reconcile a bank statement covers the same close step by step.
Frequently asked questions
Can QuickBooks Online import a Banco BPM PDF directly?
No. QuickBooks imports CSV and QBO files, not PDFs. Convert the Banco BPM statement PDF to CSV first, normalize the dates and decimals, and then import the CSV.
What do I do with long bonifico references?
Keep them in the CSV description. They link a payment to its invoice or purpose, and trimming them makes later matching and audits harder. Shorten only the vendor display name inside QuickBooks if needed.
Why is my euro balance off after import?
Usually a comma decimal survived conversion, a fee line was dropped, or a transaction was dated into the next month. Check the decimal format first, then compare row counts against the PDF.
Should I reconcile in euros or dollars?
In euros, the statement currency. Apply exchange rates in your reporting, not in the bank account, so the reconciliation check stays exact.
Ready to import your Banco BPM activity? Convert the statement, normalize the formats, and import it with the steps above, starting from the ConvertStatement home page. If you convert statements in volume, check pricing for larger plans.