I will build an automated excel inventory tracker with reorder alerts
Data analytics and business performance specialist
About this Gig
Are you managing inventory with disconnected files, manual calculations, or unreliable stock balances?
I will build a custom Excel inventory tracker that helps you record stock movements, monitor available quantities, and identify products that require attention.
FEATURES MAY INCLUDE:
- product and supplier master data
- stock-in and stock-out transactions
- automatic current stock calculation
- low-stock and reorder alerts
- location and category tracking
- Power Query imports
- VBA buttons or forms
- inventory dashboard and user guide
PACKAGES:
- BASIC: Tracker for up to 100 products and 1 location.
- STANDARD: Automated system for up to 500 products and 2 locations.
- PREMIUM: Multi-location system for up to 1,500 products and 5 locations.
I combine practical inventory knowledge with Excel automation. Every workbook is customized and tested against the agreed sample data.
IMPORTANT:
This is an Excel-based tool, not a cloud WMS or ERP. Live SAP, ERP, API, database, POS, accounting, and simultaneous multi-user integration are not included. VBA and Power Query compatibility depends on your Excel version and operating system.
Please contact me on Fiverr before ordering.
Platform:
Excel
•
VBA
•
Microsoft Office
Development technology:
VBA
•
Power Query
•
Excel
Expertise:
Pivot tables
•
Formulas
•
Macros
•
Dashboard
•
Data validation
My Portfolio
FAQ
What type of inventory system can you create?
I can create Excel-based stock trackers with product master data, stock-in and stock-out transactions, current stock, low-stock alerts, reorder levels, locations, suppliers, dashboards, and reporting.
Which Excel version should I use?
Microsoft Excel for Windows 2019, 2021, or Microsoft 365 is recommended. Please provide your exact Excel version and operating system before the project begins.
Will the system work on a Mac?
Some formulas may work on Mac, but VBA and Power Query compatibility can differ. Mac users must contact me before ordering so I can review the requested functions.
Can you build the system in Google Sheets?
This Gig is for Microsoft Excel. A Google Sheets version may require a separate custom offer because VBA and Power Query are not directly transferable.
Can you customize my existing inventory workbook?
Yes, after reviewing a sample. The price depends on the existing structure, formulas, data quality, and requested modifications.

