Skip to main content

Get Inventory Divergence

GET 

/api/ledger/reconciliation/inventory

Inventory sub-ledger reconciliation (Lane 2). SKU is the authoritative subsidiary ledger for inventory, so this returns one row per inventory control account comparing SKU's per-account inventory value against the provider's live GL balance (pulled from the Xero Trial Balance) — most divergent first.

Authorization

Any valid API token can call this endpoint — no specific scope required. Manage tokens.

Authentication: Requires Bearer token. The provider connection must have the accounting.reports.read scope.

Row fields: gl_code, gl_account_name, gl_account_id, sku_value (null when SKU cannot value the account, e.g. Amazon FBA accounts valued via a separate subsystem), sku_quantity, provider_balance, divergence (provider_balance − sku_value; null when sku_value is null), status (divergent | matched | sku_unavailable).

The warehouse→GL mapping is SKU's own warehouses.nominal_code_id. A non-zero divergence is the basis for a suggested adjusting journal on the provider side.

Request

Responses

OK

Response Headers
    Content-Type