A full commission agent ERP built on Google Sheets — the kind of trading operation that runs on a daily ledger, a set of khatas and a godown, where the software sold to it is either far too big or a spreadsheet somebody's nephew made. This covers the whole cycle in one app, with no server and no monthly licence.
The cashbook and roznamcha record the day as it happens. Supplier and buyer accounts are maintained as khata, so what each party owes or is owed is a running balance rather than a calculation somebody does at month end. Stock moves through godown management, sales and payments are tracked against it, and billing runs through a POS screen. On top of that sit the parts that decide whether the year was good: partner profit sharing, a loan and EMI system, and a profit and loss report built from the same records. A CRM and lead pipeline handles the buyers you have not sold to yet.
Mandi commission agents, traders, wholesalers and distributors who work on commission, hold stock in a godown and settle with partners — and anyone who wants to see how far an Apps Script and Sheets system can be taken before it needs a real server.
| Version | v1.0 |
| Published | Apr 5, 2026 |
| Platform | Google Apps Script |
| Database | Google Sheets |
| Category | ERP & Business Suite, CRM & Sales |
| Tags | |
| Video | Watch walkthrough |
| License | Regular License |
| Code.gs Files | Complete Apps Script source code files |
| HTML Files | All HTML template files included |
| Google Sheet | Your own copy with all data and scripts |
| Setup Guide | Step-by-step video tutorials included |
| 6 Months Support | Bug fixes, tweaks, and guidance — all free |
| Free Updates | All future updates included at no extra cost |
Extra modules, your branding, integrations or reports built on top of this file. You get a clear quote and timeline before any work starts, and support after delivery.
What We Customize
20-30% advance to start • Clear quote before work begins • Support included after delivery
What buyers of this file added to the same order
Vibe Coding Just Got FREE: This AI Builds Full Apps AND Dashboards From One Prompt (Google Sheets)
2 buyers took both
How to Build a Full HR & Payroll ERP with Google Apps Script and React | Salary Slip + Attendance
2 buyers took both
Build a B2B Ecommerce Web Portal with Gemini AI + Google Sheets
Bought with this one
What buyers and viewers say about Commission Agent ERP System | Google Apps Script + React | 30+ Features | E51.