A Holi ledger for a housing society needs two things: a list of what each flat contributed and a list of what was spent, with a running balance after every entry. At the end, the closing balance is what you report to residents. Keep it in one sheet with columns for date, type, flat or item, money in, money out and balance, and share the final figures openly.
What columns does the ledger need?
- A: Date
- B: Type, either Collection or Expense
- C: Flat number for collections, item and vendor for expenses
- D: Money in
- E: Money out
- F: Balance after this entry
- G: How it was paid, such as UPI, cash or cheque
- H: Proof, such as a bill number or a screenshot
The balance in F2 is =SUM($D$2:D2)-SUM($E$2:E2). Copy it down and each row shows what is left after that entry. Entries must be in date order for the running balance to make sense.
A worked example for a society of 42 flats
Say the committee asks every flat for ₹300. Thirty-eight flats pay that, two give ₹500 each and two do not take part. Collections are 38 × 300 = 11,400 plus 2 × 500 = 1,000, which is ₹12,400. The spends are as below.
| Expense | Paid to | Amount |
|---|---|---|
| Colours | Shop, bill kept | ₹2,800 |
| Water arrangement | Water supplier | ₹1,200 |
| Sound system | Hire vendor | ₹2,500 |
| Snacks and thandai | Caterer | ₹3,600 |
| Extra cleaning staff | Staff, listed by name | ₹1,000 |
| Floor covering | Shop, bill kept | ₹600 |
| Total spent | - | ₹11,700 |
The total is 2,800 + 1,200 + 2,500 + 3,600 + 1,000 + 600 = 11,700. The closing balance is 12,400 - 11,700 = ₹700.
Here is how the first few rows might read. Row 2 is a collection from flat 101, ₹300 in, balance ₹300. Row 3 is a collection from flat 102, ₹300 in, balance ₹600. Row 4 is the colours bill, ₹2,800 out, balance -₹2,200 if collections are still thin, which is a useful warning that you are spending ahead of what you have collected. Collect first, spend after, and the balance never dips below zero.
A second small table on another tab is also worth having: a list of all flats with a Paid column. =COUNTIF(B2:B43,"Yes") then counts how many have contributed, and =COUNTA(A2:A43)-COUNTIF(B2:B43,"Yes") shows how many are still to come, if flat numbers are in A2 to A43 and Yes or No is in column B.
What do you do with the leftover balance?
Decide before you collect. Common choices are to carry it forward to the next society event, to put it toward a common-area cost, or to refund it. ₹700 across 40 paying flats is ₹17.50 each, which is awkward to refund, so carrying it forward may be the practical choice. The committee should agree and write the decision in the sheet so it does not turn into an argument later.
How do you keep the money trail clean?
- Collect through the society's own account where one exists, and avoid a personal account for society money.
- Give every cash payment a receipt or a signed entry.
- Record each expense on the day, with the vendor and a bill number.
- Have two committee members check the ledger against the bills before it is shared.
- Check your society's bye-laws for how event funds should be held and reported.
What if some flats did not contribute?
Keep a column for flats not yet paid and review it with the committee. Contributions for festivals are usually voluntary, so follow whatever your committee and residents agreed. Do not publicly name flats unless that is already how your society handles such matters.
Before the event
- Amount per flat decided and announced with the purpose
- A single person responsible for the ledger
- Account to collect into agreed
- Spending limit for each line set
- Date set for sharing the final statement
Useful ideas start with a clearer picture of your own spending.
Explore your reports


