Allows you to retrieve report for TrialBalance
GET {{baseUrl}}/Reports/TrialBalance?date=<date>&paymentsOnly=<boolean>
Request Params
| Key | Datatype | Required | Description |
|---|---|---|---|
date | string | The date for the Trial Balance report e.g. 2018-03-31 | |
paymentsOnly | string | Return cash only basis for the Trial Balance report |
HEADERS
| Key | Datatype | Required | Description |
|---|---|---|---|
xero-tenant-id | string | (Required) Xero identifier for Tenant |
RESPONSES
status: OK
{"Id":"0b3ee35e-b97c-4b3c-b7e2-9a465233e329","Status":"OK","ProviderName":"Java Public Example","DateTimeUTC":"/Date(1556129558740)/","Reports":[{"ReportID":"TrialBalance","ReportName":"Trial Balance","ReportType":"TrialBalance","ReportTitles":["Trial Balance","Dev Evangelist - Sid Test 1 (US-2016-06)","As at 24 April 2019"],"ReportDate":"24 April 2019","UpdatedDateUTC":"/Date(1556129558724)/","Fields":[],"Rows":[{"RowType":"Header","Cells":[{"Value":"Account"},{"Value":"Debit"},{"Value":"Credit"},{"Value":"YTD Debit"},{"Value":"YTD Credit"}]},{"RowType":"Section","Title":"Revenue","Rows":[{"RowType":"Row","Cells":[{"Value":"Big Expense (002)","Attributes":[{"Value":"da962997-a8bd-4dff-9616-01cdc199283f","Id":"account"}]},{"Value":"","Attributes":[{"Value":"da962997-a8bd-4dff-9616-01cdc199283f","Id":"account"}]},{"Value":"0.00","Attributes":[{"Value":"da962997-a8bd-4dff-9616-01cdc199283f","Id":"account"}]},{"Value":"","Attributes":[{"Value":"da962997-a8bd-4dff-9616-01cdc199283f","Id":"account"}]},{"Value":"80.00","Attributes":[{"Value":"da962997-a8bd-4dff-9616-01cdc199283f","Id":"account"}]}]},{"RowType":"Row","Cells":[{"Value":"Sales (400)","Attributes":[{"Value":"02439bca-5fdc-4b62-b281-0bdf9f16fd5b","Id":"account"}]},{"Value":"","Attributes":[{"Value":"02439bca-5fdc-4b62-b281-0bdf9f16fd5b","Id":"account"}]},{"Value":"200.00","Attributes":[{"Value":"02439bca-5fdc-4b62-b281-0bdf9f16fd5b","Id":"account"}]},{"Value":"","Attributes":[{"Value":"02439bca-5fdc-4b62-b281-0bdf9f16fd5b","Id":"account"}]},{"Value":"1020.22","Attributes":[{"Value":"02439bca-5fdc-4b62-b281-0bdf9f16fd5b","Id":"account"}]}]},{"RowType":"Row","Cells":[{"Value":"Sales-35325 (1302)","Attributes":[{"Value":"3f50db14-1fe6-450b-bfe8-b2d894f18c62","Id":"account"}]},{"Value":"","Attributes":[{"Value":"3f50db14-1fe6-450b-bfe8-b2d894f18c62","Id":"account"}]},{"Value":"1000.00","Attributes":[{"Value":"3f50db14-1fe6-450b-bfe8-b2d894f18c62","Id":"account"}]},{"Value":"","Attributes":[{"Value":"3f50db14-1fe6-450b-bfe8-b2d894f18c62","Id":"account"}]},{"Value":"1000.00","Attributes":[{"Value":"3f50db14-1fe6-450b-bfe8-b2d894f18c62","Id":"account"}]}]}]},{"RowType":"Section","Title":"Expenses","Rows":[{"RowType":"Row","Cells":[{"Value":"Foobar14043 (123)","Attributes":[{"Value":"d1602f69-f900-4616-8d34-90af393fa368","Id":"account"}]},{"Value":"0.00","Attributes":[{"Value":"d1602f69-f900-4616-8d34-90af393fa368","Id":"account"}]},{"Value":"","Attributes":[{"Value":"d1602f69-f900-4616-8d34-90af393fa368","Id":"account"}]},{"Value":"40.00","Attributes":[{"Value":"d1602f69-f900-4616-8d34-90af393fa368","Id":"account"}]},{"Value":"","Attributes":[{"Value":"d1602f69-f900-4616-8d34-90af393fa368","Id":"account"}]}]},{"RowType":"Row","Cells":[{"Value":"MyExp51937 (1231239)","Attributes":[{"Value":"90f10e0a-a043-46fe-b87e-630e9a951dae","Id":"account"}]},{"Value":"0.00","Attributes":[{"Value":"90f10e0a-a043-46fe-b87e-630e9a951dae","Id":"account"}]},{"Value":"","Attributes":[{"Value":"90f10e0a-a043-46fe-b87e-630e9a951dae","Id":"account"}]},{"Value":"80.00","Attributes":[{"Value":"90f10e0a-a043-46fe-b87e-630e9a951dae","Id":"account"}]},{"Value":"","Attributes":[{"Value":"90f10e0a-a043-46fe-b87e-630e9a951dae","Id":"account"}]}]}]},{"RowType":"Section","Title":"Assets","Rows":[{"RowType":"Row","Cells":[{"Value":"Accounts Receivable (120)","Attributes":[{"Value":"31ae5bb4-611c-4f89-a369-86e4d56e90b6","Id":"account"}]},{"Value":"1190.00","Attributes":[{"Value":"31ae5bb4-611c-4f89-a369-86e4d56e90b6","Id":"account"}]},{"Value":"","Attributes":[{"Value":"31ae5bb4-611c-4f89-a369-86e4d56e90b6","Id":"account"}]},{"Value":"36555.04","Attributes":[{"Value":"31ae5bb4-611c-4f89-a369-86e4d56e90b6","Id":"account"}]},{"Value":"","Attributes":[{"Value":"31ae5bb4-611c-4f89-a369-86e4d56e90b6","Id":"account"}]}]},{"RowType":"Row","Cells":[{"Value":"Business Wells Fargo (088)","Attributes":[{"Value":"6f7594f2-f059-4d56-9e67-47ac9733bfe9","Id":"account"}]},{"Value":"0.00","Attributes":[{"Value":"6f7594f2-f059-4d56-9e67-47ac9733bfe9","Id":"account"}]},{"Value":"","Attributes":[{"Value":"6f7594f2-f059-4d56-9e67-47ac9733bfe9","Id":"account"}]},{"Value":"7639.04","Attributes":[{"Value":"6f7594f2-f059-4d56-9e67-47ac9733bfe9","Id":"account"}]},{"Value":"","Attributes":[{"Value":"6f7594f2-f059-4d56-9e67-47ac9733bfe9","Id":"account"}]}]},{"RowType":"Row","Cells":[{"Value":"Generic Cash Clearing (8003)","Attributes":[{"Value":"f4be973a-25fc-48d0-a7df-7f719f239729","Id":"account"}]},{"Value":"0.00","Attributes":[{"Value":"f4be973a-25fc-48d0-a7df-7f719f239729","Id":"account"}]},{"Value":"","Attributes":[{"Value":"f4be973a-25fc-48d0-a7df-7f719f239729","Id":"account"}]},{"Value":"1443.00","Attributes":[{"Value":"f4be973a-25fc-48d0-a7df-7f719f239729","Id":"account"}]},{"Value":"","Attributes":[{"Value":"f4be973a-25fc-48d0-a7df-7f719f239729","Id":"account"}]}]},{"RowType":"Row","Cells":[{"Value":"Generic Credit Card Clearing (8002)","Attributes":[{"Value":"a10867ac-0bc4-4aa5-af00-b9e5b207c6c3","Id":"account"}]},{"Value":"0.00","Attributes":[{"Value":"a10867ac-0bc4-4aa5-af00-b9e5b207c6c3","Id":"account"}]},{"Value":"","Attributes":[{"Value":"a10867ac-0bc4-4aa5-af00-b9e5b207c6c3","Id":"account"}]},{"Value":"","Attributes":[{"Value":"a10867ac-0bc4-4aa5-af00-b9e5b207c6c3","Id":"account"}]},{"Value":"96.49","Attributes":[{"Value":"a10867ac-0bc4-4aa5-af00-b9e5b207c6c3","Id":"account"}]}]},{"RowType":"Row","Cells":[{"Value":"Generic Inventory (1400)","Attributes":[{"Value":"7422f1b6-619f-488c-89e1-91bdde20216c","Id":"account"}]},{"Value":"0.00","Attributes":[{"Value":"7422f1b6-619f-488c-89e1-91bdde20216c","Id":"account"}]},{"Value":"","Attributes":[{"Value":"7422f1b6-619f-488c-89e1-91bdde20216c","Id":"account"}]},{"Value":"","Attributes":[{"Value":"7422f1b6-619f-488c-89e1-91bdde20216c","Id":"account"}]},{"Value":"160.00","Attributes":[{"Value":"7422f1b6-619f-488c-89e1-91bdde20216c","Id":"account"}]}]},{"RowType":"Row","Cells":[{"Value":"My Savings (090)","Attributes":[{"Value":"7e5e243b-9fcd-4aef-8e3a-c70be1e39bfa","Id":"account"}]},{"Value":"0.00","Attributes":[{"Value":"7e5e243b-9fcd-4aef-8e3a-c70be1e39bfa","Id":"account"}]},{"Value":"","Attributes":[{"Value":"7e5e243b-9fcd-4aef-8e3a-c70be1e39bfa","Id":"account"}]},{"Value":"219.92","Attributes":[{"Value":"7e5e243b-9fcd-4aef-8e3a-c70be1e39bfa","Id":"account"}]},{"Value":"","Attributes":[{"Value":"7e5e243b-9fcd-4aef-8e3a-c70be1e39bfa","Id":"account"}]}]},{"RowType":"Row","Cells":[{"Value":"Payment Wall Clearing Account (8001)","Attributes":[{"Value":"bc06840c-12c5-4e22-bb57-fef4d64bac10","Id":"account"}]},{"Value":"0.00","Attributes":[{"Value":"bc06840c-12c5-4e22-bb57-fef4d64bac10","Id":"account"}]},{"Value":"","Attributes":[{"Value":"bc06840c-12c5-4e22-bb57-fef4d64bac10","Id":"account"}]},{"Value":"1.00","Attributes":[{"Value":"bc06840c-12c5-4e22-bb57-fef4d64bac10","Id":"account"}]},{"Value":"","Attributes":[{"Value":"bc06840c-12c5-4e22-bb57-fef4d64bac10","Id":"account"}]}]}]},{"RowType":"Section","Title":"Liabilities","Rows":[{"RowType":"Row","Cells":[{"Value":"Accounts Payable (200)","Attributes":[{"Value":"e9132ee7-4dcf-4fad-b76c-86e212af645a","Id":"account"}]},{"Value":"","Attributes":[{"Value":"e9132ee7-4dcf-4fad-b76c-86e212af645a","Id":"account"}]},{"Value":"0.00","Attributes":[{"Value":"e9132ee7-4dcf-4fad-b76c-86e212af645a","Id":"account"}]},{"Value":"","Attributes":[{"Value":"e9132ee7-4dcf-4fad-b76c-86e212af645a","Id":"account"}]},{"Value":"9223.00","Attributes":[{"Value":"e9132ee7-4dcf-4fad-b76c-86e212af645a","Id":"account"}]}]},{"RowType":"Row","Cells":[{"Value":"Deferred Revenue (2300)","Attributes":[{"Value":"f22cd74e-f59d-4f38-a08d-07e14df28c24","Id":"account"}]},{"Value":"","Attributes":[{"Value":"f22cd74e-f59d-4f38-a08d-07e14df28c24","Id":"account"}]},{"Value":"0.00","Attributes":[{"Value":"f22cd74e-f59d-4f38-a08d-07e14df28c24","Id":"account"}]},{"Value":"","Attributes":[{"Value":"f22cd74e-f59d-4f38-a08d-07e14df28c24","Id":"account"}]},{"Value":"1854.24","Attributes":[{"Value":"f22cd74e-f59d-4f38-a08d-07e14df28c24","Id":"account"}]}]},{"RowType":"Row","Cells":[{"Value":"Rounding (260)","Attributes":[{"Value":"f0072999-8f7c-4b01-bce9-bd9352f98e02","Id":"account"}]},{"Value":"","Attributes":[{"Value":"f0072999-8f7c-4b01-bce9-bd9352f98e02","Id":"account"}]},{"Value":"0.00","Attributes":[{"Value":"f0072999-8f7c-4b01-bce9-bd9352f98e02","Id":"account"}]},{"Value":"","Attributes":[{"Value":"f0072999-8f7c-4b01-bce9-bd9352f98e02","Id":"account"}]},{"Value":"0.01","Attributes":[{"Value":"f0072999-8f7c-4b01-bce9-bd9352f98e02","Id":"account"}]}]},{"RowType":"Row","Cells":[{"Value":"Sales Tax (220)","Attributes":[{"Value":"af0be362-45fe-4730-a8af-634c2fb93f4d","Id":"account"}]},{"Value":"","Attributes":[{"Value":"af0be362-45fe-4730-a8af-634c2fb93f4d","Id":"account"}]},{"Value":"0.00","Attributes":[{"Value":"af0be362-45fe-4730-a8af-634c2fb93f4d","Id":"account"}]},{"Value":"","Attributes":[{"Value":"af0be362-45fe-4730-a8af-634c2fb93f4d","Id":"account"}]},{"Value":"1578.35","Attributes":[{"Value":"af0be362-45fe-4730-a8af-634c2fb93f4d","Id":"account"}]}]},{"RowType":"Row","Cells":[{"Value":"Suspense (250)","Attributes":[{"Value":"5ec2f302-cd60-4f8b-a915-9229dd45e6fa","Id":"account"}]},{"Value":"10.00","Attributes":[{"Value":"5ec2f302-cd60-4f8b-a915-9229dd45e6fa","Id":"account"}]},{"Value":"","Attributes":[{"Value":"5ec2f302-cd60-4f8b-a915-9229dd45e6fa","Id":"account"}]},{"Value":"41.00","Attributes":[{"Value":"5ec2f302-cd60-4f8b-a915-9229dd45e6fa","Id":"account"}]},{"Value":"","Attributes":[{"Value":"5ec2f302-cd60-4f8b-a915-9229dd45e6fa","Id":"account"}]}]},{"RowType":"Row","Cells":[{"Value":"Unpaid Expense Claims (210)","Attributes":[{"Value":"38e6967d-4da1-4a93-85f1-ea3c93b61041","Id":"account"}]},{"Value":"","Attributes":[{"Value":"38e6967d-4da1-4a93-85f1-ea3c93b61041","Id":"account"}]},{"Value":"0.00","Attributes":[{"Value":"38e6967d-4da1-4a93-85f1-ea3c93b61041","Id":"account"}]},{"Value":"","Attributes":[{"Value":"38e6967d-4da1-4a93-85f1-ea3c93b61041","Id":"account"}]},{"Value":"135.00","Attributes":[{"Value":"38e6967d-4da1-4a93-85f1-ea3c93b61041","Id":"account"}]}]}]},{"RowType":"Section","Title":"Equity","Rows":[{"RowType":"Row","Cells":[{"Value":"Retained Earnings (320)","Attributes":[{"Value":"6ef53919-b47d-4341-b11a-735a3f8a6515","Id":"account"}]},{"Value":"","Attributes":[{"Value":"6ef53919-b47d-4341-b11a-735a3f8a6515","Id":"account"},{"Value":"","Id":"fromDate"},{"Value":"12/31/2018","Id":"toDate"}]},{"Value":"0.00","Attributes":[{"Value":"6ef53919-b47d-4341-b11a-735a3f8a6515","Id":"account"},{"Value":"","Id":"fromDate"},{"Value":"12/31/2018","Id":"toDate"}]},{"Value":"","Attributes":[{"Value":"6ef53919-b47d-4341-b11a-735a3f8a6515","Id":"account"},{"Value":"","Id":"fromDate"},{"Value":"12/31/2018","Id":"toDate"}]},{"Value":"30871.69","Attributes":[{"Value":"6ef53919-b47d-4341-b11a-735a3f8a6515","Id":"account"},{"Value":"","Id":"fromDate"},{"Value":"12/31/2018","Id":"toDate"}]}]}]},{"RowType":"Section","Title":"","Rows":[{"RowType":"SummaryRow","Cells":[{"Value":"Total"},{"Value":"1200.00"},{"Value":"1200.00"},{"Value":"46019.00"},{"Value":"46019.00"}]}]}]}]}