Inventory Item Details report (New)

Use the Inventory Item Details report to help manage your active inventory in Xero. Keep track of quantities on hand and changes to the value of your tracked inventory.

Your user role determines if you can see this report, and whether you can save and publish it or just view it.

Image showing the Inventory Item Details report

Access and run the Inventory Item Details report

  1. In the Reports menu, select All Reports.
  2. Under Inventory, click ... to expand the section if the report is hidden.
  3. Click Inventory Item Details (New).
  4. Select a date range, then click Update to view your report.

Image of the date range options.

Customize your report

Click Report Settings to customize your report.

Image of the Report Settings link.

Display column options explained

  • Margin

    Calculates the difference between the cost price and sale price as a percentage.

  • Profit per Item

    The difference between the cost price and sale price.

  • QoH Movement

    The quantity of the inventory item that was sold, purchased or adjusted.

  • Source

    Transaction type: Payable Invoice, Receivable Invoice, Spend Money, Receive Money or Inventory Adjustment.

  • Unit Cost

    The cost to purchase each inventory item. Also called the Cost Price and Unit Price.

  • Value Movement

    The change in value of your inventory item.