Lines counted
93%
Count accuracy
54%
Net variance value
-$67
Stock Count Sheet
Count stock by location against system quantities, with variance by units and value, recount flags, count accuracy and results by location.
11 free stocktake inventory templates, ready to edit in your browser and download for Excel, Word, Google Sheets or your calendar app. This collection brings together 11 spreadsheets from Inventory & Stock Management, Warehouse Management and Reordering & Stock Planning. Start with Stock Count Sheet, Stock Movement Ledger and Reorder Point & Safety Stock Calculator: each comes with realistic sample content, working formulas or ready-to-use wording, and a step-by-step guide.
Lines counted
93%
Count accuracy
54%
Net variance value
-$67
Count stock by location against system quantities, with variance by units and value, recount flags, count accuracy and results by location.
Stock value
$8,664
Items to reorder
1
Log every receipt, issue and adjustment and see the running quantity on hand for each item.
Items to order now
3
Units to order
4,361
Items tracked
5
Work out when to reorder each item from its demand, lead time and how variable both are.
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.
Overall sell-through
53%
Lines to reorder
4
Lines to mark down
4
Units received and sold by product, with sell-through rate, weeks of cover and a reorder or markdown call.
Net P&L
$2,364
Win rate
55%
Average R
0.6
Log every trade with entry, stop and exit, and see P&L, R-multiples, win rate, profit factor and which setups actually make money.
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.
Items to reorder
4
Expiring within 60 days
2
Expired
1
Stock on hand against par levels with expiry dates, reorder flags and the value of stock by storage area.
Items
10
Annual usage value
$102,618
A items
3
Rank every item by annual usage value and class it A, B or C so you know where control matters most.
Stock value
$27,060
Overall turnover
4.7
Slow or dead value
$14,060
Value stock by category and see turnover and days on hand so slow movers stand out.
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.