Back to Tables
Items Table
Inventory and service items from Xero. View item codes, prices, descriptions, and stock levels.
Use it to get a full price list, a stock-on-hand report or a margin check out of Xero and into a sheet you can sort and filter, without exporting a CSV every time.
How to insert the Items table
- Open the XO Report task pane and click Tables and Reports.
- Choose Items.
- Pick the organisation (this step is skipped when only one is connected).
- Click Insert Table. The full list lands on a new sheet named “Items”. When prices or stock change in Xero, refresh it from the task pane. No need to insert again.
What you can build with it
- Price list: keep Code, Name and SalesPrice, filter IsSold to TRUE, and you have a customer-ready price list that refreshes from Xero.
- Stock valuation: filter IsTrackedAsInventory to TRUE; QuantityOnHand and TotalCostPool give you units and value on hand per item.
- Margin check: add a column for SalesPrice minus PurchasePrice (or the % equivalent) to spot items sold below cost or with thin margins.
Items table or XO.LITEM?
The table gives you the whole list on one sheet. If you only need one detail of one item in a single cell (say the price of “WIDGET-001” next to a quantity), use the XO.LITEM formula instead.
Output Columns
| Column | Description |
|---|---|
| Code | Item code (SKU) |
| Name | Item name |
| Description | Sales description |
| PurchaseDescription | Purchase description |
| PurchasePrice | Cost price |
| SalesPrice | Selling price |
| IsSold | Whether item is sold |
| IsPurchased | Whether item is purchased |
| IsTrackedAsInventory | Whether inventory tracked |
| QuantityOnHand | Current stock quantity |
| TotalCostPool | Total inventory value |
| ItemID | Xero unique identifier |
Plus OrgID, OrgName, and Timestamp columns.
API Limitation
No archived/deleted filter is available for Items, because the Xero API does not support item status filtering. All items (active and inactive) are always returned.
Tips
- Filter by IsTrackedAsInventory to see stock items
- Use QuantityOnHand for reorder point analysis
- Compare SalesPrice vs PurchasePrice for margin analysis