How to Prepare a Monthly Neighborhood Cash Report
A worked neighborhood cash report with opening balance, receipts, expenses, closing balance, and a reconciliation checklist.
A monthly neighborhood cash report summarizes money actually received and spent during a defined period. Residents should be able to understand the position without reading every receipt, while administrators retain supporting records.
What belongs in the report?
Include the community name, reporting period, preparation date, opening balance, receipts, expenses, closing balance, and reviewer. Keep unpaid dues separate: an outstanding bill is not cash received.
A worked monthly example
These figures are illustrative and do not represent a Dico Society customer.
- Opening balance: Rp2,000,000.
- Dues received: Rp3,000,000.
- Cleaning: Rp1,200,000.
- Security: Rp800,000.
- Facility maintenance: Rp250,000.
- Total expenses: Rp2,250,000.
- Closing balance: Rp2,750,000.
The formula is closing balance = opening balance + receipts − expenses. Once reviewed, Rp2,750,000 becomes the opening balance for the next month.
Reconcile against available money
Check the community bank balance and count cash on hand at the same closing date. Records should explain their combined amount. Document unidentified transfers and payments awaiting review, then resolve them before finalizing the report.
Do not change the closing balance simply to make it match. Investigate duplicate entries, unrecorded bank fees, or timing differences. Keep the reason, date, and reviewer for any correction.
Share the summary appropriately
A resident-facing report can show spending by category and upcoming needs. Full account numbers, phone numbers, and personal details in payment evidence do not need to be published. Offer a clear channel for residents to ask about a transaction.
Monthly closing checklist
- Define the period and closing date.
- Match receipts to verified evidence.
- Group expenses and retain receipts.
- Count cash and reconcile the bank account.
- Ask another administrator to review the summary before sharing it.
Read the transparent dues guide, or explore Dico Society reporting features.
Frequently asked questions
What is the closing cash balance formula?
Closing balance equals opening balance plus money actually received minus expenses paid.
Are unpaid dues part of the cash balance?
No. Track unpaid dues separately from money received and recognize the receipt once payment is verified.
Related articles
Build a Neighborhood Budget Around Real Community Needs
Start a community budget with needs and estimated costs, then compare them with realistic receipts. Agree on dues collectively; the example in this article is not a required rate.
A Checklist for Moving Community Dues to a Digital App
Begin with clean member records, an agreed opening balance, billing rules, and administrator roles. Test one billing cycle and reconcile the results before expanding use.
Ready to manage dues more easily?
Try Dico Society free for your community — transparent and hassle-free.
Get Started