A Ganpati mandal register is two linked lists and one summary: donations received, each with a receipt number; expenses paid, each under a head; and a closing statement that sets one against the other. Keep the lists in a spreadsheet or a bound ledger, update them the day money moves, and have a second member check them before the festival ends.
How should the donations list be laid out?
Give every donation its own line and keep cash, UPI and goods apart, so that you can reconcile each with a different thing: the cash box, the bank account and the stores.
| Column | Purpose |
|---|---|
| Receipt no. | Matches the printed receipt book |
| Date | When it was received |
| Donor name and flat or shop | So the receipt can be traced |
| Amount in rupees | Cash or UPI value only |
| Mode | Cash, UPI or cheque |
| Goods donated | Item and approximate value, kept in its own column and not added to cash |
| Received by | Volunteer's name |
If the receipt book starts at 1 and numbers run in sequence, you can count the missing receipts with =MAX($A$2:$A$400)-COUNT($A$2:$A$400). A result of zero means no number is missing. A positive result tells you how many receipts to look for, whether cancelled, unused or not yet entered.
What are the usual expense heads?
- Mandap and structure
- Idol and its transport
- Sound and lights
- Electricity or generator
- Aarti items, flowers and prasad
- Decoration and banners
- Cultural events and competitions
- Visarjan: vehicle, band, cleanup
Record the date, vendor, head, amount, mode and bill number for every payment. Name the person who authorised it. Where members pay from their own pockets and claim back later, mark those rows so that the mandal does not end up owing someone without anybody noticing.
How do I total each head and the whole festival?
With heads in column C and amounts in column E of an Expenses tab, =SUMIF(Expenses!$C$2:$C$400, "Mandap and structure", Expenses!$E$2:$E$400) returns the total for one head. Note the argument order: SUMIF takes the range to test, then the criterion, then the range to add. For the whole festival, =SUM(Expenses!$E$2:$E$400).
Two habits make the expense list easier to defend later. First, never record a round figure without a bill or voucher behind it. Second, if a vendor is paid in two parts, enter both parts as separate rows against the same bill number, so that the advance and the balance can be traced.
What should the closing statement show?
Take a hypothetical festival. Cash donations come to ₹2,10,000, UPI to ₹45,000 and banner sponsors to ₹30,000, which is ₹2,85,000. Expenses are mandap ₹70,000, idol ₹55,000, sound and lights ₹40,000, electricity ₹15,000, aarti items and prasad ₹35,000, decoration ₹25,000 and visarjan ₹20,000, which comes to ₹2,60,000. The surplus is ₹25,000. Goods donated stay on a separate line in the statement as items received, with their approximate value, and are not part of that figure.
Do members need to see the books?
Most mandals share a one-page closing statement at a general meeting or on a notice board, and keep the full register available for any member who wants to see it. Whether your mandal has registration, audit or tax obligations depends on how it is constituted and where it operates. Rules vary and change, so ask your CA or the local registering office.
What to do in the last week
- Reconcile the receipt book against the donations list
- Collect every outstanding bill, and write a numbered voucher for any payment that has none
- Count the cash box with a second person and deposit it as the committee decides
- Compare the bank account with the UPI entries
- Draft the closing statement and circulate it before the meeting
- File the register, bills and receipt books together for next year's treasurer
Useful ideas start with a clearer picture of your own spending.
Explore your reports

