Web-based: Advanced Inventory Management System

The Web-based: Advanced Inventory Management System is a Google Apps Script web app that runs in any browser with Google Sheets as the database. The system covers 9 core inventory pages, 2 user roles, 14+ exportable reports, and ships fully bilingual in English and French — switchable from a single toggle. Deploy to your own Google account in under 15 minutes by following the included setup video. Replace the seeded data, add your warehouses, and your team starts logging stock-in, stock-out, transfers, and adjustments the same day.

🌍 Join 8,400+ teams in 40+ countries using NextGenTemplates to replace paid SaaS tools with one-time-purchase Excel, Google Sheets Dashboards, Power BI, and HTML templates.

✅ Instant download · One-time payment · No subscription · No per-user fees · Lifetime access · Source code included

Web-based: Advanced Inventory Management System — Bilingual Login Screen (EN/FR)

🔑 Key Features of the Web-based: Advanced Inventory Management System

🔹 Web-based architecture on Google Apps Script — runs in any modern browser, hosted on your own Google Drive. No installs, no plugins, no Windows-only restrictions. Works on Windows, Mac, Chromebook, and tablets. Your Google Sheet is the database, so you keep 100% ownership of every stock record, supplier name, and customer transaction.

🔹 Bilingual interface — English and French — a single toggle in the top-right switches every label, button, navigation item, table header, and error message between EN and FR. Built for francophone businesses in Canada, France, Belgium, Switzerland, and across West and Central Africa who need a French-language stock tool that does not exist in most Excel templates.

🔹 2 role-based user types — Admin and User — Admins manage users, lists, and settings; standard Users record transactions, view stock, run reports, and use master data. Login credentials are validated against the embedded User Management sheet, so adding a new team member takes one row.

🔹 9 operational pages plus admin and resources — Dashboard, Current Stock, Stock Ledger, Reports, Product Master, Stock In / Purchases, Stock Out / Issues, Stock Transfers, and Stock Adjustments — covering every move a stock item makes through your warehouse network.

🔹 Executive Dashboard with inward vs outward trend — KPI cards plus an inward, outward, and net-flow chart drawn by Chart.js. Spot which products are moving and which are sitting on the shelf without writing a single formula.

🔹 Multi-warehouse stock transfers with full ledger — move stock between warehouses, record adjustments with reason codes, and the Stock Ledger captures every movement for audit. Closing balances on Current Stock recalculate live.

🔹 14+ exportable reports — filter by date, warehouse, product, or supplier and export to Excel (XLSX). Built on SheetJS so the export works directly inside the browser without server round-trips.

🔹 Configurable currency and tax fields — set your currency symbol ($, €, £, ₹, ¥), tax ID, default warehouse, and default language in one Settings page. Localised cost columns flow through every report and dashboard tile.

📦 What’s Inside the Web-based: Advanced Inventory Management System

The system contains 11 fully-linked pages organised by use frequency. The download includes the Code.gs server file, the Index.html front-end file, and a step-by-step Google Apps Script deployment guide.

Dashboard — KPI tiles, top products, and inward vs outward trend

🔹 1. Dashboard — KPI tiles for total stock value, active products, top suppliers, low-stock alerts, plus an inward / outward / net-flow chart and a breakdown of stock value by warehouse.

Dashboard — secondary analytics view with top movers and category mix

🔹 3. Stock Ledger — full audit trail of every inward, outward, transfer, and adjustment. Filter by date, warehouse, product, or transaction type. The ledger is the single source of truth for inventory accuracy reviews.

Stock Ledger — every inward, outward, transfer, and adjustment in one audit trail

🔹 4. Reports — 14+ pre-built inventory reports with filters for date range, warehouse, supplier, and product. One-click Excel export through SheetJS — no copy / paste, no broken formulas.

Reports — filter, generate, and export 14+ inventory reports to Excel

🔹 5. Product Master — central catalogue of every SKU with unit of measure, batch, reorder level, default supplier, and category. Drives every dropdown and validation in the transaction pages.

Product Master — SKU, batch, unit, reorder level, supplier link

🔹 6. Stock In / Purchases — record goods received against suppliers, with batch numbers, unit cost, warehouse, and invoice reference. Posts directly to the Stock Ledger and updates Current Stock.

Stock In / Purchases — receive goods from suppliers

🔹 7. Stock Out / Issues — issue stock to customers, internal departments, or projects. Captures issue-to party, reference document, and warehouse — and updates valuation using the running average cost.

Stock Out / Issues — issue stock to customers or internal departments

🔹 8. Stock Transfers — move stock between warehouses with from / to references. Creates two linked ledger entries so the audit trail is complete on both ends.

Stock Transfers — move stock between warehouses with traceable references

🔹 9. Stock Adjustments — correct stock counts after physical inventory or breakage / loss events. Each adjustment carries a reason code and a remark so corrections stay traceable.

Stock Adjustments — correct counts with reason codes for full traceability

🔹 10. Masters — Warehouses, Suppliers, Customers / Issue-To — three master-data pages that feed every transaction with validated dropdowns. Add a new warehouse, supplier, or customer in one row and it appears across every form instantly.

Warehouses — central master for every storage location

🔹 11. Admin — Users, Lists, Settings — Admin-only pages to manage usernames, passwords, roles, dropdown list values, and company settings (currency symbol, tax ID, default warehouse, default language EN or FR).

User Management — Admin-only page to add, edit, and remove users

Settings — currency, default warehouse, tax ID, default language

📊 Web-based: Advanced Inventory Management System vs. Excel Inventory Template vs. Paid Inventory SaaS — Where This Fits

For small and mid-size businesses that want a real web-based inventory app without paying $30+ per user per month for Zoho Inventory or NetSuite, the Web-based: Advanced Inventory Management System sits in the sweet spot — full transactions, multi-warehouse, bilingual, and you own the source code.

👥 Who This Template Is For — and Who It’s Not For

✅ This template is built for:

• Small and mid-size retail, wholesale, manufacturing, and distribution businesses (5–500 staff) wanting a web-based stock app without monthly SaaS fees
• Operations managers and warehouse leads tracking stock across 2–10 warehouse locations with transfers and adjustments
• Francophone businesses in Canada, France, Belgium, Switzerland, and West / Central Africa needing a bilingual EN / FR inventory tool
• Founders and accountants who want to own their inventory data on Google Drive instead of a vendor cloud
• Consultants and developers who want a starter Apps Script web app they can rebrand and resell to their clients

❌ This template is NOT for:

• Enterprise teams requiring SOC 2 compliance, SAML SSO, or audit-trail logs across 10,000+ SKUs and 50+ warehouses
• Businesses needing live barcode scanner integration with hardware devices and shop-floor terminals
• Teams that do not use Google accounts — the system runs on Google Apps Script and requires Google Workspace or a free Google account to deploy
• Real-time multi-currency revaluation with FX feeds — currency is configurable but is a single fixed symbol per deployment

⚙️ How to Use the Web-based: Advanced Inventory Management System

1. Download and unzip the source code package — you will see Code.gs, Index.html, and a deployment guide PDF.
2. Open Google Drive, create a new Google Sheet, then go to Extensions → Apps Script to open the script editor.
3. Paste Code.gs and Index.html into the Apps Script project (delete the default Code.gs first, then add the Index.html file via the + button → HTML).
4. Deploy as a Web App from the Deploy → New Deployment menu. Choose “Execute as: Me” and “Who has access: Anyone with the link” (or restrict to your Google Workspace domain).
5. Open the deployment URL and log in with the seeded credentials (Admin1 / abcd). Change the password immediately and add your real users on the User Management page.
6. Set company defaults on the Settings page — currency symbol, tax ID, default warehouse, and default language (English or French).
7. Populate masters in this order: Warehouses → Suppliers → Customers → Product Master. Then your team can start recording Stock In, Stock Out, Transfers, and Adjustments.

💼 Real-World Use Cases

Amadou runs a 40-person electronics distribution business in Abidjan with three warehouses. His team uses the Web-based: Advanced Inventory Management System in French to record stock-in from suppliers, transfer between branches in Abidjan, Bouaké, and Yamoussoukro, and issue stock to retail customers. Every Monday he opens the Dashboard, reviews the inward / outward trend chart, and exports the slow-mover report to Excel for his procurement meeting — without paying for Zoho Inventory licences in CFA francs.

Priya is the operations manager at a 90-person cosmetics manufacturer in Mumbai. She rolled out the Web-based: Advanced Inventory Management System across two warehouses and a quality-hold area. Her warehouse supervisors log goods received against purchase orders in real time on tablets, the Stock Ledger captures every movement, and quarterly stock-count adjustments stay traceable through the reason-code column. Setup took her IT contact 12 minutes following the deployment video.

Sophie is a freelance ERP consultant in Montreal serving bilingual SME clients. She uses the system as a starter template for each new engagement, rebranding the Settings sheet, switching the default language to French for Québécois clients, and tweaking the Reports page to add client-specific filters. The included Code.gs and Index.html source files mean she controls every line of the app — and she charges her clients a deployment fee that pays back the $49 one-time purchase many times over.

❓ Frequently Asked Questions

What pages does the Web-based: Advanced Inventory Management System include?

The Web-based: Advanced Inventory Management System includes 11 pages — Dashboard, Current Stock, Stock Ledger, Reports, Product Master, Stock In / Purchases, Stock Out / Issues, Stock Transfers, Stock Adjustments, plus three masters (Warehouses, Suppliers, Customers) and Admin pages for User Management, List Management, and Settings.

How does the bilingual English / French toggle work?

A single language toggle in the top-right of the screen switches every label, button, navigation item, table header, error message, and dashboard tile between English and French. The selected language is also stored as the default in the Settings page so new users land in the correct language.

How long does deployment to a Google account take?

Deployment of the Web-based: Advanced Inventory Management System takes under 15 minutes. Follow the included setup video — create a Google Sheet, paste Code.gs and Index.html into Apps Script, deploy as a web app, and log in with the seeded Admin1 credentials. The full step-by-step video is linked in the download package.

How does this compare to Zoho Inventory or Sortly?

Zoho Inventory starts around $29 per organization per month plus per-user fees, and Sortly starts around $49 per month for the Advanced plan. The Web-based: Advanced Inventory Management System is a $49 one-time purchase with no recurring fees, no per-user pricing, source code included, and your data stays in your own Google Drive.

Does it work on Mac, Chromebook, and tablets?

Yes. Because the Web-based: Advanced Inventory Management System runs entirely in a browser through Google Apps Script, it works on Windows, Mac, Chromebook, iPad, and Android tablets — anywhere you can open Chrome, Edge, Safari, or Firefox and sign in to your Google account.

Can I customise the source code or add new pages?

Yes. The download includes the full Code.gs server file and the Index.html front-end file. You can add new pages, change colours, edit the language pack, add custom reports, or integrate with other Google services using Google Apps Script documentation.

Is the Web-based: Advanced Inventory Management System a one-time purchase?

Yes. The Web-based: Advanced Inventory Management System is $49 one-time, instant download, no subscription, no per-user fees, and lifetime access. You also receive the Code.gs and Index.html source files so you fully own and control the deployment.

👤 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 (@PK-AnExcelExpert, @NextGenTemplates, @NeoTechNavigators). Every template is hand-built and tested before release.

🔗 Explore Related Templates

🔹 Out-of-Stock Rate KPI Dashboard in Power BI — Power BI counterpart for teams tracking out-of-stock metrics across the supply chain.

🔹 Shelf Space Utilization KPI Dashboard in Power BI — pair with this system for shelf-space and inventory efficiency analytics.

🔹 Supplier Performance KPI Dashboard in Power BI — track supplier-level KPIs feeding into your inventory operations.

🔹 Browse all Google Sheets Inventory Management Templates and Google Sheets Dashboards on NextGenTemplates.

📖 Click here to read the Detailed Blog Post

🎥 Visit our YouTube channel for step-by-step video tutorials

👉 YouTube.com/@NextGenTemplates

🎬 Watch the Product Demo:

🛠️ Watch the Deployment Setup Guide: