The Theoretical Item Cost By GL Code report displays the theoretical-vs-actual usage of inventory items, grouped by GL code. This report can be accessed from the Reports module and the Recipes module under the ‘Reports’ tab. Note that you must be using the Inventory and Recipes modules to utilize this report. 

Report Usage 

This report can be used to identify inefficient use, loss, theft, or over-portioning of your inventory items for an inventory cycle. 

Report Features

  • Filter by location(s) or location group(s).
  • Filter by date. This report can be run for any specified length of time.
  • Use the ‘View’ drop-down field to select whether to show or hide inventory item details.
  • Filter by Inventory Cycle.
  • Select whether or not to display items that only belong to the selected inventory cycle.
  • Select whether to sort by location name or location ID.
  • Select a secondary sorting method. “Item Name” will be selected by default.
  • Select whether or not to display inventory items.
  • Select whether or not to hide items with zero activity.
  • Filter by one or more specific GL Codes.
  • Select whether or not to view all items or only the top 20% of purchased items. “All Items” is selected by default.
  • You can further filter reported results by items with zero usage, items with non-zero usage, items with zero purchases, items with non-zero purchases, items with zero inventory, or items with non-zero inventory.
  • This report can be viewed/exported in various formats. It can also be directly emailed. 

Frequently Asked Questions 

Q: How is the theoretical usage calculated?
A: The theoretical usage is calculated by running the items sold in the POS through your recipes and calculating the dollar amount by the cost of each ingredient. That theoretical amount is then compared to the actual amounts entered via inventory.