What is the Ingredients Movements report?
Ingredients movements report shows the lifecycle of your products, ingredients, preparations, or dishes kept in stock. How and when did they appear in stock? How and when were they withdrawn? What was their cost during the reporting period?
To view the ingredients movements report:
Go to Inventory → Ingredients movements in the management console.
Set the reporting period or day at the top right.
Select a Storage location included in the report.
Or select Location to include multiple storage locations linked to a specific location.
Select the product type and category being displayed.
Show Ingredients filter enables you to show or hide products/ingredients with no movement (activity) during the selected period.
Click ⿲ Columns to add or hide some extra columns if necessary.
Click a column name to sort data in ascending or descending order.
Name - product or ingredient name
Type - entity type, ingredient, preparation, product, or dish.
Initial balance - the amount of ingredients at the start of the reporting period
Initial avg. cost - ingredient cost per kg, l, or pcs at the start of the reporting period
Initial cost - total cost of the ingredients at the start of the reporting period.
Supplies - the amount of ingredients added to the stock during the reporting period.
Expense - the amount of ingredients withdrawn from the stock during the reporting period.
Final balance - the amount of ingredients at the end of the reporting period.
Final avg. cost - ingredient cost per kg, l, or pcs at the end of the reporting period
Tot. cost - total cost of the ingredients at the end of the reporting period.
Remember that the report presents information based on calendar days, rather than cash shifts.
☝️ Food cost is calculated by the weighted average method. It includes the total price of the ingredient and the total amount of the ingredient in stock.
Following guides might be helpful too: