Inventory Item Transactions report

Use the Inventory Item Transactions report to list the transactions you've entered into Xero for an untracked inventory item. Invoices, bills and credit notes which have the status of draft or awaiting approval, as well as inventory items you've used in purchase orders, are not included in this report. Access this report from the older Inventory Items Summary.

Your user role determines what you can see and do with this report. If you're viewing a report produced by someone with the Adviser user role, you may see notes or a summary on the report.

Image showing main screen of Inventory Item Transactions.

Choose the data to show in the report then generate it

Choose or update the report options then generate the report. Use the:

  • Item field to choose from your list of inventory items. Only those items that have ever been used on a transaction will display. The default is the item you drilled down from the Inventory Items Summary.
  • From and To fields to choose the timeframe of the report. The default dates are the same as the report you've drilled down from.

Then use the Update button to generate your report. Use the Update button each time you change the date or other report options.

Fields

If you're using multi-currency and want to see inventory transactions in their original currency, clear the Show in [base currency] checkbox.

View transactions that make up sales and purchases of the untracked inventory item

View invoices

All approved invoices, bills, credit notes, spend money and receive money transactions that use the inventory item you've chosen will display.

Select individual transactions

Click on the date of the invoice, bill, credit note, spend money or receive money transaction to drill down to the see the transaction.

Image showing the corresponding invoice.

Image showing how you can select an inventory item date to look at the invoice.