If you’re seeing a larger or smaller inventory value than expected, it's due to either:
Missing Item Costs
If an item doesn’t have a cost assigned, it shows as $0 when viewing your inventory report.
Every time you complete an inventory count, your email summary report details how many items are missing a cost.
You can add missing item costs in both the WISK Web Portal and mobile app. To learn more, please see:
When it comes to data errors, there will either be an issue with the cost, quantity, or both.
If the inventory value of an item is higher or lower than expected, check that you have assigned the cost to the correct measurement.
Most of the time you’ll either enter the cost per unit or the cost per case. If you enter the value in the wrong field, that will misrepresent your inventory value.
If you have never received an invoice for the item, you can adjust the cost by clicking into the cell on the Items page.
In the example below we have an item where the cost per case ($180) was mistakenly entered as the cost per unit. As a result, it’s showing an inflated inventory value of $5,400.
To fix this, click into the “Cost per Case” column and enter the correct value.
All of the other values (Cost per Unit, Inventory Value) update to reflect the new cost.
If you’ve added invoices for the item with the cost error, you’ll need to adjust the cost on the invoice itself.
In this example, the cost per unit of the item ($20) was entered as the cost per case. As a result, our cost per unit is only $1.67 and it’s showing an inventory value of $40. To fix this:
Place your cursor over the item, and click the information icon beside the cost to see the full invoice history
Click the “Edit” button beside the invoice that has the incorrect cost information
Place your cursor over the item and click the Pencil icon in the “Cost” column
Click the “Cost per UM” drop down arrow and select the correct unit of measurement (in this example, units). Click “Save”
The cost and total update to reflect the new amount. Close the invoice by clicking the "X" button.
With the cost per unit updated, the proper cost per case and total inventory value display
If the count for an item is inaccurate, this will give you a higher or lower inventory $ value than expected.
Common causes of miscounts include:
Missed counting stock in an area
Double counted items
Submitted a count as cases instead of units or vice versa
The best time to correct a miscount is when reviewing the totals before submitting the inventory. If taking inventory on the app, when reviewing the final counts for an item, you can tap the item to see a full breakdown of where it was counted and make adjustments if needed.
The second best time is immediately after submitting the inventory because you can still get an accurate count. To edit a submitted inventory count, please see:
To help identify potential miscounts, hover your cursor over the “Stock” column on the Items page of the WISK Web Portal to see a breakdown by area of the most recent inventory count.
In this specific example, it shows 4 units were counted in the Main Bar and nothing in the Stockroom area. To get more information, go to the Consumption page. This compares the most recent inventory count to the previous one.
The Consumption page shows that 30 units were counted in the previous inventory count, but only 4 units were counted in the most recent.
Click the “By Area” toggle to get a breakdown of each count by area for each inventory.
The “By Area” view shows that 24 units were counted in the Stockroom during the previous inventory, but 0 were counted now. While it’s possible the Stockroom could be empty, it’s also possible that this item was missed during the count and should be double checked.
Note: To see a full breakdown of the inventory count, click the information icon beside the number. This opens the inventory in a separate window where you can click the details button to see every submission of full and partial units and cases.
If there is stock in that area when you check it, edit the inventory to reflect the real count: