Browse categories
Explore
Fiverr Pro
English
$
USD
I will build an excel warehouse inventory and reorder tracker
Excel and VBA Tools for Operations Teams
I bring an operations leadership perspective to Excel and VBA tools. I build practical spreadsheets for employee scheduling, attendance and labor tracking, warehouse inventory and reorder planning, an...
About this Gig
See what is in stock and which items need attention with an Excel tracker built around your warehouse workflow.
BASIC: Up to 100 items at one location, manually maintained balances and reorder flags.
STANDARD: Up to 500 items at one location, receipts/issues log and calculated balances.
PREMIUM: Up to 1000 items across 3 locations, movement log, dashboard and one custom summary.
You receive an editable .xlsx workbook, fictional sample entries and operating instructions. One clean item list within package limits is included. Reorder flags use thresholds or simple rules agreed before work starts. Formula counts mean distinct calculation types, not copied cells.
Send your Excel version, item count, locations and sanitized sample before ordering for lots, serial numbers, expiry dates or valuation needs. Live integrations, barcode hardware, VBA, advanced forecasting and extensive data cleanup require a separate scope.
Revisions refine the agreed workbook; new workflows or features are separately scoped.
Platform:
Excel
Development technology:
Excel
Expertise:
Formatting
•
Formulas
•
Dashboard
•
Charts
•
Data validation
FAQ
Is this a live inventory system?
It is an Excel workbook updated through the agreed manual-entry workflow. Live synchronization with ecommerce, ERP or warehouse systems is not included.
How are reorder levels determined?
You provide thresholds, or we agree on a simple calculation using your data. Advanced forecasting and purchasing decisions are outside the standard scope.
Can you track lots or expiry dates?
Potentially, after reviewing your workflow and agreeing on a custom scope. These features are not included in the listed packages.
Can you import my item list?
One clean item list within package limits is included. Extensive cleanup, deduplication or joining inconsistent sources requires a separate scope.
What do the formula counts mean?
They refer to distinct calculation types such as on-hand balance or reorder flags, not the number of copied formula cells. Each package includes an editable workbook and usage notes.
