Where do we get the Cost of Goods in Item Sales ?
1. The Xero Invoice endpoint does NOT provide the Cost of the Item sold .
The Cost of the Item has to derived and it depends on the value of the Item endpoint field IsTrackedInventory.
If IsTrackedInventory is TRUE
Cost of Item = Item.TotalCostPool / Item.QuantityOnHand)
If IsTrackedInventory is FALSE
Cost of Item = Item.PurchaseUnitPrice
2. If the standard Xero inventory is used for sales and inventory then the above assumption provides an accurate cost. If third party Add-ons are used the outcomes are different
- Standard Xero Inventory and Sales
- Invoices contain Items Codes and Tracking Codes
- Item tables is updated so COGS and Stock values are accurate
- So Bi4Cloud CAN be used for Sales Analysis by Item and By Tracking Code and COGS is accurate
- Dear Integration to Xero
- Creates invoices in Xero that have Item Codes
- Invoices contain tracking codes that can be used for Salesman and Region
- Item table is not updated so no Cost or SOH
- So Bi4Cloud CAN be used for Sales Analysis by Item and By Tracking Code but COGS is not accurate
- Unleashed Integration to Xero
- Creates Invoices with no Item Codes
- Item table is not updated so no Cost or SOH
- So Bi4Cloud can be used but has limited Sales Analysis
- Trade Gecko Integration
- Creates Invoices with no Item Codes
- Item table is not updated so no Cost or SOH
- So Bi4Cloud can be used for limited Sales Analysis