Report - Trial Balance
GET {{baseUrl}}/fund/trialBalance?fundId={{fundId}}&start={{start}}&end={{end}}
Allows you to retrieve the Trial Balance for a specified fundId.
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
Response
trialbalance array
| Key | Data Type | Description/Contraints |
|---|---|---|
| fundId | string | The Unique ID of the entity. This is unique across all entities on Simple Fund 360 |
| start | Date | The Start Date of Report |
| end | Date | The end date of the report |
Data Array.
Refer to Chart of Accounts for details on the Chart of Accounts in SF360. |
| Key | Data Type | Description/Contraints |
|---|---|---|
| accountClass | Object | C = Control, S = Sub-account, N= Normal |
| accountCode | String | The Account Code from the Chart of Accounts. |
| accountType | String | The Account Type from the Chart of Accounts. |
| minCode | Number | The minimum account code used by the accountType |
| maxCode | Number | The minimum account code used by the accountType |
| name | string | The name of the account from the Chart of Accounts |
| units | Number (nullable | The Number of Units on hand as at the End Date. Only used if accountType is Investment |
| debits | Number (nullable) | The Debit Balance of the account as at the End Date. |
| credits | Number (nullable) | The Credit Balance of the account as at the End Date |
| unitsPrev | Number (nullable) | The Number of Units on hand as at the Start Date. Only used if accountType is Investment |
| debitsPrev | Number (nullable) | The Debit Balance of the account as at the Start Date. |
| creditsPrev | Number (nullable) | The Credit Balance of the account as at the Start Date |
| balancePrev | Number (nullable) | The Balance of the account as at the Start Date. A Positive number equals a debit balance. A credit balance equals a Credit balance |
Request Params
| Key | Datatype | Required | Description |
|---|---|---|---|
fundId | string | [REQUIRED] The unique fund id | |
format | string | [OPTIONAL] Will return data in json or xml. Is optional and if not supplied data will be returned in json. | |
start | string | [OPTIONAL] Start date of Report. Expected format : yyyy-mm-dd | |
end | string | [OPTIONAL] End date of Report. Expected format : yyyy-mm-dd |
HEADERS
| Key | Datatype | Required | Description |
|---|---|---|---|
Authorization | string |
RESPONSES
status: OK
{"trialBalance":{"fundId":"8a9c9e744ebc893a014ebd429dea000c","start":"2017-06-30T14:00:00Z","end":"2018-06-30T13:59:59Z","data":[{"accountClass":"N","accountCode":"24700","accountType":{"label":"Income","minCode":20000,"maxCode":29999,"name":"Income"},"name":"Changes in Market Values of Investments","units":0,"debits":0,"credits":0,"unitsPrev":null,"debitsPrev":79759.59,"creditsPrev":0,"balancePrev":79759.59},{"accountClass":"C","accountCode":"28000","accountType":{"label":"Income","minCode":20000,"maxCode":29999,"name":"Income"},"name":"Property Income","units":0,"debits":0,"credits":0,"unitsPrev":0,"debitsPrev":0,"creditsPrev":0,"balancePrev":0},{"accountClass":"S","accountCode":"28000/5smithst","accountType":{"label":"Income","minCode":20000,"maxCode":29999,"name":"Income"},"name":"5 Smith Street, Collingwood","units":0,"debits":0,"credits":0,"unitsPrev":null,"debitsPrev":0,"creditsPrev":7765.75,"balancePrev":-7765.75},{"accountClass":"C","accountCode":"33400","accountType":{"label":"Expense","minCode":30000,"maxCode":47999,"name":"Expense"},"name":"Depreciation","units":0,"debits":0,"credits":0,"unitsPrev":0,"debitsPrev":0,"creditsPrev":0,"balancePrev":0},{"accountClass":"S","accountCode":"33400/5smithst","accountType":{"label":"Expense","minCode":30000,"maxCode":47999,"name":"Expense"},"name":"5 Smith Street, Collingwood","units":0,"debits":0,"credits":0,"unitsPrev":null,"debitsPrev":37500,"creditsPrev":0,"balancePrev":37500},{"accountClass":"N","accountCode":"48500","accountType":{"label":"Allocation","minCode":48000,"maxCode":49999,"name":"Allocation"},"name":"Income Tax Expense","units":0,"debits":0,"credits":0,"unitsPrev":null,"debitsPrev":0,"creditsPrev":7338.91,"balancePrev":-7338.91},{"accountClass":"N","accountCode":"49000","accountType":{"label":"Allocation","minCode":48000,"maxCode":49999,"name":"Allocation"},"name":"Profit/Loss Allocation Account","units":0,"debits":0,"credits":0,"unitsPrev":null,"debitsPrev":0,"creditsPrev":82527.32,"balancePrev":-82527.32},{"accountClass":"C","accountCode":"50010","accountType":{"label":"Member","minCode":50000,"maxCode":59999,"name":"Member"},"name":"Opening Balance","units":0,"debits":0,"credits":0,"unitsPrev":0,"debitsPrev":0,"creditsPrev":0,"balancePrev":0},{"accountClass":"S","accountCode":"50010/SIMHOM00003A","accountType":{"label":"Member","minCode":50000,"maxCode":59999,"name":"Member"},"name":"(Opening Balance) Simpson, Homer - Accumulation (Accumulation)","units":null,"debits":0,"credits":717158.55,"unitsPrev":null,"debitsPrev":0,"creditsPrev":717158.55,"balancePrev":-717158.55},{"accountClass":"S","accountCode":"50010/SIMMAR00002A","accountType":{"label":"Member","minCode":50000,"maxCode":59999,"name":"Member"},"name":"(Opening Balance) Simpson, Marge - Accumulation (Accumulation)","units":null,"debits":0,"credits":478105.7,"unitsPrev":null,"debitsPrev":0,"creditsPrev":478105.7,"balancePrev":-478105.7},{"accountClass":"C","accountCode":"52420","accountType":{"label":"Member","minCode":50000,"maxCode":59999,"name":"Member"},"name":"Contributions","units":0,"debits":0,"credits":0,"unitsPrev":0,"debitsPrev":0,"creditsPrev":0,"balancePrev":0},{"accountClass":"S","accountCode":"52420/SIMHOM00003A","accountType":{"label":"Member","minCode":50000,"maxCode":59999,"name":"Member"},"name":"(Contributions) Simpson, Homer - Accumulation (Accumulation)","units":null,"debits":0,"credits":501000,"unitsPrev":null,"debitsPrev":0,"creditsPrev":501000,"balancePrev":-501000},{"accountClass":"C","accountCode":"53100","accountType":{"label":"Member","minCode":50000,"maxCode":59999,"name":"Member"},"name":"Share of Profit/(Loss)","units":0,"debits":0,"credits":0,"unitsPrev":0,"debitsPrev":0,"creditsPrev":0,"balancePrev":0},{"accountClass":"S","accountCode":"53100/SIMHOM00003A","accountType":{"label":"Member","minCode":50000,"maxCode":59999,"name":"Member"},"name":"(Share of Profit/(Loss)) Simpson, Homer - Accumulation (Accumulation)","units":null,"debits":28073.8,"credits":0,"unitsPrev":null,"debitsPrev":28073.8,"creditsPrev":0,"balancePrev":28073.8},{"accountClass":"S","accountCode":"53100/SIMHOM00010P","accountType":{"label":"Member","minCode":50000,"maxCode":59999,"name":"Member"},"name":"(Share of Profit/(Loss)) Simpson, Homer - Pension (Market Linked)","units":null,"debits":13652.52,"credits":0,"unitsPrev":null,"debitsPrev":13652.52,"creditsPrev":0,"balancePrev":13652.52},{"accountClass":"S","accountCode":"53100/SIMHOM00013P","accountType":{"label":"Member","minCode":50000,"maxCode":59999,"name":"Member"},"name":"(Share of Profit/(Loss)) Simpson, Homer - Pension (Account Based Pension)","units":null,"debits":55982.85,"credits":0,"unitsPrev":null,"debitsPrev":55982.85,"creditsPrev":0,"balancePrev":55982.85},{"accountClass":"S","accountCode":"53100/SIMMAR00002A","accountType":{"label":"Member","minCode":50000,"maxCode":59999,"name":"Member"},"name":"(Share of Profit/(Loss)) Simpson, Marge - Accumulation (Accumulation)","units":null,"debits":8758.73,"credits":0,"unitsPrev":null,"debitsPrev":8758.73,"creditsPrev":0,"balancePrev":8758.73},{"accountClass":"S","accountCode":"53100/SIMMAR00010P","accountType":{"label":"Member","minCode":50000,"maxCode":59999,"name":"Member"},"name":"(Share of Profit/(Loss)) Simpson, Marge - Pension (Transition to Retirement Pension)","units":null,"debits":15168.5,"credits":0,"unitsPrev":null,"debitsPrev":15168.5,"creditsPrev":0,"balancePrev":15168.5},{"accountClass":"C","accountCode":"53330","accountType":{"label":"Member","minCode":50000,"maxCode":59999,"name":"Member"},"name":"Income Tax","units":0,"debits":0,"credits":0,"unitsPrev":0,"debitsPrev":0,"creditsPrev":0,"balancePrev":0},{"accountClass":"S","accountCode":"53330/SIMHOM00003A","accountType":{"label":"Member","minCode":50000,"maxCode":59999,"name":"Member"},"name":"(Income Tax) Simpson, Homer - Accumulation (Accumulation)","units":null,"debits":0,"credits":3863.14,"unitsPrev":null,"debitsPrev":0,"creditsPrev":3863.14,"balancePrev":-3863.14},{"accountClass":"S","accountCode":"53330/SIMMAR00002A","accountType":{"label":"Member","minCode":50000,"maxCode":59999,"name":"Member"},"name":"(Income Tax) Simpson, Marge - Accumulation (Accumulation)","units":null,"debits":0,"credits":1907.03,"unitsPrev":null,"debitsPrev":0,"creditsPrev":1907.03,"balancePrev":-1907.03},{"accountClass":"C","accountCode":"53920","accountType":{"label":"Member","minCode":50000,"maxCode":59999,"name":"Member"},"name":"Life Insurance Premiums","units":0,"debits":0,"credits":0,"unitsPrev":0,"debitsPrev":0,"creditsPrev":0,"balancePrev":0},{"accountClass":"S","accountCode":"53920/SIMHOM00003A","accountType":{"label":"Member","minCode":50000,"maxCode":59999,"name":"Member"},"name":"(Life Insurance Premiums) Simpson, Homer - Accumulation (Accumulation)","units":null,"debits":750,"credits":0,"unitsPrev":null,"debitsPrev":750,"creditsPrev":0,"balancePrev":750},{"accountClass":"C","accountCode":"54160","accountType":{"label":"Member","minCode":50000,"maxCode":59999,"name":"Member"},"name":"Pensions Paid","units":0,"debits":0,"credits":0,"unitsPrev":0,"debitsPrev":0,"creditsPrev":0,"balancePrev":0},{"accountClass":"S","accountCode":"54160/SIMHOM00010P","accountType":{"label":"Member","minCode":50000,"maxCode":59999,"name":"Member"},"name":"(Pensions Paid) Simpson, Homer - Pension (Market Linked)","units":null,"debits":7000,"credits":0,"unitsPrev":null,"debitsPrev":7000,"creditsPrev":0,"balancePrev":7000},{"accountClass":"C","accountCode":"54500","accountType":{"label":"Member","minCode":50000,"maxCode":59999,"name":"Member"},"name":"Benefits Paid/Transfers Out","units":0,"debits":0,"credits":0,"unitsPrev":0,"debitsPrev":0,"creditsPrev":0,"balancePrev":0},{"accountClass":"S","accountCode":"54500/SIMHOM00003A","accountType":{"label":"Member","minCode":50000,"maxCode":59999,"name":"Member"},"name":"(Benefits Paid/Transfers Out) Simpson, Homer - Accumulation (Accumulation)","units":null,"debits":1500,"credits":0,"unitsPrev":null,"debitsPrev":1500,"creditsPrev":0,"balancePrev":1500},{"accountClass":"S","accountCode":"54500/SIMMAR00002A","accountType":{"label":"Member","minCode":50000,"maxCode":59999,"name":"Member"},"name":"(Benefits Paid/Transfers Out) Simpson, Marge - Accumulation (Accumulation)","units":null,"debits":2500,"credits":0,"unitsPrev":null,"debitsPrev":2500,"creditsPrev":0,"balancePrev":2500},{"accountClass":"C","accountCode":"56100","accountType":{"label":"Member","minCode":50000,"maxCode":59999,"name":"Member"},"name":"Internal Transfers In","units":0,"debits":0,"credits":0,"unitsPrev":0,"debitsPrev":0,"creditsPrev":0,"balancePrev":0},{"accountClass":"S","accountCode":"56100/SIMHOM00010P","accountType":{"label":"Member","minCode":50000,"maxCode":59999,"name":"Member"},"name":"(Internal Transfers In) Simpson, Homer - Pension (Market Linked)","units":null,"debits":0,"credits":120000,"unitsPrev":null,"debitsPrev":0,"creditsPrev":120000,"balancePrev":-120000},{"accountClass":"S","accountCode":"56100/SIMHOM00013P","accountType":{"label":"Member","minCode":50000,"maxCode":59999,"name":"Member"},"name":"(Internal Transfers In) Simpson, Homer - Pension (Account Based Pension)","units":null,"debits":0,"credits":1145076.07,"unitsPrev":null,"debitsPrev":0,"creditsPrev":1145076.07,"balancePrev":-1145076.07},{"accountClass":"S","accountCode":"56100/SIMMAR00010P","accountType":{"label":"Member","minCode":50000,"maxCode":59999,"name":"Member"},"name":"(Internal Transfers In) Simpson, Marge - Pension (Transition to Retirement Pension)","units":null,"debits":0,"credits":300000,"unitsPrev":null,"debitsPrev":0,"creditsPrev":300000,"balancePrev":-300000},{"accountClass":"C","accountCode":"57100","accountType":{"label":"Member","minCode":50000,"maxCode":59999,"name":"Member"},"name":"Internal Transfers Out","units":0,"debits":0,"credits":0,"unitsPrev":0,"debitsPrev":0,"creditsPrev":0,"balancePrev":0},{"accountClass":"S","accountCode":"57100/SIMHOM00003A","accountType":{"label":"Member","minCode":50000,"maxCode":59999,"name":"Member"},"name":"(Internal Transfers Out) Simpson, Homer - Accumulation (Accumulation)","units":null,"debits":1265076.07,"credits":0,"unitsPrev":null,"debitsPrev":1265076.07,"creditsPrev":0,"balancePrev":1265076.07},{"accountClass":"S","accountCode":"57100/SIMMAR00002A","accountType":{"label":"Member","minCode":50000,"maxCode":59999,"name":"Member"},"name":"(Internal Transfers Out) Simpson, Marge - Accumulation (Accumulation)","units":null,"debits":300000,"credits":0,"unitsPrev":null,"debitsPrev":300000,"creditsPrev":0,"balancePrev":300000},{"accountClass":"C","accountCode":"60400","accountType":{"label":"Asset - Bank","minCode":60400,"maxCode":60800,"name":"AssetBank"},"name":"Bank Accounts","units":0,"debits":0,"credits":0,"unitsPrev":0,"debitsPrev":0,"creditsPrev":0,"balancePrev":0},{"accountClass":"S","accountCode":"60400/bank","accountType":{"label":"Asset - Bank","minCode":60400,"maxCode":60800,"name":"AssetBank"},"name":"CBA BANK","units":null,"debits":271108.47,"credits":0,"unitsPrev":null,"debitsPrev":271108.47,"creditsPrev":0,"balancePrev":271108.47},{"accountClass":"C","accountCode":"60800","accountType":{"label":"Asset - Bank","minCode":60400,"maxCode":60800,"name":"AssetBank"},"name":"Term Deposits","units":0,"debits":0,"credits":0,"unitsPrev":0,"debitsPrev":0,"creditsPrev":0,"balancePrev":0},{"accountClass":"S","accountCode":"60800/TD001","accountType":{"label":"Asset - Bank","minCode":60400,"maxCode":60800,"name":"AssetBank"},"name":"TD Macquarie","units":null,"debits":116000,"credits":0,"unitsPrev":null,"debitsPrev":116000,"creditsPrev":0,"balancePrev":116000},{"accountClass":"C","accountCode":"77200","accountType":{"label":"Investment","minCode":70000,"maxCode":79999,"name":"Investment"},"name":"Real Estate Properties ( Australian - Residential)","units":0,"debits":0,"credits":0,"unitsPrev":0,"debitsPrev":0,"creditsPrev":0,"balancePrev":0},{"accountClass":"S","accountCode":"77200/5smithst","accountType":{"label":"Investment","minCode":70000,"maxCode":79999,"name":"Investment"},"name":"5 Smith Street, Collingwood","units":1,"debits":600000,"credits":0,"unitsPrev":1,"debitsPrev":600000,"creditsPrev":0,"balancePrev":600000},{"accountClass":"C","accountCode":"77600","accountType":{"label":"Investment","minCode":70000,"maxCode":79999,"name":"Investment"},"name":"Shares in Listed Companies (Australian)","units":0,"debits":0,"credits":0,"unitsPrev":0,"debitsPrev":0,"creditsPrev":0,"balancePrev":0},{"accountClass":"S","accountCode":"77600/01OO.L","accountType":{"label":"Investment","minCode":70000,"maxCode":79999,"name":"Investment"},"name":"NORDIC INVESTMENT BANK 5.25% BDS 26/11/2019 GBP(VAR)","units":1000,"debits":10000,"credits":0,"unitsPrev":1000,"debitsPrev":10000,"creditsPrev":0,"balancePrev":10000},{"accountClass":"S","accountCode":"77600/A2M.AX","accountType":{"label":"Investment","minCode":70000,"maxCode":79999,"name":"Investment"},"name":"The A2 Milk Company Limited","units":100000,"debits":175000,"credits":0,"unitsPrev":100000,"debitsPrev":175000,"creditsPrev":0,"balancePrev":175000},{"accountClass":"S","accountCode":"77600/CBA.AX","accountType":{"label":"Investment","minCode":70000,"maxCode":79999,"name":"Investment"},"name":"Commonwealth Bank Of Australia.","units":3159,"debits":234934.83,"credits":0,"unitsPrev":3159,"debitsPrev":234934.83,"creditsPrev":0,"balancePrev":234934.83},{"accountClass":"S","accountCode":"77600/CLH.AX","accountType":{"label":"Investment","minCode":70000,"maxCode":79999,"name":"Investment"},"name":"Collection House Limited","units":20818,"debits":22899.8,"credits":0,"unitsPrev":20818,"debitsPrev":22899.8,"creditsPrev":0,"balancePrev":22899.8},{"accountClass":"S","accountCode":"77600/MQG.AX","accountType":{"label":"Investment","minCode":70000,"maxCode":79999,"name":"Investment"},"name":"Macquarie Group Limited","units":1589,"debits":109482.1,"credits":0,"unitsPrev":1589,"debitsPrev":109482.1,"creditsPrev":0,"balancePrev":109482.1},{"accountClass":"S","accountCode":"77600/NAB.AX","accountType":{"label":"Investment","minCode":70000,"maxCode":79999,"name":"Investment"},"name":"National Australia Bank Limited","units":970,"debits":24667.1,"credits":0,"unitsPrev":970,"debitsPrev":24667.1,"creditsPrev":0,"balancePrev":24667.1},{"accountClass":"S","accountCode":"77600/RRL.AX","accountType":{"label":"Investment","minCode":70000,"maxCode":79999,"name":"Investment"},"name":"Regis Resources Limited","units":40000,"debits":136800,"credits":0,"unitsPrev":40000,"debitsPrev":136800,"creditsPrev":0,"balancePrev":136800},{"accountClass":"S","accountCode":"77600/TLS.AX","accountType":{"label":"Investment","minCode":70000,"maxCode":79999,"name":"Investment"},"name":"Telstra Corporation Limited.","units":10000,"debits":55600,"credits":0,"unitsPrev":10000,"debitsPrev":55600,"creditsPrev":0,"balancePrev":55600},{"accountClass":"S","accountCode":"77600/TSE.AX","accountType":{"label":"Investment","minCode":70000,"maxCode":79999,"name":"Investment"},"name":"Transfield Services Limited","units":20000,"debits":21100,"credits":0,"unitsPrev":20000,"debitsPrev":21100,"creditsPrev":0,"balancePrev":21100},{"accountClass":"S","accountCode":"77600/VOC.AX","accountType":{"label":"Investment","minCode":70000,"maxCode":79999,"name":"Investment"},"name":"Vocus Communications Limited","units":6667,"debits":56802.84,"credits":0,"unitsPrev":6667,"debitsPrev":56802.84,"creditsPrev":0,"balancePrev":56802.84},{"accountClass":"C","accountCode":"77700","accountType":{"label":"Investment","minCode":70000,"maxCode":79999,"name":"Investment"},"name":"Shares in Listed Companies (Overseas)","units":0,"debits":0,"credits":0,"unitsPrev":0,"debitsPrev":0,"creditsPrev":0,"balancePrev":0},{"accountClass":"S","accountCode":"77700/AAPL.NDQ2","accountType":{"label":"Investment","minCode":70000,"maxCode":79999,"name":"Investment"},"name":"Apple Inc.","units":100,"debits":12873.69,"credits":0,"unitsPrev":100,"debitsPrev":12873.69,"creditsPrev":0,"balancePrev":12873.69},{"accountClass":"C","accountCode":"78200","accountType":{"label":"Investment","minCode":70000,"maxCode":79999,"name":"Investment"},"name":"Units in Listed Unit Trusts (Australian)","units":0,"debits":0,"credits":0,"unitsPrev":0,"debitsPrev":0,"creditsPrev":0,"balancePrev":0},{"accountClass":"S","accountCode":"78200/CFM0404AU","accountType":{"label":"Investment","minCode":70000,"maxCode":79999,"name":"Investment"},"name":"CFS WS Aust Share Fund Core","units":10000,"debits":13679,"credits":0,"unitsPrev":10000,"debitsPrev":13679,"creditsPrev":0,"balancePrev":13679},{"accountClass":"N","accountCode":"84000","accountType":{"label":"Liability","minCode":80000,"maxCode":89999,"name":"Liability"},"name":"GST Payable/Refundable","units":null,"debits":0,"credits":617.85,"unitsPrev":null,"debitsPrev":0,"creditsPrev":617.85,"balancePrev":-617.85},{"accountClass":"N","accountCode":"85000","accountType":{"label":"Liability","minCode":80000,"maxCode":89999,"name":"Liability"},"name":"Income Tax Payable/Refundable","units":null,"debits":0,"credits":3916.55,"unitsPrev":null,"debitsPrev":0,"creditsPrev":3916.55,"balancePrev":-3916.55},{"accountClass":"N","accountCode":"89000","accountType":{"label":"Liability","minCode":80000,"maxCode":89999,"name":"Liability"},"name":"Deferred Tax Liability/Asset","units":null,"debits":8274.47,"credits":0,"unitsPrev":null,"debitsPrev":8274.47,"creditsPrev":0,"balancePrev":8274.47},{"accountClass":"N","accountCode":"91000","accountType":{"label":"Unallocated","minCode":90000,"maxCode":99999,"name":"Unallocated"},"name":"Bank Data Clearing Account","units":null,"debits":0,"credits":25039.88,"unitsPrev":null,"debitsPrev":0,"creditsPrev":25039.88,"balancePrev":-25039.88},{"accountClass":"N","accountCode":"94910","accountType":{"label":"Unallocated","minCode":90000,"maxCode":99999,"name":"Unallocated"},"name":"Investment Movement Data Clearing Account","units":null,"debits":61884,"credits":0,"unitsPrev":null,"debitsPrev":61884,"creditsPrev":0,"balancePrev":61884},{"accountClass":"N","accountCode":"99800","accountType":{"label":"Unallocated","minCode":90000,"maxCode":99999,"name":"Unallocated"},"name":"Unspecified Data Clearing Account","units":null,"debits":0,"credits":332884,"unitsPrev":null,"debitsPrev":0,"creditsPrev":332884,"balancePrev":-332884}]}}