Stock value
$894
Items to reorder
4
Out of stock
1
Inventory Tracker with Reorder Alerts
Stock on hand from a movements log, with reorder points from real usage, lead time and safety stock, days of cover and a ready-made reorder list.
9 free tr inventory tracker templates, ready to edit in your browser and download for Excel, Word, Google Sheets or your calendar app. This collection brings together 9 spreadsheets from Inventory & Stock Management, Specialized Inventory and Investment Tracking. Start with Inventory Tracker with Reorder Alerts, Batch & Expiry Date Tracker and Investment Portfolio Tracker: each comes with realistic sample content, working formulas or ready-to-use wording, and a step-by-step guide.
Stock value
$894
Items to reorder
4
Out of stock
1
Stock on hand from a movements log, with reorder points from real usage, lead time and safety stock, days of cover and a ready-made reorder list.
Batches expiring in 14 days
3
Expired batches
1
Value at risk
$350
Track every lot with its expiry date, days left and what to use, discount or dispose of first.
Portfolio value
$74,144
Unrealised gain
$13,013
Total return
21%
Holdings, gains, allocation by asset class and the exact buys and sells to rebalance to your targets.
Replacement value
$15,123
Cover headroom
$9,877
Missing proof
5
Belongings by room and category with serial numbers, receipts, photos, warranty status and replacement value, plus totals to check against your insurance cover.
Items low or out
5
Lots expiring in 30 days
2
Units on hand
664
Track stock in and out by item, reorder levels and best-by dates, and log households and people served each distribution.
Items to restock
4
Expired items
1
Expiring within 60 days
1
Track every first aid kit’s contents against required quantities, with expiry warnings and restock flags.
Live listings
6
Suppressed listings
1
Listings to restock
2
Every SKU on every marketplace with listing status, stock cover, content quality score and the next action to take.
Loss at cost
$321
Shrinkage rate
1%
Incidents
8
Record every loss by cause, value it at cost and see where theft, damage and waste are costing you most.
Returns logged
6
Open returns
2
Refunded
$85
Log each return from request to refund, with reasons, condition, cost and time to resolve.