# Planner Monthly Inventory Health Review Checklist > Source: https://netray.co/tools/planner-monthly-inventory-health-review-checklist > Publisher: Netray (netray.co), AI and integration engineering for ERP and manufacturing systems. > Section: Free Tools ## Short answer A 30-item monthly checklist to review parameters, stock levels, accuracy and supplier performance in one sitting. ## Category supply-chain ## Audience - Materials planner - Supply chain manager - Inventory control ## Tool **Kind:** checklist **Groups:** #### Planning parameters **Items:** **Text:** Review parts with planned lead time differing from recent receipts **Critical:** true **Text:** Review reorder points on A items against recent demand **Critical:** true **Text:** Check safety stock on parts that stocked out in the past month **Critical:** true Confirm lot sizes and order multiples still match supplier terms Check MRP type and planning flags on newly released parts Review parts with parameters set to zero that carry demand Look for parts with manual overrides older than 90 days #### Stock levels and excess **Items:** **Text:** List parts above maximum stock and decide action **Critical:** true List parts with no movement in the last 12 months **Text:** Check days of supply on the top 20 parts by value **Critical:** true **Text:** Review open purchase orders on parts already overstocked **Critical:** true Check aged stock against reserve policy with finance Look for stock held in the wrong location or status Review customer-owned and consignment stock separately #### Accuracy and counts **Items:** **Text:** Compare cycle count completion with the plan **Critical:** true Review count variances by reason code **Text:** Check negative stock records and clear their cause **Critical:** true Check for open receipts not put away Check goods issued without matching order reference Confirm all adjustments above limit have approval #### Suppliers and open orders **Items:** **Text:** Review past due purchase orders by supplier **Critical:** true Check promised dates updated for all expedited lines Review blanket orders nearing expiry or exhaustion Check suppliers with repeated late delivery Check incoming quality rejections affecting supply Confirm supplier lead time changes are in the ERP #### Reporting **Items:** Update inventory turns and days of supply **Text:** Update service level and stockout count **Critical:** true Report excess and obsolete exposure to finance Record actions and owners from this review Archive this checklist with the month's date **Scoring Note:** Aim to tick every critical item each month. Items you cannot complete signal a data or process gap worth fixing before next month. ## Content **Intro:** A monthly review keeps inventory from drifting. This checklist walks a planner through parameters, excess, accuracy, suppliers and reporting in a repeatable order, so nothing depends on memory. **Sections:** #### How to run the review **Body:** Block out two or three hours at the same point each month, ideally after month-end close when numbers are final. Work through each group in order and tick items as you complete them. Note actions on the spot, with an owner and a date. Critical items are the ones most likely to cause a stockout or a write-down, so do not skip them when time is short. #### Why these groups **Body:** The five groups follow how inventory problems actually arise. Parameters set the plan; stock levels show whether the plan is working; accuracy tells you whether the numbers are true; suppliers explain why the plan fails; reporting shows leadership the result. Reviewing them in this order means each step informs the next, for example finding a lead time error before you judge reorder points. **Bullets:** - Parameters first, because they drive everything - Excess alongside shortage, not separately - Accuracy before conclusions about stock #### Using ERP reports **Body:** Most items map to standard reports: MRP exception lists, stock overview and aging reports, cycle count variance reports, open purchase order and past due reports, and inventory valuation. Save these as variants or saved searches so the review starts from the same data every month. Where a check needs a manual export, consider automating it. #### Common mistakes **Body:** Reviewing only what is short, and ignoring what is excess, is the classic one; both cost money. Another is making changes without recording them, so no one knows why a parameter moved. And skipping the review in busy months is exactly when drift happens. **Cta:** If the review takes a full day because the reports are scattered, we can consolidate it into a single view from your ERP data. Ask for a review. **Faq:** #### How long should the review take? **Answer:** Two to four hours for a plant with a few thousand active parts if reports are ready. It takes longer the first time while you set up saved reports. Focus on A items and exceptions. #### Should this be monthly or weekly? **Answer:** Monthly suits parameter and excess reviews. Shortages and past due orders need daily or weekly attention. Use this checklist monthly and the shortage log for daily work. #### Who attends? **Answer:** The planner leads. Invite a buyer for supplier items and finance for reserves. Many plants do the first half alone and the second half in a short meeting. #### What do I do with the findings? **Answer:** Record each as an action with owner and date, review last month's open actions first, and report the trend to your supply chain manager. Repeated findings point to a process cause. ## Search terms monthly inventory review checklist, materials planner checklist, inventory health check, inventory management checklist excel, planning parameter review checklist, month end inventory review --- Talk to an engineer: https://netray.co/contact?intent=erp_ai | Machine catalog: https://netray.co/agent/catalog.json