Bi4Cloud + Xero : Inventory Sales

xero-logo-0DE623D530-seeklogo.com.gif.pngWhere 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
Was this article helpful?
0 out of 0 found this helpful

Articles in this section

See more
Ask the BI4 Community
Need help using this report or feature?