Open from the Reporting Menu

FSN Analysis sits inside Inventory, Reporting, alongside the other stock reports your team already knows.

Set Date Range, Thresholds, and Filters

Pick the From and To dates and the company, type your own Fast Moving and Slow Moving threshold numbers, narrow by warehouses, internal locations, products, or product categories, and tick Include Zero Stock if those items belong in the report.

Three Output Buttons

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

On-Screen List with FSN Badges

Rows are grouped under Fast Moving, Slow Moving, and Non-Moving headers with subtotals. Each row shows internal reference, product, category, warehouse, Opening, Incoming, Outgoing, Adjustment, Closing, Avg Stock, Sales Qty, Turnover, Days Since Last Movement, FSN badge, and Inventory Value.

Ready-Made Filters and Group By

Quick filters jump straight to Fast Moving, Slow Moving, Non-Moving, Positive Stock, Negative Stock, or High Value over 10K. Group By organises the same rows by FSN Category, Warehouse, Product Category, or Company.

Pivot Roll-Up by FSN Category

Switch to pivot to roll up Closing Stock, Sales Qty, Stock Turnover Ratio, and Inventory Value across Fast Moving, Slow Moving, and Non-Moving categories in one screen.

PDF with Summary Cards

The PDF prints the applied filters and thresholds at the top, then five summary cards (Fast Moving count, Slow Moving count, Non-Moving count, Total Products, Total Value), followed by the colour-banded product table and a legend at the foot.

Excel Export with the Same Layout

The Excel file mirrors the PDF: report parameters at the top, a summary statistics block with counts and percentages, and the colour-banded detail table. Drop it into a working file when finance needs to slice further.