Click eMail below Member Investment Values.
The Report Selection screen will be displayed.
The following columns are displayed:
- Scheme Code
- S_Timestamp
- D_Captured
- Report_Type
- R_Sequence_No
- Action
There are 3 report selections available:
- Display
- Portfolio Summary
- Income Type Summary
Click on the hyperlinked display in the Action column alongside the required report.
The Report Selection screen will display the report.
The following columns are displayed:
- Scheme code
- Pay Centre Code
- Membership reference
- Name
- Initials
- Date of Birth
- Date of Joining Scheme
- Date of Exit
- Portfolio Description
- Investment Manager
- Date of Unit Price
- Unit Price
- Unit Balance (sum of unit balances)
- Market Value (sum of market values)
- Not Yet Unitised (sum of un-unitised balances)
- Switch in Process
- Total
- Bonus Portfolio
- Bonus Rate (bonus rate used in interest calculation)
- Contribution Category
- Benefit Category
- Investment Category
Enter the e-mail address to which the report should be sent, then click EXPORT.
A message will confirm that the e-mail has been sent.
Export started to email address: [email protected]
The report will be e-mailed as a CSV file, and it will be zipped. Once unzipped, the file can be viewed in Excel.
The following columns are displayed:
- Scheme code
- Pay Centre Code
- Membership reference
- Name
- Initials
- Date of Birth
- Date of Joining Scheme
- Date of Exit
- Portfolio Description
- Investment Manager
- Date of Unit Price
- Unit Price
- Unit Balance (sum of unit balances)
- Market Value (sum of market values)
- Not Yet Unitised (sum of un-unitised balances)
- Switch in Process
- Total
- Bonus Portfolio
- Bonus Rate (bonus rate used in interest calculation)
- Contribution Category
- Benefit Category
- Investment Category
Main Umbrella Schemes
If the Report is for a Main Umbrella Scheme, the data will be extracted per Sub Umbrella Scheme linked to the Main Umbrella Scheme, and displayed in one report.
The same information as per the Sub Umbrella reports is displayed and the information is grouped per Sub Umbrella scheme, and sorted per Scheme code as follows:
- Numeric codes Ascending order
- Alpha codes Alphabetical order
- Combination codes Alphabetical order
When a report is selected, the same report is displayed on the Report Selection screen.
Enter the e-mail address to which the report should be sent, then click EXPORT.
A message will confirm that the e-mail has been sent. The report will be e-mailed as a CSV file, and it will be zipped. Once unzipped, the file can be viewed in Excel. The following screen is an example of the layout of the report in Excel.
The following columns are displayed:
- Main Umbrella Scheme code
- Main Umbrella Scheme code
- Effective Date of List
- Sub Umbrella Scheme code
- Sub Umbrella Scheme Name
- Pay Centre Code
- Membership reference
- Name
- Initials
- Date of Birth
- Date of Joining Scheme
- Date of Exit
- Portfolio Description
- Investment Manager
- Date of Unit Price
- Unit Price
- Unit Balance (sum of unit balances)
- Market Value (sum of market values)
- Not Yet Unitised (sum of un-unitised balances)
- Total
- Bonus Portfolio
- Bonus Rate (bonus rate used in interest calculation)
The Sub Umbrella Scheme totals will be summed and displayed as Grand Totals as follows on the last page of the report:
The following are displayed as grand totals:
- Market Value
- Not Unitised Yet
- Total
- Bonus Portfolio
Portfolio Summary
To display a summary per investment report, click on the hyperlinked portfolio summary in the Action column alongside the appropriate selection in the Report Description column.
The following report will be displayed.
The following columns are displayed:
- Scheme code
- Pay Centre Code
- Membership reference
- Name
- Initials
- Date of Birth
- Date of Joining Scheme
- Date of Exit
- Portfolio Description
- Investment Manager
- Date of Unit Price
- Unit Price
- Unit Balance (sum of unit balances)
- Market Value (sum of market values)
- Not Yet Unitised (sum of un-unitised balances)
- Switch in Process
- Total
- Bonus Portfolio
- Bonus Rate (bonus rate used in interest calculation)
- Contribution Category
- Benefit Category
- Investment Category
Income type Summary
Note:
This selection will only be enabled if it is a “Switch by Income Type” scheme.
To display a summary per Income Type per Portfolio report, click on the hyperlinked income type summary in the Action column alongside the appropriate selection in the Report Description column.
The following report will be displayed.
The following columns are displayed:
- Scheme code
- Pay Centre Code
- Membership reference
- Name
- Initials
- Date of Birth
- Date of Joining Scheme
- Date of Exit
- Portfolio Description
- Investment Manager
- Date of Unit Price
- Unit Price
- Unit Balance (sum of unit balances)
- Market Value (sum of market values)
- Not Yet Unitised (sum of un-unitised balances)
- Switch in Process
- Total
- Bonus Portfolio
- Bonus Rate (bonus rate used in interest calculation)
- Contribution Category
- Benefit Category
- Investment Category