On 14th February we are releasing an enhancement to this report to enable users to run it for a date range. The report will show the variance using the opening stock and the closing stock nearest to the dates selected.
By not picking a date, the report will continue to show the variance between the last 2 stocktakesThe Variance report is to be used to show you an itemised variance between your actual closing stock using your last stocktake and your theoretical stock, calculated by IndiCater.
The date picker gives you the option to either use your last 2 stocktakes as the opening and closing counts, or to pick an earlier stocktake as the opening count.
The assumption is made that the stocktake is recorded at the end of the day so if the opening stocktake is dated the 1st January, the purchases, sales etc are included from the 2nd. If the stocktake is started on the 1st and runs past midnight, the user should ensure they are amending the date to be the 1st to ensure transactions from the 2nd are included in the reports.
Stocktakes in an outlet should be recorded on the same day. If a product is in multiple stock takes all counted on different days we can’t provide any useful data as there is no one start date.
Purchases are only counted in the period the user has booked off the order. If the order was due for delivery on the 1st, the closing stock recorded on the 5th and the order booked off on the 10th, it won’t be included as a purchase. It will be included in the following period.
If the order is booked off and 100 baguettes receipted, the estimate for 100 will be included in the report. If in the following period, the invoice for the baguettes is approved and the quantity is adjusted to 90, -10 will be included in the purchasing figure in that following period.
The categorisation is dependant on the KPI category setting in the income and purchasing categories.
For Dish Wastage we use the Profit Category in the recipe so this needs to be set to food or liquor.