Life events

Ganpati mandal treasurer: collection and expense register

A collection and expense register for a Ganpati mandal treasurer: donations with receipt numbers, expenses by head, and a closing statement for members.

Editorial illustration for Ganpati mandal treasurer: collection and expense register

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.

ColumnPurpose
Receipt no.Matches the printed receipt book
DateWhen it was received
Donor name and flat or shopSo the receipt can be traced
Amount in rupeesCash or UPI value only
ModeCash, UPI or cheque
Goods donatedItem and approximate value, kept in its own column and not added to cash
Received byVolunteer'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

  1. Reconcile the receipt book against the donations list
  2. Collect every outstanding bill, and write a numbered voucher for any payment that has none
  3. Count the cash box with a second person and deposit it as the committee decides
  4. Compare the bank account with the UPI entries
  5. Draft the closing statement and circulate it before the meeting
  6. File the register, bills and receipt books together for next year's treasurer
SPENDIXAI JOURNAL

Useful ideas start with a clearer picture of your own spending.

Explore your reports