Browse categories
English
$
USD
Connect to your AI
I will build an excel inventory tracker and a dashboard
About this Gig
Not sure how much stock you really have? I build Excel inventory trackers that do the counting for you. Log a delivery or a sale, and your stock, alerts and dashboard update instantly.
What's inside:
Inventory sheet: one row per SKU (product, color, size) with automatic on hand stock, status and stock value
Transactions log for stock in, sales and corrections
low stock and out of stock alerts, with a reorder level you set per item
Dashboard: stock value, units sold, revenue, gross profit, a needs attention list and charts
Settings sheet: edit your products, colors, sizes and sales channels once and every dropdown updates
Built in "How to use" guide
Why work with me:
Working formulas, nothing hardcoded. Duplicate or unknown SKUs get flagged
Made for nontechnical users: dropdowns and color coded input cells
Set up with your products and branding
Excel files (.xlsx), formulas only, no macros or VBA
Message me before ordering with what you sell and roughly how many items you stock, and I'll recommend the right package.
Platform:
Excel
•
Google Sheets
Development technology:
Excel
Expertise:
Formatting
•
Formulas
•
Functions
•
Dashboard
•
Modeling
FAQ
Do I need Excel skills to use it
No. The tracker uses dropdowns and color-coded cells, and every file includes a "How to use" guide.
Can you fix or upgrade my existing spreadsheet?
Yes. Message me before ordering and send the file, and I'll tell you the best package
Does it work in Google Sheets?
It's built and tested for Microsoft Excel (.xlsx). Please don't order if you need Google Sheets
Does it use macros or VBA?
No. It uses formulas only, so there are no security warnings and it works on any modern Excel.
Can I add more products later?
Yes. Add new rows in the Inventory sheet and your dropdowns come from the Settings sheet. Basic includes up to 50 SKUs entered by me, and you can keep adding your own after delivery.
Will it work on Mac?
Yes, on any current Excel for Windows or Mac
