Portfolio Review Report (Bulk) Overview

The Portfolio Review Report Wizard enables you to easily merge a customised Portfolio Review Report (PRR) for the selected client that is pre-populated with their data recorded in XPLAN. You can:

• Produce a single report for a couple, or for a couple and their related entities.
  
• Produce consolidated reports for your client’s portfolios, providing a combined view of the accounts and assets held by the client, their spouse and related entities.
  
• Select/deselect the portfolio reports to be included, and how you’d like the information to be displayed in the client’s merged report.
  
• Select/deselect other sections to be included in the report, such the client’s goals and objectives, attitude to investing, insurance, and estate planning.
  
• Nominate the reporting start and end dates.
  
• Include a Tax File Number (TFN) Consent Form and Electronic Consent Form at the end of the merged PRR.
  

What’s more, you have the flexibility to include two of each of the Portfolio (IPS) Reports with different date ranges and grouping preferences, as required. For example, you could include two Portfolio Valuations for comparison purposes – one for year ending 30 June 2017 grouped by Position, and one for year ending 31 December 2017 grouped by Product.

You also have the ability to select your Practice’s ‘My Business’ Cover Letter and preferred header and footer to be displayed on merged PRRs. To find out how, in the Zendesk go to Custom Settings:

• Your Practice Cover Letters
  
• Your Practice logos
  

Did you know that you can also merge PRRs for groups of clients in bulk? To find out more, in Zendesk go to Reports > Portfolio Review Report (Individual).

How do I merge Portfolio Review Reports in bulk

To merge (or generate) Portfolio Review Reports for a list of clients:

1. Click Advanced in the search area of the Title Bar (at the top right-hand corner of the screen):
   
2. Select the required Advanced Search or create a new Advanced Search to generate the list of clients.
   
3. A list of clients that meet the Advanced Search criteria will be displayed in the Search Result panel.
   
4. In the Search Filter panel, from the View dropdown list select Related Entities
   
1. Use this filter option to avoid merging two or more reports for a couple and their related entities
   
   
   
   
5. Select the clients to be included the PRR Bulk Merge, if required.
   
1. If no clients are selected (ticked), PRRs will be merged for all clients
   
2. If some clients are selected, PRRs will only be merged for those selected
   
6. From the menu on the left-hand side, go to Merge Wizard > Portfolio Review Report Bulk Wizard.
   
7. Enter a unique and meaningful Scenario Name (e.g. February 2018 PRR) and click Create Scenario.
   
8. In the Portfolio Review Report Details panel, select/enter as required:
   
1. Tick Include Related Entities to include details of portfolios owned by entities associated with the Client or Partner, e.g. their self-managed super fund.
   

2. In the Cover Letter dropdown list, select where it is to be displayed in the merged PRR: Before the Cover Page or After the Cover Page (or select No if a cover letter is not required).
   

3. The Use My Business Cover Letter dropdown list will be displayed if you’ve selected to include a cover letter:
   

   • Select Yes to use My Business cover letter, as set up by your Practice at Group Menu > Cover Letters.
     

   • Select No to use the standard cover letter.
     

4. For Sections to Include, select the required sections in the merged PRR.
   

5. Insurance Layout: Schedule or Table.
   

6. Attitude to Investing Pie Chart: Risk Profile Only, Current Allocation Only, Both Risk Profile and Current Allocation.
   

7. Disclaimer Position: After IPS Reports, End of Document.
   

8. Include Market Commentary: Yes or No.
   
   
   
   

9. In the Additional Forms panel, select the options required:
   

1. Include Tax File Number (TFN) Consent Form: Yes or No.
   

2. Include Electronic Consent Form: Yes or No.
   
   

10. In the Investment Report Details panel, select/enter as required:
    
    This panel will only be displayed if the Investment option is selected in Step 8.4.

1. Tick Combine all entities in the same Portfolio Report to merge a single report for a group of related entities
   

2. Date Range Options: Custom, Last month / End of Previous Month, Last 12 months / End of Previous Year, Last 2 years, Since Inception.
   

3. Report Start Date (if Custom date range selected).
   

4. Report End Date (if Custom date range selected).
   

5. Report Grouping Preference:
   

1. Position
   

2. Product
   

3. Security Type, Position
   

4. GICS Indusry Group, Position
   

5. Portfolio, Subfund, Product
   

6. Portfolio, Subfund, Security Type, Position
   

7. Portfolio, Subfund, GICS Industry Group, Product
   

8. Portfolio, Account, Asset Class, Position
   

6. Tick the Portfolio Reports required.
   
   
   
   
   

11. In the Portfolio Valuation Reports panel, select the options required:
    
    This panel will only be displayed if the Portfolio Valuation option is selected in Step 10.6.

1. Report Options: Portfolio Summary, Portfolio Valuation - Simple, Portfolio Valuation with CGT Cost.
   

2. Include Additional Report: Select Yes to merge additional Portfolio Valuation reports.
   

3. Date Range: If Yes is selected for 11.2, select the date range for the additional Portfolio Valuation reports (Custom, Last month, Last 12 months, Last 2 years, Since Inception).
   

4. Start Date and End Date: If Custom is selected for 11.3, enter the date range for the additional Portfolio Valuation reports.
   

5. Grouping Preference: Select your grouping preference for the additional Portfolio Valuation reports (refer to Step 10.5 for available options).
   
   
   
   

12. In the Asset Allocation Reports panel, select the options required:
    
    This panel will only be displayed if the Asset Allocation option is selected in Step 10.6.

1. Report Options: Pie Chart, Comparison Bar Graph, Table (agreed vs actual), Table (agreed vs actual) - grouped by Growth & Defensive, Asset Allocation Breakdown.
   

2. Include Additional Report: Select Yes to merge additional Asset Allocation reports.
   

3. Date Range: If Yes is selected for 12.2, select the date for the additional Asset Allocation reports (Custom, End of previous month, End of previous year).
   

4. As at: If Custom is selected for 12.3, enter the date for the additional Asset Allocation reports.
   

13. In the Performance Reports panel, select the options required:
    
    This panel will only be displayed if the Performance option is selected in Step 10.6.

1. Report Options: Performance After Fees (IRR), Performance Before Fees (Period IRR), Performance Before Fees (Period IRR) - Cash Basis, Performance Before Fees (Period IRR) - Enhanced Cash, Performance with Enhanced Cash (IRR), Portfolio Progress Chart, Fund and Equity Investment Performance.
   

2. Include Additional Report: Select Yes to merge additional Performance reports.
   

3. Date Range: If Yes is selected for 13b, select the date range for the additional Performance reports (Custom, Last month, Last 12 months, Last 2 years, Since Inception).
   

4. Start Date and End Date: If Custom is selected for 13.3, enter the date range for the additional Performance reports.
   

5. Grouping Preference: Select your grouping preference for the additional Performance reports (refer to Step 10.5 for available options).
   
   
   
   

14. In the Transaction Reports panel, select the options required:
    
    This panel will only be displayed if the Transaction option is selected in Step 10.6

1. Report Options: Cash Transaction Report, Purchases and Sales, Transaction Summary.
   

2. Include Additional Report: Select Yes to merge additional Transaction reports.
   

3. Date Range: If Yes is selected for 14.2, select the date range for the additional Transaction reports (Custom, Last month, Last 12 months, Last 2 years, Since Inception).
   

4. Start Date and End Date: If Custom is selected for 14.3, enter the date range for the additional Transaction reports.
   

5. Grouping Preference: Refer to Step 10.5 for available options.
   
   
   

15. In the Tax (Income) Reports panel, select the options required:
    
    This panel will only be displayed if the Tax option is selected in Step 10.6.

1. Report Options: Income Tax Statement, Capital Gains Tax - Realised, Capital Gains Tax - Unrealised.
   

2. Include Additional Report: Select Yes to merge additional Tax reports.
   

3. Date Range: If Yes is selected for 15.2, select the date range for the additional Tax reports (Custom, Last month, Last 12 months, Last 2 years, Since Inception).
   

4. Start Date and End Date: If Custom is selected for 15.3, enter the date range for the additional Tax reports.
   
   
   

16. In the Projection Reports panel, select the options required:
    
    This panel will only be displayed if the Projection option is selected in Step 10.6.
    

1. Report Options: Current Monthly Projections, Current Yearly Projection, Projected Annual Income and Growth.
   

2. Include Additional Report: Select Yes to merge additional Projection reports.
   

3. Date Range: If Yes is selected for 16.2, select the date range for the additional Projection reports (Custom, Last month, Last 12 months, Last 2 years, Since Inception).
   

4. As at: If Custom is selected for 16.3, enter the date for the additional Projection reports.
   

5. Grouping Preference: Refer to Step 10.5 for available options.
   
   

17. Click Next.
    

18. Click Merge Review Report.
    

19. Select the Target clients for which to merge a PRR:
    

1. All Listed Clients will merge a PRR for all clients in the Search Results
   

2. Only Selected Clients will merge a PRR for the clients selected in the Search Results
   

20. The clients’ review reports will be merged in the background. Click Ok.
    

21. When the clients’ review reports have been merged, click  to display the new system message.
    

22. Click Download Report to download the zip file containing the merged PRRs.
    

1. For instructions on how to print PRRs (and other documents) merged in bulk, in the Zendesk go to Administration > Printing Word and PDF documents in bulk.
   

Troubleshooting

1.  If the IPS account has been linked to a record in Client Focus, the status of the Client Focus record (in Financial Details) must be Active:
   
   
2. Portfolio filtering may been applied to the client’s IPS Account. To find out more, in the Zendesk go to Portfolio (IPS) > Portfolio Report > Portfolio Filtering.