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

      AVERAGE PRICE SUMMARY REPORT

      Average Price Summary Report

      The Average Price Summary Report allows you to see the Average Price of your Category Items alongside the current Inventory over a selected Period or Date Range. Refer to the steps below on how to view the Average Price Summary Report.

      Viewing Average Price Summary Report

      1. Click Reports > Reports List from the navigation.

        mceclip2.png

      2. Click Average Price Summary under the Inventory heading.

        mceclip0.png

      3. Filter by Period/Date.

      4. Click Go to view the results.

        mceclip1.png

       

      Some things to keep in mind

      • Each column in the report can be clicked on to reorganize the data. 
        For example, you can click on Inventory Average to see in descending order which Categories have the most valuable items on average.

      • Export the data in this report to Excel by clicking the download button in the upper right.

      • The report will default to pulling data by Period (time between audits). 
        If you do not see the desired results initially, try filtering By Date.

      • Categories with a large discrepancy between the Average Price and the current Inventory Average should see Average Price Details Report under Reports List > Inventory for more information.

      Column Key

      Category: Name of Category

      Received: Total quantity of Category Items received through vendor invoices 

      Amount: Total $ value of Category Items received through vendor invoices 

      Avg Price: The Average Price of a Category Item: Amount / Received 

      Inv Qty: Total quantity of Category Items counted in inventory 

      Inv Amt: Total $ value of Category Items counted in inventory 

      Inv Avg: Inv Amt / Inv Qty