This report uses both sales data and inventory session data. You must have completed two inventory sessions for the variance report to populate. Report views are based on session dates and will include sales logged between the two session dates.
This report utlizes item usage rate to compare against sales. Usage in Backbar is calculated with the following data
We calculate item usage rate based on this and compare it to sales during the same time period. Usage Rate on the Variance report is the same information contained within the Inventory>Usage details report. Usage calculation formula and info is linked here.
Variance is the difference between the total sales and usage rate of an item (Actual vs theoretical usage). The right column of the report shows variance by:
High variance is marked in red to flag when the usage rate is significantly higher than the item sales.
It's not uncommon for their to be slight variance, so it's important to be familiar with your acceptable range of variance.
No orders: One of the most common reasons for variance is if you are not logging orders in Backbar. Without tracking orders, it's likely the variance report will be skewed due to negative usage rates. Having the order received on the wrong date can also lead to incorrect usage reporting and in turn variance.
Inventory counts: If inventory counts aren't entered properly, or inventory sessions are set to the correct close date, this can throw off your usage rate.
Point-of-sale workflow: If your point-of-sale isn't set up properly, like missing items, for example, then sales won't be tracked properly in Backbar. Similiarly, if your the item mapping in Backbar isn't accurate, then sales will be incomplete in Backbar.
In-house issues: Other reasons for high variance include theft, overpouring, and improper tracking by employee.
