I will create an excel inventory tracker and dashboard
About this Gig
Still tracking your stock on paper or in a messy spreadsheet? I will build you a clean Excel inventory tracker that shows exactly what you have, what is running low and what you need to order.
I am not just an Excel freelancer. I run daily operations for a food import and distribution company with 11 warehouses. The tools I build for you come from real field use, not from a template.
What you get:
Stock in and stock out entry sheets with drop-down lists
Live stock balance for every item
Low-stock alerts with automatic color coding
Purchase order log (Standard and Premium)
Dashboard with key figures and charts (Standard and Premium)
Multi-warehouse tracking and a user guide sheet (Premium)
Why work with me:
Simple files your team can use without training
No macros: works in any recent Excel version, no security warnings
Fully editable file, all formulas visible
English or French version available
Perfect for shops, distributors, warehouses, restaurants, e-commerce sellers and small businesses.
Please message me before ordering with your number of items, warehouses and what you track today. I reply fast.
Platform:
Excel
•
Google Sheets
Development technology:
Excel
•
VLOOKUP
FAQ
Can I use the tracker in Google Sheets?
Yes. I can deliver it in Excel or Google Sheets. Just tell me which one before ordering.
What do you need from me to start?
Your list of items (even a rough one), the number of warehouses or locations, and how you track stock today. A photo of your current paper sheet is fine.
Can I add more items later?
Yes. The file is built so you can add new items and rows yourself without breaking the formulas.
Does the file contain macros?
No. It only uses standard formulas, so it opens without security warnings on any computer.
Can you adapt it to my business?
Yes. Every tracker is set up with your own items, units and categories. It is not a generic template.

