In this article we are going to take a closer look at the Report/ProfitAndLossSummary endpoint. This report shows business income and expense.
To generate the report, we can use the HTTP method GET from the endpoint Report/ProfitAndLossSummary. Please note, we must also pass the following parameters;
- StartDate is the date that we would like to start at.
- EndDate is the date of the end of the period.
- ReportingBasis will either be Cash or Accrual.
- YearEndAdjust stats if we are including Year end Adjustments. This is a true or false value.
Example request:
https://arl2.api.myob.com/accountright/0c7fc03e-e47AA4-42dc-9a46-2fa91694d984/Report/ProfitAndLossSummary?StartDate=2021-04-01&EndDate=2021-04-30&ReportingBasis=Accrual&YearEndAdjust=true
Example Response:
{"StartDate": "2021-04-01T00:00:00",
"EndDate": "2021-04-30T23:59:59",
"ReportingBasis": "Accrual",
"YearEndAdjust": true,
"AccountsBreakdown": [{
"AccountTotal": 0.0,
"Account": {
"UID": "8d0e7f6d-da41-4c8c-8fbb-cc77f1e986d7",
"Name": "Sales - Spring Water",
"DisplayID": "4-1100",
"URI": "https://arl2.api.myob.com/accountright/0c7fc03e-e474-42dc-9a46-2fa91694d984/GeneralLedger/Account/8d0e7f6d-da41-4c8c-8fbb-cc77f1e986d7"
}},{
"AccountTotal": 0.0,
"Account": {
"UID": "abdf6c3e-d77b-4893-826b-4d5663bc083b",
"Name": "Sales - Carbonated Water",
"DisplayID": "4-1200",
"URI": "https://arl2.api.myob.com/accountright/0c7fc03e-e474-42dc-9a46-2fa91694d984/GeneralLedger/Account/abdf6c3e-d77b-4893-826b-4d5663bc083b"
}},{
"AccountTotal": 0.0,
"Account": {
"UID": "6132e2df-758b-42ed-9d42-fc421d81d47f",
"Name": "Sales - Water Cooler",
"DisplayID": "4-1300",
"URI": "https://arl2.api.myob.com/accountright/0c7fc03e-e474-42dc-9a46-2fa91694d984/GeneralLedger/Account/6132e2df-758b-42ed-9d42-fc421d81d47f"
}
},
....
....
{
"AccountTotal": 0.0,
"Account": {
"UID": "562d8bac-bb00-40b8-9d3d-09d1ec8b364d",
"Name": "Private Use",
"DisplayID": "9-3000",
"URI": "https://arl2.api.myob.com/accountright/0c7fc03e-e474-42dc-9a46-2fa91694d984/GeneralLedger/Account/562d8bac-bb00-40b8-9d3d-09d1ec8b364d"
}}],
"URI": "https://arl2.api.myob.com/accountright/0c7fc03e-e474-42dc-9a46-2fa91694d984/Report/ProfitAndLossSummary?EndDate=2021-04-30&ReportingBasis=Accrual&StartDate=2021-04-01&YearEndAdjust=true"
}
Common error:
'The Start Date and End Date are not in the same financial year'.
The StartDate and EndDate needs to be within the same financial year. We can only report on one financial year, not across multiple financial years.
For more information on P 'n' L report please see this article - Analyse your profit or loss
If you have any questions, feel free to log a ticket with the Customisation & Integration Team.
Comments
0 comments
Article is closed for comments.