How to work with inventory reports on movement of products and ingredients

To control stock deduction, you can view ingredients movement for a selected period. It is shown as a spreadsheet with supplies, expenses and average food cost.

To view ingredients and products movement:

1. Go to Inventory → Ingredients movements in the management console.

2. Set the reporting period in the calendar in the upper right corner.

3. Select a storage location from the drop-down list to view the movement of products in the kitchen, bar, or other storage locations and check the cost in that storage location.

4. Select the type of products, e.g. ingredients, products or manufactured dishes and preparations.
   

5. Choose a category of ingredients, products, dishes or preparations. For example, the type is “Ingredients” and the category is “Seafood”.

6. Click + Filter to view information on specific products in stock.

7. Click on ⿲ Columns in the top right corner to select which columns to hide or show in the report.

8. Click on the name of the column in which you want to sort the data.

9. Check the initial and final average cost of products for the selected period.
   

10. Click on ▼ next to the product unit in the Supplies column to view its supply amount, production and inventory checks.

11. Click on ▼ in the Expense column to view sales, manual waste, production and inventory checks.

12. View the total cost of all products for the selected period at the bottom of the table.
    

💡 Click Export to download an Excel spreadsheet with the information on the movement of products and ingredients in a storage location, or click Print to print a report.

💡 Calculation of products and ingredients food cost is based on supplies and the weighted average cost method.

☝️ Report is displayed for a calendar day, not for a cash shift.

If ingredients are expired or should be written off the stock for a different reason, you can add them to wastes manually.  

Read more:

— What is Manufacture and how-to manufacturing of dishes

— How to add a supply in the Management console

— How the food cost calculates