The Investment tab within the Review stage pulls portfolio data directly from Xplan. Understanding where each data point originates helps you verify figures, troubleshoot discrepancies, and ensure the correct portfolios and date ranges are in scope before presenting to clients.
The Investment tab is divided into six sub-tabs: Overview, Summary, Valuation, Performance, Asset Allocation, and Fund Investment Performance.
💡 Note: Data is sourced from Xplan at the time the Review is generated. If portfolio data has been updated in Xplan after the Review was created, use the refresh or re-import function to pull through the latest figures.
How data is organised
Within Advice Designer, investment data is segmented by entity — individual clients, joint holdings, and any related entities such as an SMSF. Use the entity tabs (e.g. Combined, Client, Partner, Joint, SMSF, Company, Trust) to view data for each party separately or in aggregate.
This mirrors Xplan's portfolio structure, where each entity holds its own portfolio and accounts.
Overview
In Xplan, navigate to Portfolios → Analytics and select the Detail (AUD) tab. Set View selected portfolios to include all relevant entities. Ensure the From and To dates match the Review period dates to reconcile figures.
Advice Designer location: Investment → Overview
Xplan source: Portfolios → Analytics → Detail (AUD) tab
💡Note: The only number AD derives locally is "additions less withdrawals" in generateOverallProgress (End − Start − Income − Total gain)
Summary
The Combined view in Advice Designer aggregates all entities.
Advice Designer location: Investment → Summary
Xplan source: Portfolios → Analytics → Summary (AUD) tab
Select the relevant entity from the portfolio selector dropdown at the top of the Xplan Analytics page to view per-entity figures.
Valuation
The Valuation tab lists all portfolio holdings as at the Review date, broken down by entity and account.
Advice Designer location: Investment → Valuation
Xplan source: Portfolios → Position (Holdings Overview)
In Xplan, navigate to Portfolios → Position and expand Filter Options for Holdings Overview. Ensure the Date is set to match the Review date and all relevant portfolios are selected (tick all entities in the portfolio selector row). Grouping should be set to Portfolio, Account.
Performance
The Performance tab shows detailed return metrics at both the combined and individual entity level. Expanding to account level in Advice Designer corresponds to the account-level breakdown available in Xplan's Analytics.
Advice Designer location: Investment → Performance
Xplan source: Portfolios → Analytics → Detail (AUD) tab/Portfolio (AUD) tab
Use the Detail (AUD) tab in Xplan Analytics for the full column set. Use the Portfolio (AUD) tab to verify standard time-period returns (1m, 3m, 6m, 1y) at the account level. Ensure the date range and fees/taxes setting (Before Fees and Taxes) match across both platforms.
Asset Allocation
The Asset Allocation tab displays the client's current portfolio allocation by asset class, compared against their target (risk profile) allocation.
Advice Designer location: Investment → Asset Allocation
Xplan source: Portfolios → Asset Allocation → Asset Class Allocations tab
Fund Investment Performance
The Fund Investment Performance tab shows standardised time-period returns at the individual security (fund) level, along with investment cost percentages.
Advice Designer location: Investment → Fund Investment Performance
Xplan source: Portfolios → Position → Analysis section → Analytics tab (Security Risk & Return)
