The Investments tab where you enter the details of any Investment Holding Accounts held by the portfolio.
The Auto Complete button uses the security list in Class to fill in the description and market type of a security or managed fund. This section shows how to use this.
Please note foreign investment assets are not supported. These will need to be manually entered.
To use the Auto Complete button, open the Excel Loader and follow the below steps.
- Select Investments tab.
- Enter the ASX code or the managed fund APIR code into either the Account Code or the Security Issue Code columns.
Note: Entering details into the Account Code column will auto-complete the Holding Description, Security Issue Code and Market Type if the investment is found in Class. However, entering the details into the Security Issue Code will not fill in the Account Code but will fill the Holding Description and the Market Type fields.
- Once the codes have been entered, click on the Auto Complete Investment Details button.
When loading unlisted investments, if the security already exists in Class, the Auto Complete button will work. Make sure you enter the account code exactly as it is in Class. If you would like to create a new security in Class, select market type as Unlisted Market and enter in a unique security issue code.
Review the Opening Balances Tab