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.
KeyTypeComments
financialYearDateCurrent Financial Year of Report
financialYearPrevDateFinancial Year of Comparatives
fundNamestringthe name of the entity
investmentListarraysee Account array below
investmentTotalnumberThe total balance of all Investments in the financialYear
investmentTotalPrevstringThe total balance of all Investments in the financialYearPrev
otherAssetsarrayAssets of the entity which are not Investments for the current Financial year. see Account array below
otherAssetsPrevarrayAssets of the entity which are not Investments for the previous Financial year. see Account array below
totalOtherAssetsnumberTotal of assets of the entity which are not Investments for the current Financial year. see Account array below
totalOtherAssetsPrevnumberTotal of Assets of the entity which are not Investments for the previouis Financial year. see Account array below
totalAssetsnumberequal to investmentTotal + totalOtherAssets for the current Financial Year
totalAssetsPrevnumberequal to investmentTotal + totalOtherAssets for the previous Financial Year
liabilitiesarraysee Account array below
totalLiabilitiesnumberTotal of Liabilities for current Financial Year
totalLiabilitiesPrevnumberTotal of Liabilities for previous Financial Year
netAssetsAvailablenumberNet assets available to pay benefits for current Financial year. Equal to investmentTotal + totalAssets less totalLiabilities
netAssetsPrevnumberNet assets available to pay benefits for previous Financial year. Equal to investmentTotal + totalAssets less totalLiabilities
liabilitiesForAccruedBenefitsarrayMember's Balances. see Account array below
totalLiabilitiesForAccruedBenefitsnumberTotal Liability for accrued benefits allocated to members' accounts for current Financial year.
totalLiabilitiesForAccruedBenefitsPrevnumberTotal Liability for accrued benefits allocated to members' accounts for previous Financial year.
netAssetLessAccruedLiabilitynumberNet 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.
netAssetLessAccruedLiabilityPrevnumberNet 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.
sofpNotBalancedEntriesarrayBalances of Accounts such as suspense accounts which would cause the Balance Sheet to not Balance. see Account array below

Account array

KeyTypeComments
accountCodeStringThe Account Code from the Chart of Accounts. Display Control Account code for Control Accounts. Display Sub-account code for sub-accounts.
amountDateBalance of the Chart Category (Control Account) in the financialYear
amountPrevDateBalance of the Chart Category (Control Account) in the financialYearPrev
namestringthe name of the account from the Chart of Accounts
subEntriesarrayFollows the same format as the Account array. This is only needed if you require a Detailed Balance sheet

Request Params

KeyDatatypeRequiredDescription
financialYearstring[REQUIRED] Financial Year of Report. Expected format : YYYY

HEADERS

KeyDatatypeRequiredDescription
Authorizationstring

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}