Chit fund Excel format — free, with formulas
A ready chit fund book format for Excel and Google Sheets: member register, monthly collection sheet, auction and dividend calculator, and a passbook per member. Formulas already written.
.xlsx · 5 tabs · No sign-up, no email needed
| C | D | E | G | H | |
|---|---|---|---|---|---|
| 5 | Winning bid | Discount | Commission | Dividend | You pay |
| 6 | 4,00,000 | 1,00,000 | 25,000 | 3,947 | 21,053 |
| 7 | 4,10,000 | 90,000 | 25,000 | 3,421 | 21,579 |
| 8 | 4,25,000 | 75,000 | 25,000 | 2,632 | 22,368 |
What’s inside the sheet
Five tabs, built for a 20-member monthly chit. Change the numbers at the top and everything recalculates.
TAB 1
Setup
Chit value, members, duration, frequency and commission. Everything else reads from here.
TAB 2
Member register
Names, phone numbers, slot numbers and the cycle each member took the pot.
TAB 3
Collection sheet
One column per cycle, one row per member. What each member actually paid.
TAB 4
Auction & dividend
Enter the winning bid; discount, commission, dividend and net payable calculate themselves.
TAB 5
Passbook
Pick a member and print their statement — due, dividend, paid and balance, cycle by cycle.
Chit calculation formula in Excel
The formulas that do all the work
Copy these straight into your own sheet if you would rather build it yourself. Example: ₹5,00,000 chit, 20 members, 5% commission, winning bid ₹4,00,000.
Base instalment
₹25,000=B2/B3Chit value ÷ number of members. What everyone would pay if nobody bid.
Discount
₹1,00,000=Setup!$B$2-C4Chit value minus the winning bid — the amount the winner gave up to take the pot early.
Foreman commission
₹25,000=Setup!$B$2*Setup!$B$5Commonly 5% of the chit value. If your group agreed a flat rupee amount, type it instead.
Dividend per member
₹3,947=(D4-E4)/(Setup!$B$3-1)Discount minus commission, split among the members who have not yet won. If your group shares it with everyone, drop the -1.
Net payable this cycle
₹21,053=Setup!$B$6-G4Base instalment minus the dividend. This is what each member actually hands over.
Running balance
₹1,24,500=SUM($I$4:I4)-SUM($J$4:J4)-SUM($E$4:E4)Everything collected minus everything paid out and commission taken, up to this row.
Honestly
Where this sheet will let you down
The formulas above are correct as long as everyone pays the full amount, on time, every cycle. That is not how collections go.
The sheet is genuinely useful for cycle one. Somewhere around cycle four, most organisers start keeping a second, private notebook for what the sheet cannot hold.
Organisers who downloaded this sheet, then stopped using it.
4.4 on Google Play · 2,000+ organisers
“Used to track everything in a diary. ChitBook made it so much easier to calculate who owes what.”
Rahul S.
Family group organiser
“The best part is I can just show the app to members to prove the calculations are correct.”
Priya M.
Office chit admin
“Simple UI, no confusing jargon. Just works perfectly for our 20-member local group.”
Anand K.
Small business owner
About this Excel format
Free to use, edit and share with your group.
Is the chit fund Excel sheet really free?
Yes. No sign-up, no email, no watermark. Download it, change it, send it to whoever you like.
Does it work in Google Sheets?
Yes — open the .xlsx in Google Sheets and take your own copy. All formulas are standard and carry across.
Can I use it for a fixed or committee chit?
Yes. Leave the auction tab empty and enter your agreed payout order in the member register — the collection sheet and passbook work the same way.
Does it handle daily or weekly chits?
The maths is identical — change the cycle labels on the collection tab. For a daily chit that is 100+ columns, which is where a spreadsheet stops being practical.
Why give away a sheet that competes with your app?
Because most organisers are already using one. If the sheet works for your chit, keep it. When it stops working, you will know exactly what you need instead.
Or skip the spreadsheet entirely.
Same maths, done for you, with a passbook for every member. Free for your first chit.