Xero · Example Payload
Xero Getreportbalancesheet Example
AccountingBank FeedsFinanceFinancial ServicesInvoicingPayrollSmall Business
Xero Getreportbalancesheet Example is an example object payload from Xero, with 6 top-level fields. It illustrates the shape of data this provider's APIs accept or return.
Top-level fields
operationIdmethodpathsummaryrequestExamplesresponseExamples
Example Payload
{
"operationId": "getReportBalanceSheet",
"method": "GET",
"path": "/Reports/BalanceSheet",
"summary": "Xero Retrieves report for balancesheet",
"requestExamples": [],
"responseExamples": [
{
"status": "200",
"contentType": "application/json",
"example": {
"Id": "2ddba304-6ed3-4da4-b185-3b6289699653",
"Status": "OK",
"ProviderName": "Provider Name Example",
"DateTimeUTC": "/Date(1555099412778)/",
"Reports": [
{
"ReportName": "Balance Sheet",
"ReportType": "BalanceSheet",
"ReportTitles": [
"Balance Sheet",
"Dev Evangelist - Sid Test 3 (NZ-2016-02)",
"As at 30 April 2019"
],
"ReportDate": "12 April 2019",
"UpdatedDateUTC": "/Date(1555099412778)/",
"Fields": [],
"Rows": [
{
"RowType": "Header",
"Cells": [
{
"Value": ""
},
{
"Value": "30 Apr 2019"
},
{
"Value": "31 Mar 2019"
},
{
"Value": "28 Feb 2019"
}
]
},
{
"RowType": "Section",
"Title": "Assets",
"Rows": []
},
{
"RowType": "Section",
"Title": "Bank",
"Rows": [
{
"RowType": "Row",
"Cells": [
{
"Value": "Country Savings",
"Attributes": [
{
"Value": "041207d2-3d61-4e5d-8c1a-b9236955a71c",
"Id": "account"
}
]
},
{
"Value": "-1850.00",
"Attributes": [
{
"Value": "041207d2-3d61-4e5d-8c1a-b9236955a71c",
"Id": "account"
}
]
},
{
"Value": "-1850.00",
"Attributes": [
{
"Value": "041207d2-3d61-4e5d-8c1a-b9236955a71c",
"Id": "account"
}
]
},
{
"Value": "0.00",
"Attributes": [
{
"Value": "041207d2-3d61-4e5d-8c1a-b9236955a71c",
"Id": "account"
}
]
}
]
},
{
"RowType": "Row",
"Cells": [
{
"Value": "My Big Bank",
"Attributes": [
{
"Value": "300f3bde-3a5c-4035-9ec5-45b09777679a",
"Id": "account"
}
]
},
{
"Value": "2146.37",
"Attributes": [
{
"Value": "300f3bde-3a5c-4035-9ec5-45b09777679a",
"Id": "account"
}
]
},
{
"Value": "2020.00",
"Attributes": [
{
"Value": "300f3bde-3a5c-4035-9ec5-45b09777679a",
"Id": "account"
}
]
},
{
"Value": "0.00",
"Attributes": [
{
"Value": "300f3bde-3a5c-4035-9ec5-45b09777679a",
"Id": "account"
}
]
}
]
},
{
"RowType": "SummaryRow",
"Cells": [
{
"Value": "Total Bank"
},
{
"Value": "296.37"
},
{
"Value": "170.00"
},
{
"Value": "0.00"
}
]
}
]
},
{
"RowType": "Section",
"Title": "Current Assets",
"Rows": [
{
"RowType": "Row",
"Cells": [
{
"Value": "Accounts Receivable",
"Attributes": [
{
"Value": "b94495d0-44ab-4199-a1d0-427a4877e100",
"Id": "account"
}
]
},
{
"Value": "154355.72",
"Attributes": [
{
"Value": "b94495d0-44ab-4199-a1d0-427a4877e100",
"Id": "account"
}
]
},
{
"Value": "154351.78",
"Attributes": [
{
"Value": "b94495d0-44ab-4199-a1d0-427a4877e100",
"Id": "account"
}
]
},
{
"Value": "356.50",
"Attributes": [
{
"Value": "b94495d0-44ab-4199-a1d0-427a4877e100",
"Id": "account"
}
]
}
]
},
{
"RowType": "Row",
"Cells": [
{
"Value": "Inventory",
"Attributes": [
{
"Value": "53a12a15-7e9b-4a31-85f4-a7cee6d04215",
"Id": "account"
}
]
},
{
"Value": "25000.00",
"Attributes": [
{
"Value": "53a12a15-7e9b-4a31-85f4-a7cee6d04215",
"Id": "account"
}
]
},
{
"Value": "25000.00",
"Attributes": [
{
"Value": "53a12a15-7e9b-4a31-85f4-a7cee6d04215",
"Id": "account"
}
]
},
{
"Value": "0.00",
"Attributes": [
{
"Value": "53a12a15-7e9b-4a31-85f4-a7cee6d04215",
"Id": "account"
}
]
}
]
},
{
"RowType": "SummaryRow",
"Cells": [
{
"Value": "Total Current Assets"
},
{
"Value": "179355.72"
},
{
"Value": "179351.78"
},
{
"Value": "356.50"
}
]
}
]
},
{
"RowType": "Section",
"Title": "Fixed Assets",
"Rows": [
{
"RowType": "Row",
"Cells": [
{
"Value": "Office Equipment",
"Attributes": [
{
"Value": "7132cab3-ce56-4389-8e47-8f60d4c137f8",
"Id": "account"
}
]
},
{
"Value": "-119.00",
"Attributes": [
{
"Value": "7132cab3-ce56-4389-8e47-8f60d4c137f8",
"Id": "account"
}
]
},
{
"Value": "-119.00",
"Attributes": [
{
"Value": "7132cab3-ce56-4389-8e47-8f60d4c137f8",
"Id": "account"
}
]
},
{
"Value": "0.00",
"Attributes": [
{
"Value": "7132cab3-ce56-4389-8e47-8f60d4c137f8",
"Id": "account"
}
]
}
]
},
{
"RowType": "SummaryRow",
"Cells": [
{
"Value": "Total Fixed Assets"
},
{
"Value": "-119.00"
},
{
"Value": "-119.00"
},
{
"Value": "0.00"
}
]
}
]
},
{
"RowType": "Section",
"Title": "",
"Rows": [
{
"RowType": "SummaryRow",
"Cells": [
{
"Value": "Total Assets"
},
{
"Value": "179533.09"
},
{
"Value": "179402.78"
},
{
"Value": "356.50"
}
]
}
]
},
{
"RowType": "Section",
"Title": "Liabilities",
"Rows": []
},
{
"RowType": "Section",
"Title": "Current Liabilities",
"Rows": [
{
"RowType": "Row",
"Cells": [
{
"Value": "Accounts Payable",
"Attributes": [
{
"Value": "a2a4795b-a01f-40eb-afa6-a34b4514875d",
"Id": "account"
}
]
},
{
"Value": "-3469.00",
"Attributes": [
{
"Value": "a2a4795b-a01f-40eb-afa6-a34b4514875d",
"Id": "account"
}
]
},
{
"Value": "-3469.00",
"Attributes": [
{
"Value": "a2a4795b-a01f-40eb-afa6-a34b4514875d",
"Id": "account"
}
]
},
{
"Value": "-184.00",
"Attributes": [
{
"Value": "a2a4795b-a01f-40eb-afa6-a34b4514875d",
"Id": "account"
}
]
}
]
},
{
"RowType": "Row",
"Cells": [
{
"Value": "GST",
"Attributes": [
{
"Value": "17d9a4a0-3181-4803-a96b-f0dbe589091b",
"Id": "account"
}
]
},
{
"Value": "-2446.21",
"Attributes": [
{
"Value": "17d9a4a0-3181-4803-a96b-f0dbe589091b",
"Id": "account"
}
]
},
{
"Value": "-2461.89",
"Attributes": [
{
"Value": "17d9a4a0-3181-4803-a96b-f0dbe589091b",
"Id": "account"
}
]
},
{
"Value": "76.50",
"Attributes": [
{
"Value": "17d9a4a0-3181-4803-a96b-f0dbe589091b",
"Id": "account"
}
]
}
]
},
{
"RowType": "SummaryRow",
"Cells": [
{
"Value": "Total Current Liabilities"
},
{
"Value": "-5915.21"
},
{
"Value": "-5930.89"
},
{
"Value": "-107.50"
}
]
}
]
},
{
"RowType": "Section",
"Title": "",
"Rows": [
{
"RowType": "SummaryRow",
"Cells": [
{
"Value": "Total Liabilities"
},
{
"Value": "-5915.21"
},
{
"Value": "-5930.89"
},
{
"Value": "-107.50"
}
]
}
]
},
{
"RowType": "Section",
"Title": "",
"Rows": [
{
"RowType": "Row",
"Cells": [
{
"Value": "Net Assets"
},
{
"Value": "185448.30"
},
{
"Value": "185333.67"
},
{
"Value": "464.00"
}
]
}
]
},
{
"RowType": "Section",
"Title": "Equity",
"Rows": [
{
"RowType": "Row",
"Cells": [
{
"Value": "Current Year Earnings",
"Attributes": [
{
"Value": "00000000-0000-0000-0000-000000000000",
"Id": "account"
}
]
},
{
"Value": "114.62",
"Attributes": [
{
"Value": "00000000-0000-0000-0000-000000000000",
"Id": "account"
},
{
"Value": "4/1/2019",
"Id": "fromDate"
},
{
"Value": "4/30/2019",
"Id": "toDate"
}
]
},
{
"Value": "156621.67",
"Attributes": [
{
"Value": "00000000-0000-0000-0000-000000000000",
"Id": "account"
},
{
"Value": "4/1/2018",
"Id": "fromDate"
},
{
"Value": "3/31/2019",
"Id": "toDate"
}
]
},
{
"Value": "500.00",
"Attributes": [
{
"Value": "00000000-0000-0000-0000-000000000000",
"Id": "account"
},
{
"Value": "4/1/2018",
"Id": "fromDate"
},
{
"Value": "2/28/2019",
"Id": "toDate"
}
]
}
]
},
{
"RowType": "Row",
"Cells": [
{
"Value": "Owner A Drawings",
"Attributes": [
{
"Value": "136ebd08-60ea-4592-8982-be92c153b53a",
"Id": "account"
}
]
},
{
"Value": "28752.00",
"Attributes": [
{
"Value": "136ebd08-60ea-4592-8982-be92c153b53a",
"Id": "account"
}
]
},
{
"Value": "28752.00",
"Attributes": [
{
"Value": "136ebd08-60ea-4592-8982-be92c153b53a",
"Id": "account"
}
]
},
{
"Value": "0.00",
"Attributes": [
{
"Value": "136ebd08-60ea-4592-8982-be92c153b53a",
"Id": "account"
}
]
}
]
},
{
"RowType": "Row",
"Cells": [
{
"Value": "Owner A Funds Introduced",
"Attributes": [
{
"Value": "5690f1e8-1d02-4893-90c2-ee1a69eff942",
"Id": "account"
}
]
},
{
"Value": "-50.00",
"Attributes": [
{
"Value": "5690f1e8-1d02-4893-90c2-ee1a69eff942",
"Id": "account"
}
]
},
{
"Value": "-50.00",
"Attributes": [
{
"Value": "5690f1e8-1d02-4893-90c2-ee1a69eff942",
"Id": "account"
}
]
},
{
"Value": "-46.00",
"Attributes": [
{
"Value": "5690f1e8-1d02-4893-90c2-ee1a69eff942",
"Id": "account"
}
]
}
]
},
{
"RowType": "Row",
"Cells": [
{
"Value": "Retained Earnings",
"Attributes": [
{
"Value": "7fc16c06-c342-4f32-995f-889b5f9996fd",
"Id": "account"
}
]
},
{
"Value": "156631.67",
"Attributes": [
{
"Value": "7fc16c06-c342-4f32-995f-889b5f9996fd",
"Id": "account"
},
{
"Value": "",
"Id": "fromDate"
},
{
"Value": "4/30/2019",
"Id": "toDate"
}
]
},
{
"Value": "10.00",
"Attributes": [
{
"Value": "7fc16c06-c342-4f32-995f-889b5f9996fd",
"Id": "account"
},
{
"Value": "",
"Id": "fromDate"
},
{
"Value": "3/31/2019",
"Id": "toDate"
}
]
},
{
"Value": "10.00",
"Attributes": [
{
"Value": "7fc16c06-c342-4f32-995f-889b5f9996fd",
"Id": "account"
},
{
"Value": "",
"Id": "fromDate"
},
{
"Value": "2/28/2019",
"Id": "toDate"
}
]
}
]
},
{
"RowType": "SummaryRow",
"Cells": [
{
"Value": "Total Equity"
},
{
"Value": "185448.29"
},
{
"Value": "185333.67"
},
{
"Value": "464.00"
}
]
}
]
}
]
}
]
}
}
]
}