Spreadsheets

Chit fund contribution tracker sheet for members and organisers

A chit fund tracker sheet for members and organisers: month-wise instalment, dividend, net paid, the month you get the pot and total paid in versus received.

Editorial illustration for Chit fund contribution tracker sheet for members and organisers

A chit fund tracker sheet is a month-by-month grid: the instalment due, any dividend or discount adjusted, the net you actually paid, and the month you receive the pot. Adding the net paid column and subtracting it from the pot you received shows the true cost or gain of the chit. Organisers use a different grid, with members across and months down.

What does a member need to track?

Make a tab with one row per month of the chit. Take the figures from your chit passbook or the organiser's statement; the terms of each chit differ, so do not assume yours matches an example.

ColumnHeadingNotes
AMonth no.1 to the last month of the chit
BDue dateDate the instalment falls due
CInstalmentSubscription for the month as per the agreement
DDividend or discountThe amount adjusted in your favour, from the statement
ENet paid=C2-D2
FDate paidActual date, to spot late payments
GPot receivedAmount received in your winning month; blank otherwise

For the winning month, type the pot amount you actually received in column G, after any discount and organiser commission that your chit deducts. Take it from the receipt, not from the headline value of the chit.

How do I see what the chit really cost?

Under the table, add three summary cells.

  • Total net paid: =SUM($E$2:$E$21)
  • Total pot received: =SUM($G$2:$G$21)
  • Net position: =total pot received - total net paid
  • Months paid late: =SUMPRODUCT(($F$2:$F$21>$B$2:$B$21)*($F$2:$F$21<>""))

Take a small, made-up chit: 10 members, ₹5,000 a month, 10 months, so the gross pot is ₹50,000. Say you win in month 4 and receive ₹44,000 after discount and commission. Across the ten months, dividends adjusted to you add up to ₹2,400, so net paid is 10 x ₹5,000 - ₹2,400 = ₹47,600. Net position is ₹44,000 - ₹47,600 = minus ₹3,600. So in this example the early pot cost ₹3,600 over the period, in exchange for having the money in month 4.

A chit won late can show the opposite sign: you may receive more than you paid in net terms. The sheet simply shows the figures; whether it was a good use of money depends on what else you could have done with that cash and on your own situation.

What should an organiser track instead?

Organisers need to know, month by month, who has paid and what is pending. Use a grid with members down column A and months across B to K. In each cell, type Paid, Pending or Part. Then:

  • Members who paid in month 1: =COUNTIF(B$2:B$21, "Paid")
  • Collected that month: =COUNTIF(B$2:B$21, "Paid") * $N$1, where N1 holds the subscription
  • Pending for one member: =COUNTIF($B2:$K2, "Pending") * $N$1
  • Which member got the pot: a column H with the winning month number, and a check cell =COUNTIF($M$2:$M$21, 1) that should equal 1 for each month

Keep a separate column for the amount actually handed over when a pot is paid and the date, with the winner's acknowledgement. If a member pays in two parts, write Part in the grid and put the amounts on a second tab.

What if a kitty party or committee works differently?

Informal kitty parties and neighbourhood committees often have no dividend at all: everyone pays the same amount and members take turns to receive the pot. Leave column D at zero and the sheet works unchanged. If a turn is decided by draw instead of auction, add a column for the draw date.

Which records should I keep?

  1. The chit agreement or rules, with the list of members
  2. Each month's receipt or entry in the passbook
  3. The bank or UPI reference for every instalment
  4. The voucher or acknowledgement for the pot received
  5. Any notice about a change in the schedule

Where can an app help?

The monthly instalment is one more transaction in your statement. SpendixAI can import the statement as PDF, CSV or Excel, and you can give chit instalments their own category, while this sheet holds the dividend and pot details that a statement does not show.

Month-end checklist

  • Instalment paid and reference noted
  • Dividend entered from the statement
  • Paid-late count checked
  • Net position reviewed once the chit ends
SPENDIXAI JOURNAL

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

Explore your reports