Group Fund Trust Report (System Reports Beneficiary Fund MI)

This report contains information per beneficiary for a specified period.

From the Beneficiary Fund menu, click alongside New under Group Fund Trust Report on the sub-menu on the left. Additional options will be displayed.

New

Click New below Group Fund Trust Report. The Group Fund Trust Report screen will be displayed.

Capture or select the relevant details as follows:

Effective Date	The start date of the period. The system defaults to the current date as being the effective date. Capture a new date if required.
Scheme Code	Capture the code for a specific scheme, or leave blank to display all schemes that fit the criteria specified.
Reference Number	Capture the trust number for a specific member, or leave blank to display all members that fit the criteria specified. This field is only enabled if Scheme Code has been captured.
Email	The email address to which the extract must be sent.

Click GENERATE REPORT.

The current report detail will be displayed on the lower portion of the screen.

A message will indicate once the job has been successfully submitted (and an e-mail will be sent to the e-mail address provided).

View

Click View below Member Register. The Report Selection screen will be displayed.

The following columns are displayed:

- Timestamp

- Date Captured

- Report Type

- Sequence Number

- Action

To select a report, click on the hyperlinked display in the Action column alongside the appropriate report.

The Group Fund Trust Report screen will be displayed.

The following columns are displayed:

Report Item	Details
Previous Administrator	Participating Employer Name
Previous Fund Code	Paycentre Code
Previous Fund	Paycentre Name
Trust Number	Membership Reference Number of Member for which the Membership Status is DECEASED
Trust Name	Name and initials of Member for which the Membership Status is DECEASED
Start Date	Membership CAR Start Date
End Date	The Memberships linked to the Deceased Member and the End Date on the Membership Payment records for these Memberships.
Capital
Initial Capital	Sum of the Original Amounts on the Membership Payment records for the Memberships with a Membership Status of BENEFICIARY linked to the Membership record with a Membership Status of DECEASED (Trust) referred to above.
Payments
Monthly Payments	Sum of the Business Transaction on the BENEFITS account for all of the Memberships linked to the Membership record with a Membership Status of DECEASED referred to above, with the Accounting Activity REGULAR PMT (and the Accounting Activities associated to it via the Accounting Activity Association with a Purpose Type TRUST REPORT) and a Due Date less than or equal to the report Effective Date and greater than the Scheme’s last Financial Year-End
Other Payments	Sum of the Business Transaction on the Member’s BENEFITS account for all of the Memberships linked to the Membership record with a Membership Status of DECEASED referred to above, with the Accounting Activity ADHOCPAYMENT (and the Accounting Activities associated to it via the Accounting Activity Association with a Purpose Type TRUST REPORT) and a Due Date less than or equal to the report Effective Date and greater than the Scheme’s last Financial Year-End.
Fees
Fees	Sum of the values for per Expense Type. Expense Type This is determined as follows: Sum of the Business Transaction per Expense Type on the Member’s MEM DEPOSIT account for all of the Memberships linked to the Membership record with a Membership Status of DECEASED referred to above, with the Accounting Activity MEMINVADMFEE (and the Accounting Activities associated to it via the Accounting Activity Association with a Purpose Type TRUST REPORT) and a Due Date less than or equal to the report Effective Date and greater than the Scheme’s last Financial Year-End. Display the Expense Type Description as the heading for each type of fee. Note: The Expense Type must be captured with a description that matches the heading in the current reporting e.g. Management Fees, Admin Fees, Tax Fees, etc.
Investments
Total Market Value	Sum of Market Values for all Portfolios.
Beneficiary Surname	Surname of Members for which the Membership Status is BENEFICIARY associated to the Membership with a Status of DECEASED.
Beneficiary Initials	Initials of Members for which the Membership Status is BENEFICIARY associated to the Membership with a Status of DECEASED.
Beneficiary ID Number	ID Number of Members for which the Membership Status is BENEFICIARY associated to the Membership with a Status of DECEASED.
Investor	The name of the Investor.
Units	Sum of the Unit Balances for all of the Memberships linked to the Membership record with a Membership Status of DECEASED referred to above per Portfolio as at the report Effective Date
Price	Unit Price as at report Effective Date or if not found latest unit price.
Market Value	Sum of the Market Values of the investments for all of the Memberships linked to the Membership record with a Membership Status of DECEASED referred to above per Portfolio as at the report Effective Date. Market Value = Unit balance on the Member’s INVSTMEMUNIT account as at report Effective Date x Unit Price as at report Effective Date or if not found latest unit price.