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.