Life events

Durga Puja para club chanda: a treasurer's income and expense sheet

A simple income and expense sheet for a Durga Puja para club treasurer: receipt-numbered chanda, costs by head, and a closing balance report for members.

Editorial illustration for Durga Puja para club chanda: a treasurer's income and expense sheet

A Durga Puja chanda account needs only two tabs: one for money received, with a receipt number against every line, and one for money spent, grouped by head such as idol, pandal, lights, bhog, priest and cultural programme. The closing balance is total received minus total spent. If both tabs are filled the same day the money moves, the final report takes ten minutes.

What goes on the income tab?

Every rupee that comes in gets one row. Set up these columns in row 1 and freeze the row so it stays visible.

ColumnWhat to enter
A: Receipt no.The number printed on the receipt book page you handed over
B: DateDate the money was received
C: ContributorHousehold, shop or sponsor name, as on the receipt
D: TypePara chanda, shop donation, sponsor, or other
E: AmountRupees received
F: ModeCash, UPI or cheque
G: Collected byName of the volunteer who took it

The receipt number is the most useful column. When two volunteers carry separate books, gaps in the sequence show a receipt that was cancelled, lost or never accounted for. To catch a number typed twice, select column A and add a conditional formatting rule with the formula =COUNTIF($A$2:$A$400,A2)>1 and a red fill.

How should expenses be grouped?

Use the same heads every year so this year can be compared with the last one. A workable list:

  • Idol and artisan: advance, balance, transport of the idol
  • Pandal and decoration: structure, cloth, theme work, labour
  • Lights and sound: lighting, generator or power, speakers
  • Bhog and prasad: ingredients, cooks, serving ware, volunteers' meals
  • Priest and puja items: priest's fee, flowers, fruit, samagri
  • Cultural programme: artists, stage, prizes
  • Permissions and miscellaneous: local clearances, cleaning, printing

Each expense row needs a date, the head, the vendor, the amount, how it was paid and a bill or voucher number. Where a vendor gives no bill, write a small voucher with the vendor's name and a signature and give it a number in the same series. Staple or photograph every bill the same day.

How do I add up each head?

Keep a summary block at the top of a third tab. For each head, use SUMIFS, which adds amounts that match a label. If the expense amounts are in column E and the heads in column C of a tab named Expenses, then =SUMIFS(Expenses!$E$2:$E$400, Expenses!$C$2:$C$400, "Bhog and prasad") gives the bhog total. The label must match the head's spelling exactly, so pick heads from a drop-down list rather than typing them.

Total income is =SUM(Income!$E$2:$E$400), total spend is =SUM(Expenses!$E$2:$E$400), and the balance is the first minus the second.

What does the closing statement look like?

Say, purely as an illustration, that 120 households gave ₹500 each, shops gave ₹35,000 and one sponsor gave ₹25,000. Income is 60,000 + 35,000 + 25,000 = ₹1,20,000. Spend might be idol ₹30,000, pandal ₹28,000, lights ₹14,000, bhog ₹22,000, priest ₹5,000 and cultural programme ₹12,000, which adds to ₹1,11,000. The closing balance is ₹9,000. Whether that sits as a cash float, a deposit in the committee account or a carry-forward is a decision for the committee, recorded in the minutes.

Do I need to publish the accounts to members?

Most committees do, and a one-page statement is the usual form: income by type, expense by head, balance, and the names of the treasurer and the person who checked the books. Whether your committee must follow registration, audit or tax requirements depends on how it is set up. Rules change, so ask your CA or the registering authority instead of relying on a sheet template.

A treasurer's checklist for the week after puja

  1. Match every receipt number in the book to a row, and mark cancelled ones as cancelled with the receipt kept
  2. Make sure every expense has a bill or a numbered voucher
  3. Compare the sheet's cash total with the tin and its UPI total with the committee account
  4. Print the closing statement and have a second member sign it
  5. Keep the receipt books, bills and the sheet together for next year's committee

One caution: SpendixAI is a personal workspace, not a team tool, so it suits your own household's pujo spending and not the committee's books. Keep the two separate so no personal payments end up in the club's records.

SPENDIXAI JOURNAL

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

Explore your reports