Tax Code Summary endpoint

In this article we are going to take a closer look at the Report/TaxCodeSummary endpoint. 

This report provides a summary of the amount of tax collected and paid for each of our tax codes. We have a choice of reporting on an accrual or cash basis.

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

1. StartDate is the date that we would like to start at.
2. EndDate is the date of the end of the period.
3. ReportingBasis will either be Cash or Accrual.
4. 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-e474-42dc-9a46-2fa91694d984/Report/TaxCodeSummary?StartDate=2020-07-01&EndDate=2021-09-30&ReportingBasis=Accrual&YearEndAdjust=true

Example Response:

{"StartDate": "2020-07-01T00:00:00",
"EndDate": "2021-09-30T23:59:59",
"ReportingBasis": "Accrual",
"YearEndAdjust": true,
"TaxCodeBreakdown": [
{
"SalesTotal": 144250.32,
"PurchasesTotal": 109150.55,
"TaxCollected": 13113.66,
"TaxPaid": 9922.76,
"TaxRate": 10.000,
"TaxCode": {
"UID": "62324ffa-0dd0-4429-bdb0-623289f1216d",
"Code": "GST",
"URI": "https://arl2.api.myob.com/accountright/0c7fc03e-e474-42dc-9a46-2fa91694d984/GeneralLedger/TaxCode/62324ffa-0dd0-4429-bdb0-623289f1216d"
}},{
"SalesTotal": 63886.63,
"PurchasesTotal": 0.0,
"TaxCollected": 2752.96,
"TaxPaid": 0.0,
"TaxRate": 25.000,
"TaxCode": {
"UID": "d7b30c32-6d40-4fbb-8bef-91898cc266f6",
"Code": "LCT",
"URI": "https://arl2.api.myob.com/accountright/0c7fc03e-e474-42dc-9a46-2fa91694d984/GeneralLedger/TaxCode/d7b30c32-6d40-4fbb-8bef-91898cc266f6"
}},
....
....
{
"SalesTotal": 0.0,
"PurchasesTotal": 0.00,
"TaxCollected": 0.0,
"TaxPaid": 0.00,
"TaxRate": 0.000,
"TaxCode": {
"UID": "99549bc5-7fc5-4d52-87ac-c10e3bb1d1dc",
"Code": "AFT",
"URI": "https://arl2.api.myob.com/accountright/0c7fc03e-e474-42dc-9a46-2fa91694d984/GeneralLedger/TaxCode/99549bc5-7fc5-4d52-87ac-c10e3bb1d1dc"
}}],
"URI": "https://arl2.api.myob.com/accountright/0c7fc03e-e474-42dc-9a46-2fa91694d984/Report/TaxCodeSummary?EndDate=2021-09-30&ReportingBasis=Accrual&StartDate=2020-07-01&YearEndAdjust=true"
}

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