I will create an excel inventory tracker with stock dashboard
Excel Spreadsheet and Digital Product Creator
About this Gig
Running out of stock or losing track of what you have? Ill build an inventory spreadsheet that keeps everything under control.
What you get:
-Product catalog with stock in, stock out and current balance
-Automatic low-stock alerts (highlighted rows when an item reaches its reorder level)
-Sales and purchase logs linked to your stock
-Summary dashboard with key numbers and charts
-Clear layout, easy to use and ready from day one
Ideal for small shops, online sellers (Mercado Libre, Shopify, Etsy, Amazon), warehouses and freelancers.
Works in Excel or Google Sheets. If you already have a file, send it and Ill organize it or improve it.
Message me before ordering if you need something specific, and Ill confirm what I can deliver.
Platform:
Excel
•
Google Sheets
•
VBA
Development technology:
Google Apps Script
•
Excel
Expertise:
Formulas
•
Functions
•
Macros
•
Dashboard
•
Charts
FAQ
What do you need to start my inventory spreadsheet?
Your product list (or an example file), what you want to track (stock in/out, prices, suppliers) and whether you prefer Excel or Google Sheets. Have a file already? Send it before ordering and I’ll tell you what I can improve.
Does it work in Excel and Google Sheets? What about Mac or Excel Online?
Both. Excel macros (VBA) don’t run in Excel Online and may be limited on Mac, so for those cases Google Sheets is the better choice. Need both versions? Add the extra.
What’s included in each package?
All packages highlight low-stock items and calculate your stock automatically. Standard and Premium add a summary chart, buttons and a user guide. Email alerts (Google Sheets only) and extra sheets are available as extras.

