The Margin Summary & Stock KPIs report offers valuable insights into key metrics within the stock period, providing a comprehensive view of critical performance indicators. This includes a comparison between actual and theoretical costs, an analysis of actual versus theoretical margin, and an overview of wastage and loss throughout the specified period. The report serves as a strategic tool for evaluating stock-related performance and making informed decisions to enhance overall operational efficiency.

This report is available only to companies subscribed to the Inventory Management module.

Note that:

For companies with multiple sites, this report is specific to the individual site period it is run from; To see this information for multiple sites, refer to the company-wide Period KPI Results report.
Data in this report is consolidated for all items. To see this data split per super group (e.g. Food vs Beverage), refer to the Margin Summary & Stock KPIs By Super Group report.
For more information on product costs in this report, Click Here.

Report Filters

The Margin Summary & Stock KPIs report displays data for all stock items within the time frame of a period, therefore there are no filters available when running this report.

To run the report:

Access the relevant stock period.
Select [MARGIN SUMMARY & STOCK KPIs] in the Reports section.

Report Output

The Margin Summary & Stock KPIs report has data split across three columns, where:

Total	Displays data for all products within the period.
Overhead	Displays data for only products that are configured as Overhead Stock Items. These are excluded from GP% calculations.
Sales	Displays data for all products excluding those configurated as overhead stock items as above. This column is used to calculate GP%.

The output of the report is split into five sections:

Section 1: Net Sales

The first section of the report displays net sales received during the period.

Section 2: Cost Of Goods

The second section displays the counts and movements behind the actual cost calculations, displaying:

Opening Stock	Displays the value of the opening stock at the start of the period, which matches the closing stock of the previous period.
Supplier Purchases	Displays the value of stock purchased via a supplier order, based on the cost of the purchase at the time.
Cash Purchases	Displays the value of stock purchased using petty cash via a cash purchase, based on the cost of the purchase at the time.
Transfers In	Displays the value of stock transferred in from other sites, based on the cost of the transfer at the time.
Transfers Out	Displays the value of stock transferred out to other sites, based on the cost of the transfer at the time.
Closing Stock Count	Displays the value of the closing stock at the end of the period, based on the latest cost for each product within the period.

Section 3: Actual Cost Of Sales

The third section displays the actual cost of sales and resulting actual cost margins, displaying:

Actual Cost Of Sales	Displays the actual cost of sales based on the opening stock value, plus or minus the movements within the period, less the closing stock value.
Actual Cost Margin	Displays the difference between net sales and the actual cost of those sales. This is also represented as a percentage of net sales.

Section 4: Theoretical Cost Of Sales

The fourth section displays the theoretical cost of sales and resulting theoretical cost margins, displaying:

Theoretical Cost Of Sales	Displays the theoretical cost of sales based on the cost of recipes at the point in time each product is sold.
Theoretical Cost Margin	Displays the difference between net sales and the theoretical cost of those sales. This is also represented as a percentage of net sales.

Section 5: Wastage Analysis

The fifth section displays any known wastage during the period, to help explain any difference between the theoretical GP% and actual GP%, displaying:

Stock Variance	Displays the cost of the stock period count variance.
Excess Yield Loss	For companies using the Product Preparation feature, this displays the cost of any unexpected yield loss.
Declared Wastage	Displays the cost of declared wastage.
Site Allowable Wastage	Displays the acceptable value of wastage allowed based on a percentage of sales, if defined within the Site Setup.
Wastage Over/Under	Displays the difference between the allowable wastage value and the actual wastage value.