Inventory Reports
      Back to home
      1. Craftable Learning Center
      2. Reports
      3. Inventory Reports

      CONSUMPTION DETAILS REPORT

      Consumption Details Report

      The Consumption Details Report allows you to see in detail how much of your 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

      1. Click Reports > Reports List from the navigation.
        mceclip0.png
      2. 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 for users who have not yet started mapping their Recipes to their POS buttons.)


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

      4. 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 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 the Director you will not see the Net Sales value, but the UPT column is calculated based on each store's Net Sales. 

      • Days on Hand is also not visible at the Director.

      Column Key

      ID: Item ID (optional)

      Item: Name of Item

      Start: Total quantity of Items counted on the starting audit of selected Period

      Received: Total quantity of Items received via invoices during selected Period

      Transferred: Total quantity of Item transferred in or out during selected Period

      End: Total quantity of Items 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