Consumption Details Report
The Consumption Details Report allows you to see in detail how much of your individual Items were consumed within a selected Period or Multi-Period. A negative consumption may indicate that vendor invoices are not being approved, thus understating the amounts Received.
Keep in mind that this report is not taking into account depletions, which come from matching your recipes to your POS buttons, but rather is just raw consumption - how much you started with, plus how much you added to your inventory, minus how much you still have. In a perfect world your consumption should match exactly with your depletions. But as we live in an imperfect world you can compare these two things (consumption vs depletions) on the Variance Details Report, as well as the variety of Actual vs Theoretical reports within Craftable. (If you aren't sure where to start, we recommend using the Actual vs Theoretical Quantity Details report.)
Refer to the steps below on how to view the Consumption Details Report.
Viewing Consumption Details Report
- Click Reports > Reports List from the navigation.
- Click the Inventory tab, and you'll find the Consumption Details report under the first section, titled Usage. (It also lives on the Popular Reports tab in the Post-Audit Checks section, and is recommended users who have not yet started mapping their Recipes to their POS buttons.)
- Filter by Period/Multi-Period. - Because this report calculates consumption based on two audit counts - your Start and End columns - you are restricted to running this report purely between audit dates.
- Click Go to view the results.
How to Use This Report
- Focus on extreme usage by clicking on the Consumed column header to sort.
- For any Items with a negative Consumed value, the Inventory quantity has somehow increased.
- Check for any Invoices that you may have not processed, or review the starting and ending Audit counts.
- Investigate any very large consumptions to confirm accuracy.
Some things to keep in mind
- The header of each column in the report can be clicked on in order to sort the data Highest > Lowest or Lowest > Highest.
- Export the data in this report to Excel by clicking the download button in the upper right.
- If you are running this report at Director you will not see the Net Sales value, but the UPT column is calculated based on each store's individual Net Sales.
- Days on Hand is also not visible at Director
Column Key
ID: Item ID (optional)
Item: Name of Item
Start: Total quantity of Item counted on the starting audit of selected Period
Received: Total quantity of Item received via invoices during selected Period
Transferred: Total quantity of Item transferred in or out during selected Period
End: Total quantity of Item counted on the ending audit of the selected Period
Consumed: Start + Received + Transferred - End
Days on Hand: How many days of the item you have In Stock in your ending count, based on the rate of consumption during this period. (Calculated as End value / (Consumed / # of Days in Period).)
CU Price: The CU Price of the item on the ending audit.
Amount: Total $ value of Item consumed during selected Period
UPT: Units Per Thousand, calculated as (Consumed / Net Sales) * 1000
Related article(s)