Inventory Manager
Stock levels, reorder points and valuation in one sheet.
Track SKUs with quantity on hand, reorder level, supplier and unit cost. Stock value and reorder alerts calculate themselves, and a movements sheet logs receipts and issues so on-hand quantity is always derived, never typed.
- Rating
- 4.8(1.5K)
- Monthly uses
- 196K
- Price
- Free
or drag it here
· processed locally, never uploaded
Files stay on your device
What it does well
- On-hand quantity derived from a movements log, so it always reconciles
- Reorder alerts with days-of-cover based on recent usage
- FIFO or weighted-average valuation on the stock summary
How to use Inventory Manager
- 1
Set your currency and valuation method.
- 2
Add product categories and locations.
- 3
Import an existing SKU list if you have one.
- 4
Download the inventory workbook.
Watch a walkthrough
Common problems and fixes
On-hand quantity is negative.
Issues were logged before the matching receipt. Check the movements sheet dates — the running balance shows exactly where it went negative.
A SKU shows no reorder alert despite being low.
Its reorder level cell is blank, so there is nothing to compare against. Set one on the products sheet.
Frequently asked questions
What people say
Handled a file with well over 200,000 rows without complaining. That is more than I can say for the desktop add-in we pay for.
Exactly what I needed. Inventory Manager used to be a twenty-minute job with a macro I did not trust; now it takes one drag and one click.
Small thing, but the error messages actually tell you what to fix. Inventory Manager flagged a hidden character that had been breaking my lookups for weeks.
More templates tools
Invoices, payroll, timesheets, budgets and dashboards — every template ships with real formulas, not screenshots, and downloads as a native .xlsx.
Browse Templates