Browse categories
Explore
Fiverr Pro
English
$
USD
I will create an inventory tracker in google sheets or excel with reorder alerts
About this Gig
Still counting inventory by hand or in a messy spreadsheet? I build an inventory tracker in Google Sheets or Excel for your products: you log deliveries and sales, the quantities update by themselves.
What you get:
- Item list with quantity on hand, reorder level and inventory value
- Inventory log: one row per delivery or sale, with dropdown lists to avoid typos
- Reorder alerts: every item shows OK, LOW or OUT
- Premium: dashboard with key figures, chart and a reorder list
- Formulas only, no macros, so it works in Google Sheets and Excel without security warnings
How it works:
1. Send me your product list (or a sample) and tell me if you use Google Sheets or Excel
2. I build the tracker with your items, categories and units and test it
3. You get the finished file plus short instructions
Every tracker is tested before delivery. Not sure which package fits? Send me your product list or a sample and I'll confirm what's possible and the exact price before you order.
Platform:
Excel
•
Google Sheets
Development technology:
Excel
•
VLOOKUP
Expertise:
Formulas
•
Dashboard
•
Data validation
My Portfolio
Other Data Processing Services I Offer
FAQ
Excel or Google Sheets?
Both. Tell me which one you use and I build the tracker for that platform.
Is my data safe?
I only use your files for your order and delete them once the order is completed. You can also send anonymized sample data.
Can you work with my existing file?
Yes. I can extend or rebuild your current inventory sheet. Send a copy (fake data is fine) and describe what should change.
Do you use macros or VBA?
No. I build formula-based trackers, so your file works in Excel and Google Sheets without macro security warnings.
What do I need to send?
Your product list or a sample, the columns you need and whether you use Excel or Google Sheets.
How many items can the tracker handle?
A few hundred items and several thousand log rows work well. Tell me your numbers and I size it. For tens of thousands of products, inventory software fits better, and I'll tell you so honestly.
Can it track several locations or warehouses?
Yes, on request. Send me a message with the number of locations before ordering and I'll confirm the price.
