Qodex.ai

Report - Balance Review

GET {{baseUrl}}/sf/balanceReview/{{fundId}}/?financialYear={{financialYear}}

The Balance Review returns a comparison for investment balances between the balance calculated by Simple Fund 360 and the balance reported by a third party such as a bank, wrap or investment portfolio.

API Scopes

The following API scopes can access this resouce

  • investment
  • audit
  • smsf_partner
  • bgl_partner

Entities Supported

The following entityTypes are supported

  • SMSF
  • BillableTrust
  • BillableCompany
  • BillableIndividual

Response

KeyDataTypeComments
financialYearString
fundNameString
investmentListarray

investmentList array

KeyDataTypeComments
parentAccountCodeStringSub-account code from the Chart of Accounts
parentAccountNameString
subAccountsarray

subAccounts array

KeyDataTypeComments
accountNumberString
accountTypeStringSee Chart of Accounts
balanceAmount360NumberThe balance as per transactions in Simple Fund 360 / Simple Invest 360.
balanceAmountLedgerNumberThe balance from the data provider (e.g. Bank, Platform, Registry)
balanceDateStringdd/mm/yyyy
bsbString
hasVariancebooleantrue or false
holdingRefStringHolding value (e.g. HIN, BSB/AccNum, Data Feed Platform Account Number)
investmentCodeString
providerNameStringData provider name.
e.g.
--BGL Bank Data Service
--Macquarie Cash ESI
--Registry Data - Advanced Share
--Registry Data - Boardroom
--Registry Data - Computershare
--Registry Data - Link
registeredNameStringRegistered name of entity as per Registry.
subAccountNameString
varianceNumberVariance = balanceAmount360 - balanceAmountLedger

Request Params

KeyDatatypeRequiredDescription
financialYearstring

HEADERS

KeyDatatypeRequiredDescription
Authorizationstring

RESPONSES

status: OK

{"financialYear":"2015","fundName":"BGL Training Fund","investmentList":{"investmentList":[{"parentAccountCode":"60400","parentAccountName":"Bank Accounts","subAccounts":[{"accountNumber":null,"accountType":"AssetBank","balanceAmount360":355040.5,"balanceAmountLedger":0,"balanceDate":"","bsb":null,"hasVariance":true,"holdingRef":null,"investmentCode":"Cash at Bank","providerName":null,"registeredName":null,"subAccountName":"Cash at Bank","variance":355040.5}]},{"parentAccountCode":"72450","parentAccountName":"Fixed Interest Securities (Australian) - Unitised","subAccounts":[{"accountNumber":null,"accountType":"Investment","balanceAmount360":1,"balanceAmountLedger":0,"balanceDate":"","bsb":null,"hasVariance":true,"holdingRef":null,"investmentCode":"SFTRAIN_WESTPACTERMD","providerName":null,"registeredName":null,"subAccountName":"Westpac Term Deposit","variance":1}]},{"parentAccountCode":"77200","parentAccountName":"Real Estate Properties ( Australian - Residential)","subAccounts":[{"accountNumber":null,"accountType":"Investment","balanceAmount360":1,"balanceAmountLedger":0,"balanceDate":"","bsb":null,"hasVariance":true,"holdingRef":null,"investmentCode":"IPTRAIN","providerName":null,"registeredName":null,"subAccountName":"2/606-608 Hawthorn Rd, Brighton East VIC 3187","variance":1}]},{"parentAccountCode":"77600","parentAccountName":"Shares in Listed Companies (Australian)","subAccounts":[{"accountNumber":null,"accountType":"Investment","balanceAmount360":1000,"balanceAmountLedger":0,"balanceDate":"","bsb":null,"hasVariance":true,"holdingRef":null,"investmentCode":"BHP.AX","providerName":null,"registeredName":null,"subAccountName":"Bhp Billiton Limited - Ordinary Fully Paid","variance":1000},{"accountNumber":null,"accountType":"Investment","balanceAmount360":4270,"balanceAmountLedger":0,"balanceDate":"25/02/2015","bsb":null,"hasVariance":true,"holdingRef":null,"investmentCode":"CRZ.AX","providerName":null,"registeredName":null,"subAccountName":"Carsales.Com Limited - Ordinary Fully Paid","variance":4270},{"accountNumber":null,"accountType":"Investment","balanceAmount360":4000,"balanceAmountLedger":0,"balanceDate":"","bsb":null,"hasVariance":true,"holdingRef":null,"investmentCode":"CBA.AX","providerName":null,"registeredName":null,"subAccountName":"Commonwealth Bank of Australia. - Ordinary Fully Paid","variance":4000},{"accountNumber":null,"accountType":"Investment","balanceAmount360":200,"balanceAmountLedger":0,"balanceDate":"","bsb":null,"hasVariance":true,"holdingRef":null,"investmentCode":"WES.AX","providerName":null,"registeredName":null,"subAccountName":"Wesfarmers Limited - Ordinary Fully Paid","variance":200}]},{"parentAccountCode":"78200","parentAccountName":"Units in Listed Unit Trusts (Australian)","subAccounts":[{"accountNumber":null,"accountType":"Investment","balanceAmount360":12700,"balanceAmountLedger":0,"balanceDate":"","bsb":null,"hasVariance":true,"holdingRef":null,"investmentCode":"GPT.AX","providerName":null,"registeredName":null,"subAccountName":"Gpt Group - Stapled Securities Fully Paid","variance":12700}]}]}}