I will build an excel inventory and stock tracker
Excel and Data Management Specialist
About this Gig
I will build an editable Excel inventory tracker that shows what is in stock after you record receipts and withdrawals. The workbook will use your item list, units, and starting balances.
Basic includes a stock movement log and current balances for one location. Standard adds low-stock flags based on your reorder points and inventory value based on the unit costs you supply. Premium covers two locations and adds a transfer log and an inventory dashboard.
The workbook is designed for manual entry in Excel. Message me before ordering if you need a connection to another system or more locations than the packages cover.
AI tools assist with workbook development and testing. Each workbook is tailored to your requirements and its calculations are checked before delivery. Stock calculations are tested with sample receipts and withdrawals.
Platform:
Excel
Development technology:
Excel
Expertise:
Formulas
•
Functions
•
Dashboard
•
Data validation
•
Modeling
FAQ
How do low-stock alerts work?
Standard and Premium highlight items in Excel when they reach the reorder points you provide.
Can I track stock moving between locations?
Yes. Premium includes transfers between two locations.
