Importing bank statements into condominium software

Importing bank statements into condominium software means loading a file of banking transactions downloaded from home banking, instead of typing them one by one. The software reads the file, recognises the date, amount, sign, and reference of each operation, and turns them into ledger entries ready for reconciliation. It is the simplest way to align accounting with the condominium bank account when automatic connection is not used, and it stays very handy for recovering past periods or handling banks that only offer downloadable files.

Which formats exist

Italian banks provide the statement in various formats. The most common in condominium management are:

• Interbank system layouts, historically used to exchange flows between bank and business, which report transactions in a fixed-length structured format;
• Separated-value files, typically with a spreadsheet extension, easy to open and check visually;
• Reporting files in an open standard format, increasingly common because they are independent of the single institution;
• The PDF statement, suitable for reading but not for automatic import, because it lacks a reliable data structure.

Before choosing the format, it is worth checking which one the condominium's bank offers and which one the software reads without losing information, especially the payment reference, which is the key to correctly matching transactions to installments and invoices.

How to set up the import

The flow is straightforward. From home banking you download the transactions file for the desired period. In the software you select the condominium's bank account and load the file. The software interprets the layout and shows a preview of the recognised rows, with the option to correct any mappings. On confirmation, the transactions enter the ledger. The first import requires attention, because you define the correspondence between the file's columns and the software's fields; subsequent imports with the same format are immediate.

The payment reference and the traceable transfer

The transaction reference is what lets the software understand who or what an operation relates to. For owners' credits, a reference stating the stairwell, unit, or installment code makes matching almost automatic. For payments to suppliers that give rise to tax deductions, such as work on common areas, it is essential that the transfer carries the data required by law, the so-called traceable transfer, with the reason, the tax code of the party entitled to the tax benefit, and the supplier's VAT number. Importing these transactions correctly later helps reconstruct the tax communications and the documentation supporting the deductions.

Checks to run after the import

The import must always be verified, because a file may contain duplicate rows or periods overlapping ones already loaded. The minimum checks are these:

• Compare the file's closing balance with the bank's actual balance on the same date;
• Rule out that transactions already present are imported twice, checking the start and end dates of the period;
• Ensure transfers between different funds are not counted as real income or expenses;
• Verify that bank charges and fees are recorded on the correct account.

A well-configured tool flags possible duplicates and prevents the same transaction from being imported twice, but the final balance check remains the strongest guarantee of accounting consistent with the condominium bank account required by Article 1129 of the Italian Civil Code.

Manual import or automatic connection

File import is flexible and requires no permanent connection to the bank, so it works well for recovering past accounting years or working with institutions that offer no automatic interfaces. It does carry a recurring time cost, though, because each period must be downloaded and uploaded. Where available, the automatic open banking connection brings the same transactions without the file step. Many firms use both methods together, automatic on the main accounts and file import for special cases or for migrating historical data.

Concrete benefits for the manager

Compared with manual transcription, importing drastically reduces typing errors, speeds up recording even hundreds of transactions, and creates a solid basis for reconciliation. Closing the annual financial report, required by Article 1130-bis, becomes a balancing check rather than a long reconstruction. The time saved can be devoted to relations with owners and to checking arrears.

AmministraPro lets you import bank statements in the most common banking formats, recognise payment references, and propose matches with installments and invoices. You will find accounting and banking management described on the /funzioni page and the plans available by number of managed condominiums at /prezzi.