Stock value
$8,664
Items to reorder
1
Stock Movement Ledger
Log every receipt, issue and adjustment and see the running quantity on hand for each item.
11 free inventory stock in and out 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, Reordering & Stock Planning and Clubs, Churches & Community Groups. Start with Stock Movement Ledger, Inventory Valuation & Turnover Report 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.
Stock value
$8,664
Items to reorder
1
Log every receipt, issue and adjustment and see the running quantity on hand for each item.
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 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.
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.
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.
Devices in use
9
Due for refresh
4
Out of warranty
8
Every laptop, phone and device with assignee, serial, warranty, age, refresh date and depreciated value, plus counts and spend by type.
To reorder
1
Running low
4
Shopping list
$152
Keep stationery, kitchen and cleaning supplies stocked with par levels, monthly usage, weeks left, a priced shopping list and spend by area and month.
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.
Products
11
Average pour cost
20%
Above target
2
Cost per pour and pour cost % for every bottle and keg, weekly usage from counts, and variance against what the POS says you sold.
Items out now
3
Overdue
3
Returned needing attention
1
Sign tools and equipment out and back in, and see what is overdue and who has it.