Report - Investment Summary with Data Source
GET {{baseUrl}}/fund/investmentSummaryWithSource?format={{format}}&fundId={{fundId}}&start={{start}}&end={{end}}
Allows you to retrieve List of Individual Summaries with data source, charts of account ( name and code ), security code and security type.
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
Request Params
| Key | Datatype | Required | Description |
|---|---|---|---|
format | string | [OPTIONAL] Will return data in json or xml. Is optional and if not supplied data will be returned in json. | |
fundId | string | [REQUIRED] The unique fund id | |
start | string | [OPTIONAL] Start date of Investment Report. Expected format : yyyy-mm-dd | |
end | string | [OPTIONAL] End date of Investment Report. Expected format : yyyy-mm-dd |
HEADERS
| Key | Datatype | Required | Description |
|---|---|---|---|
Authorization | string |
RESPONSES
status: OK
{"investmentSummaryWithSource":{"fundId":"8a9c9e744ebc893a014ebd429dea000c","start":"2017-06-30T14:00:00Z","end":"2018-06-30T13:59:59Z","data":[{"securityCode":null,"securityType":null,"investType":null,"marketPriceDate":null,"units":null,"marketPrice":188096.5,"averageCost":188096.5,"accountingCost":188096.5,"currentYearUnRealisedMovement":null,"portfolioWeight":0,"unRealisedMovement":null,"dataSource":"SF360","controlChartAccountCode":"60400","controlChartAccountName":"Cash/Bank Accounts","subChartAccountName":"CBA BANK","subChartAccountCode":"bank","marketValueAsPerLedger":188096.5,"marketValue":188096.5},{"securityCode":null,"securityType":null,"investType":null,"marketPriceDate":null,"units":null,"marketPrice":116000,"averageCost":116000,"accountingCost":116000,"currentYearUnRealisedMovement":null,"portfolioWeight":0,"unRealisedMovement":null,"dataSource":"SF360","controlChartAccountCode":"60800","controlChartAccountName":"Cash/Bank Accounts","subChartAccountName":"TD Macquarie","subChartAccountCode":"TD001","marketValueAsPerLedger":116000,"marketValue":116000},{"securityCode":"CFM0404AU","securityType":null,"investType":"UUT","marketPriceDate":"2017-08-28","units":10000,"marketPrice":1.3789,"averageCost":10,"accountingCost":100000,"currentYearUnRealisedMovement":-0.86,"portfolioWeight":0,"unRealisedMovement":-86211,"dataSource":"SF360","controlChartAccountCode":"78200","controlChartAccountName":"Units in Listed Unit Trusts (Australian)","subChartAccountName":"CFS WS Aust Share Fund Core","subChartAccountCode":"CFM0404AU","marketValueAsPerLedger":100000,"marketValue":13789},{"securityCode":"AAPL.NDQ","securityType":"Ordinary_Shares","investType":"NASDAQ","marketPriceDate":"2017-08-29","units":100,"marketPrice":205.5387,"averageCost":100,"accountingCost":10000,"currentYearUnRealisedMovement":1.06,"portfolioWeight":0,"unRealisedMovement":10553.87,"dataSource":"SF360","controlChartAccountCode":"77700","controlChartAccountName":"Shares in Listed Companies (Overseas)","subChartAccountName":"Apple Inc.","subChartAccountCode":"AAPL.NDQ2","marketValueAsPerLedger":10000,"marketValue":20553.87},{"securityCode":"5smithst","securityType":"Ordinary_Shares","investType":"MANUAL","marketPriceDate":"2016-06-30","units":1,"marketPrice":600000,"averageCost":750000,"accountingCost":750000,"currentYearUnRealisedMovement":-0.2,"portfolioWeight":0,"unRealisedMovement":-150000,"dataSource":"SF360","controlChartAccountCode":"77200","controlChartAccountName":"Real Estate Properties ( Australian - Residential)","subChartAccountName":"5 Smith Street, Collingwood","subChartAccountCode":"5smithst","marketValueAsPerLedger":750000,"marketValue":600000},{"securityCode":null,"securityType":null,"investType":null,"marketPriceDate":null,"units":null,"marketPrice":83011.97,"averageCost":83011.97,"accountingCost":83011.97,"currentYearUnRealisedMovement":null,"portfolioWeight":0,"unRealisedMovement":null,"dataSource":"CSVBank","controlChartAccountCode":"60400","controlChartAccountName":"Cash/Bank Accounts","subChartAccountName":"CBA BANK","subChartAccountCode":"bank","marketValueAsPerLedger":83011.97,"marketValue":83011.97},{"securityCode":"01OO.L","securityType":"Ordinary_Shares","investType":"LSE","marketPriceDate":null,"units":1000,"marketPrice":0,"averageCost":10,"accountingCost":10000,"currentYearUnRealisedMovement":-1,"portfolioWeight":0,"unRealisedMovement":-10000,"dataSource":"SF360","controlChartAccountCode":"77600","controlChartAccountName":"Shares in Listed Companies (Australian)","subChartAccountName":"NORDIC INVESTMENT BANK 5.25% BDS 26/11/2019 GBP(VAR)","subChartAccountCode":"01OO.L","marketValueAsPerLedger":10000,"marketValue":0},{"securityCode":"A2M.AX","securityType":"Ordinary_Shares","investType":"ASX","marketPriceDate":"2017-08-29","units":100000,"marketPrice":5.02,"averageCost":0.8,"accountingCost":80000,"currentYearUnRealisedMovement":5.28,"portfolioWeight":0,"unRealisedMovement":422000,"dataSource":"CSVBroker","controlChartAccountCode":"77600","controlChartAccountName":"Shares in Listed Companies (Australian)","subChartAccountName":"The A2 Milk Company Limited","subChartAccountCode":"A2M.AX","marketValueAsPerLedger":80000,"marketValue":502000},{"securityCode":"CBA.AX","securityType":"Ordinary_Shares","investType":"ASX","marketPriceDate":"2017-08-29","units":3159,"marketPrice":75.73,"averageCost":65.24,"accountingCost":206090.48,"currentYearUnRealisedMovement":0.16,"portfolioWeight":0,"unRealisedMovement":33140.59,"dataSource":"SF360","controlChartAccountCode":"77600","controlChartAccountName":"Shares in Listed Companies (Australian)","subChartAccountName":"Commonwealth Bank Of Australia.","subChartAccountCode":"CBA.AX","marketValueAsPerLedger":206090.48,"marketValue":239231.07},{"securityCode":"CLH.AX","securityType":"Ordinary_Shares","investType":"ASX","marketPriceDate":"2017-08-29","units":818,"marketPrice":1.32,"averageCost":0.95,"accountingCost":780,"currentYearUnRealisedMovement":0.38,"portfolioWeight":0,"unRealisedMovement":299.76,"dataSource":"SF360","controlChartAccountCode":"77600","controlChartAccountName":"Shares in Listed Companies (Australian)","subChartAccountName":"Collection House Limited","subChartAccountCode":"CLH.AX","marketValueAsPerLedger":780,"marketValue":1079.76},{"securityCode":"MQG.AX","securityType":"Ordinary_Shares","investType":"ASX","marketPriceDate":"2017-08-29","units":1589,"marketPrice":86.13,"averageCost":60.43,"accountingCost":96015.7,"currentYearUnRealisedMovement":0.43,"portfolioWeight":0,"unRealisedMovement":40844.87,"dataSource":"SF360","controlChartAccountCode":"77600","controlChartAccountName":"Shares in Listed Companies (Australian)","subChartAccountName":"Macquarie Group Limited","subChartAccountCode":"MQG.AX","marketValueAsPerLedger":96015.7,"marketValue":136860.57},{"securityCode":"CLH.AX","securityType":"Ordinary_Shares","investType":"ASX","marketPriceDate":"2017-08-29","units":20000,"marketPrice":1.32,"averageCost":1.05,"accountingCost":21000,"currentYearUnRealisedMovement":0.26,"portfolioWeight":0,"unRealisedMovement":5400,"dataSource":"CSVBroker","controlChartAccountCode":"77600","controlChartAccountName":"Shares in Listed Companies (Australian)","subChartAccountName":"Collection House Limited","subChartAccountCode":"CLH.AX","marketValueAsPerLedger":21000,"marketValue":26400},{"securityCode":"NAB.AX","securityType":"Ordinary_Shares","investType":"ASX","marketPriceDate":"2017-08-29","units":970,"marketPrice":30.08,"averageCost":44.54,"accountingCost":43200.77,"currentYearUnRealisedMovement":-0.32,"portfolioWeight":0,"unRealisedMovement":-14023.17,"dataSource":"SF360","controlChartAccountCode":"77600","controlChartAccountName":"Shares in Listed Companies (Australian)","subChartAccountName":"National Australia Bank Limited","subChartAccountCode":"NAB.AX","marketValueAsPerLedger":43200.77,"marketValue":29177.6},{"securityCode":"TLS.AX","securityType":"Ordinary_Shares","investType":"ASX","marketPriceDate":"2017-08-29","units":10000,"marketPrice":3.84,"averageCost":5,"accountingCost":50000,"currentYearUnRealisedMovement":-0.23,"portfolioWeight":0,"unRealisedMovement":-11600,"dataSource":"SF360","controlChartAccountCode":"77600","controlChartAccountName":"Shares in Listed Companies (Australian)","subChartAccountName":"Telstra Corporation Limited.","subChartAccountCode":"TLS.AX","marketValueAsPerLedger":50000,"marketValue":38400},{"securityCode":"RRL.AX","securityType":"Ordinary_Shares","investType":"ASX","marketPriceDate":"2017-08-29","units":40000,"marketPrice":4.05,"averageCost":2.5,"accountingCost":100000,"currentYearUnRealisedMovement":0.62,"portfolioWeight":0,"unRealisedMovement":62000,"dataSource":"CSVBroker","controlChartAccountCode":"77600","controlChartAccountName":"Shares in Listed Companies (Australian)","subChartAccountName":"Regis Resources Limited","subChartAccountCode":"RRL.AX","marketValueAsPerLedger":100000,"marketValue":162000},{"securityCode":"TSE.AX","securityType":"Ordinary_Shares","investType":"ASX","marketPriceDate":"2015-11-03","units":20000,"marketPrice":1.055,"averageCost":1,"accountingCost":20000,"currentYearUnRealisedMovement":0.06,"portfolioWeight":0,"unRealisedMovement":1100,"dataSource":"CSVBroker","controlChartAccountCode":"77600","controlChartAccountName":"Shares in Listed Companies (Australian)","subChartAccountName":"Transfield Services Limited","subChartAccountCode":"TSE.AX","marketValueAsPerLedger":20000,"marketValue":21100},{"securityCode":"VOC.AX","securityType":"Ordinary_Shares","investType":"ASX","marketPriceDate":"2017-08-29","units":6667,"marketPrice":2.39,"averageCost":7.5,"accountingCost":50000,"currentYearUnRealisedMovement":-0.68,"portfolioWeight":0,"unRealisedMovement":-34065.87,"dataSource":"CSVBroker","controlChartAccountCode":"77600","controlChartAccountName":"Shares in Listed Companies (Australian)","subChartAccountName":"Vocus Communications Limited","subChartAccountCode":"VOC.AX","marketValueAsPerLedger":50000,"marketValue":15934.13}]}}