Article Contents
Introduction
For select POS integrations, WISK supports Revenue Centers. This means your sales data includes the Revenue Center each menu / POS item was sold in.
This allows you to filter and segment your Sales data on the "Sales" page to view it by Revenue Center. This means you could see the total sales of an item and then see the breakdown of how many were sold in each Revenue Center.
This also gives you the option to map your revenue centers to inventory areas in WISK. This allows you to get:
Real time stock by area
variance by area for each inventory count
Note: Getting real time stock and variance by area is an advanced feature that also requires using transfers within the venue. You will need to make sure that all transfers of items to revenue centers are being tracked. This is the only way to get accurate consumption to compare to your sales. To learn more, see:
Supported POS Systems
The following POS Integrations currently support revenue centers and variance by area:
Easygoband
Jonas Club
Lightspeed (L Series)
Omnivore
Silverware
Squirrel
Toast
View Sales by Revenue Center
On the Sales (Totals) tab of the Sales page, there's an option to view your sales by area / revenue center.
Clicking this option gives a breakdown of where each menu item was sold in the selected range.
In the example below, it shows that 30 Modelo Draft were sold in total during the selected inventory range, across 3 revenue centers.
1Restaurant
2SnackBar
3BackBar
By seeing where an item is sold, this can help when investigating any variances after you have mapped your Revenue Centers.
Mapping Revenue Centers to Inventory Areas
To get the most out of sales by Revenue Centers, you must map them to inventory areas in WISK.
When an item is sold, it knows to deduct the ingredients in the mapped POS Item from the stock in the mapped area.
By doing this you can get:
real time stock by area
variance by area
How to Map Revenue Centers
To map your Revenue Centers to inventory areas:
Go to Inventories > Areas on the side menu bar
On the Areas page, there is a section for Revenue Centers. This shows any Revenue Centers currently linked to an inventory area. Click an inventory area to assign it a Revenue Center
Note: This only appears for POS Systems that support this feature.
In the window that opens, click the "Revenue Centers" drop-down and select one or more Revenue Centers. This list populates with any Revenue Centers detected in your venue's sales data
Note: You can assign multiple Revenue Centers to a single inventory area, however you can't assign a Revenue Center to multiple areas
The Revenue Center(s) are applied to the selected inventory area. Close the window when finished and continue to assign Revenue Centers to more areas
As you assign Revenue Centers to other areas, you'll see fewer options in the drop-down. Once a Revenue Center is assigned to an inventory area you can't assign it to another unless it is removed
When finished, for each inventory area, you'll see the Revenue Centers(s) assigned to it. Revenue Centers should only be assigned to areas where sales occur. For example, the Stock Room is not mapped to anything
Best Practices
If you have already set up your inventory areas and haven't assigned Revenue Centers to them, you may need to make some changes to your areas.
As mentioned in the section above, there are some rules for mapping Revenue Centers:
You can assign more than one revenue center to an area, but
You cannot assign any one revenue center to multiple areas. You can only assign a revenue center to a single area.
For example, lets say you have your "Restaurant Bar" which you have split into three separate areas to make it easier to keep track and split the work.
Restaurant Bar - Well
Restaurant Bar - Fridge
Restaurant Bar - Back Wall
You won't be able to assign the "1Restaurant" Revenue Center to all 3 areas.
If you try to assign that Revenue Center to the other areas, you won't see the option because it's already assigned.
To make this work, you'll need to archive the other two areas and rename the remaining area to represent the entire area. In this example, "Restaurant Bar - Well" will become "Restaurant Bar".
When taking inventory you'll count the entire "Restaurant Bar" in this area. This is the tradeoff of being able to get real time stock and variance by area.
To learn more about archiving areas, see:
Real Time Stock & Variance by Revenue Center
Now that your Revenue Centers are mapped to inventory areas, you're on your way to getting real time stock and variance by Revenue Center.
However, to make full use of this, it requires tracking the movement of every item in your venue.
This is done through transfers. When items move from a stock area to a Revenue Center, you'll need to add a transfer to account for this. This way you'll get accurate consumption per area, which is compared to the sales to determine the variance.
This also makes sure that the real-time stock is the most up to date.
Note: The real-time stock is always an estimate because it is based on POS Item mapping. If more is being poured / used than what is mapped it can't account for that.
To learn more about transfers, see:
Real Time Stock
When a Revenue Center is mapped to an inventory area, any time an item is sold, it subtracts from the stock in the inventory area.
The amount subtracted is based on the mapping of the POS Item.
When you mouse over the real-time stock column, it shows the "real-time" stock in each area. This is based a number of factors:
The count from the last completed inventory
Any invoices, returns, depletions or transfers
Any sales since the last completed inventory
Note: As mentioned before, using transfers is required to get the most accurate stock in each area
If you click the arrow button that appears on mouseover, it shows you each POS Item sold and the quantity since the last inventory.
In this example, the real time stock of Jameson 750ml is 9.29 units, which means 0.71 units have been sold based on mapping since the last inventory count. Sales have occurred in the Back and Restaurant Bars.
Variance
When all Revenue Centers are assigned to inventory areas, you have the option to see your variance by Revenue Center.
Note: As a reminder, for this to be accurate, you need to track all instances of items moving around in your venue. This includes anything coming in via invoices, moving between inventory areas, and returns to suppliers.
In this example we noticed that we have a variance on our Jameson 750ml. According to our mapping, we sold 0.71 units, but we consumed 1.30 units in the venue overall. This resulted in a variance of -0.59 units.
By viewing our variance by area, we can find out if this is coming from a specific Revenue Center.
To view variance by area:
Go to Reports / Analytics > Variance on the side menu bar
Under the inventory / date range selector, click the "filter by area" drop-down and select an inventory area
Note: You can select multiple inventory areas to view at a time. In this example we'll select the "Restaurant Bar"
All data in the table updates to reflect the area that was selected. It shows the beginning and ending inventory counts, along with any sales and the total consumption. With the Sales and COGS it also gives the overall cost percentage for the area.
In this example there is a small variance of 0.08 units on the Jameson, but doesn't fully explain the variance. Lets check other areas.
In the next area (Snack Bar), there is no Jameson because it is not inventoried or sold there
In the last area (Back Bar), we see there is a sizeable variance, which could be due to a miscount or overpouring. Sales were 0.39 units, but 0.90 units were consumed. This area is responsible for the majority of the variance
Transfers & Consumption
As mentioned previously, tracking transfers of product is key to getting an accurate variance by area.
If in the examples above, we moved the following without adding a transfer:
2 bottles of Jameson from the Stock Room to the Restaurant Bar and
2 bottles of Jameson from the Stock Room to the Back Bar
We wouldn't have an accurate consumption value in those areas.
Restaurant Bar Without Transfers
In the example above, it shows the ending inventory increased with no reason to account for it. This is because the 2 units of Jameson moved from the Stock Room to the Restaurant Bar were not accounted for.
As a result it shows a positive variance of 1.92 units - saying we have more product than we should compared to the sales of 0.32 units.
Restaurant Bar With Transfers
With the transfer added, we see the 2 units in the "Invoices (units)" column. This goes towards calculating the consumption, which is actually only 0.40 units. Compared to the sales of 0.32 units, it is a variance of -0.08 units.
Back Bar Without Transfers
Like above, when the transfers aren't added it shows the stock increased in this area, giving it a negative consumption value.
It shows a positive variance of 1.49 units, compared to the sales of 0.39 units.
Back Bar With Transfers
With the transfer added, the consumption value is accurate and that can be compared to the sales to determine there is a real variance in this area of -0.51 units.
