Open from the Reporting Menu

Inventory Turnover Analysis sits inside Inventory, Reporting, next to Stock, Locations, and the standard Moves reports, so the team finds it where they already look.

Set Date Range and Filters

Pick a From and To date, choose one or more companies, warehouses, and internal locations, and narrow the scope by individual products or product categories. Tick Include Zero Movement Products if you want items that did not move during the period to appear too.

Three Output Buttons

View Report opens the analysis on screen, Print PDF prints a formatted document, and Export XLSX downloads the spreadsheet. Pick whichever fits the audience for that moment.

On-Screen Turnover Analysis

Each row shows product, category, warehouse, company, Opening and Closing quantity and value, Average Inventory Value, Total Sold Qty, Cost of Goods Sold, the Turnover Ratio, Days Inventory Outstanding, and a colour-coded Stock Status. Rows group by category with subtotals at the top.

Ready-Made Filters and Group By

Quick filters jump straight to Fast Moving, Normal Moving, Slow Moving, or Dead Stock. Group By organises the same data by Product, Category, Warehouse, Company, or Stock Status.

Pivot Roll-Up Across Categories

Switch to the pivot view to roll up Opening, Closing, Average Inventory Value, Sold Qty, COGS, Turnover Ratio, and Days Inventory Outstanding across categories, products, and companies in one screen.

Colour-Banded PDF Report

The PDF prints the applied filters at the top, a Fast / Normal / Slow / Dead legend, then a clean table with every product, its costs, turnover, DIO, and a coloured Status badge. A totals row and a short formula note close the report.

Excel Export with the Same Layout

The Excel file mirrors the PDF: applied filters, classification legend, the full columnar table with colour-banded Status, a totals row, and currency in the last column. Drop it into a working file when finance needs to slice further.