You need Stock permission to generate the stock on hand report. If you don't have access to this module, ask someone with Managers permission to update your user permissions.
The stock on hand report can be used at any point in time to give you a calculated amount of food, beverage or other stock on hand. In order for this information to be accurate, you need to have your POS Item Links created, a Stocktake completed, and all purchase orders/credit requests marked as received.
To access head to Stock, Reports and then Stock on Hand.
Select which template you'd like to generate the report for (for the example below we have selected 'Beverage') by clicking on the template title.
Select the date you want to run the report for. You can even run it for a date in the past - no more pesky stocktakes a couple of days after you’ve just completed one. Happy operations team and happy accountant!
The report will load for you and pull through calculate to the current day and time. It is organised in the same order as your stocktake templates with the stock items & their count by unit listed on the left-hand side.
How is each value calculated?
Field | Calculation |
Closest Count | The count from the Stocktake that is the closest date to the date you have selected to run the report. It can be either a past or a future date. |
Received | The quantity of stock received between the Closest Count date and the Stock on Hand report date using the Received date for the invoice or purchase order and converted into the counting unit. |
Calculated Usage | The quantity of the stock item used, calculated from POS Item links between the Closest Count and the Stock on Hand report date, converted into the counting unit. |
Quantity on Hand | Closest Count plus Received, less Calculated Usage |
Value on Hand | Quantity on Hand x Latest Price for the Stock Item at the date of the Stock on Hand report |
The Closest Count value uses the closest stocktake to the day you’re running the Stock on Hand report for. You can see the exact details of this by clicking on the value.
The Received column will show all invoices, purchase orders & credit requests that have been received since your most recent stocktake. You can see the detail of this by clicking on the value.
The Calculated Usage column will show all orders & wastage processed through the tills since your most recent stocktake. You can see the exact details of this by clicking on the value.
The Stock on Hand column lists the estimated quantity of stock on hand (by unit) given the information from the prior columns.
The $ Stock on Hand column lists the estimated quantity of stock on hand (by dollar value) given the information from the prior columns & your latest stock price. You can see the exact details of this by clicking on the value.
