Skip to main content
Summary Dashboards

These dashboards provide high level information about the main pillars of WISK inventory, invoices, sales and variance

Nick Neale avatar
Written by Nick Neale
Updated this week

Article Contents

Introduction

On the Dashboard page of the WISK Web Portal, these five tabs provide a high level summary of your venue's data:

These tabs show your venue's performance over time, comparing your data from each inventory period.

When looking at your data, the most recent inventory period is selected by default, but you can click the drop-down to select any other period.

The "Inventory Range" dropdown shows all available inventory periods

Note: Only completed inventory counts appear. If you are currently taking an inventory count you must submit it before the inventory range appears.

Data Refresh Frequency

When looking at these tabs, it's important to know how the data refreshes and when.

When looking at your most recent inventory period (your last two completed inventory counts), any changes to your data are reflected immediately in the dashboard.

If you make a change that can apply to multiple inventory periods, for example editing a POS Item, or changing an item category, there will be a batch update at the end of the day.

However, you can force a recalculation for an inventory period by either:

  1. going to the Variance Page and selecting that specific inventory range or

  2. Selecting a range and clicking the message to recalculate if the info is out of date

The message to recalculate data


Note: Changes only apply to unlocked inventory periods.

Overview Tab

The Overview tab provides insights into your performance for the selected inventory period, and compares it to the past to spot any trends.

The "Overview" tab that shows your venues' performance for the selected inventory period

The following numbers display along the top of the page for the selected inventory period:

  • Variance Cost - The sum of the Variance Cost for each item. Variance Cost = Cost per Unit * Variance. A negative Variance Cost indicates a loss. A positive Variance Cost indicates you used less than you sold

  • Variance Retail / Revenue Potential - The theoretical value that the Variance Cost could've sold for based on your POS Item recipes. For more info see "What is Variance Retail?"

  • Inventory Value - The dollar value of the closing inventory count for the selected period

  • Target Cost % - Based on your POS Item mapping, there is a theoretical cost for each item assuming there is no wastage. Target Cost % = Target Consumption / Sales. This assumes you are using exactly what is mapped to your POS Items.

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

  • Performance - This is how your Actual Cost % compares to the Target Cost %. This value is calculated by taking the lower value of the two and dividing it by higher one. In most cases, Target Cost % will be the lower of the two due to waste/spillage, etc. The closer to 100%, the smaller your variance.

Performance Graph

Below those numbers you'll see a line graph that compares your Performance % between inventory periods.

The goal is to get to as close as 100% as possible. The closer to 100%, the smaller your variance. This means you're consuming what you're supposed to based on your POS Item mapping.

You can mouse over any point on the graph to get more information for the specific inventory period.

The Performance line graph shows the performance % for each inventory period

Actual vs Target Cost Graph

This graph shows how your performance rating is calculated. The measure for success in this graph is having your actual and target cost % as close together as possible.

The closer they are, the smaller your variance for the period.

You can mouse over any point on the graph to see the actual/target cost % breakdown for the selected inventory period.

Your target cost fluctuates as your item costs go up and down.

The chart comparing the Actual and Target costs

Inventory, Sales, and Consumption Breakdown

As you scroll down the page, you'll see a breakdown by family of the:

  • closing inventory value

  • sales, and

  • consumption cost for the inventory period

The pie charts for inventory value, sales and consumption for the selected inventory period

If you mouse over any of the pie charts, it displays the dollar values for each family.

The "Liquor" value has been moused over in the Inventory value pie chart

Historical Sales

This graph compares your total sales for each inventory period. Place your mouse over a specific point to see the total for that period.

The Historical Sales sales graph that compares sales totals between inventory periods


For more detailed sales information, please see the Sales Tab.

Historical Purchases

This graph compares your total purchases for each inventory period. This value is calculated based on the invoices you've added. Place your mouse over a specific point to see the total for that period.

The Historical Purchases graph which shows the total amount spent on invoices for the period

For more detailed purchases information, please see the Purchases Tab.

Variance Tab

The Variance Tab provides an in-depth look at how your variance cost is calculated. With this data you can see where your problem points are, including which items are most responsible for your losses.

The top section of the Variance tab that provides an overview

The following numbers display along the top of the page for the selected inventory period:

  • Variance Cost - The sum of the Variance Cost for each item. Variance Cost = Cost per Unit * Variance. A negative Variance Cost indicates a loss. A positive Variance Cost indicates you used less than you sold

  • Sold ($) - 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 Cost ($) - 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).

  • Variance Retail / Revenue Potential - The theoretical value that the Variance Cost could've sold for based on your POS Item recipes. For more info see "What is Variance Retail?"

Variance by Family

This table shows a breakdown for each item family

This table shows the breakdown of the variance by family. For each family it displays the following information:

  • Family - The name of the item family

  • Sold ($) - The total sales for the item family

  • Target Consumption Cost ($) - The dollar value of what should have been consumed based on POS Item mapping.

  • Consumption Cost ($) - The dollar value at cost of what was actually consumed (based on inventories and invoices received)

  • Variance Cost ($) - Equals Target Consumption Cost - Consumption Cost. If this value is negative it indicates a loss. You used more than you were supposed to based on recipe mapping

  • Variance Retail - An estimate of what the Variance Cost value would’ve sold for (based on POS Items)

  • Actual Cost (%) - Your overall cost percentage for the family. Actual Cost (%) = Consumption Cost ($) / Sold ($)

  • Target Cost (%) - Your target cost percentage for the family. Target Consumption Cost ($) / Sold ($). This is if you use exactly what is mapped to your POS Items

You can use this table to spot the families that have the largest variances. The larger the difference between the Actual and Target costs, the larger the variance.

Variance by Category

After seeing your Variance by Family, the Variance by Category table drills down to see which categories are responsible for the variance.

This table has all the same columns as Variance by Family, but is now in the context of specific categories.

This shows the breakdown for each category

By comparing the Actual Cost to the Target Cost, you can measure your venue's overall performance.

Top 10 by Losses

This section shows your top 10 items with the largest losses. These are items where you consumed more than you sold.

Note: This can display fewer items if you have less than 10 with losses.

The items display by Variance Cost ($) in descending order. Click the "Detailed Variance Report" button to go to the Variance page to see more information about the items.

The bar graph visualizes the losses, and the table on the right shows the full values

The table displays the following values:

  • Item - the name of the item

  • Variance (%) - How much of the total consumption of the item is due to variance. Variance % = Variance / Consumption

  • Variance (units) - Equal to Sold (units) - Consumed (units). The difference between what was sold and what was actually consumed

  • Variance Cost ($) - the dollar value of the loss at cost

  • Variance Retail ($) - An estimate of what the Variance Cost value would’ve sold for (based on POS Items)

Top 10 by Under Usage

This section shows your top 10 items by under usage. These are items where you sold more than you actually consumed, or have a negative consumption value (you gained stock without a reason to account for it).

Note: This can display fewer items if you have less than 10 items with sales greater than consumption.

The items display by Variance Cost ($) in descending order. Click the "Detailed Variance Report" button to go to the Variance page to see more information about the items.

The Top 10 by Under Usage table. Shows items with negative consumption or sales greater than consumption

The table displays the following values:

  • Item - the name of the item

  • 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 actually used during the inventory period.

  • Variance (%) - How much of the total consumption of the item is due to variance. Variance (%) = Variance / Consumption

  • Variance (units) - Equal to Sold (units) - Consumed (units). The difference between what was sold and what was actually consumed

  • Variance Cost ($) - the dollar value of the overage at cost

  • Variance Retail ($) - An estimate of what the Variance Cost value would’ve sold for (based on POS Items)

Variance Trend

This table shows the difference between your Target Cost and Actual Cost for each family by inventory period. Your most recent inventory period is at the top of the table.

The difference = Target Cost % - Actual Cost %.

  • A negative value indicates that your Actual Cost was over the Target Cost.

  • A positive value indicates your Actual Cost was below the Target Cost.

A value is highlighted in red if it is greater than + or - 3%.

Ideally, you want your values to be as close to 0% as possible. You can use this table to see how your performance has improved or worsened over time.

An example of the variance trend table

In this example we can see that both Beer and Liquor have mostly been improving week to week, but Wine is still experiencing some larger swings.

Inventory Tab

The Inventory tab compares the beginning and ending counts in the selected inventory period, and provides a breakdown of the consumption (COGS). It also shows the progression of your inventory durations.

An overview of the Inventory Tab

The following numbers display along the top of the page for the selected inventory period:

  • Beginning Inventory Value - The dollar value of the starting inventory count for the selected period

  • Ending Inventory Value - The dollar value of the closing inventory count for the selected period

  • Percent Change - The % change in inventory value between the beginning and ending inventory counts. It also displays the change in $ amount. If the number is positive, the inventory value increased, if the number is negative, the inventory value decreased.

  • Consumption Cost - 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).

Inventory Value vs Consumption Graph

Below those numbers is a line graph that compares the dollar value of each inventory to the consumption cost/COGS of the inventory period.

The inventory value vs consumption cost line graph

The purpose of this is to see your inventory turnover. The closer the inventory value and consumption cost lines are, the more efficiently you are using your stock.

In other words, the product you have in your inventory is being sold and not taking up space / tying up cash flow.

If you have a large gap between your inventory and consumption, you may have overstock or deadstock and should adjust your purchases from your suppliers. You may have also missed adding some invoices for the period.

You can mouse over any point on the graph to get more information for the specific inventory period.

To learn more about overstock and deadstock, see:

Inventory and Consumption Breakdown

As you scroll down the page, you'll see a breakdown by family of the:

  • closing inventory value

  • consumption cost for the inventory period

The pie charts for inventory value and consumption for the selected inventory period

If you mouse over either of the pie charts, it displays the dollar values for each family.

The "Liquor" value has been moused over in the Inventory value pie chart

In the Consumption pie chart you can mouse over the sub-sections to see the value per item category.

The smaller section has been moused over and shows the breakdown of consumption by category

Inventory Duration

This graph shows the in-app time of each completed inventory count.

When a user is taking inventory on an iOS device, the in-app timer increases. If the user is idle or remains on the same screen for too long, the timer stops counting.

This tracks how much time was actively spent taking the inventory.

The Inventory duration in minutes graph

To learn more about in-app time, please see:

Ideally, your first inventory will take the longest and it should decrease over time as you become more familiar with using WISK. There will be some variation if your inventory size increases, or you have new staff.

Purchases Tab

The Purchases tab provides a breakdown of your purchases for the select inventory period, and compares your spending to previous inventory periods.

The Purchases tab which shows a breakdown of invoices for the selected period

The following numbers display along the top of the page for the selected inventory period:

  • Current Period Purchases - The $ value of invoices added during the selected inventory period

  • Previous Period Purchases - The $ value of invoices added during the previous inventory period

Historical Purchases

Below those numbers you'll see a line graph that compares your purchases between inventory periods. This is the total value of all invoices added during the inventory period.

You can mouse over any point on the graph to get more information for the specific inventory period.

The Historical Purchases graph shows your purchases/invoices added for each inventory period

Purchased Products by Total

This table shows the products purchased during the selected inventory period, sorted from the highest to lowest amount spent.

Shows all products purchased during the period from high to low.

Purchases by Family & Distributor

As you scroll down the page, you'll see a breakdown of your purchases during the selected inventory period by:

  • item family

  • distributor

Shows the percentage breakdown of purchases by family and distributor

If you place your cursor over a section of the chart, it displays the dollar value.

The "Liquor" value has been moused over in the purchases pie chart

In the example above, $2,269.97 was spent on Liquor, which accounts for 53.13% of the total ($4,272.17).

Cost Changes

This table shows any cost changes during the selected inventory period, and shows the specific invoice the change occurred in.

The cost changes table

Sales Tab

The Sales Tab provides a breakdown of your sales for the selected inventory period. It compares your sales to consumption over time, shows the sales per item family, and highlights your top sellers (by total sales and by profit).

The Sales Tab - shows performance of sales to consumption over time

The following numbers display along the top of the page for the selected inventory period:

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

  • Consumption Cost - 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)

  • Profit - Sales minus Consumption for the selected inventory period.

Sales vs Consumption Cost

Below those numbers you'll see a line graph that compares your sales and consumption for each inventory period.

These values are used to calculate your Actual Cost % (Consumption / Sales).

The line graph that compares sales to consumption

You can mouse over any point on the graph to get more information for the specific inventory period.

Sales Breakdown by Family

Shows a breakdown of sales by item family

This table shows the breakdown of your sales by family. This is categorized based on the family of the items mapped to your POS Items.

For each family it displays the following information:

  • Family - The name of the item family

  • Sales - The total sales for the item family during the period

  • Sales (%) - The percentage of the overall sales assigned to the family

  • Target Consumption Cost ($) - The dollar value of what should have been consumed based on POS Item mapping.

  • Consumption Cost ($) - The dollar value at cost of what was actually consumed (based on inventories and invoices received)

  • Profit - Overall profit for the item family. Profit = Sales - Consumption Cost ($)

  • Actual Cost (%) - Your overall cost percentage for the family. Actual Cost (%) = Consumption Cost ($) / Sold ($)

  • Target Cost (%) - Your target cost percentage for the family. Target Consumption Cost ($) / Sold ($). This is if you use exactly what is mapped to your POS Items

Overall - Top Sales

This table displays your top selling items based on your POS Item Mapping. Sales are assigned to an item based on the percentage of the overall cost it makes up.

This table shows your top selling items based on POS Item mapping

For each item it displays the following information:

  • Item - The name of the item

  • Sales - The total sales for the item during the period

  • Sales (%) - The percentage of the overall sales assigned to the item

  • Target Consumption Cost ($) - The dollar value of what should have been consumed based on POS Item mapping.

  • Consumption Cost ($) - The dollar value at cost of what was actually consumed (based on inventories and invoices received)

  • Profit - Overall profit for the item. Profit = Sales - Consumption Cost ($)

  • Actual Cost (%) - Your overall cost percentage for the item. Actual Cost (%) = Consumption Cost ($) / Sold ($)

  • Target Cost (%) - Your target cost percentage for the family. Target Consumption Cost ($) / Sold ($). This is if you use exactly what is mapped to your POS Items

Overall - Top Profits

This table displays your items sorted by profit. It has the same columns as the Top Sales table.

Shows the same as the Top Sales table but is sorted by profit.

Did this answer your question?