Chitty Kampany
Chitty Kampany turns a Google Sheet into a chit-fund management app - a phone-based collection screen instead of paper registers, and a live, auditable ledger instead of reconciling notebooks by hand. No server, no separate app to install, no IT team to keep it alive - it runs entirely on infrastructure the committee already has open in a browser tab every day.
Why I did the project?
A friend of mine is part of a chit committee in Kerala, one of a small group of small vendor organisations running their own chit funds. They needed a way to bring some order to their daily collections and draws, but the usual answer - a paid chit-fund app - was never really on the table: there’s no IT team behind these committees, and no budget for recurring software costs either. With AI in the loop to help build it, I leaned into that constraint rather than around it: low-tech, on infrastructure they already trust and already have open every day - Google Sheets - with Apps Script doing the actual work underneath.
Features
- Full chit lifecycle (Enrolling → Active → Closed) across six collection frequencies: Daily, Working days only, Alternate days, Weekly, Monthly, and a committee-chosen custom set of weekdays
- One deliberately narrow agent screen - pick a chit, pick a member, log the payment - with a pre-submit duplicate-payment warning and one-time catch-up payments for late joiners
- Provably-fair spin-wheel draws: the winner is decided on the server before the wheel visually spins, with every spin logged to an audit trail
- Cryptographically verifiable receipts - every payment is stamped with a hidden seal, and a public, no-login page lets any member check a receipt’s Ref code and get back “genuine” or “not verified”
- An admin dashboard with date-range and per-chit filtering, plus a per-day “My Day” dashboard for agents (and admins) showing Cash/UPI totals and a chitwise breakdown
- Configurable branding (app title, four colour themes) and editable WhatsApp/email message templates
- Role-based access control (Admin/Agent), enforced server-side and never trusting what the client claims about itself
- Soft-delete everywhere - a member, chit, or payment record can be hidden from the app without ever erasing its row, so history stays intact
- A realistic demo dataset for trying the app out before wiring up a real committee
Tech
| Language | Google Apps Script (JavaScript), HTML, CSS |
| Framework | plain Apps Script + HTML Service |
| Database | Google Sheets (No Actual DB and decentralised) |
| Hosting | Google Sheets + Google Apps Script (no server) |
Timeline
Published: August 2026
Status: Live
License
Open source under the MIT license. Source on GitHub, issues and pull requests welcome.