Reconciliation is dull and essential. Make it routine and it stays dull.
Match by booking
Every receipt should attach to a booking and an instalment. Unmatched money is a risk.
Track mode and status
Cash, cheque, bank transfer or other, and whether cleared. Filter payments by mode to check batches.
Close the loop weekly
Accounts and sales confirm unmatched items together. Differences usually come from late updates, not fraud.
Why reconciliation matters
Payments arrive through cheques, bank transfers, online payments and sometimes cash. If receipts are not matched promptly to bookings, balances become unreliable: buyers receive reminders for paid amounts, and finance cannot trust the collections report.
Regular reconciliation keeps the booking records, bank statements and accounts aligned.
Match by booking
Every receipt should be recorded against a specific booking, with amount, mode, reference and date. Ask buyers to include the booking reference in transfer remarks to make matching easier.
When a receipt cannot be matched, record it in a suspense list and investigate quickly. Unmatched receipts are a common source of disputes.
Tracking mode and status
Record the payment mode and status: received, cleared, bounced or pending. A cheque recorded as received may still bounce, so distinguish between received and cleared amounts.
Update status when the bank confirms clearance, and alert accounts and sales immediately if a cheque bounces.
Handling bounced cheques
When a cheque bounces, update the booking, inform the buyer politely and agree a replacement payment quickly. Apply any charges according to your written policy.
Record the event so that future payments from the same buyer can be monitored more closely if necessary.
Weekly bank matching
Once a week, compare bank statements with recorded receipts. Mark matched entries, investigate differences and correct errors. Weekly matching keeps problems small and easy to solve.
At month end, perform a fuller reconciliation and confirm totals with finance.
Separation of duties
Where possible, separate the person who records receipts from the person who reconciles them. Separation reduces the risk of errors going unnoticed and protects staff from suspicion.
Keep an audit trail of changes to payment records, including who edited what and why.
Communicating with buyers
Send buyers a receipt or confirmation when a payment is recorded. Clear confirmations reduce queries and give buyers confidence that their money has been accounted for.
If a payment is unmatched, contact the buyer promptly to confirm details rather than waiting until it becomes a dispute.
Reports that help
Useful reports include payments by mode, uncleared cheques, bounced payments and unmatched receipts. Owners should see collections by cleared amount, not just received amount.
Review these reports weekly alongside overdue collections.
A worked example
A bank statement shows a transfer without a booking reference. Accounts places it in the suspense list and checks recent bookings for a matching amount. A call to the likely buyer confirms the payment, which is then recorded on the correct booking and a receipt is sent.
The same week, a cheque bounces; the buyer is informed and pays by transfer two days later.
Common mistakes
Common mistakes include counting received cheques as cleared, leaving unmatched receipts unresolved for weeks, recording payments without references and allowing one person to record and reconcile everything without review.
Another mistake is reconciling only at month end, when errors are harder to trace.
Questions teams often ask
Should cash be accepted? Follow your company policy and applicable rules, and record cash receipts with the same care as other modes.
How quickly should payments be recorded? The same day they are received or confirmed.
In short
Record every receipt against a booking with mode and reference, distinguish received from cleared, handle bounced cheques quickly, match bank statements weekly, separate duties where possible and send buyers confirmations.
A reconciliation checklist
Daily: every receipt recorded against a booking with amount, mode, reference and date; confirmations sent to buyers; bounced cheques flagged to accounts and sales immediately.
Weekly: bank statements matched to recorded receipts; differences investigated; unmatched receipts worked from the suspense list; uncleared cheques reviewed.
Monthly: full reconciliation with finance; totals confirmed by project; audit trail checked for unusual edits; process issues noted and fixed. Keeping these three rhythms separates small daily corrections from the bigger monthly picture.
Why this protects buyers too
Accurate reconciliation is not only about the developer’s books. Buyers who pay on time deserve to see their payments reflected promptly and to never receive a reminder for money they have already sent. Clean records protect their trust and your reputation.
When disputes do arise, a clear record of every receipt, with references and dates, settles them quickly and fairly.
In practice
Start with the weekly bank match. Choose a fixed day, give one person ownership and work through the suspense list until it is empty. Once that rhythm is stable, add same-day recording discipline and the monthly finance review, and you will have a reconciliation process that keeps balances trustworthy all year.
Reconciliation done every week is quick; reconciliation left for months becomes a project of its own, full of guesses and difficult calls.
Keep it weekly and keep it boring.
Boring is good here.
Can I filter by payment mode?
Yes, payments can be filtered by project, mode and type.