Xplan Essentials (UK) - Portfolio Report template - User Guide

[mary.galloway]

 

Contents

• Contents
• User Guide
• To create a bespoke IPS Report Template
• Access Xword
• Download the IPS report template
• Edit the template to your requirements
• Test your template before uploading to Xplan
• Save the Xmerge template
• Generate a portfolio report using the template
• Individual client
• Bulk client reporting

User Guide

The Portfolio Report templates will provide a simple and efficient way to generate portfolio reports in line with your firm’s corporate branding.  The Smart Styling settings saved in Xplan are used in both templates, portrait and landscape.

The templates include options for the following:

     Cover page                                Contents

     Logo on first page                      Title and Subtitle

     Title of document                       Table format

     Report for                                   Label to identify the output 

     Provided by

     Date

To create a bespoke IPS Report Template

Access Xword

1. Access Xword and generate the required portfolio report syntax. Keep this safe for now, it will be used in the template in part 5.

Community links:

Xword: Xmerge Tool for Microsoft word

https://community.iress.com/t5/Help-Guide-Xplan/Xword-Xmerge-Tool-for-Microsoft-Word/ta-p/4960

Xmerge Table Formats

https://community.iress.com/t5/Help-Guide-Xplan/Xmerge-Table-Formats/ta-p/5217

Smart Styling: Apply the Smart Style to Templates - Item 8

https://community.iress.com/t5/Training-Xplan/Xplan-Content-Apply-the-Smart-Style-to-Templates/ta-p/...

Iress Learning Centre courses:

Xword Toolbar (micro learn) 

How to code a basic document (virtual classroom)

Introduction to coding (virtual classroom)

Download the IPS report template

1. Navigate to Admin > Site > Templates > Iress Templates > Portfolio Report template
2. Download the Portfolio Report template and save a copy to your desktop.
3. Do not remove the first section of text as this is necessary to drive the smart styling

 Syntax to drive the Smart Styling - do not remove this section

Edit the template to your requirements

1. Update the template by editing any of the following:  

Cover page

Logo - can be located left, centre or right.

Cover page title - replace the text within the quotation marks to your chosen report name.

Prepared for - select the recipient entity:client, partner or joint and delete the unwanted code. 

Provided by - client adviser name set as default in line with other valuation reports.

Prepared on - today’s date set as default in line with other valuation report.

Contents

Title or Subtitle - update/delete as necessary.

Insert the syntax - 3 examples of how to insert the portfolio report syntax and table.

1. No table  - simply use the Insert Element to generate the syntax.

2. Table Format - select the table format from the drop-down list in the Format field within Xword.  Insert the syntax using the Insert Element, the table format will be displayed.

TIP: Your firm’s table format may be saved as your billing id rather than your firm’s name. Iress can provide this information on request.

3. Fixed table format - to always use the table format saved as part of your Smart Styling insert the text in red below to your portfolio report syntax.

Ensure it is saved within the parenthesis and typed exactly as displayed below.

Label to identify the output (flag) - replace the text highlighted in yellow to the required report name, eg. Portfolio report, Transaction report etc.

 This text will be used as the name of the output report. It is extremely useful when generating reports in bulk.

The same label is used for the Bulk Letter template making it easy for you to match the outputs.

Test your template before uploading to Xplan

6. Navigate to Client > Servicing > Report Generation > Merge Template

Click on Upload Template button

Click on Select Files button

Locate your template. Wait for the Status to change from In Progress to Complete.

Execute

OK

Your report will be sent to the Notification bell icon as an Adhoc template.

Save the Xmerge template

     7. Navigate to Admin > Site > Templates.

Select your firm’s category

 Upload your template, with a relevant name, to your firm’s folder. Eg. Portfolio report - client only, 

Portfolio report - partner only, Portfolio report - joint. This will help users to identify the required 

template.

TIP: Please do not upload your templates to the folders prefixed with ‘Iress’ as they will be visible to all users on the site, not just users in your firm.

Community link:

Xword: Create Xmerge Templates

https://community.iress.com/t5/tkb/articleprintpage/tkb-id/XPLANHelpGuide/article-id/1142

 Iress Learning Courses:

Managing Xmerge Templates (micro learn)

Coding for Xplan modules (micro learn)

Generate a portfolio report using the template

Individual client

   8. Navigate to Client > Servicing > Report Generation > Merge Report

Locate your Report Category and Template

Click on the Action button (triangle) to the left of the template name

Execute

Ok

Your report will be sent to the Notification bell icon.

Bulk client reporting

   9. Run the Advanced Search 'Is Master' to prevent duplicate reports for joint entities

      Select the list of clients for whom you wish to generate a report

Select Reports in the menu

Select Merge report

Locate your Report Category and Template

Click on the Action button (triangle) to the left of the template name

Execute

Ok

Your reports will be sent to the Notification bell icon in a zip file.

The User Guide videos can be viewed here.