The stock movement report gives you a dedicated view of stock lost to spoilage, breakage, staff comps and expiry, or stock that’s been voided or refunded from a booking, so you can see what's being wasted, why and how much it's costing your venue.
This is an operations report, not a financial report. It's designed to support day-to-day decisions about your stock. It is not a financial report for accounting or tax reporting.
Premium feature
Stock movement recording and reporting is a Premium Plus+ feature. To unlock this feature with a Premium plan and above, contact your customer success manager or the support team.
What is this report used for?
Use the stock movement report to support operational decisions about your food and beverage stock. For example, you might use it to:
Identify which stock items are wasted most often, and investigate why.
Spot patterns by reason: spoilage, breakage, staff comps, or expiry, to target where to focus.
See which staff members are recording wastage, to support training or accountability conversations.
Track the total cost impact of wastage to your venue.
How to run the report
To access the stock movement report:
From Venue Manager, go to Reports > All reports.
Scroll to the Operations section and select stock movement report.
.png)
Group and filter the report results
The stock movement report is grouped by Reason by default, so you can see wastage, voids and refunds broken down by things like spoilage, breakage, staff comp and expiry at a glance.
Regroup the report: drag and drop column headers to regroup by product name, stock type, staff member or date instead of the default reason grouping.
Date range: use the date selector at the top of the page to choose a day, date or range.
What data can I see?
Column | Description |
|---|---|
Product name | The name of the stock product that was recorded as wasted, voided or refunded. |
Date | Date the action was recorded. |
Qty | The quantity of the item recorded as wasted, voided or refunded. |
Stock type | Whether the product is Food & beverage, Retail, Miscellaneous or Untagged. |
Reported by | The staff member who recorded the entry. |
Total cost | The cost of goods (COGS) value for the quantity wasted, voided or refunded. |
At the top of the report, you'll also see totals for:
Total cost (total cost of wasted, voided or refunded stock).
Total incidents (number of events).
Quantity (total quantity of items wasted, voided or refunded).
Top reason (wastage reason with the highest quantity of wasted, voided or refunded items).
Top item (item with the highest total quantity wasted, voided or refunded).
Make sure the report shows accurate data
For the stock movement report to be useful, stock movement needs to be recorded, and the underlying stock products need to be set up correctly.
Record stock movement at POS or in Venue Manager
The data in this report depends on staff members recording stock movement at POS or in Venue Manager.
See the process of recording wastage by selecting the steps in the interactive demo below. Learn more about recording stock movement in the guide Record and report on stock wastage.
Enter the cost of goods on each stock variation
Without an accurate cost of goods value, the total wastage cost in this report will be misleading.
Each variation of a stock product should have a value in the COGS field.
Learn how to enter COGS for each variation in the guide Cost of Goods report.
Ensure stock products are classified correctly
For items to be reported under the correct stock type, each product needs to be labelled accordingly. Anything without a stock type selected will be classified as Untagged.
You can update the stock type in the Additional options section of the product using the drop down.
Learn how to enter a stock type for each stock product in the guide Create stock products.
Frequently asked questions
Why doesn't my product appear in the stock movement report?
Only items with a recorded wastage, void or refund entry appear in this report. If an item is missing, confirm wastage, void or refund was recorded within the selected date range.
Can I record stock movement for items with zero or unlimited stock on hand?
No. Recording stock movement in POS isn't available for items with zero or unlimited quantity on hand.
Who can record stock movement?
Staff need the Can record wastage in POS permission to record stock movement in POS without a Manager PIN. Manager and administrator system roles have this permission by default. It isn't enabled for the POS operator role by default, but it can be added to a custom role.
Can I regroup the report by something other than reason?
Yes. Drag and drop column headers to regroup by Product, Stock type, Staff member, or Date instead of the default Reason grouping.