Article Contents

Introduction

While the dashboard provides a high-level view of your variances by family/category, the Variance page displays variances by individual items. For each item, you’ll see the amount sold and consumed, displayed in a number of ways ($ value, by units, by oz). 

By default, it displays the most recent inventory period, but you can adjust the “from” and “to” dates to any completed inventory.

Sales / Consumption Overview

Before looking at each item, you’ll see some high-level information regarding your sales and consumption:

  • Sales - The sales for the defined inventory period. This doesn't include sales of any archived POS Items, or any POS Items that contain an item that is marked as "Excluded from Variance".

  • Consumption - How much product was used at cost in the venue during the inventory period. Consumption = Starting Inventory + Invoices - Ending Inventory. This is also known as the Cost of Goods Sold (COGS).

  • Cost of Sales - The overall cost percentage for the inventory period. Cost of Sales % = Consumption / Sales

  • Variance Cost - The sum of the Variance Cost for each item. Variance Cost = Cost per Unit * Variance. A negative Variance Cost indicates a loss

  • Variance Retail - The theoretical value that the Variance Cost could've sold for based on your POS Item recipes.

  • Shrinkage Percentage - The percent reduction in your starting inventory due to Variance Cost. Shrinkage Percentage = Variance Cost / Beginning Inventory.

Note: We display this information because you must have accurate sales and consumption data to determine whether a variance is real, or because of missing/incorrect data.

Variances by Item

The main section of this page is where you can view the sales, consumption, and variance for each item in your venue.

You can use the search bar to find items by name, or by family / category, or make use of the predefined filters and views.

The default columns display the following information:

Sold (units): The number of units sold based on the sales data received from your POS system and using the POS items and recipes you have created. 

Consumed (units):  (Beginning inventory + Invoices Added) – Ending inventory. In other words, what was used/poured during the inventory period.

Variance (units): Sold (units) - Consumed (units). A negative value indicates a loss, whereas a positive value indicates a surplus.

Variance Cost ($): The cost of the variance based on the wholesale price (your cost/unit on the Items page). 

Variance Retail ($): The retail value of the variance based on a weighted average of all the POS items that the item is an ingredient. In other words, what the variance cost would have sold for.

Details: Clicking details provides a full breakdown of your data, showing exactly what was sold, the recipes / POS Items, and your history of inventory counts and invoices.

See the "Customizing Display" section below to learn how to toggle on and re-arrange columns. 

Predefined Filters

There are a number of filters to help identify any issues you may have with your variance.

You can find more information on the predefined filters here.

Customizing Display

When reviewing your variance, there are a number of ways to customize your display to see the exact information you need:

  • Views

  • Columns

  • Sorting, Grouping & Filters

For more in-depth information, please see:

Views

There are preset views that change the layout of your items on the Variance page.

  • Default - your items are ungrouped but sorted from the highest to lowest variance.

  • Family > Category - groups your items by family and then by category

  • Category - groups your items by category

  • Add view - you can create your own preset view and customize it

Columns

Aside from the default columns, there are many more that you can toggle on by clicking the gear icon on the left-hand side of the screen, then "Columns"

Some options include seeing your sales, consumption, and variance in ounces, and beginning and ending inventory counts.

Just hover your cursor over the "i" icon on a column header to see a definition.

You can customize the layout of this page by dragging and dropping columns to where you want them.

Sorting, Grouping & Filtering Information

For more information, please see:

Did this answer your question?