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.
Access and run the Inventory Item Details report
- In the Reports menu, select All Reports.
- Under Inventory, click ... to expand the section if the report is hidden.
- Click Inventory Item Details (New).
- Select a date range, then click Update to view your report.
Customise your report
Click Report Settings to customise your report.
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.