The Electrical Supplies Distributor Management System Web App is a complete Google Apps Script trading system for electrical wholesalers: 24 screens, 18 date-ranged reports, 6 roles enforced by 41 named permissions, and a Google Sheets database of 26 tables that ships pre-seeded with roughly 14,000 rows of a real trading year – 203 SKUs, 60 customer accounts, 24 suppliers, 22 brands, 5 warehouses, 280 purchase orders, 655 sales orders, 596 tax invoices, 887 payments and 569 dispatches. It deploys into your own Google account in about 15 minutes and you get both source files.
Most electrical distributors run on the same three things: a stock sheet per branch, a WhatsApp group, and somebody’s memory of who gets which discount. That works until a contractor asks what is actually available at Nashik, or until you try to work out how much of the Rs 1.68 crore you are owed is past its due date. This system replaces the lot with linked documents – purchase order to goods receipt to stock to sales order to invoice to delivery to payment – and a receivables book that ages itself. Everything below comes from the shipped build, screen by screen.
🚀 Try the Live Demo Before You Buy
We have deployed this exact build in our own Google account so you can open every screen, run every report and sign in as every role – against the full seeded trading year – before you pay anything. No signup, no email, no card.
🔑 Test Login Credentials – all six roles
Sign in as admin to see all 24 screens and all 41 permissions, then sign out and come back as kavita.iyer (Viewer) or farid.shaikh (Warehouse). The sidebar shrinks, the Save buttons disappear and the money screens vanish entirely. That role separation is the product, and it takes about ten seconds to see.
💡 These credentials are public on purpose. They are the seeded logins of one shared demo instance that resets, not of anybody’s live business. Please do not enter real customer or supplier data into it – other visitors can see it, and it is wiped. What you get after purchase: the full source (Code.gs + Index.html) and a step-by-step deployment guide, so you build your own private instance, with your own database, in your own Google account, in under 15 minutes.
Key Features of the Electrical Supplies Distributor Management System Web App
The whole purchase-to-cash chain lives in one app. Purchase Orders raise on your supplier; Goods Receipt books what actually arrived and what was rejected against a supplier invoice number; Stock updates by warehouse and bin; Sales Orders allocate it; Invoices apply GST; Deliveries dispatch it against a transporter, vehicle and LR number; Payments settle it. Every document names the one before it, so an invoice always shows the sales order it came from.
Stock is genuinely multi-location. The seeded book holds 609 stock lines across five stocking points – Mumbai Central Warehouse, Navi Mumbai Godown, Pune Distribution Centre, Nashik Godown and Nagpur Distribution Centre, 89,200 sqft in total. Each line carries on hand, allocated, available to promise, reorder-at, unit cost, value, a health flag and a last-counted date, plus a bin reference such as A-11-03. 41,723 units are on hand, of which 3,069 are already committed to orders.
Pricing is a rules table, not a habit. Six price lists – Retailer Standard, Contractor Plus, Panel Builder, Project Special, Government Rate and Solar Partner – drive 132 discount rules, each scoped to a brand and category with a minimum order value and a valid-from / valid-to window. The average realised discount across every rule is 8.3%, with Government Rate deepest at 11% and Retailer Standard shallowest at 5%.
Receivables age themselves. The Rs 1,68,47,645 outstanding splits into Current Rs 68,68,206, 1-30 days Rs 29,21,052, 31-60 days Rs 24,75,998, 61-90 days Rs 7,00,914 and 90+ days Rs 38,81,475. The dashboard reports DSO in days (51 in the seeded book) and the Customers screen flags the accounts over their credit limit before you release stock to them.
Access control is enforced on the server, not in the menu. Six roles – Administrator, Manager, Sales Executive, Warehouse, Accounts and Viewer – map onto 41 named permissions. The permission map drives the sidebar and every server entry point, so hiding a menu item is not the security boundary; each call re-checks the permission before it does anything. Passwords are salted and SHA-256 hashed and cannot be read back by anyone, including the administrator.
Screens Explained
Dashboard
Eight KPI cards over a period selector: Invoiced revenue for the last 12 months (Rs 12,06,99,440 across 509 invoices, average Rs 2,37,131), Gross margin (Rs 1,55,48,964 at 15.1% of net sales), Receivables outstanding (Rs 1,68,47,645 with Rs 99,79,439 overdue and DSO 51 days), Stock value at cost (Rs 1,91,51,449 over 609 lines), Revenue this month, Collected this month, Open sales orders and Lines at or below reorder level. Beneath them sit Revenue and collections by month, Sales mix by category (Switchgear leads at Rs 2.46 Cr of a Rs 9.74 Cr net), Top brands by net sales value, Receivables ageing by bucket and Stock by warehouse. An Email summary button mails the same picture to your inbox.
Product Catalogue
203 SKUs across 10 categories and 22 brands, with 200 active. Each row shows the SKU and internal product code, a description with sub-type (MCB, MCCB, RCCB, SPD, Contactor, Isolator, Changeover), brand badge, category, unit of measure, cost, list price against MRP, margin percentage, on-hand versus its reorder point, a stock health flag and status. Catalogue stock value is Rs 1,91,51,449 at purchase cost with an average list margin of 21.8%. Filter by category, brand, unit, stock state or status; import and export by CSV.
Purchase Orders and Goods Receipt
280 purchase orders worth Rs 4,38,62,307 excluding cancelled, 16 still open with Rs 24,74,190 committed, across a sourcing base of 24 suppliers with an 11-day average lead time. Each PO carries a number and date, supplier, deliver-to warehouse, expected date, line count, net, tax, order value and a status of Draft, Sent, Part Received, Received or Cancelled. Goods Receipt then books 256 GRNs against those orders – 74,180 units received worth Rs 4,31,85,799, with 142 units rejected for a 0.19% rejection rate, each receipt tied to a supplier invoice number and marked Received or Received with Rejection.
Sales Orders
655 orders taken worth Rs 15,05,28,321 excluding cancelled, 28 still to fulfil with Rs 62,21,715 pending, and Rs 1,12,21,350 of discount given against list price. Every order records the customer and their type, the salesperson and territory, the ship-from warehouse, a promised date, line count, discount, order value and a status of Draft, Confirmed, Part Delivered, Invoiced or Cancelled. Filters cover status, territory, salesperson and warehouse.
Invoices and Payments
596 tax invoices totalling Rs 14,09,06,601, of which 499 are fully settled, with Rs 1,68,47,645 outstanding and Rs 99,79,439 past its due date. Each invoice row shows taxable value, total, paid, balance, due date, margin percentage and a payment badge of Paid, Part Paid or Unpaid, and the ageing strip sits at the top of the page. Payments records 715 customer receipts totalling Rs 12,40,58,956 and 172 supplier settlements of Rs 2,63,78,683 across six modes – RTGS, NEFT, cheque, bank transfer, cash and UPI – each with a UTR or cheque reference and a cleared status.
Reports
Eighteen reports across sales, procurement, inventory, finance, logistics and quality. Pick one, set From and To dates or use a quick range, and press Apply filter. Sales Summary by Month returns headline counters, an Invoice total by month chart and a searchable row-level detail table; Stock Valuation by Warehouse, Low Stock / Reorder, Slow Moving and Dead Stock, Receivables Ageing, Payment Collection, Gross Margin by Brand, Gross Margin by Product, GST Summary, Customer Credit Exposure, Delivery Performance and Returns and Warranty Analysis all work the same way. Every one exports to CSV or prints at your chosen paper size.
The rest of the sidebar follows the same pattern. Customers holds 60 accounts across 10 territories with credit limits and live outstanding. Suppliers holds 24 principals with payment terms, lead time and a 5-point rating. Brands holds 22 brands with principal supplier, category focus, warranty months and default margin. Warehouses, Stock, Price Lists and Stock Adjustments cover the inventory side; Deliveries tracks 569 dispatches and 13,447 cartons at 76.0% on time across six transporters; Returns & Warranty logs 110 cases worth Rs 4,44,853 of credit by reason. Users, Lists (19 dropdown lists and 130 values you can edit without touching code), Settings, Audit Log and Archive make up the administration block, with Help and Get More Templates under Support.
How to Deploy and Use It
- Try the live demo first. Use the green box above. Sign in as
admin / Sparx#7412, then again askavita.iyer / Readonly#9935, and decide whether the screens and the role separation are what you actually need before you spend anything. - Create the Apps Script project. Open script.google.com, choose New project, paste
Code.cs.txtinto Code.gs, add an HTML file named exactlyIndexand pasteIndex.txtinto it, then Save. - Deploy it. Deploy > New deployment > Web app, Execute as Me, Who has access Anyone. Accept the unverified-app warning – it is your own script – and copy the web app URL. Remember that later code edits need Deploy > Manage deployments > New version to go live.
- Build the database. Open the URL and click Build the database now, or run
setup()from the editor. It runs in 22 stages, remembers where it stopped, schedules its own resume trigger and never double-seeds.setupStatus()prints the current stage. - Change the administrator password immediately, then create your own team under Users and delete the seeded accounts you do not need.
- Configure Settings. Company name, address, GSTIN and logo; currency symbol and code, date format and financial-year start; default GST rate, place of supply and invoice round-off; print size, footer note and copy labels; email on or off.
- Load your own masters via the CSV Import button on Customers, Suppliers, Brands, Product Catalogue and Stock, after clearing the seeded transaction rows from the database spreadsheet.
- Run the cycle – Purchase Order, Goods Receipt, Stock, Sales Order, Invoice, Delivery, Payment – and press Refresh or Alt+R when you want fresh figures, because each screen caches on purpose.
Electrical Supplies Distributor Management System vs. a Spreadsheet vs. Paid Distribution SaaS – Feature Comparison
| Feature | Electrical Supplies Distributor Management System Web App | Excel / Google Sheets workbook | Zoho Inventory / TallyPrime / NetSuite |
|---|---|---|---|
| Cost | $39.99 one-time ✅ | Free, but you build and maintain it | $29-500 / month, tiered by users and orders |
| Platform | Apps Script web app in your own Google account ✅ | A file that has to be shared and merged | Vendor’s cloud, vendor’s terms |
| Setup time | Under 15 minutes, database self-builds ✅ | Weeks to build purchase-to-cash yourself | Days of onboarding, often paid implementation |
| Role-based access | 6 roles, 41 permissions, re-checked server-side ✅ | Sheet protection only – not a real boundary | Yes, priced per user |
| Multi-warehouse stock | 5 locations, bin refs, allocated vs available ✅ | Manual columns per location | Yes, usually on a higher plan |
| Built-in reports | 18, date-ranged, CSV and print ✅ | Whatever pivot tables you write | Extensive, some behind add-ons |
| Source code you own | Yes – Code.gs and Index.html ✅ | Yes, but there is no app to edit | No – closed platform |
| Year-1 cost at 5 users | $39.99 total ✅ | $0 plus your build time | $1,700-$9,000+ |
| Your data lives | In your own Google Sheets and Drive ✅ | In your own file | On the vendor’s servers |
For an electrical wholesaler who wants purchase-to-cash, multi-warehouse stock and a receivables book without a per-user monthly bill, the Electrical Supplies Distributor Management System Web App sits in the sweet spot.
Who Should Use This Template
Perfect for:
- Electrical wholesalers and distributors with 2-30 staff running one to five warehouses or godowns
- Switchgear, wire and cable, lighting, fan, conduit and accessories traders selling to retailers, contractors, panel builders, industrial maintenance accounts, government projects and solar EPCs on different price lists
- Businesses currently running on a shared spreadsheet who want documents that link to each other and a receivables position they can trust
- Owners who want the source code and their data inside their own Google account rather than on a monthly seat licence
- Developers who want a working, non-trivial Apps Script trading system to study, fork or rebrand
Not a fit if:
- You need statutory filing. The GST Summary is a working paper for your accountant – it files no return, generates no IRN or e-invoice and produces no e-way bill.
- You need barcode scanning, a weighbridge feed, EDI to a principal, or a payment gateway. None of these exist; stock moves and payments are keyed in by a person.
- You need SSO/SAML, SOC 2 or a formal audit certification. The system has its own salted SHA-256 password store, permission map and audit log, and nothing beyond that.
- You are a very large distributor. The database is Google Sheets – strong into the tens of thousands of rows, which is exactly why an Archive screen ships with it.
- You need a customer-facing ordering portal or a native mobile app. This is one internal, browser-based web app.
Real-World Use Cases
Anand runs a switchgear and cable wholesaler in Mumbai with five stocking points. Each branch used to keep its own stock sheet, so nobody could say what was actually available to promise. Now Stock shows on-hand, allocated and available per SKU per warehouse with bin references, and the Low stock alert emails his purchase team the 59 lines at or below reorder before a contractor calls asking for them.
Meera manages sales for a distributor covering retailers, panel builders and government projects. Discounts used to be settled by argument. Now six price lists carry 132 slab rules by brand and category, each with a minimum order value and validity dates, and the Sales Orders screen totals the discount given against list – Rs 1,12,21,350 in the seeded book – instead of surfacing it at year end.
Vivek keeps the accounts for a family-run electrical trading business. He opens Invoices, sees Rs 99,79,439 past due split across ageing buckets, filters to the 90+ column, prints Receivables Ageing and Customer Credit Exposure for the owner, and emails payment receipts from the same screen. The two customers over their credit limit are flagged before stock leaves the godown.
Advantages of the Electrical Supplies Distributor Management System Web App
- One payment instead of a monthly bill. At five users, a mid-tier distribution SaaS runs $1,700-$9,000 in year one. This is $39.99 once, with no per-user charge as your team grows.
- You own the code and the data. Code.gs and Index.html are yours to edit; the database is a Google Sheets file in your Drive. There is no vendor lock-in and no export request to file.
- It is populated on day one. Because setup seeds a full trailing trading year, every chart, every report and every filter has something in it while you are still deciding whether to keep it.
- Configuration is data, not code. Customer types, adjustment reasons, bank accounts, transporters and every other dropdown live on the Lists screen – 19 lists and 130 values you can change without opening the editor.
- It prints like a trading business needs to. The same invoice renders on a 3-inch thermal roll, a 4-inch roll or A4 letterhead, with your company block, GSTIN and footer note.
- Performance is deliberate. Each screen loads once and then serves from the browser cache; the backend reads each sheet at most once per request and writes in a single batch.
Opportunities for Improvement
Everything here was observed in the shipped build. None of it stops the system working, but you should know it before you buy.
- Two different “last 12 months” totals. The Dashboard reads Rs 12,06,99,440 across 509 invoices. The Reports screen, on its own Last 12 months quick range (29-08-2025 to 29-08-2026), reads Rs 12,11,41,889 across 511. The gap is exactly the Aug-25 stub the inclusive From date pulls in – 2 invoices, Rs 4,42,449 – which is also why that report’s chart draws 13 month buckets instead of 12. Both numbers are correct for their own window; the labels just do not say so.
- “At reorder level” is counted two ways. Product Catalogue reports 3 SKUs at reorder level, while the Dashboard and the Stock screen both report 59 lines at or below reorder. The catalogue counts SKUs whose total on-hand across all warehouses is at or below the product reorder point; Stock counts individual warehouse-SKU lines. Both are defensible, but if you replenish from the catalogue card you will under-order.
- Two purchase-order counts against the same money. The Purchase Orders screen reads 280 orders raised (all time) beside Rs 4,38,62,307 excluding cancelled. The Suppliers screen attributes that identical Rs 4,38,62,307 to 263 purchase orders. The 17-order difference is the cancelled and draft orders, but only one of the two screens tells you that.
- The Audit Log screen caps at 400 entries. The card says “Newest 400 shown” while the seeded database holds 800 audit rows. Older entries are still in the sheet and still export, but you cannot page back to them from the screen.
- The Archive register is empty by design. The screen states this plainly – nothing has been archived yet, which is the correct state for a fresh install – but it does mean you cannot see what an archived record looks like until you run one yourself.
- Seven of the eight seeded users show “Last sign in: Never”. Expected on a fresh seed, but the Users screen looks emptier than the rest of the system until your own team starts signing in.
- The demo data is Indian. Rupee symbols, lakh-crore grouping, an 18% default GST rate, a CGST+SGST split and a Maharashtra place of supply. All of it is configurable under Settings > Regional and Settings > Tax, but a first-time buyer outside India should expect to change it before loading real data.
Best Practices
- Change every seeded password before the URL leaves your desk. Eight accounts ship active; delete the ones you do not need and create real ones under Users.
- Take a backup before any bulk import or archive. Settings > Backup now copies the whole database to Drive in one click.
- Set credit limits properly. The over-limit flag on Customers is only as useful as the limits behind it, and it is the cheapest control in the system.
- Give the price lists real validity dates. The Price Lists screen tracks validity windows for a reason – stale slab rules quietly erode margin.
- Count stock and record it. The last-counted date on every stock line is what turns Cycle Count Correction from a guess into an audit trail.
- Redeploy after every code edit. Editing Code.gs does not change the live app; use Deploy > Manage deployments > New version, or your team keeps seeing the old build.
- Archive on a schedule. Once the book gets heavy, archive closed and paid transactions before a cutoff. Master data and any open order or unpaid invoice are never touched.Electrical Supplies Distributor Management System Web App
Explore Relevant Templates
If you supply the building trades rather than the electrical trade specifically, the Building Material Supplier Management System Web App and the Concrete Supplier Management System Web App use the same architecture for builders’ merchants. The Beauty Products Distributor Management System Web App is the closest direct analogue in another category, and the Auto Parts Inventory Management System Web App covers spares distribution.
On the warehousing and last-mile side, see the Cold Storage Management System Web App and the Courier & Parcel Delivery Management System Web App. If you want reporting rather than a whole system, the Electrical Contractor KPI Dashboard in Google Sheets covers your customers’ side of the trade and the Purchase and GRN Data-Entry System in Excel is a lightweight goods-inward log. The full range sits in the Mini Web Apps catalogue.
New to Apps Script? Google’s own Web Apps guide explains what “Execute as” and “Who has access” actually do, and is worth five minutes before your first deployment.Electrical Supplies Distributor Management System Web App
Frequently Asked Questions
Can I try it before buying?
Yes. A full working instance of the Electrical Supplies Distributor Management System Web App is live in the green box above, seeded with a complete trading year, and all eight accounts across six roles are published there. No signup and no email are needed. The credentials are public by design on a shared demo instance that resets, so please do not enter real data into it.Electrical Supplies Distributor Management System Web App
What is actually in the download?
A ZIP holding Code.cs.txt (the Apps Script backend), Index.txt (the complete front end) and a user manual PDF. You paste the two source files into your own Apps Script project and deploy. There is no licence key, no server to rent and no ongoing account with us.Electrical Supplies Distributor Management System Web App
How long does setup take?
Roughly 15 minutes for a first-time Apps Script user. Creating and deploying the project takes about five; the database build then runs itself in 22 resumable stages, creating all 26 sheets, seeding the trading year and building the Drive folder tree.Electrical Supplies Distributor Management System Web App
Who can see my data?
Only you and the users you create. The database is a Google Sheets file and a Drive folder tree inside your own Google account, made by your own deployment. NextGenTemplates has no access. Passwords are salted and SHA-256 hashed, so an existing one cannot be read back by anybody, including the administrator.
Does it do GST returns, e-invoicing or e-way bills?
No. The Electrical Supplies Distributor Management System Web App applies a default GST rate with a CGST+SGST or IGST split, prints your GSTIN and place of supply, and produces a GST Summary report for your accountant. It files no statutory return, generates no IRN or e-invoice, and produces no e-way bill.Electrical Supplies Distributor Management System Web App
How does it compare to Zoho Inventory or TallyPrime?
Those are mature commercial platforms with integrations this does not have – payment gateways, barcode hardware, e-invoicing and mobile apps. This system costs $39.99 once rather than $29-500 a month, runs inside your own Google account, and hands you the source so you can change any screen, report or document layout yourself.Electrical Supplies Distributor Management System Web App
Can I customise it for my own trade?
Yes. Every dropdown is data on the Lists screen – 19 lists, 130 values – editable without touching code, and you hold both source files for anything deeper. NextGenTemplates also customises the system or builds new modules on request.Electrical Supplies Distributor Management System Web App
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.Electrical Supplies Distributor Management System Web App
Conclusion
The Electrical Supplies Distributor Management System Web App gives an electrical wholesaler the thing a spreadsheet cannot: linked documents, real per-warehouse stock, priced discount rules, an ageing receivables book and 18 reports, all behind six roles that are checked on the server. It ships with a full trading year already in it, deploys into your own Google account in about 15 minutes, and comes with both source files so nothing about it is locked away from you.Electrical Supplies Distributor Management System Web App
Do not take any of that on trust – open the live demo, sign in as admin / Sparx#7412, then sign in again as kavita.iyer / Readonly#9935 and watch the system shut half of itself off. Ten minutes there will tell you more than this whole article.Electrical Supplies Distributor Management System Web App
👉 Click here to purchase the Electrical Supplies Distributor Management System Web App
Instant download · One-time payment · No subscription · Runs in your own Google accountElectrical Supplies Distributor Management System Web App
More Apps Script systems, dashboards and trackers on Youtube.com/@NeoTechNavigators.
Last updated: September 2026Electrical Supplies Distributor Management System Web App
