This report lists all members who have exited within a specified date range and for whom contributions are outstanding, i.e. the exit is finalised, but there is still money available in the Contribution Account.
From the Exits menu, click alongside Transfer Out Values on the sub-menu on the left. Additional options will be displayed.
Click New below Transfer Out Values. The Transfer Out Values screen will be displayed.
Capture data in order to specify the information to be extracted for the report as follows:
|
Effective Date |
The effective date of the report.
This field is mandatory. |
|
Paycentre Code |
The specific Pay Centre to which members are associated, that must be reported on.
Select a value from the drop-down list.
This field is optional. |
|
Membership Group |
The specific Membership Group to which members are linked, that must be reported on.
Select a value from the drop-down list.
This field is optional. |
|
Membership Status |
The specific Membership Status for the members, that must be reported on.
Select a value from the drop-down list.
This field is optional. |
|
Email Address |
The email address to which notification of the completion of the report must be sent.
This field is mandatory. |
ClickGENERATE REPORT.
The following message will be displayed once the job has been submitted:
Report job submitted successfully
Once the extract has completed, the following email will be sent to the email address captured.
The Transfer Out Values Report has been created successfully. You can now view the report from the web page.
Click View below Transfer Out Values. The Report Selection screen will be displayed.
To select the report, click on the hyperlinked display in the Action column.
The Report Selection screen will be displayed.
If a combination of criteria is selected, the following columns are displayed:
- Employer Code
- Pay Centre Code
- Branch Code
- Member Reference
- Surname
- Initials
- Date of Birth
- ID Number
- Company Number
- Transfer Credits Contributions
- Transfer Credits Value
- Transfer In Date
- Pensionable Service Date
- Employee Contributions
- Employee Contributions Value
- Employer Contributions
- Employer Contributions Value
- Employee Voluntary Contributions
- Employee Voluntary Contributions Value
- Employer Voluntary Contributions
- Employer Voluntary Contributions Value
- System Conversion Contributions
- System Conversion Contributions Value
- Total Fund Value
- Employee Contributions to previous provident fund
- Total Tax Free Amount
- Pay Centre Name
- Employer name
- Branch Name
When GENERATE REPORT is selected, the following information will be extracted for the Members for which the balance on their investment account is not zero as at the report Effective Date i.e. the unit balance on their INVSTMEMUNIT account for the Portfolios for which the Earning Allocation Code is UNITISED is not zero and the monetary balance on their INVESTMEMB account for the Portfolios for which the Earning Allocation Code is BONUS is not zero:
- If a Paycentre is selected then the information for the Memberships associated to the Paycentre selected will be extracted.
- If a Membership Group is selected the information for the Memberships linked to the Membership Group selected will be extracted.
- If Membership Status is selected the information for the Memberships with a Membership Status equal to the Membership Status selected will be extracted.
- If a combination of criteria is selected the information for the Memberships meeting all of the critera selected will be extracted.
The contribution, market value and tax free amount values will be extracted as per the table below.
|
|
Column |
Source |
|
A |
Transfer Credits Contributions |
Retrieve the Business Transactions (BT’s) from the Member’s CONTRIBUTION account for the Income Types for which the Classification is TRANSFER IN and for which the Effective Date is less than or equal to the report Effective Date.. Sum the amounts. |
|
B |
Transfer Credits Value |
Retrieve the unit balances by Effective Date on the Member’s INVSTMEMUNIT account per Portfolio where the Earning Allocation Code for the Investment Medium is UNITISED for the Income Types for which the Classification is TRANSFER IN as the report Effective Date. Find the Unit Price for with an Effective Date equal to the report Effective date and calculate the market value. If no unit price is found for the report Effective Date find the unit price for the last working immediately prior to the report Effective Date and if not found find the latest unit price. Retrieve the balances on the Member’s INVESTMEMB account per Portfolio where the Earning Allocation Code for the Investment Medium is BONUS for the Income Types for which the Classification is TRANSFER IN as at the report Effective Date. Calculate the market value by calculating interest to the report Effective date as per the Member Values Report and adding it to the balance. Sum the market values. |
|
C |
Transfer In Date |
Effective Date of earliest Business Transaction in A. |
|
D |
Pensionable Service Date |
Read the Pensionable Service Date on the latest Transfer Detail record for the Member. If not found CAR Start Date. |
|
E |
Employee Contributions |
Retrieve the balance by Effective Date on the Member’s CONTRIBUTION account as at the report Effective Date for the Income Types for which the Contributing Party is EMPLOYEE, the value for INCOME OPTIONALITY is M (mandatory) and the Classification is null.. |
|
F |
Employee Contributions Value |
Retrieve the unit balances by Effective Date on the Member’s INVSTMEMUNIT account per Portfolio where the Earning Allocation Code for the Investment Medium is UNITISED for the Income Types for which the Contributing Party is EMPLOYEE, the value for INCOME OPTIONALITY is M (mandatory) and the Classification is null as the report Effective Date. Find the Unit Price for with an Effective Date equal to the report Effective date and calculate the market value. If no unit price is found for the report Effective Date find the unit price for the last working immediately prior to the report Effective Date and if not found find the latest unit price. Retrieve the balances on the Member’s INVESTMEMB account per Portfolio where the Earning Allocation Code for the Investment Medium is BONUS for the Income Types for which the Contributing Party is EMPLOYEE, the value for INCOME OPTIONALITY is M (mandatory) and the Classification is null as at the report Effective Date. Calculate the market value by calculating interest to the report Effective date as per the Member Values Report and adding it to the balance. Sum the market values. |
|
G |
Employer Contributions |
Retrieve the Balance by Effective Date on the Member’s CONTRIBUTION account as at the report Effective Date for the Income Types for which the Contributing Party is EMPLOYER, the value for INCOME OPTIONALITY is M (mandatory) and the Classification is null. |
|
H |
Employer Contributions Value |
Retrieve the unit balances by Effective Date on the Member’s INVSTMEMUNIT account per Portfolio where the Earning Allocation Code for the Investment Medium is UNITISED for the Income Types for which the Contributing Party is EMPLOYER, the value for INCOME OPTIONALITY is M (mandatory) and the Classification is null as the report Effective Date. Find the Unit Price for with an Effective Date equal to the report Effective date and calculate the market value. If no unit price is found for the report Effective Date find the unit price for the last working immediately prior to the report Effective Date and if not found find the latest unit price. Retrieve the balances by Effective Date on the Member’s INVESTMEMB account per Portfolio where the Earning Allocation Code for the Investment Medium is BONUS for the Income Types for which the Contributing Party is EMPLOYER, the value for INCOME OPTIONALITY is M (mandatory) and the Classification is null as at the report Effective Date. Calculate the market value by calculating interest to the report Effective date as per the Member Values Report and adding it to the balance. Sum the market values. |
|
I |
Employee Voluntary Co |
Retrieve the balance by Effective Date on the Member’s CONTRIBUTION account as at the report Effective Date for the Income Types for which the Contributing Party is EMPLOYEE, the value for INCOME OPTIONALITY is O (optional) and the Classification is null and for which the Transaction Date is less than or equal to the report Effective Date. |
|
J |
Employee Voluntary Contributions Value |
Retrieve the unit balances by Effective Date on the Member’s INVSTMEMUNIT account per Portfolio where the Earning Allocation Code for the Investment Medium is UNITISED for the Income Types for which the Contributing Party is EMPLOYEE, the value for INCOME OPTIONALITY is V (voluntary) and the Classification is null as the report Effective Date. Find the Unit Price for with an Effective Date equal to the report Effective date and calculate the market value. If no unit price is found for the report Effective Date find the unit price for the last working immediately prior to the report Effective Date and if not found find the latest unit price. Retrieve the balances by Effective Date on the Member’s INVESTMEMB account per Portfolio where the Earning Allocation Code for the Investment Medium is BONUS for the Income Types for which the Contributing Party is EMPLOYEE, the value for INCOME OPTIONALITY is M (mandatory) and the Classification is null as at the report Effective Date. Calculate the market value by calculating interest to the report Effective date as per the Member Values Report and adding it to the balance. Sum the market values. |
|
K |
Employer Voluntary Contributions |
Retrieve the balance by Effective Date on the Member’s CONTRIBUTION account as at the report Effective Date for the Income Types for which the Contributing Party is EMPLOYER, the value for INCOME OPTIONALITY is V (voluntary) and the Classification is null. |
|
L |
Employer Voluntary Contributions Value |
Retrieve the unit balances by Effective Date on the Member’s INVSTMEMUNIT account per Portfolio where the Earning Allocation Code for the Investment Medium is UNITISED for the Income Types for which the Contributing Party is EMPLOYEE, the value for INCOME OPTIONALITY is O (optional) and the Classification is null as the report Effective Date. Find the Unit Price for with an Effective Date equal to the report Effective date and calculate the market value. If no unit price is found for the report Effective Date find the unit price for the last working immediately prior to the report Effective Date and if not found find the latest unit price. Retrieve the balances by Effective Date on the Member’s INVESTMEMB account per Portfolio where the Earning Allocation Code for the Investment Medium is BONUS for the Income Types for which the Contributing Party is EMPLOYEE, the value for INCOME OPTIONALITY is M (mandatory) and the Classification is null as at the report Effective Date. Calculate the market value by calculating interest to the report Effective date as per the Member Values Report and adding it to the balance. Sum the market values.. |
|
M |
System Conversion Contributions |
Retrieve the balance by Effective Date on the Member’s CONTRIBUTION account as at the report Effective Date for the Income Types for which the Contributing Party is OTHER, the value for INCOME OPTIONALITY is O (optional) and the Classification is CONVERSION. |
|
N |
System Conversion Contributions Value |
Retrieve the unit balances by Effective Date on the Member’s INVSTMEMUNIT account per Portfolio where the Earning Allocation Code for the Investment Medium is UNITISED for the Income Types for which the Classification is CONVERSION as the report Effective Date. Find the Unit Price for with an Effective Date equal to the report Effective date and calculate the market value. If no unit price is found for the report Effective Date find the unit price for the last working immediately prior to the report Effective Date and if not found find the latest unit price. Retrieve the balances by Effective Date on the Member’s INVESTMEMB account per Portfolio where the Earning Allocation Code for the Investment Medium is BONUS for the Income Types for which the Classification is CONVERSION as at the report Effective Date. Calculate the market value by calculating interest to the report Effective date as per the Member Values Report and adding it to the balance. Sum the market values. |
|
O |
Total Fund Value |
B + F + H + J + L + N |
|
P |
Employee Contributions to previous provident fund |
If the Type of Retirement Fund is PROVIDENT or PENSION read the value for Member Contributions on the Member’s Transfer Value Detail record for which the value for Type of Transfer is CNV PROV – PEN, TRN PROV – PENS, TRN PROV – PROV or TRN PROV – PUBL. If a value for Member Contributions and Tax Free Amount is found on the same Transfer Value Detail record read the value for Tax Free Amount. If a value for Member Contributions and Tax Free Amount is found on the same Transfer Value Detail record read the value for Tax Free Amount. If more than one Transfer Value Detail record is found for a Member display a row for each record. |
|
Q |
Total Tax Free Amount |
If the Type of Retirement Fund for the Scheme to which the Membership is linked is PROVIDENT retrieve the Balance on the Member’s CONTRIBUTION Account as at the report Effective Date for the Income Type for which the Contributing Party is EMPLOYEE and the Classification is null and sum the balances Sum the values for P and add to the sum of the balances. |