IMS-ERP
A complete inventory and business management ERP built on Google Sheets and Apps Script.
Problem
Small and medium businesses in India need a robust ERP system for inventory, sales, purchases, and GST compliance — but enterprise software is too expensive, and spreadsheets are too limited. They needed a system that is powerful, free to host, and works without technical expertise.
Solution
We built IMS-ERP — a full ERP system using Google Apps Script and Google Sheets as the database, with a Node.js web portal for easy access, Razorpay for payments, and Supabase for real-time sync. The system includes role-based access, GST billing, purchase management, inventory tracking, and an affiliate program.
What We Built
Inventory Management
Full stock tracking with purchase orders, goods receipt, stock adjustments, and low-stock alerts.
Sales & Billing
GST-compliant invoicing with Razorpay payment integration and automated receipt generation.
Multi-User Access
Role-based access control (Admin, Manager, Staff) with secure login via the web portal.
Financial Reports
P&L statements, sales reports, purchase reports, and custom date-range analytics.
Security Audit
Comprehensive 11-point security audit — authentication hardening, payment verification, and data protection.
Affiliate Program
Built-in referral system with commission tracking for business partners.