Debt

A chit fund tracker: contributions, dividends and your prize month

A chit fund tracker with columns for contribution, dividend, net paid and your prize month, plus a 20-month example and spreadsheet formulas.

Editorial illustration for A chit fund tracker: contributions, dividends and your prize month

A chit fund tracker needs six columns: month, contribution, dividend received, net paid, cumulative net paid and prize received. Fill one row per month, and the bottom of the sheet tells you whether you paid more than you received. The 20-month example below is invented; copy the layout, not the figures.

What does the 20-month sheet look like?

This is a chit of 20 members, each paying ₹5,000 a month. In this invented chit the dividend equals the month's discount divided by 20, every member shares the dividend until they take the prize (including in their prize month) and gets none afterwards. You take the pot in month 9 with a winning bid of ₹90,000. Your organiser's rules may differ.

MonthContributionDividendNet paidCumulative net paidPrize received
1₹5,000₹1,000₹4,000₹4,000-
2₹5,000₹900₹4,100₹8,100-
3₹5,000₹750₹4,250₹12,350-
4₹5,000₹700₹4,300₹16,650-
5₹5,000₹650₹4,350₹21,000-
6₹5,000₹600₹4,400₹25,400-
7₹5,000₹600₹4,400₹29,800-
8₹5,000₹550₹4,450₹34,250-
9₹5,000₹500₹4,500₹38,750₹90,000
10₹5,000₹0₹5,000₹43,750-
11₹5,000₹0₹5,000₹48,750-
12₹5,000₹0₹5,000₹53,750-
13₹5,000₹0₹5,000₹58,750-
14₹5,000₹0₹5,000₹63,750-
15₹5,000₹0₹5,000₹68,750-
16₹5,000₹0₹5,000₹73,750-
17₹5,000₹0₹5,000₹78,750-
18₹5,000₹0₹5,000₹83,750-
19₹5,000₹0₹5,000₹88,750-
20₹5,000₹0₹5,000₹93,750-

What do the totals tell me?

Over 20 months you paid ₹1,00,000 in contributions and received ₹6,250 in dividends, so your net paid is ₹1,00,000 - ₹6,250 = ₹93,750. You received ₹90,000 in month 9. The difference, ₹90,000 - ₹93,750, is -₹3,750: you paid ₹3,750 more than you got. That gap is the price of having the money in month 9 in this invented chit.

Why track dividends separately?

The dividend is the part of the sheet most likely to go wrong, because it changes every month and is easy to forget on the day you pay. Writing it in its own column lets you check it against the organiser's list and shows how your net payment drifts up as the discounts shrink.

Which formulas do I need?

Put headers in row 1 and months in rows 2 to 21. Columns: A month, B contribution, C dividend, D net paid, E cumulative, F prize received. These work in Excel and Google Sheets.

  • Net paid, in D2: =B2-C2. Copy down to D21.
  • Cumulative net paid, in E2: =SUM($D$2:D2). Copy down to E21.
  • Total dividends: =SUM($C$2:$C$21)
  • Net position: =SUM($F$2:$F$21)-SUM($D$2:$D$21)

A negative net position means you have paid more than you have received so far, which is normal before your prize month and also true of an early prize. A positive one means you are ahead. Leave F blank until your prize month, and enter the real amount you received then.

What should I do before my prize month?

Before you bid, work out the position under each outcome. Fill the sheet for taking the pot now and for waiting, then compare the net positions. The next step is a decision about whether you need the money now; the sheet only shows what each choice costs.

How do I match it with my bank statement?

Contributions usually leave your account by UPI or transfer on the same day each month. Compare the contribution column with your statement each quarter. If the amounts differ, find out why. SpendixAI can import your statement so the monthly transfers are listed together, and you can file them under a chit category of your own.

A short checklist

  1. One row per month, filled in on the day you pay.
  2. Dividend taken from the organiser's record.
  3. Prize received entered in the real month, with the real amount.
  4. Net position checked every quarter.
  5. Any difference from the organiser's figure raised in writing.
SPENDIXAI JOURNAL

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

Explore your reports