Allows you to retrieve report for BalanceSheet
GET {{baseUrl}}/Reports/BalanceSheet?date=<date>&periods=<integer>&timeframe=<string>&trackingOptionID1=<string>&trackingOptionID2=<string>&standardLayout=<boolean>&paymentsOnly=<boolean>
Request Params
| Key | Datatype | Required | Description |
|---|---|---|---|
date | string | The date of the Balance Sheet report | |
periods | string | The number of periods for the Balance Sheet report | |
timeframe | string | The period size to compare to (MONTH, QUARTER, YEAR) | |
trackingOptionID1 | string | The tracking option 1 for the Balance Sheet report | |
trackingOptionID2 | string | The tracking option 2 for the Balance Sheet report | |
standardLayout | string | The standard layout boolean for the Balance Sheet report | |
paymentsOnly | string | return a cash basis for the Balance Sheet report |
HEADERS
| Key | Datatype | Required | Description |
|---|---|---|---|
xero-tenant-id | string | (Required) Xero identifier for Tenant |
RESPONSES
status: OK
{"Id":"2ddba304-6ed3-4da4-b185-3b6289699653","Status":"OK","ProviderName":"Provider Name Example","DateTimeUTC":"/Date(1555099412778)/","Reports":[{"ReportID":"BalanceSheet","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-000-000000000000","Id":"account"}]},{"Value":"114.62","Attributes":[{"Value":"00000000-0000-0000-000-000000000000","Id":"account"},{"Value":"4/1/2019","Id":"fromDate"},{"Value":"4/30/2019","Id":"toDate"}]},{"Value":"156621.67","Attributes":[{"Value":"00000000-0000-0000-000-000000000000","Id":"account"},{"Value":"4/1/2018","Id":"fromDate"},{"Value":"3/31/2019","Id":"toDate"}]},{"Value":"500.00","Attributes":[{"Value":"00000000-0000-0000-000-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"}]}]}]}]}