Incomplete Variance Report

Incomplete Variance Report

Incomplete Variance Report


The Incomplete Variance Report is used to show products that have missing or incomplete information. As a result of this missing information, you may want to exclude these products from the reports you send to your clients. This is so that the variance % and other overall venue data such as GP%, COG% is not distorted by an incomplete dataset.


As a company, we do not want a few bad or missing pieces of information to stop us from sending a reporting package to our clients that will still offer them huge insights into what is happening in their business over the previous audit period. That is why we created the Incomplete Variance Report to move that bad/incomplete data out of the reporting package while also in the interest of being completely transparent with our clients, allow our clients to see what products/data we have moved out of their main reports such as the Liquor Variance Report.
​

This type of bad/incomplete information could be:


  • Missing invoices or purchase information from the client

  • Purchases on an invoice, but no product in the venue

  • No recorded information for product transfers or loans to other venues.

  • Incomplete or no product sales data from the POS or written down in the case of functions or parties

  • Lack of recipe information from the client to assign products to recipes and map sales to those recipes


Besides the Liquor Variance Report, the following reports will also be affected by moving a product from the Liquor Variance Report to the Incomplete Variance Report:


  • Operations Summary Report

  • Variance by Category

  • Variance by Category With Target COG/GP - 

  • Liquor Variance Report 

  • Variance to COG Comparison

  • COG Detailed Comparison 

  • Potential COG by Product 

  • Ranked Product Movements 


With the exception of the Operations Summary Report, all the reports listed above treat “incomplete products” as if they do not exist in the venue and therefore none of their data such as sales, costs, usage etc are not included in the reports in any shape or form.


Below is a screenshot of how the Operations Summary  Report is affected by moving a product to the Incomplete Report. In summary, what the screenshot is saying is that when you move a product to the incomplete report, the only data that is removed for the incomplete products are variance data….sales and usage/depletion information come across as normal. 




The reason the report is calculated this way, is to keep certain financial information consistent with what the client will see with their own systems.  For instance, there will be situations where you must ‘incomplete’ your top-selling products. What you’re effectively doing in this situation is ‘removing the variance’ from the calculations for these products.  This is the best way to keep sales, costs, and other information consistent with what happens in the business. This will also allow the client to focus on real issues happening within the reports, rather than thinking about how all of the counting mistakes Barmetrix could be making is affecting his business. 

Focusing on the key things that matter, will put that business in the best position to move forward.