Business Dashboard Report Overview

The Business Dashboard Report gives you the ability to extract client information from your XPLAN database for reporting and analysis. Targeted client information can be reported on by selecting the required Worksheet(s):

• Client Snapshot: A segmented report of your Practice’s clients that enables you to analyse FOFA, funds under management (FUM) and revenues information at Adviser and Client level.
  
  
• Referrer Snapshot: Allows you to report on and analyse the clients referred to yourPractice from various referral sources, and enables you to measure the value of each referrer to your business.

If you’d like further information about the client information (or data) displayed in each Worksheet and where this data is sourced, please refer to the following Appendices:

• Appendix 1: What is displayed in each Worksheet?
  
  
• Appendix 2: How is your clients' data sourced?

When should I merge the report and how long will it take?

Due to the processing resources required and time it will take to merge the Business Dashboard Report, it is highly recommended you merge it after business hours.

The estimated time it will take to merge is based on the number of clients to be reported on:

How to merge the Business Dashboard Report

To merge (or generate) the Business Dashboard Report:

1. Click List and then Entire List in the search area of the Title Bar (at the top right-hand corner of the screen):
   
   
   • Alternatively, to generate a list of targeted clients click Advanced in the search area of the Title Bar (at the top right-hand corner of the screen), and select the required Saved Search or create a new Advanced Search.
     
     
     
     
2. In the Search Filter panel, the following filters are recommended:
   
   
   • From the Entity Status dropdown list, select as required (e.g. Client and Prospect) and click Ok:
     
     
     
     
   • For Client Adviser, ensure All Users is selected.
     
     
   • For User Group, ensure the required Practice (or group) is selected.
     
     
   • For Categories, ensure All Categories is selected.
     
     
     
     
   • From the Type dropdown list, select the required client types and click Ok:
     
     
     
     
3. The client list to be reported on will be displayed in the Search Result panel.
   
   
   • If no clients are selected (ticked), all clients will be displayed in report
     
     
   • If some clients are selected, only those selected (ticked) will be displayed in the report
     
     
4. From the menu on the left-hand side, go to Merge Wizard > Business Dashboard Wizard.
   
   
5. Enter a unique and meaningful Scenario Name (e.g. June 2018) and click Create Scenario.
   
   
6. In the Business Dashboard Report Settings panel, it is recommended the Include Related Entities? option is ticked:
   
   
   
   
7. In the Worksheets to include panel, select (tick) the Worksheets required in the Business Dashboard Report:
   
   
   • Client Snapshot
     
     
   • Referrer Snapshot
     
     
8. The Client Snapshot Grouping Options panel will be displayed if you’ve selected Client Snapshot in Step 7 above. Select how you would like your clients grouped in the merged Worksheet:
   
   
   • Category (service package)
     
     
   • Strategy Choice (Where to Play (WTP) segmentation)
     
     
9. In the Revenue Settings panel, select the Reporting Period required: Last 12 months (default), Last 6 months, Last 3 months, or Custom date range.
   
   
10. Click Next.
    
    
11. Click Merge Report.
    
    
12. Select the Target clients for inclusion in the Business Dashboard Report:
    
    
    • All Listed Clients will include all clients in your Search Results
      
      
    • Only Selected Clients will include only the clients selected in your Search Results
      
      
13. The Business Dashboard Report will be merged in the background. Click Ok.
    
    
14. When the Report has been merged, click the letter icon to display the new system message.
    
    
15. Click Download Report to download the file (it will be an Excel spreadsheet).

Appendix 1: What is displayed in each Worksheet?

Client Snapshot

The Client Snapshot is a segmented report of your Practice’s clients that enables you to analyse FOFA, funds under management (FUM) and revenues information at Adviser and Client level.

The Summary and Graph provide an overview of the number of clients in the selected grouping for each Adviser and the revenues (fees) received from those clients.

The Detailed section of the report displays the information captured for each client, including:

• Master client’s name, and their related entities and entity status
  
  
• Category (service package) and WTP Strategy Choices Segmentation
  
  
• FOFA information, such as Next Disclosure Statement Date and Next Opt-in Date
  
  
• Next Review Date and Referrer
  
  
• Financial information, such as funds under management (FUM) and fees paid (ongoing advice, trail commissions, insurance commissions and upfront fees)

The clients displayed in the Detailed section of the report are grouped as follows:

• Adviser; then
  
  
• Category (service package) or Where to Play (WTP) Strategy Choices Segmentation, as selected when merging the report; then
  
  
• Master entity (or client).

Referrer Snapshot

The Referrer Snapshot allows you to report on and analyse the clients referred to your Practice from various referral sources, and enables you to measure the value of that referrer to your business.

The Summary and Graph provide an overview of the number of clients referred by each referral source and the revenues (fees) received from those clients. Referral sources include:

• Existing clients that have referred another client
  
  
• Individual Referrers that have referred a client
  
  
• Individual Referrers within Referrer Companies that have referred a client

The Detailed section of the report displays the information captured for each client, including:

• Master client’s name, and their related entities and entity status
  
  
• Category (service package) and WTP Strategy Choices Segmentation
  
  
• Financial information, such as funds under management (FUM) and revenues

The clients displayed in the Detailed section of the report are grouped as follows:

• Referrer Company; then
  
  
• Referrer Individual; then
  
  
• Master entity (or client).

Appendix 2: How is your clients' data sourced?

The table below outlines where the information displayed for each client in the Worksheet columns is sourced from:

The table below outlines how the fees displayed in the Worksheets have been calculated from the CommPay policies mapped to each client. If you have any queries regarding your clients’ CommPay data, send an email to your Wealth Axis Adviser at support@wealthaxis.com.au