Forecast months of stock on hand (custom mode)
Learn how to add a calculation in Custom mode that divides stock on hand by the average monthly quantity sold over the last 12 months. You'll define both measures and use offsets so the date range updates automatically, which keeps the column accurate if you save it as a favorite.
Supporting documentation
Related video tutorials
Combine inventory and sales to find dead stock
Learn how to identify dead stock by comparing stock on hand value with sales value by product in total mode. Right-click a cell showing zero and filter for an exact value of zero to list items with no sales in the current month, then slice by warehouse and supplier to see where the most dead stock sits. You get the information you need to act on it quickly.
Stop losing stock to silence
Learn how to catch dead stock before it ties up cash and warehouse space. You'll filter for products with stock on hand but no sales, sort to find the biggest outliers, and build an inventory turns calculation you can duplicate for other periods. Save any result as a favorite, add it to a dashboard, or create an alert.
Explain the variance, don't just log it
Learn how to find the cause of cycle count and adjustment variances so they stop recurring. You'll view a stock snapshot over 12 months, switch to variances, and compare product groups to spot the largest discrepancy. Drilling into that item turns unknown shrinkage into a specific pattern or location, such as a bin or user, where your data supports it.
Know your weeks of cover
Learn how to work out your forward stock position by bringing sales quantity and stock on hand into one grid and building calculations that reference other columns, such as average monthly sales. You can duplicate a calculation to compare other periods, then save, send, or download the report, which updates as ERP data refreshes.