v1

latestOpenAPI 3.0.3Apache 2.02026-08-062991191002.1 KB

BalanceSheetReport

Retrieves a mapped balance sheet

get/balance_sheet_report

Query parameters

asOfstring date-time

YYYY-MM-DD

refreshstring

If refresh is set, data will be fetched from the source application even when cached data is available

Response

BalanceSheetReport resource

asOfstring date

lastReconciledstring date nullable

isReconciledboolean

hasCompleteDataboolean

sourcesstring[]

Example response

{
  "totals": {
    "assets": 342650.6,
    "liabilities": 65386.34,
    "assets_current": 342650.6,
    "liabilities_current": 40386.34,
    "equity": 277264.26,
    "net_income": 277264.26
  },
  "details": [
    {
      "id": "56",
      "name": "Cash on hand",
      "value": 279325.6,
      "mapping": "Assets - Cash"
    },
    {
      "id": "59",
      "name": "Accounts Receivable (A/R)",
      "value": 59325,
      "mapping": "Assets - AR"
    },
    {
      "id": "54",
      "name": "Inventory Asset",
      "value": 4000,
      "mapping": "Assets - Inventory"
    },
    {
      "id": "62",
      "name": "Accounts Payable (A/P)",
      "value": 0,
      "mapping": "Liabilities - AP"
    },
    {
      "id": "57",
      "name": "GST/HST Payable",
      "value": 40386.34,
      "mapping": "Liabilities - Taxes"
    },
    {
      "id": "61",
      "name": "Bank loans",
      "value": 25000
    },
    {
      "id": "55",
      "name": "Opening Balance Equity",
      "value": -5000,
      "mapping": "Equity - Investment"
    },
    {
      "id": "50",
      "name": "Retained Earnings",
      "value": 142324.26,
      "mapping": "Equity - Investment"
    }
  ],
  "asOf": "2021-06-30",
  "lastReconciled": "2021-01-31",
  "hasCompleteData": true,
  "sources": [
    "xero"
  ]
}