I will build an excel inventory tracker and dashboard
Data Entry and Excel Specialist
About this Gig
Stop tracking stock and supplier payments on paper or in messy sheets. I'll build you a clean, automated Excel tracker designed around your business.
What you get:
- Purchase log with dropdowns for supplier, item and unit (Carton, Pcs, Kg, Liter, Box or your own)
- Live stock balance with low-stock / reorder alerts
- Supplier ledger: total purchases, total paid and outstanding due per supplier
- Dashboard with key totals and a chart
- Formula cells protected so nothing breaks; yellow cells for your entries
- A short "Start Here" guide inside the file
- Works in Microsoft Excel and Google Sheets (formulas only, no macros)
For restaurants, shops, traders, wholesalers and online sellers.
I run a building-materials trading business, so stock and supplier dues are things I handle every day.
I believe in honest work: I'll tell you clearly what I can and can't do, I use AI-assisted tools openly, and I check every file personally before delivery.
Please message me before ordering so I can confirm the right package.
Platform:
Excel
•
Google Sheets
•
LibreOffice
Development technology:
Excel
•
VLOOKUP
Expertise:
Formulas
•
Dashboard
•
Data validation
My Portfolio
FAQ
Will it work in Google Sheets?
Yes. I test it in both Excel and Google Sheets.
Can I add more items or suppliers later?
Yes. The file has room for hundreds of items and thousands of entries.
Do you use AI tools?
Yes, openly, to work faster. I check and test every file personally before delivery.

