Description
#InventoryManagement #GoogleSheets #AppsScript #StockManagement #SmallBusiness
Run your entire stock, warehouses, purchases, and inventory value from one web-based command center β built 100% in Google Sheets + Google Apps Script. Fully bilingual (English / French), with login, role-based access, dashboard, ledger, and 14+ reports.
π GET IT: https://nextgentemplates.com/product/web-based-advanced-inventory-management-system/
πΊ Subscribe for more: https://www.youtube.com/@NextGenTemplates
βββββββββββββββββββββββββββββββββββ
β WHAT'S INSIDE THIS INVENTORY SYSTEM
βββββββββββββββββββββββββββββββββββ
β
Web-based app β runs in the browser, hosted on your own Google Drive
β
Bilingual interface β switch between English π¬π§ and French π«π· in one click
β
Secure Login with 2 user roles (Admin + User)
β
Executive Dashboard with KPIs, charts, and inward/outward trend
β
Current Stock view with live valuation
β
Stock Ledger β every movement, fully auditable
π¦ INVENTORY TRANSACTIONS
- Stock In / Purchases
- Stock Out / Issues
- Stock Transfers (between warehouses)
- Stock Adjustments
ποΈ MASTER DATA
- Product Master with SKU & batch tracking
- Warehouses (multi-warehouse support)
- Suppliers
- Customers / Issue-To parties
π REPORTS & EXPORTS
- 14+ pre-built inventory reports
- Filter, generate, and export to Excel
- Configurable currency symbol (USD, EUR, INR, GBP, etc.)
π ADMIN CONTROLS
- User Management
- List Management (dropdown values)
- Company Settings, Tax ID / GST / VAT, Default Warehouse, Default Language
βββββββββββββββββββββββββββββββββββ
πΌ WHO IS THIS FOR?
βββββββββββββββββββββββββββββββββββ
- Small business owners managing inventory in spreadsheets
- Warehouse & operations managers
- Retail, wholesale, manufacturing, and distribution teams
- Accountants and finance teams needing a clean stock ledger
- Anyone who wants an inventory app WITHOUT paying monthly SaaS fees
- Francophone businesses needing a French-language stock tool
Our Digital Template Store:
https://nextgentemplates.com
Join our Course of Excel Pivot Tables for Data Analysis: Basic to Advanced:
https://bit.ly/3WkcAND
Subscribe our new YouTube Channel:
https://www.youtube.com/@NeotechNavigators
Need Consulting Servicing in Power BI, Excel or VBA:
Email Us at info@PK-AnExcelExpert.Com
Connect Us on Telegram:
@PKanExcelExpert
Watch the Step by Step tutorial for Project Plan (Gantt Chart) in Excel
https://youtu.be/kpLnxV3a1bE
Download our free Excel utility Tool and improve your productivity:
https://www.pk-anexcelexpert.com/pks-utility-tool-v3-0-free
See our Excel Products:
https://www.pk-anexcelexpert.com/products/
Visit to learn more:
Chart and Visualizations: https://www.pk-anexcelexpert.com/category/blogs/charts-and-visualization/
VBA Course: https://www.pk-anexcelexpert.com/vba/
Download useful Templates: https://www.pk-anexcelexpert.com/category/templates/
Dashboards: https://www.pk-anexcelexpert.com/excel-dashboard/
Watch the best info-graphics and dynamic charts from below link:
https://www.youtube.com/playlist?list=PLbDvAYjpWJ7CEAHn-iuGSeLbUtFnYekHr
Learn and download best excel Dashboard template:
https://www.youtube.com/playlist?list=PLbDvAYjpWJ7CpupRYMRkXSN0L92t7nUuF
Learn Step by Step VBA:
https://www.youtube.com/playlist?list=PLbDvAYjpWJ7BcoaFQD-syOrZzNSLZycwH
Website:
https://WWW.PK-AnExcelExpert.com
Threads
https://www.threads.com/@pkanexcelexpert
Facebook:
https://www.facebook.com/PKAnExcelExpert
Telegram:
https://t.me/joinchat/AAAAAE2OnviiEk5o1o8i4w
Pinterest:
https://www.pinterest.com/PKAnExcelExpert/
LinkedIn:
https://www.linkedin.com/company/pk-anexcelexpert
Twitter:
https://twitter.com/priyendra_kumar
Instagram:
https://www.instagram.com/pkanexcelexpert
Visit our Amazon Store
https://www.amazon.in/shop/pkanexcelexpert