Stock Period Reports
Period Variance
Every stock movement for each product in a stock period, and any variance between expected and counted stock.
Can't find what you need? Contact Cinchio:
About
Inventory Management only
This report is only available to companies using Inventory Management.
The Period Variance report summarises the stock movements for each product in a stock period. It compares the expected stock with what was counted, and highlights any variance so you can find discrepancies.
Open it from either place:
Reports menu
Go to Reports & Analysis > Period Results > Site Reports > Period Variance, then choose the period in the filters.
A stock period
Open it from inside any stock period. It shows that period.
Tracking down a variance
Select any figure in the report to see the movements behind it. See Reviewing Variances.
Filters
Choose these before you run the report.
The period to report on. Set for you when you open the report from a stock period.
Optionally, all or part of a product's name.
Show only products whose cost variance is more than this value, either way. For example, entering 10 shows variances above 10 or below −10.
Show values as costs, quantities or both, for each product.
Show only this number of products with the highest cost variances.
The product groups to include. Leave blank for all.
Report Output
Stock movements and counts for the period, split by product group.
Same for every reporting profile
This report looks the same whichever reporting profile your company uses.
How the variance is worked out
Which costs are used
Opening
The previous period's closing cost.
Movements
The cost at the time of each movement.
Expected, counted and variance
The period's last cost value.
Columns
Linked column names open the detail behind that figure, on the Reviewing Variances tab.
The product name.
The unit size quantities are based on, the latest cost in the period, or both. Find out how product costs work.
The opening quantity or cost: the closing count or cost from the previous approved period.
Total quantity or cost bought on supplier orders or cash purchases.
Total quantity or cost from product preparations, based on recipes at the time.
Total quantity or cost transferred in from other sites or external sources.
Total quantity or cost transferred out to other sites or external destinations.
Total quantity or cost sold, based on product recipes at the time of sale.
Total quantity or cost of approved wastage, based on recipes at the time.
The quantity or cost expected at the end of the period: the opening value plus or minus every movement.
Total quantity or cost counted on all count sheets in the period.
The difference between the expected and counted quantity or cost.
Reviewing Variances
Select a value in the report to see the movements behind it, to track down where a variance came from.
Purchasing value
The supplier orders and cash purchases that make up the purchasing figure. Select an ID to open the order or cash purchase in a new tab.
Product preparations value
The product preparation records where the product was used or made. Select a preparation ID to open it in a new tab.
Transfers in value
The transfers that brought the product into the site. Select a transfer ID to open it in a new tab.
Transfers out value
The transfers that took the product out of the site. Select a transfer ID to open it in a new tab.
Sales value
How much of the product was used in sales of each saleable product that has it in its recipe.
Wastage value
Each wastage record where the product was wasted, directly or as part of a recipe product. Select a waste ID to open it in a new tab.
Count value
The total counted on each count sheet in the period. Select a count sheet description to open it in a new tab.
Counts of recipe products
If a Recipe type product was counted on a stock count sheet, the count is shared out across its stock items in proportion, and that share is shown here.
Variance value
The product's cost variance history in the Variance History Chart. The chart covers the 12 weeks before the selected period and, if it isn't the latest period, any periods since.
If your company uses Company Periods, the chart also shows the product's average cost variance across all your sites, so you can compare this site with the company average.