Practical guide
Managing the condominium cash day book
The cash day book is the chronological register of every cash and bank movement of the condominium: the foundation the property manager builds the annual financial statement on. A poorly kept day book is not just a cosmetic issue, it makes the statement easier to challenge at the assembly and slows down its approval. This guide covers how to record movements correctly, how to reconcile them against bank statements, and how to reach year end with balances that actually match, whether working manually or with management software such as AmministraPro.
What to record in the day book, movement by movement
Every entry in the day book needs a date, a description, an amount, a counterparty and a spending or income category. Recording the amount alone is not enough: the description must make it possible, months later, to reconstruct what that movement referred to without reopening the original invoice or receipt.
Instalment payments from residents should be recorded separately for each unit and each instalment, so it is always possible to check who has paid and who is in arrears. Payments to suppliers, incidental costs such as stamp duties and bank fees, and any contributions to the special reserve fund for extraordinary works should also be tracked distinctly.
A good practice is linking every movement to the corresponding line of the cost allocation plan, so that at year end the day book feeds directly into the financial statement instead of requiring everything to be reclassified by hand.
Reconciling against the condominium bank account
Property managers are required to keep condominium funds in a bank account held in the condominium's name, kept separate from their own assets. This makes bank reconciliation close to a mandatory step, not merely good accounting practice.
Reconciling means comparing, line by line, the movements recorded in the day book with those shown on the bank statement: every incoming transfer must match a recorded receipt, every debit a recorded payment. The most common discrepancies come from bank fees not yet recorded, transfers in transit across month end, or payments credited with a generic reference that need to be reattributed to the correct resident.
Reconciling monthly, rather than once a year, sharply reduces the time needed to close the financial statement and allows errors or anomalies to be caught immediately, which also protects the property manager in the event of a review.
Reaching the year end balance
Balancing means verifying that the cash and bank balance at year end, calculated by summing every movement in the day book, matches exactly the actual balance on the bank account and in the cash box. If it does not match, the discrepancy needs to be found before the financial statement is closed, not after the assembly meeting.
An effective method is progressive balancing: checking the balance at the end of every month, not only at year end. This way an error made in March is caught in April, when the cause is still easy to trace, rather than in December among hundreds of movements.
The annual financial statement, to be complete, should be structured into an accounting register, a financial summary and an explanatory note. A day book kept correctly and balanced throughout the year turns drafting these documents into a near automatic step rather than a retroactive reconstruction.
Digital tools for an error free day book
Keeping the day book on a spreadsheet exposes it to manual sum errors, duplicate entries and lost links between movements and supporting documents. Dedicated condominium management software such as AmministraPro records every movement already linked to the resident, the instalment and the expense category, calculating balances in real time and flagging discrepancies before they become a problem at statement time.
With digital recording of movements and assisted bank reconciliation, the property manager can check the balance at any point in the year, not only right before the assembly, and produce the financial statement with the required documents already populated with accurate data.
Frequently asked questions
How often should the condominium cash day book be updated?
The day book should be updated at every movement, in practice each time a payment is received or made, and in any case no later than the end of the month in which the movement occurred. Timely updates allow monthly bank reconciliation and turn the year end balancing into a quick check rather than a complex reconstruction. Software such as AmministraPro records the movement at the moment the payment or receipt is detected, removing the delay typical of manual spreadsheet keeping.
What happens if the day book does not balance at year end?
If the balance calculated from the day book does not match the actual holdings on the bank account and in cash, the financial statement cannot be considered reliable and the property manager needs to find the error before presenting it to the assembly. The most frequent causes are unrecorded movements, duplicate entries or amount errors. Progressive balancing month by month, rather than only at year end, reduces the number of movements to check and makes it easier to isolate the error.
Is a separate bank account mandatory for the condominium?
Yes, property managers are required to route all sums received, for any reason, from residents or third parties through a specific bank or postal account held in the condominium's name. This obligation ties the day book and bank reconciliation closely together: every cash movement must find a match on the account held in the condominium's name, never on the property manager's personal accounts.
What is the difference between the day book and the annual financial statement?
The day book is the analytical, chronological register of every single cash movement during the year, while the annual financial statement is the summary document the condominium approves at the assembly, made up of an accounting register, a financial summary and an explanatory note. A day book kept correctly and updated throughout the year is what allows the statement to be built without reconstructing movements after the fact.
Can condominium management software replace a paper day book?
Yes, and it is the solution most widely adopted today among professional property managers: software such as AmministraPro replaces the paper or spreadsheet day book with a digital register where every movement is already linked to the resident, the instalment and the expense line of the cost allocation plan. This reduces transcription errors, speeds up bank reconciliation and allows the annual financial statement to be generated with data already organized in the required structure.
Try AmministraPro
Accounting, thousandths-based cost splitting, meetings, communications and artificial intelligence in a single Italian software, compliant with UNI 10801 and GDPR.