Balance Sheet Summary endpoint

In this article we are going to take a closer look at the Report/BalanceSheetSummary endpoint. This endpoint returns a Balance Sheet Summary.

To generate the report, we can use the HTTP method GET from the endpoint Report/BalanceSheetSummary. Please note, we must also pass the following parameters;

1. AsOfDate is the date of the end of the period.
2. YearEndAdjust states if we are including Year end Adjustments. This is a true or false value.

Example request:

https://arl2.api.myob.com/accountright/0c7fc03e-e474-42dc-9a46-2fa91694d984/Report/BalanceSheetSummary?AsOfDate=2020-10-31&YearEndAdjust=false

Example response:

{
"AsOfDate": "2020-10-31T00:00:00",
"YearEndAdjust": false,
"AccountsBreakdown": [
{
"AccountTotal": 64217.19,
"Account": {
"UID": "df7bba7e-5982-43cd-a518-5e0bb4b42e09",
"Name": "Clearwater Provision Account",
"DisplayID": "1-1150",
"URI": "https://arl2.api.myob.com/accountright/0c7fc03e-e474-42dc-9a46-2fa91694d984/GeneralLedger/Account/df7bba7e-5982-43cd-a518-5e0bb4b42e09"
}},
....
....
{
"AccountTotal": 0.00,
"Account": {
"UID": "3ffa4468-9105-4d3d-889c-79a683df8606",
"Name": "Retained Earnings",
"DisplayID": "3-8000",
"URI": "https://arl2.api.myob.com/accountright/0c7fc03e-e474-42dc-9a46-2fa91694d984/GeneralLedger/Account/3ffa4468-9105-4d3d-889c-79a683df8606"
}},
{
"AccountTotal": 0.0,
"Account": {
"UID": "39b43ca9-6fb5-4cf0-8282-ba6c5dd18baa",
"Name": "Current Earnings",
"DisplayID": "3-9000",
"URI": "https://arl2.api.myob.com/accountright/0c7fc03e-e474-42dc-9a46-2fa91694d984/GeneralLedger/Account/39b43ca9-6fb5-4cf0-8282-ba6c5dd18baa"
}},
{
"AccountTotal": 250000.00,
"Account": {
"UID": "c231dc3a-8649-4f1e-a07a-e0fe112be0ce",
"Name": "Historical Balancing Account",
"DisplayID": "3-9999",
"URI": "https://arl2.api.myob.com/accountright/0c7fc03e-e474-42dc-9a46-2fa91694d984/GeneralLedger/Account/c231dc3a-8649-4f1e-a07a-e0fe112be0ce"
}}],
"URI": "https://arl2.api.myob.com/accountright/0c7fc03e-e474-42dc-9a46-2fa91694d984/Report/BalanceSheetSummary?AsOfDate=2020-10-31&YearEndAdjust=false"
}

Please note, the Retained Earnings gets updated in the next FY, only when we close the previous FY.

When we set the date in the report to a new FY the current years earnings account will be set to 0 which is normal practice to simulate the rolling of the FY. But, only dates within the last, current and next FY are accurate.

If you have any questions, feel free to log a ticket with the Customisation & Integration Team.