Report Information
The Period Variance report offers a clear summary of stock movements for each product during a stock period. By comparing opening balances with counted values, it highlights any variances, helping to identify discrepancies. This report is a key tool for accurate inventory control and informed stock management.
This report is available only to companies subscribed to the Inventory Management module.
Access the Period Variance report via either:
- The main menu via: Report & Analysis > Period results > Site Reports > Period Variance.
- Directly with each individual Stock Period.
Information on report filter options
The table below summarises report filter options available for this report.
| Company Period |
Select which period to report on. |
| Product Name |
Enter the name (or part of) of a specific product, if applicable. |
| Cost Variance Threshold |
Enter a value to isolate products which have a cost variance that exceeds this threshold. All products with a cost variance greater than the positive, or less than the negative, of the value entered will be returned. |
| View Type |
Select whether to view values based on cost, quantities, or both combined, per product. |
|
Top Cost Variances |
Enter a number to view only the top X products with the highest cost variance. |
| Product Groups |
Select which product groups to include. If left blank, all groups will be included. |
Report Output
Split per product group, the report provides an overview of stock movements and counts within the period.
Additional information on this view
The table below summarises the data shown in each column of this report view.
| Product |
Displays the name of the product. |
|
Unit / Last Cost Value |
Displays the size unit that quantities are based on and/or the latest cost within the period. For more information on products costs, Click Here. |
| Open |
Displays the opening quantity/cost for the period. This reflects the closing count/cost of the previous approved period. |
| Purch |
Displays the total quantity/cost of purchases via a supplier order or cash purchase. |
| Prep |
Displays the total quantity/cost of product preparation records based on recipes at the time. |
| Tran(In) |
Displays the total quantity/cost of transfers into site from other sites and/or external. |
| Tran(Out) |
Displays the total quantity/cost of transfers out from site to other sites and/or external. |
| Sales |
Displays the total quantity/cost sold based on product recipes at the time of sale. |
| Waste |
Displays the total quantity/cost of approved wastage based on recipes at the time. |
| Exp |
Displays the total quantity/cost expected at the end of the period based on the opening values +/- movements. |
| Count |
Displays the total quantity/cost of all counts entered in all count sheets within the period. |
| Var |
Displays the total quantity/cost of the variance between the expected and counted figures. |
Note that:
- Values shown as a hyperlink in the table above can be selected to view detail on what makes up total shown in the report. More information on these links is covered later in this article.
- Opening costs are based on the closing cost of the previous period.
- Movement costs are based on the costs at the time of each movement throughout the period.
- Expected, counted and variance costs are based on the period last cost value shown.
- For more information on costs, Click Here.
Analysing Period Variance Data
Selecting a value within the report will provide information on what movements resulted in the value shown to assist in variance investigation.
Purchasing Value
Selecting a purchasing value will display each supplier order that resulted in the purchasing figure for the selected product. The order ID can be selected to open the supplier order in a new tab.
Note that the value also includes purchases made using a Cash Purchase, however these are not listed when selecting the value.
Product Preparations Value
Selecting a product preparation value will display product preparation records where the selected product was used as part of a Product Preparation, or where the product was made as part of a preparation. The product preparation ID can be selected to open the product preparation in a new tab.
Transfers In Value
Selecting a transfer in value will display transfer records where the product was transferred into the site. The transfer ID can be selected to open the transfer in a new browser tab.
Transfers Out Value
Selecting a transfer out value will display transfer records where the product was transferred out of the site. The transfer ID can be selected to open the transfer in a new browser tab.
Sales Value
Selecting a sales value will display the quantity that was used in the sales of each saleable product that uses the selected product within its recipe .
Wastage Value
Selecting a sales value will display each wastage record where the product was wasted directly or as part of a recipe product being waste. The waste ID can be selected to open the wastage in a new browser tab.
Count Value
Selecting a count value will display the total count entered into each count sheet within the period. The count sheet description can be selected to open the count sheet in a new browser tab
If a count has been entered against a Recipe type product within stock count sheets, the count is proportionally assigned to the component stock item and this allocation is referenced within this section.
Variance Value
Selecting a variance cost value will display a history of cost variances for the selected product.
The Variance History Chart displays the cost variance during the 12 weeks prior to the selected period and, if the selected period is not the latest period, the chart displays the cost variances for any subsequent periods too.
In addition to displaying the products cost variance at the site, if the company uses the Company Periods feature, the chart also displays the average cost variances for the product across all sites within the company to help gauge performance of this product against the company average.
Comments
0 comments
Article is closed for comments.