Practical guide
How to run the periodic reconciliation of cash and bank
Reconciliation is the check that verifies the consistency between the real balances of the condominium's money, petty cash and current account, and what the books show. Doing it periodically, and not only at year end, lets you catch errors while they are still few and easy to reconstruct, instead of ending up at year end with a discrepancy of unknown size and months of movements to retrace. This guide explains how to set up a periodic reconciliation of cash and bank, which balances to compare, how to spot and correct the most common discrepancies and how this check prepares a solid statement that is hard to challenge at the owners' meeting.
The steps of periodic reconciliation
- Compare the account's book balance with the bank statement balance on the same date
- Compare the cash book balance with the cash actually on hand
- Record missing bank charges: fees, commissions, stamp duty and interest
- Verify that transfers between cash and bank are neutral on totals
- Check that recorded payments correspond to real debits and there are no duplicates
- Verify the sum of all resources against the previous period
What reconciling the books means
Reconciling means verifying that the balances shown by the books match the money actually available. For the current account the reference is the bank statement balance on a given date; for petty cash it is the money physically present. The books are correct when the book balances of account and cash match these real figures, to the cent.
Reconciliation is not a formality but the proof that every movement has been recorded and that no real operation has been left out of the books or counted twice. A book balance that matches the bank balance is the guarantee that the statement rests on true data, not on estimates or omissions.
Why do it periodically and not only at year end
Postponing reconciliation to the close of the year is the most expensive mistake. At year end the accumulated discrepancy can be of unknown size and the result of dozens of movements over many months: reconstructing it means retracing the whole year in search of the error, a long and frustrating task that often lands right before the approval meeting.
Monthly reconciliation, or at least on every receipt of the bank statement and the charges statement, keeps the discrepancy always close to zero. If one month does not balance, the error is confined to that month's movements and is found in minutes. Periodic discipline turns a potentially unmanageable problem into a quick routine check.
Comparing balances: account and cash
For the account you compare the book balance with the bank statement balance on the same date. Care is needed with value dates: a transfer recorded in the books on the order date but credited by the bank with a later value date creates a temporary discrepancy that clears itself, and it must be distinguished from real errors. Items in transit, such as cheques not yet cashed, must be considered in the reconciliation.
For cash you compare the cash journal book balance with the cash actually present. A discrepancy here usually signals a small expense paid in cash but not recorded, or a forgotten withdrawal or deposit between cash and bank. Since the cash box should move only modest amounts, discrepancies are generally small and easy to reconstruct, but they must be closed all the same.
Spotting and correcting the most common discrepancies
Recurring discrepancies have typical causes. Unrecorded bank charges, fees, commissions and stamp duty debited by the bank without a real-time document, are the first to check: you record them from the charges statement and the discrepancy clears. A payment counted twice, or a receipt recorded but not yet credited, are other frequent causes.
Badly recorded transfers are a classic: a withdrawal from the account counted as an expense, or a deposit counted as a receipt, shifts the totals without the real money having changed. The neutrality check, that is verifying that the sum of all resources is consistent with the previous period net of the real income and outgoings, helps isolate these cases. Every discrepancy must be corrected at its source, not offset with a generic adjustment.
Reconciliation as the basis of the statement
The statement required by Article 1130 bis of the Italian Civil Code must represent clearly and truthfully the condominium's income, outgoings and financial position. Books reconciled month by month are the condition for the year-end statement and cash position to be immediately reliable, without last-minute adjustments.
A statement built on already-reconciled books is also harder to challenge at the owners' meeting: the balances match the bank statements, every movement has its supporting document and the financial position reflects the money actually available. Periodic reconciliation is therefore not only a technical check, but a safeguard for the manager toward the owners.
Reconciling with software
A management platform that keeps every resource's balances up to date and allows reconciliation with the bank statement makes periodic reconciliation a fast operation: it shows the discrepancy between the book balance and the bank balance, highlights unreconciled movements and flags transfers that alter totals. The neutrality check on resources becomes automatic.
AmministraPro lets you reconcile movements with the bank statement, compare the book balances of account and cash with the real figures and spot discrepancies before closing, so that the statement rests on reconciled data. To see how these checks integrate with the cash journal, bank charges and the statement, you can review the features on the /funzioni page and the plans on the /prezzi page.
Frequently asked questions
How often should cash and bank be reconciled?
Ideally every month, or at least on every receipt of the bank statement and the bank charges statement. Periodic reconciliation keeps the discrepancy always close to zero: if one month does not balance, the error is confined to that period's movements and is found in minutes. Postponing the check to the close of the year is the most expensive mistake, because at year end the accumulated discrepancy may require retracing months of movements right before the meeting.
What exactly do I compare to reconcile the current account?
The account's book balance with the bank statement balance on the same date. Value dates must be considered, because a transfer recorded on the order date but credited with a later value date creates a temporary discrepancy that clears itself, along with items in transit such as cheques not yet cashed. Once these temporary differences are explained, the book balance must match the bank balance to the cent.
The cash balance doesn't match the cash on hand: where do I look?
A discrepancy between the cash journal book balance and the cash actually present usually signals a small expense paid in cash but not recorded, or a forgotten withdrawal or deposit between cash and bank. Since the cash box should move only modest amounts, discrepancies are generally small and easy to reconstruct by retracing recent movements. They must still be closed by correcting the error at its source, not with a generic adjustment.
How do I notice if a transfer has distorted the reconciliation?
With the neutrality check: the sum of all resource balances, cash and bank, must be consistent with the previous period net of the real income and outgoings. If the overall total has changed without a real expense or receipt, a transfer was mistakenly recorded as a cost or income. A withdrawal counted as an expense or a deposit counted as a receipt are the typical cases, to be corrected at the source with the correct neutral description.
Why does periodic reconciliation make the statement harder to challenge?
Because a statement built on already-reconciled books rests on balances that match the bank statements, with every movement backed by its supporting document and a financial position that reflects the money actually available. The statement required by Article 1130 bis of the Italian Civil Code must be clear and truthful: reconciling month by month ensures the statement and cash position are reliable, without last-minute adjustments that fuel doubts at the meeting.
Try AmministraPro
Accounting, thousandths-based cost splitting, meetings, communications and artificial intelligence in a single Italian software, compliant with UNI 10801 and GDPR.