Click on images to expand in a new tab
Overview
The Client Web Portal displays investment performance, portfolio values, asset allocation and document information using data stored in AdviserLogic. Most figures shown in the portal are sourced directly from AdviserLogic reports, allowing you to reconcile the information clients see with your internal records.
This article explains how each value is calculated, where the data originates, and how you can verify the results within AdviserLogic.
Your Annual Investment Performance
The Annual Investment Performance card provides a summary of portfolio performance over the selected date range.
Dates
The end date will default to the last full trading day.
The start date will default to today’s date for the previous calendar year.
Ending Balance
The Ending Balance represents the total value of all investment and superannuation holdings at the close of business on the selected end date.
This value matches the Market Value column in the Valuation Report.
Total Gain
Total Gain shows the increase or decrease in portfolio value over the selected period, excluding management fees.
This matches the Income & Growth column in the Income & Growth Report.
Calculation
Total Gain = (Value at End) − (Value at Start) − (Additions − Withdrawals) + Income
Where:
Value at End = Units at End × Price at End
Value at Start = Units at Start × Price at Start
Additions = Contributions and Purchases
Withdrawals = Redemptions and Sales
Cumulative Contribution
Cumulative Contribution displays the portfolio rate of return for the selected period.
For reporting periods of one year or less, this matches the Actual ROR column in the Income & Growth Report.
For portfolios, the displayed value is the weighted average return across all holdings.
For individual holdings of one year or less:
Net Return = Income & Growth ÷ (Value at Start + Additions)
Recalculating XIRR
Go to the Assets & Liabilities tab > Assets
For a selected holding, hover over the vertical ellipsis (three dots) and select Transaction List from the drop-down.
Highlight the transactions, copy (Ctrl + c), and paste (Ctrl + v) them into an Excel spreadsheet.
Delete any transactions that fall outside of the date range.
For holdings that start after inception, add a row for the starting balance, noting the start date in the Date column, and add the balance at this date in the Amount column. (The balance at the start date can be taken from the Value at Start column on the Income & Growth Report in AdviserLogic if the report is configured to the same dates.)
For holdings that remain in place after the end date, add a row for the ending balance, noting the end date in the Date column, and add the balance at this date in the Amount column. (The balance at the end date can be taken from the Value at End column on the Income & Growth Report in AdviserLogic if the report is configured to the same dates.)
Sort the data by date, with the earliest date first.
Ensure that the start balance and any contributions are negative values.
Ensure that the end balance and any withdrawals or income are positive values.
In a new cell in the excel sheet, click Formulas > Financial > XIRR
In the values field, select the range of cells in the Amount column.
In the date field, select the range of cells in the Date column.
The result will equal the Net Returns figure on the Client Wealth Portal.
A worked example of this calculation is available in Excel for further reference.
Cumulative Contribution – Additions
This value shows all contributions and purchases made during the selected period.
It matches the Additions column in the Income & Growth Report.
Calculation
Additions = Sum of all contributions and purchases
Cumulative Contribution – Withdrawals
This value shows all withdrawals, redemptions and sales made during the selected period.
It matches the Withdrawals column in the Income & Growth Report.
Calculation
Withdrawals = Sum of all redemptions and sales
Your Top Holdings and Asset Allocation
Asset Allocation %
The Asset Allocation section displays how investments are distributed across asset classes.
The percentages displayed match the Asset Allocation Report in AdviserLogic.
Top 10 Allocated Holdings
This card lists the top 10 holdings across the entire portfolio based on Market Value.
The Amount column displays the Market Value of each holding.
The Weight column displays the Market Value of a holding / the Market Value of the Portfolio.
Your Net Worth
This section provides an overview of all investment accounts, displaying each account name and its corresponding balance. Lifestyle assets are not included.
Your Accounts (Net Worth)
Net Worth is calculated as
Total Assets − Total Debts
Assets
Includes balances for
Superannuation
Investment portfolios
Cash accounts
Balances may be displayed at the platform level or as consolidated off-platform assets.
Debts
Includes liabilities such as:
Loans
Credit cards
Other recorded debts
Documents
This card provides an overview of any files/documents shared by the adviser or client for mutual visibility.
Name
For any documents filed under a Category in the Document Vault, the category will appear as a folder name in this field.
Files that have not been assigned a category will be listed directly, with the file name appearing under the Name column.
Read
Will state read if the file has been opened.
Folders will have a blank status, as the status will only apply to the underlying files.
Modified
Shows the date that the file was last saved to the Document Vault.
Folders will have a blank date as the modified date will only apply to the underlying files.
Investment Summary
Refer to the Overview section for explanations and calculations of the following :
How are my investments doing?
Ending Balance
The blue Ending Balance line on the chart maps the Total Portfolio Value at the end of each month the nominated timeframe.
The Ending Balance figure is the total portfolio balance as at the close of business for the nominated end date.
Cumulative Contribution
The red Cumulative Contribution line on the chart maps the sum of Additions minus the sum of Withdrawals at the end of each month during the nominated timeframe.
The Cumulative Contribution figure is the net investment (Additions – Withdrawals) during the nominated timeframe.
How are my investments diversified?
The asset allocation pie chart matches the pie chart on the Overview page.
How much have my investments grown?
This bar chart shows how your investments have performed over the selected period. This is taken from the Actual ROR in the Income and Growth Report.
To replicate each amount in AdviserLogic select the date range (eg. 01/01/2022 - 31/01/2022) in the Income & Growth Report and refer to the Actual ROR column or calculate this manually as outlined in the Overview section.
It is calculated monthly when 1 year or less is selected as the duration and yearly when more than 1 year is selected.
Since the period selected is always less than 1 year, it refers to the Actual ROR for that period.
Which of my accounts are included?
Value
The value is equal to the End Balance on the Overview page
Value = Units at End * Price at End
Net Investment
The Net Investment is equal to Additional minus Withdrawals for the nominated timeframe.
Where a different date range is specified to the Overview page, the value will capture the difference between Additions and Withdrawals for that range.
Returns
The Returns figure shows the net returns over the nominated timeframe.
Where a different date range to the Overview page is specified, the value will capture the Net Returns figure for that range.
Inception Date
This field shows the date of the first investment in the specified holding and is not impacted by the nominated timeframe.
Holdings in My Household
Value
The value is the End Balance for each holding.
Weight
The Weight is the proportional value of the holding relative to the total portfolio value.
Weight = Value / Total Portfolio Value and is expressed as a percentage.
Shares
The number of shares held in the specified holding at the End Date.
Security Type
This field shows the classification based on Morningstar data.