Article Contents
Introduction
On the Dashboard page of the WISK Web Portal and mobile app, 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.
WISK Web Portal
Mobile App
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 drop-down shows your last 25 inventory periods, but you can load more by clicking "Load all inventories".
Note: Only completed inventory counts appear. If you are currently taking an inventory count you must submit it before the inventory range appears. You must complete at least 2 inventory counts for data to populate on these tabs.
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:
going to the Variance Page and selecting that specific inventory range or
Selecting a range and clicking the message to recalculate if the info is out of date
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 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.
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.
Inventory, Sales, and Consumption Breakdown
As you scroll down the page, you'll see a breakdown by family of the:
closing inventory value
sales based on POS mapping, and
consumption cost for the inventory period
If you mouse over any of the pie charts, it displays the dollar values for each family.
Historical Sales
This graph compares your total sales of mapped POS Items for each inventory period. Place your mouse over a specific point to see the total for that period.
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.
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 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 ($) - This represents the sales of mapped POS Items for the selected inventory period. If you have unmapped items you will see a difference between the number here and what is on the "Sales" page. This number doesn't include sales of:
unmapped POS Items
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 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 based on POS Item mapping 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.
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 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 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.
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 / counting times.
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
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).
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.
Inventory Value vs Consumption Graph vs Turnover
Below those numbers is a combination bar & line graph comparing the dollar value of each inventory to the consumption cost/COGS of the inventory period.
These values calculate your inventory turnover percent (how much of your inventory was used during the period) which displays on the bar graph.
Inventory Turnover = Consumption Cost / Average Inventory Value
The closer the inventory value and consumption cost lines are, the higher the inventory turnover percent. This is a measure of how efficiently you're 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
Each color represents an item family. Placing your cursor over the centre of the pie charts displays the dollar values for each family.
Place your cursor over the sub-sections to see the value per item 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.
Note: Depending on your number of completed inventories, the graph will automatically show your most recent counts. To see more counts, place your cursor over the graph and scroll your mouse/trackpad to zoom in and out.
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 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.
Purchased Products by Total
This table shows the products purchased during the selected inventory period, sorted from the highest to lowest amount spent.
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
If you place your cursor over a section of the chart, it displays the dollar value.
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.
Sales Tab
The Sales Tab provides a breakdown of your sales based on POS mapping 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).
Note: If you have unmapped POS Items, they are not included in the Sales total.
The following numbers display along the top of the page for the selected inventory period:
Sales - This represents the sales of mapped POS Items for the selected inventory period. If you have unmapped items you will see a difference between the number here and what is on the "Sales" page. This number doesn't include sales of:
unmapped POS Items
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)
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).
You can mouse over any point on the graph to get more information for the specific inventory period.
Sales Breakdown by Family
This table shows the breakdown of your sales by family based on POS mapping. 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.
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.