Report - Detailed Balance Sheet
GET {{baseUrl}}/sf/funds/:fundId/reports/balanceSheet?financialYear={{financialYear}}
Allows you to retrieve the Detailed Statement of Financial Position (or Balance Sheet) for a specific entity.
API Scopes
The following API scopes can access this resouce - investment - audit - smsf_partner
Entities Supported
The following entityTypes are supported - SMSF - BillableTrust - BillableCompany - BillableIndividual
The Detailed Statement of Financial Position provides comprehensive information of each:
Investment; and Asset; and Liability account of the entity grouped according to the general ledger account to which they belong.
This gives a further breakdown of the accounts of the entity and identifies which control account they fall under.
Example of Detailed Statement of Financial Position (PDF)
- If you require a Summarised Balance Sheet all entries under each subEntries element can be ignored.
- If you require a Detailed Balance Sheeet all entries under each subEntries element are required.
| Key | Type | Comments |
|---|---|---|
| financialYear | Date | Current Financial Year of Report |
| financialYearPrev | Date | Financial Year of Comparatives |
| fundName | string | the name of the entity |
| investmentList | array | see Account array below |
| investmentTotal | number | The total balance of all Investments in the financialYear |
| investmentTotalPrev | string | The total balance of all Investments in the financialYearPrev |
| otherAssets | array | Assets of the entity which are not Investments for the current Financial year. see Account array below |
| otherAssetsPrev | array | Assets of the entity which are not Investments for the previous Financial year. see Account array below |
| totalOtherAssets | number | Total of assets of the entity which are not Investments for the current Financial year. see Account array below |
| totalOtherAssetsPrev | number | Total of Assets of the entity which are not Investments for the previouis Financial year. see Account array below |
| totalAssets | number | equal to investmentTotal + totalOtherAssets for the current Financial Year |
| totalAssetsPrev | number | equal to investmentTotal + totalOtherAssets for the previous Financial Year |
| liabilities | array | see Account array below |
| totalLiabilities | number | Total of Liabilities for current Financial Year |
| totalLiabilitiesPrev | number | Total of Liabilities for previous Financial Year |
| netAssetsAvailable | number | Net assets available to pay benefits for current Financial year. Equal to investmentTotal + totalAssets less totalLiabilities |
| netAssetsPrev | number | Net assets available to pay benefits for previous Financial year. Equal to investmentTotal + totalAssets less totalLiabilities |
| liabilitiesForAccruedBenefits | array | Member's Balances. see Account array below |
| totalLiabilitiesForAccruedBenefits | number | Total Liability for accrued benefits allocated to members' accounts for current Financial year. |
| totalLiabilitiesForAccruedBenefitsPrev | number | Total Liability for accrued benefits allocated to members' accounts for previous Financial year. |
| netAssetLessAccruedLiability | number | Net Assets less liabilities less netAssetLessAccuredLiability for current Financial year. If this feild is not equal to zero then it indicates Balance Sheet is out of Balance. |
| netAssetLessAccruedLiabilityPrev | number | Net Assets less liabilities less netAssetLessAccuredLiability for previous Financial Year. If this feild is not equal to zero then it indicates Balance Sheet is out of Balance. |
| sofpNotBalancedEntries | array | Balances of Accounts such as suspense accounts which would cause the Balance Sheet to not Balance. see Account array below |
Account array
| Key | Type | Comments |
|---|---|---|
| accountCode | String | The Account Code from the Chart of Accounts. Display Control Account code for Control Accounts. Display Sub-account code for sub-accounts. |
| amount | Date | Balance of the Chart Category (Control Account) in the financialYear |
| amountPrev | Date | Balance of the Chart Category (Control Account) in the financialYearPrev |
| name | string | the name of the account from the Chart of Accounts |
| subEntries | array | Follows the same format as the Account array. This is only needed if you require a Detailed Balance sheet |
Request Params
| Key | Datatype | Required | Description |
|---|---|---|---|
financialYear | string | [REQUIRED] Financial Year of Report. Expected format : YYYY |
HEADERS
| Key | Datatype | Required | Description |
|---|---|---|---|
Authorization | string |
RESPONSES
status: OK
{"financialYear":2019,"financialYearPrev":2018,"fundName":"BGL Training Fund","investmentList":[{"accountCode":"72450","amount":40000,"amountPrev":40000,"name":"Fixed Interest Securities (Australian) - Unitised","subEntries":[{"accountCode":"SFTRAIN_WESTPACTERMD","amount":40000,"amountPrev":40000,"name":"Westpac Term Deposit","subEntries":[]}]},{"accountCode":"77200","amount":350000,"amountPrev":350000,"name":"Real Estate Properties ( Australian - Residential)","subEntries":[{"accountCode":"IPTRAIN","amount":350000,"amountPrev":350000,"name":"2/606-608 Hawthorn Rd, Brighton East VIC 3187","subEntries":[]}]},{"accountCode":"77600","amount":423493,"amountPrev":364803,"name":"Shares in Listed Companies (Australian)","subEntries":[{"accountCode":"CRZ.AX","amount":43981,"amountPrev":43981,"name":"Carsales.Com Limited - Ordinary Fully Paid","subEntries":[]},{"accountCode":"CBA.AX","amount":331120,"amountPrev":277480,"name":"Commonwealth Bank of Australia. - Ordinary Fully Paid","subEntries":[]},{"accountCode":"WES.AX","amount":7232,"amountPrev":9272,"name":"Wesfarmers Limited - Ordinary Fully Paid","subEntries":[]},{"accountCode":"BHP.AX","amount":41160,"amountPrev":34070,"name":"Bhp Billiton Limited - Ordinary Fully Paid","subEntries":[]}]},{"accountCode":"78200","amount":78105,"amountPrev":63754,"name":"Units in Listed Unit Trusts (Australian)","subEntries":[{"accountCode":"GPT.AX","amount":78105,"amountPrev":63754,"name":"Gpt Group - Stapled Securities Fully Paid","subEntries":[]}]}],"investmentTotal":891598,"investmentTotalPrev":818557,"liabilities":[{"accountCode":"85000","amount":-14512.64,"amountPrev":-14512.64,"name":"Income Tax Payable","subEntries":[{"accountCode":"85000","amount":-14512.64,"amountPrev":-14512.64,"name":"Income Tax Payable","subEntries":[]}]},{"accountCode":"89000","amount":-67491.2,"amountPrev":-60187.1,"name":"Deferred Tax Liability","subEntries":[{"accountCode":"89000","amount":-67491.2,"amountPrev":-60187.1,"name":"Deferred Tax Liability","subEntries":[]}]}],"liabilitiesForAccruedBenefits":[{"accountCode":"JONJOH00001P","amount":569786.11,"amountPrev":533601.6,"name":"Jeffries, John - Pension (Pension)","subEntries":[{"accountCode":"JONJOH00001P","amount":0,"amountPrev":0,"name":"(Pensions Paid) Jones, John - Pension (Pension)","subEntries":[]},{"accountCode":"JONJOH00001P","amount":36184.51,"amountPrev":-1514.25,"name":"(Share of Profit/(Loss)) Jones, John - Pension (Pension)","subEntries":[]},{"accountCode":"JONJOH00001P","amount":0,"amountPrev":0,"name":"(Life Insurance Premiums) Jones, John - Pension (Pension)","subEntries":[]},{"accountCode":"JONJOH00001P","amount":533601.6,"amountPrev":535115.85,"name":"(Opening Balance) Jones, John - Pension (Pension)","subEntries":[]},{"accountCode":"JONJOH00001P","amount":0,"amountPrev":0,"name":"(Income Tax) Jones, John - Pension (Pension)","subEntries":[]}]},{"accountCode":"JONMAR00001A","amount":573148.55,"amountPrev":543596.16,"name":"Jones, Mary - Accumulation ","subEntries":[{"accountCode":"JONMAR00001A","amount":0,"amountPrev":0,"name":"(Contributions) Jones, Mary - Accumulation (Accumulation)","subEntries":[]},{"accountCode":"JONMAR00001A","amount":0,"amountPrev":0,"name":"(Contributions Tax) Jones, Mary - Accumulation (Accumulation)","subEntries":[]},{"accountCode":"JONMAR00001A","amount":543596.16,"amountPrev":544832.31,"name":"(Opening Balance) Jones, Mary - Accumulation (Accumulation)","subEntries":[]},{"accountCode":"JONMAR00001A","amount":36856.49,"amountPrev":-1541.75,"name":"(Share of Profit/(Loss)) Jones, Mary - Accumulation (Accumulation)","subEntries":[]},{"accountCode":"JONMAR00001A","amount":-7304.1,"amountPrev":305.6,"name":"(Income Tax) Jones, Mary - Accumulation (Accumulation)","subEntries":[]},{"accountCode":"JONMAR00001A","amount":0,"amountPrev":0,"name":"(Life Insurance Premiums) Jones, Mary - Accumulation (Accumulation)","subEntries":[]}]}],"netAssetLessAccruedLiability":0,"netAssetLessAccruedLiabilityPrev":0,"netAssetsAvailable":1142934.66,"netAssetsAvailablePrev":1077197.76,"otherAssets":[{"accountCode":"60400","amount":333340.5,"amountPrev":333340.5,"name":"Bank Accounts","subEntries":[{"accountCode":"Cash at Bank","amount":333340.5,"amountPrev":333340.5,"name":"Cash at Bank","subEntries":[]}]}],"sofpNotBalancedEntries":[],"totalAssets":1224938.5,"totalAssetsPrev":1151897.5,"totalLiabilities":-82003.84,"totalLiabilitiesForAccruedBenefits":1142934.66,"totalLiabilitiesForAccruedBenefitsPrev":1077197.76,"totalLiabilitiesPrev":-74699.74,"totalOtherAssets":333340.5,"totalOtherAssetsPrev":333340.5}