The Chit Fund Management System Web App is a Google Apps Script workspace for the paperwork side of a chit business – the monthly auction, the demand it raises, the money that comes back over the counter, the prize money that goes out and the ledger that proves the three still add up. It installs with a complete sample book already in place: 16 chit groups, 92 subscribers, 342 tickets, 220 auctions, 5,039 instalment rows and 4,920 receipts across 20 database sheets, so no screen is empty on the first sign-in. Six roles, sixteen modules and eighteen exportable reports. Before you spend anything, open the live demo below and sign in as the most restricted role you can find.
What this product is, plainly: record-keeping software. It does not register, license, audit or make compliant a chit fund, committee, ROSCA, susu or any savings and credit scheme; it is not a banking, NBFC, lending, deposit-taking or investment product; it gives no financial, legal, tax or investment advice; and it promises no return, yield or payout. Whether you may run a scheme at all, and under whose rules, is a question for your own advisers and your own regulator.
Try the Live Demo – Free, No Signup
The whole system is deployed and seeded. Open it, sign in with any account below and click anything you like.
Demo Logins – One Per Role
| Role | Username | Password | What that role sees |
|---|---|---|---|
| Admin | admin | Admin@2026 | Everything, including user management, settings and the audit log |
| Foreman | foreman | Foreman@2026 | The chit business end to end – schemes, auctions, collections, payouts, commission |
| Branch Manager | branch | Branch@2026 | Branch work: enrolment, auctions, collections, arrears, agents; no commission ledgers |
| Accountant | accounts | Accounts@2026 | Receipts, prize money release, commission settlement and the statements |
| Collection Agent | agent | Agent@2026 | Field collection only – no commission, no prize money, no scheme profitability |
| Auditor | auditor | Auditor@2026 | Read-only across the whole business, plus the audit log; can export, changes nothing |
These credentials are public on purpose. They belong to a shared demo instance that is periodically reset – not to anybody’s live system. Your own copy is created on your own Google account, with your own passwords.
Key Features of the Chit Fund Management System Web App
- One auction call does the arithmetic. Enter the winning bid and the app computes the discount, the foreman commission, the dividend pool, the dividend per ticket, the payable and the prize money in a single step.
- Six roles with a server-side guard. The same permission map drives the sidebar and every endpoint, so removing a page from a role removes access to the data, not just the menu item. Roles are editable under User Management.
- Demand tracked ticket by ticket. Each instalment row carries subscription, dividend, payable, paid, balance, days late and the agent responsible.
- Arrears ranked by real risk. Ageing buckets of 0-30, 31-60, 61-90 and over 90 days, with prized-but-behind accounts flagged Critical regardless of age – because that money belongs to the other members of the group.
- Prize money with a paperwork gate. Payouts move through Pending, Approved, Held and Paid, and a release can be blocked until the surety and agreement documents are on file.
- Two commission ledgers. Foreman commission per auction and agent commission calculated on what was actually banked, not on what was demanded.
- Eighteen exportable reports grouped as Assurance, Schemes, Collections, Arrears, Payouts, Earnings and Subscribers – every one printable and exportable to Excel or CSV.
- A document register in your own Drive. KYC proofs, chit agreements, prize money agreements and surety documents file themselves into one folder tree under a single application root folder.
- 26 editable dropdown lists. Occupation, payment mode, KYC status, ticket fraction, waive reason and 21 more – add a value once and it appears everywhere it belongs.
- An audit log you cannot switch off. Every create, change, deletion, approval, fee note, sign-in and archive, filterable by user, module and action.
What’s Inside the Chit Fund Management System Web App
Sixteen pages, grouped in the sidebar as Overview, The Schemes, The Money, Field & Records, Insights, Administration and Support.
Dashboard – collection efficiency, collected over twelve months, arrears outstanding, chit value under management, this month’s demand, dividend returned, foreman commission and prize money awaiting release, all filterable by branch. Below them sit Demand against collection, Winning discount trend, Arrears by age, Collection by branch and Schemes by status.
Chit Groups – every scheme the company runs, with chit value, tickets filled, term progress, collected, arrears, efficiency and commission on one row. Vacant tickets are counted for you, because a scheme cannot start until every ticket is filled.
Auctions – the register of every monthly auction, the bid that won it, the dividend it declared and the demand it raised, plus a Does the period balance? panel that sets demand raised against prize money awarded plus foreman commission and shows the variance.
Subscribers – the register of who subscribes, what they hold, what they owe and who stands surety for them, with KYC state and a credit rating per member. A second tab holds the sureties.
Collections – what each ticket was asked for this month, what came back through the counter and what has not, split into an instalment-demand tab and a receipts tab. Payments are taken at the counter or imported in bulk.
Arrears & Penalties – who is behind, by how much and for how long, with a penalty ledger alongside and a reminder mailer.
Prize Money – the one point where a large sum leaves the company, and the paperwork that has to be in place first.
Commissions – what the company earned on each auction and what it owes the field force, with commission by month and a top-earning-agents ranking.
Agents & Branches – the field force and the offices they work from, with collection by agent and by branch.
Documents – KYC packs, chit agreements, prize money agreements and surety documents, filed against the record they belong to.
Reports – Ledger Reconciliation, Group Schedule / Chit Chart, Auction Register, Group Profitability, Monthly Demand and Collection, Collection Efficiency, Receipt Register, Agent Performance, Defaulter and Ageing Report, Penalty Register, Prize Money Disbursement, Foreman Commission Statement, Agent Commission Statement, Dividend Distribution, Subscriber Statement, Subscriber Ledger Summary, Branch Performance and KYC Compliance.
User Management, List Management, Settings, Audit Log, Help and Get More Templates – accounts and editable role permissions, 26 dropdown lists holding 128 values, seven groups of settings (business identity, chit rules, operations, printing, email, security and system), the activity trail, and a seven-tab help centre covering how a chit works, module by module, printing and email, import, archive and backup, and troubleshooting.
A word on the sample numbers. The seeded demo book is written for an Indian company, so the figures on screen are rupees, shown with lakh and crore grouping. None of that is fixed: CurrencySymbol sits in Settings > Chit Rules alongside the commission percentage, the maximum discount, the due-day offset, the grace days and the penalty rate. Change it once and every screen, receipt and report follows.
Chit Fund Management System Web App vs. a Spreadsheet Workbook vs. Paid Chit Fund SaaS – Where This Fits
| This web app | A spreadsheet workbook | Paid chit fund SaaS | |
|---|---|---|---|
| Cost | One payment, yours to keep | Free, if you build it yourself | Recurring subscription, usually per branch or per user |
| Platform | Google Apps Script front end, Google Sheets database | Excel or Google Sheets | Vendor-hosted |
| Setup time | Paste two files, run setup, deploy – the sample book is already there | Weeks of formula work | Onboarding scheduled by the vendor |
| Real-time team collaboration | Yes, one deployment for the whole office | Fragile once several people edit | Yes |
| Mobile access | Yes, any browser | Awkward on a phone | Yes |
| Customisable fields | 26 editable lists, editable roles, editable code | Anything, by hand | Only what the vendor exposes |
| Share with a link | Yes, your deployment URL | File sharing | Yes |
| Where the data lives | Your own Google account and Drive | Your own file | The vendor’s servers |
| Auction arithmetic computed for you | Yes – discount, dividend, payable, prize, commission | Only if you write it | Usually |
| Ledger reconciliation report | Yes, with a variance figure | Manual | Varies |
| Year-one cost for a five-person office | The purchase price, once | Your own time | Twelve subscription payments |
Who This Template Is For – and Who It’s Not For
A good fit if you are a foreman or a small chit company running schemes on paper, in a notebook or across several spreadsheets; if you have branches and collection agents whose numbers need to meet in one place; if you want your data to stay in your own Google account; or if you want a working chit system to study, adapt or hand to a developer as a starting point.
Not a good fit if you need a regulator-approved or certified system, a statutory filing tool or anything that carries legal or audit weight – this is not that, and no amount of configuration will make it that. It is also the wrong tool if you need integrated payment collection, SMS gateways or bank reconciliation out of the box, if your team will not accept a Google sign-in, or if you have hundreds of thousands of transaction rows, since the database is a Google Sheet with a practical row ceiling (the built-in archive exists for exactly that reason).
How to Use the Chit Fund Management System Web App
- Open the live demo first and sign in as the Auditor, then as the Collection Agent. Ten seconds of that shows you what role separation actually does here.
- Deploy your own copy. Create an Apps Script project, paste Code.cs.txt into Code.gs, add an HTML file named Index and paste Index.txt into it, then save.
- Run setup once. Either press “Set up the database” on the sign-in card, or run the setup function from the editor. It is staged and resumable, so a free Google account’s six-minute limit will not break it, and it never duplicates a row.
- Deploy as a web app – execute as Me, access set as you prefer – and open the URL it gives you.
- Change every seeded password before any real data goes in, from the menu under your name or from User Management.
- Put your own details in Settings – business identity, then the chit rules: currency symbol, foreman commission percentage, maximum discount, due-day offset, grace days and penalty rate. Changing a rule affects the next auction; auctions already held keep the figures they were struck at.
- Add branches and agents, then subscribers – one at a time, or in bulk from the Import button.
- Open a chit group and fill its tickets, then run your first auction from the Auctions page. The demand, the prize money and the commission are raised for you in one step.
- Clear the sample data when you are ready – the manual lists exactly which sheets to empty and which four to keep.
Real-World Use Cases
Venkatesh runs a five-branch chit company. Before, each branch manager sent a weekly collection sheet and the numbers never agreed. Now every receipt is booked at the counter it was taken at, and the Collection by branch chart on the dashboard tells him by lunchtime which office is behind.
Priya is a foreman with eleven running groups. Her problem was never the auction, it was remembering which winners had not signed the prize money agreement. The Prize Money page holds those payouts as Blocked on paperwork until the document is filed, so nothing leaves the bank early.
Rakesh keeps the books. Every month he needs one number to be true: that the demand raised equals the prize money awarded plus the foreman commission, and that collected plus arrears equals the demand. The Ledger Reconciliation report puts both halves on one page with a variance figure, and the Auditor login lets his reviewer read the whole business without being able to change a thing.
Frequently Asked Questions
Does this make my chit fund compliant, registered or legal?
No. It is record-keeping software and nothing more. It does not register a scheme, apply for a licence, satisfy a registrar, produce a statutory filing or certify anything, and installing it changes your legal position not at all. Chit funds, committees, ROSCAs and similar schemes are regulated differently in different places – in India, for example, under the Chit Funds Act and by state Registrars. Whether you may run a scheme, and on what terms, is a matter for your own lawyer, accountant and regulator. Please settle that before you take a single rupee, and treat this app purely as the ledger you keep afterwards.
Is this a banking, lending or investment product? Does it promise a return?
No to both. It holds no money, moves no money, connects to no bank or payment gateway, and offers no financial, legal, tax or investment advice. It promises no return, yield or payout to anyone – it only records what you tell it happened.
Can I try it before buying?
Yes. The live demo above is the complete system with the sample book loaded, and there are six logins – one per role – so you can see exactly what each member of your team would and would not be able to reach. No signup, no card.
The demo shows rupees and lakh figures. Can I use my own currency?
Yes. The sample data was written for an Indian company, so that is what the seeded screens show. The currency symbol is a single setting under Settings > Chit Rules, along with the commission percentage, discount cap, grace days and penalty rate. Set them to your own before you start entering records.
What exactly do I get in the download?
A ZIP containing the Apps Script code file, the HTML interface file and an illustrated PDF user manual that covers deployment, every module, the roles, printing, email, import, archive and backup, and troubleshooting.
Do I need to be a developer, and does it cost anything to run?
No and no. Deployment is copy, paste, run one function and click Deploy – the manual walks it step by step with screenshots. It runs on your own Google account under the standard Apps Script quotas, so there is no hosting bill and no server to maintain. A Google Workspace account gives you higher quotas than a free one, but a free account works.
Can I change the modules, add fields or rename things?
Yes – the code ships unlocked and unobfuscated. The 26 dropdown lists and the role permission map are editable from inside the app without touching code at all, and if you want structural changes made for you, NextGenTemplates quotes customisation work.
About the Author
Built by PK – Microsoft Certified Professional with 15+ years of Excel, Google Sheets, and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels. Every template is hand-built and tested before release.
Explore Related Templates
Other finance and practice systems from the same line: the Auditing Firm Management System Web App, the Accounting Firm Client Management System Web App and the Payroll and Salary Management System Web App. If you only need to follow money in and money out, the Money Lent & Borrowed Tracker in Google Sheets and the Loan EMI Repayment Tracker in Google Sheets are far lighter. Browse the whole Web Apps category, or the Google Sheets templates if a spreadsheet is closer to what you need.
Ready? Open the live demo, sign in as the Auditor, and look at the Ledger Reconciliation report. If the variance being zero is the thing your current book cannot show you, add this to your cart – the download is instant and the deployment takes about ten minutes.
Last updated: 21 August 2026 – Chit Fund Management System Web App v1.0.0
Reviews
There are no reviews yet.