Quickly identify Inventory that is not selling
One of the best ways to identify slow moving and dead stock is to focus on items that have not sold for a while.
This Article covers the following:
- Run the Favourite report Inventory Slow Movers - Not Sold in 15 Weeks
- Change the Filter dimensions to suit your business
- Visualise to see slow moving Inventory problems more clearly
- Other Filters to remove Items that are not sold individually
1. Run the Favourite report Inventory Slow Movers - Not Sold in 15 Weeks
This Favourite is filtered to report on:
- All Items in Inventory
- Where the Item has not been sold for 15 weeks (Last Sold Weeks is > 15 weeks); and
- Where the Item was last purchased more than 4 weeks ago (Last Purchased Weeks >4)
- this is to remove any new items that may have been recently added but have no sales history
Change the Order By field to sort the data
- Last sold Weeks (Descending) - to show the oldest items first
- On Hand Cost - to see where you have the most money tied up in slow moving goods
2. Change the Filter dimensions to suit your business
Simply change the Filters to focus your attention on your specific inventory if 15 weeks is too long or too short:
- Run the Favourite report Inventory Slow Movers - Not Sold in 15 Weeks
- Click on the Filters icon
- Scroll down to Numeric Filters
- Edit the filters and click Done
- Learn more about Filters
- Click Save to Save this as a new Favourite report that you can reuse over and over
- Schedule to email out automatically - this also creates a snap shot at month end to help with Inventory provisions
3. Visualise to see slow moving Inventory problems more clearly
Rather than a long boring list of hundreds of slow moving items, sometimes it is easier to see the key problem items using a visualisation.
Focus your attention on:
- Run the Favourite VDB: Inventory Slow Movers - Not sold in 15 weeks
- High $ value tied up in inventory not selling
- Dead stock where inventory has not sold in a very long time
Scroll down to see the data in more detail.
4. Other Filters to remove Items that are not sold individually
If you have raw materials or component parts that are not sold individually then these will also appear on this report as they have Not Sold in the past 15 weeks.
To identify and then filter to exclude these types of items:
- Add raw materials and component parts to a separate Inventory group;
- Filter to Exclude this item group
- Learn how to Filter to exclude certain things
NOTE: Limitation of using Weeks since Sold
If just one item is sold during the date range then this will reset the Last Sold date and the item will no longer appear on the report! Use the Inventory Cover report instead.