Article Contents
Introduction
If your POS is integrated with WISK and your recipes are mapped, your movements and sales data is used to calculate an estimate of the Real Time Stock for each item.
You can view your current Real Time Stock on the Items page and the Historical Item Stock Report.
Note: To learn more about Real Time Stock, see:
The Historical Item Stock Report also records your Real Time Stock (Estimated Stock) at the end of each day.
When you select a day, it shows the last completed inventory count for each item and anything that adds or removes inventory since that count. This calculates the Estimated Stock as of the end of the selected day (11:59PM in the venue's selected timezone)
Important: This number is an estimate based on anything added or removed from the venue. Make sure you add all invoices and anything moving out of the venue and that they are dated correctly. Your POS Items also need to be mapped correctly since they're used to calculate the amount removed via "Sales". For information about how to handle missing or incorrect data, see "Making Changes / Updates to Data" below.
Viewing the Report
To view the Historical Item Stock report click Reports / Analytics > Historical Item Stock on the side menu bar.
By default, it shows today's date and all actions affecting item stock since the last inventory count. This gives you each item's current Estimated Stock.
For each item it shows:
Title - the name of the item
Last Inventory Stock Count - The count from the last completed inventory before the selected date
Invoices - Any stock that has come into the venue. This includes invoices and also transfers in from partner venues.
Sales - The amount sold since the last completed inventory. This is based on what's mapped to your POS Items and only using exactly the mapped quantity.
Transfer to Partner Venue - Any stock transferred out of the venue to a partner venue
Returns - Any stock returned to suppliers / distributors
Estimated Stock - The estimated stock based on all movements in and out of the venue since the last inventory count
External ID (if used) - The ID code of the item if used in another system
The full formula for Estimated Stock is:
Last Inventory Stock Count + Invoices - Sales - Transfer to Partner Venue - Returns - Depletions* = Estimated Stock
Note*: At this time Depletions do not appear as a column on this page, but they are used in the calculation for Estimated Stock. If you add the Invoices value to the Last Inventory Stock Count and subtract everything else and notice a difference between that number and the Estimated Stock, check if you have added any depletions. This column will be added in a future update.
Estimated Stock Example
By following the columns from left to right you can see the count from the last inventory, any stock that has come in, and all reasons stock has been deducted.
For example for Tanqueray Dry Gin 750ml:
15.37 units were counted in the last inventory before April 10th
5 units were received from invoices (15.37 +5 = 20.37)
3.55 units were deducted based on Sales data (20.37 - 3.55 = 16.82)
There were no returns, transfer outs, or depletions (16.82)
The Estimated Stock based on activity since the last inventory is 16.83 units (there is some small variation due to rounding the display to 2 decimal places).
Changing the Date
While the report shows the current Estimated Stock by default, you can use it to see the Estimated Stock at the end of past days.
When you change the date, it shows everything that happened in the venue after the last inventory count and before 11:59PM in the venue's timezone that day.
To change the date:
Click "Date" on the top right corner
Click a date and click "OK"
The page displays the Estimated Stock for each item at the end of the selected date (11:59PM). Depending on the date you select, the "Last Inventory Stock Count" could change since it may be before your most recent inventory count
Quick Sorting
To quickly sort items on this page, click the column headers. For example, if you want to view your items from the lowest to highest Estimated Stock you can sort by ascending:
Making Changes / Updates to Data
When viewing the report, if you notice any information is incorrect or missing you can add or edit the related movement or fix any sales issues. Examples include but are not limited to:
Data entry errors
Missing or duplicate movements (invoices, depletions, transfers etc)
Movements not dated correctly - the date and time should reflect the moment the stock was impacted
Wrong quantities (either in movements, received 1 unit instead of 1 case or inventory miscounts)
Sales data and mapping errors
Missing sales data
Unmapped POS Items
Incorrect POS Item mapping
When you make changes, the Estimated Stock is updated for each impacted day.
Note: If your changes affect a long period, the last 7 days are prioritized by the system. Those values are recalculated almost immediately, and anything past that will be run in the background. It may take some time for those updates to appear. This mostly applies to any changes in POS Item Mapping since it impacts all sales data in unlocked inventory periods.
Missing Invoice Example
Let's say when viewing the Historical Item Stock report, we notice we forgot to add an invoice for Modelo. Based on the previous count and sales it shows the current Estimated Stock as 75 units.
By adding the invoice and setting the correct date it'll update the Estimated Stock for all impacted days.
We know that we received 1 case on April 7th but the invoice hasn't been added yet. When we go back and add the invoice it recalculates the Estimated Stock for each day from April 7th forward.
When viewing the current date after adding the invoice we see the updated Estimated Stock. It nows says 99 units to reflect the 24 units added via invoices.
If we change the date to Apr 6th, we can see this is before the invoice was added.
When we switch over to Apr 7th, the invoice has been added and the Estimated Stock has updated for this day and each day after that.
