All Collections
Inventory and Stock reports
How to read the ingredients movements report
How to read the ingredients movements report

View ingredients in stock, their supplies, expenses, and average food cost for today, yesterday, or any other date or period in the past

Max avatar
Written by Max
Updated over a week ago

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:

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

  2. Set the reporting period or day at the top right.

  3. Select a Storage location included in the report.

  4. Or select Location to include multiple storage locations linked to a specific location.

  5. Select the product type and category being displayed.

  6. Show Ingredients filter enables you to show or hide products/ingredients with no movement (activity) during the selected period.

    ☝️ Movement is any activity involving products or ingredients in the stock. This includes supplying ingredients to the stock, transferring ingredients between storage locations, and manually or automatically withdrawing ingredients.

  7. Click ⿲ Columns to add or hide some extra columns if necessary.

  8. Click a column name to sort data in ascending or descending order.

💡 Click in the Supply or Expense columns to see a detailed breakdown.

Report legend

  • 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.

💡 Enable All, Inc. without movement in Show ingredients to see the total cost of all ingredients down the page. Enabling this option includes the costs of ingredients that didn't experience any movement to the report.

☝️ 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.

💡 Click Export to download an Excel copy of the report or click Print to print it.

Feel free to contact our customer support if you have any questions or concerns. We're available in chat @joinposter.com and email contact@joinposter.com


Following guides might be helpful too:

Did this answer your question?