# Slow-Moving Inventory Review Worksheet for Distributors > Source: https://netray.co/tools/distributor-slow-moving-inventory-review-worksheet > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer An editable worksheet that computes months of supply and tied-up cash for each item and records the action you decide, ready to export to Excel. ## Category supply-chain ## Erp Epicor Prophet 21 ## Industry Wholesale Distribution ## Audience - Inventory manager - Purchasing - Branch manager ## Tool **Kind:** worksheet **Mode:** editable **Currency:** $ **Columns:** #### Item **Key:** item **Type:** text #### Description **Key:** desc **Type:** text #### On hand **Key:** onhand **Type:** number #### Unit cost **Key:** unit_cost **Type:** number **Format:** currency #### Annual usage **Key:** annual_usage **Type:** number #### Last sale **Key:** last_sale **Type:** date #### Inventory value **Key:** value **Type:** number **Expr:** onhand * unit_cost **Format:** currency #### Months of supply **Key:** months **Type:** number **Expr:** if(gt(annual_usage,0), onhand / annual_usage * 12, 99) **Format:** decimal #### Excess over 12 months **Key:** excess_qty **Type:** number **Expr:** max(0, onhand - annual_usage) **Format:** integer #### Excess value **Key:** excess_value **Type:** number **Expr:** excess_qty * unit_cost **Format:** currency #### Action **Key:** action **Type:** select **Options:** - Keep - Promote - Return to vendor - Transfer to branch - Bundle - Write down - Scrap **Rows:** **Item:** VLV-2210 **Desc:** Ball valve 2 in brass **Onhand:** 180 **Unit cost:** 22.4 **Annual usage:** 60 **Last sale:** 2026-08-12 **Action:** Promote **Item:** GSK-0415 **Desc:** Gasket 4 in flange **Onhand:** 900 **Unit cost:** 1.15 **Annual usage:** 1100 **Last sale:** 2026-10-02 **Action:** Keep **Item:** MTR-7731 **Desc:** Motor 3 HP 1800 rpm **Onhand:** 14 **Unit cost:** 410 **Annual usage:** 3 **Last sale:** 2025-11-19 **Action:** Return to vendor **Item:** FIL-3308 **Desc:** Hydraulic filter element **Onhand:** 75 **Unit cost:** 18.9 **Annual usage:** 0 **Last sale:** 2024-09-30 **Action:** Write down **Item:** BLT-5520 **Desc:** V-belt B68 **Onhand:** 220 **Unit cost:** 6.8 **Annual usage:** 190 **Last sale:** 2026-09-27 **Action:** Keep **Totals:** #### Total inventory value **Key:** value **Agg:** sum **Format:** currency #### Total excess value **Key:** excess_value **Agg:** sum **Format:** currency **Summary:** #### Excess as share of value **Key:** excess_share **Expr:** if(gt(sum_value,0), sum_excess_value / sum_value * 100, 0) **Format:** percent **Primary:** true **Description:** Share of reviewed inventory value above 12 months of supply. **Notes:** Items with no usage show 99 months of supply as a flag. Use usage from a consistent period, ideally trailing 12 months of sales and transfers. Add one row per item or per item and location. ## Content **Intro:** Most distributors can run a slow-moving report, but the decision work happens in a spreadsheet. This worksheet takes the numbers you export from your ERP and computes months of supply and excess value, then lets you record what to do with each item. **Sections:** #### How to use the worksheet **Body:** Export on-hand quantity, unit cost, trailing 12-month usage and last sale date for the items you want to review, then replace the sample rows. The computed columns update as you type. Sort by excess value, review the top items first, and pick an action for each. Export the result to Excel to circulate it to purchasing and sales. **Bullets:** - Use the same usage period for all rows - Include transfers in usage if you move stock between branches - Review items with no sales in 12 months first - Check open purchase orders before choosing an action #### The method **Body:** Months of supply is on hand divided by annual usage, times 12. Excess quantity is the on-hand above 12 months of usage, and excess value is that quantity times unit cost. A 12-month threshold is a common starting point, but fast-turn categories may deserve 3 to 6 months while engineered or seasonal lines can justify more. Change the formula logic by adjusting your own judgement in the action column. #### Choosing actions **Body:** Return to vendor is the best cash recovery if terms allow, so check return policies first. Promote or bundle works for items with real demand that is just slow. Transfer to branch fits stock that sells elsewhere. Write down or scrap is the last resort and involves finance, since it hits earnings. Record the reason, so the next review does not repeat the debate. #### Common mistakes **Body:** Using a short usage window that misses seasonality, ignoring items with supplier minimum order quantities that created the excess, and reviewing once a year instead of quarterly. Also review the reorder parameters of excess items, otherwise replenishment buys more of what you are trying to sell down. **Cta:** If the export, refresh and review cycle is manual, we can discuss a read-only report that builds this view directly from your ERP data. **Faq:** #### What threshold defines slow-moving? **Answer:** There is no universal rule. Many distributors flag items above 12 months of supply or with no sales in 6 to 12 months, then adjust by category. Pick thresholds with purchasing and finance and apply them consistently. #### Where do I get the input data? **Answer:** From an inventory and sales history report in your ERP, exported to Excel or CSV. You need on-hand, cost, trailing usage and last sale date. Paste or type the values into the table. #### How does this relate to inventory reserves? **Answer:** The worksheet identifies candidates. Whether and how much to reserve is an accounting policy decision for your controller and auditors, so use the excess value as an input, not as the reserve itself. #### Can I add more columns? **Answer:** Not on screen, but you can export to Excel and extend the sheet there, for example with vendor, location or open PO quantity. The computed columns come across as values. ## Search terms slow moving inventory report excel, excess inventory worksheet distributor, months of supply calculator, obsolete inventory review template, dead stock review worksheet, p21 slow moving report, inventory disposition worksheet, stock aging review template --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json