alongside Contributions on the sub-menu on the left. Additional options will be displayed.From the Reports menu, click alongside Contributions on the sub-menu on the left. Additional options will be displayed.
Note:
For SAP, the following additional options will be displayed.
This report displays all the contributions received for all members.
Click Contribution Report below Contributions.
The Contribution Report screen will be displayed.
Click SEARCH. The results will be displayed on the lower portion of the screen.
The following fields will be displayed:
- Reference Number
- Client Structure
- Surname and Initials
- Earnings
- EE Actual
- EE Calculated
- ER Actual
- ER Calculated
Use NEXT and PREVIOUS to view members on subsequent or previous pages.
If there is no data available for display, a warning message will appear.
You can export the information.
When the SAP Interface 1 batch job runs for the pay centres for which the data capture option is set to AUTO, if there is a value for the Date of Joining Fund field on the SAP file (PCL4-AEDAT) for an existing Membership, these details will be displayed on the Sap Contribution Report.
Note:
The member's Date of Joining Fund will not be updated.
This allows for date of joining scheme changes contained in the SAP file to be made to the members' records manually irrespective of the membership status. If the members' status is LIVE or EXIT IN PROCESS, the Date of Joining Scheme field will be enabled for update on the JU3AO Membership Details Maintain screen.
Note:
The system will update the Date Joining Fund field on Payroll in the next open cycle.
For more information, refer to
Clients
Members
Click Sap Report below Contributions.
The Sap Contribution Report screen will be displayed.
The following fields will be displayed:
- Scheme
- Reference
- Type
- Surname
- Initials
- Date of Birth
- Payroll Amount
- Payroll Calculated
- Salary
- Billing Amount
- Billing Expected
- Payroll Cycle Control (number)
- Cycle Date
This report displays various totals relating to the members' salaries and contributions. The types of totals displayed may differ from scheme to scheme, depending on how they have been coded.
Click Salary & Contribution below Contributions.
The Pay Centre screen will be displayed, and the relevant totals will be displayed.
This report allows a comparison to be made between contributions received and expected contributions.
For some schemes, contributions received may be via Interface 4 and expected contributions via Interface 2.
Note:
Salaries used in the Expense Income Run are displayed in the report.
Click Contribution / Expense Billing Report below Contributions.
The Contribution vs Expense Billing Report screen will be displayed.
The screen displayed will depend on the selections made using the following filters on the screen:
|
Filter |
Description |
|
Variance |
Define the level by which contribution amounts and expected contribution amounts may vary for the report.
Note: The use of this filter is optional.
Click on the drop-down box and select greater than (>) or equal to (=).
Define the variance amount.
Example:
|
|
Expense vs Contribution |
Select one of the following options from the drop-down list:
· Expense To Contrib · Contrib To Expense
Note: This selection is mandatory.
The selection made will determine which of the two reports is displayed. i.e.
· Expenses To Contributions Report · Contributions To Expenses Report |
|
Income Type |
Define the specific Income Type that must be displayed in the report.
Select a value from the drop-down list.
The default value is ALL TYPES.
Note: The use of this filter is optional. |
|
Ascending / Descending order |
Click on the appropriate radio button to display the report in ascending or descending order.
Note: The use of this filter is optional. |
Once the necessary selection(s) have been made, click SEARCH.
If Expense To Contrib was selected, the following report will be displayed.
If Contrib To Expense was selected, the following report will be displayed.
These reports validate contributions by comparing stored contribution values with calculated contribution values.
These reports execute the calculation per type per member without storing the value on the member record, and then do the compare to the actual value.
When a calculation does not exist on the database, the report will skip the calculation and display a zero value.
These reports have been optimized to only show one income type on the screen when all members are selected. All types can be viewed on the screen when one member is selected to a maximum of 20 types.
Click Contrib Validation Member Defined below Contributions.
The Member Defined report will be displayed.
The following fields will be displayed:
- Fund
- Pay Centre
- Membership Reference
- Expected Amount
- Contribution Amount
- Income Type
This facility allows the Calculation Validation report to be viewed by Income Type.
Click Contrib Validation By Type below Contributions.
The Contribution Validation By Type screen will be displayed.
The report screen displayed will depend on the selections made using the following filters on the screen:
|
Filter |
Description |
|
Reference No |
Capture a single member reference number, to display only the details for the member specified. |
|
Variance |
Define what the difference should be between the stored contribution value and the calculated contribution value for this report.
Note: A value of –1 will display all values. |
|
Income Type |
Define the specific Income Type that must be displayed in the report.
Select a value from the drop-down list.
The default value is ALL TYPES.
Note: The use of this filter is optional.
All income types can be viewed on the screen when one member is selected, up to a maximum of 20 types. |
|
Optional Types |
Click the tick-box to enable the report to use the rest of the Income types linked to the Fund ie:Voluntary/regular. |
|
Ascending / Descending order |
Click on the appropriate radio button to display the report in ascending or descending order.
Note: The use of this filter is optional. |
Once the necessary selection(s) have been made, click SEARCH.
The required report details will be displayed at the bottom of the screen.
The following fields will be displayed:
- Reference Number
- Client Structure
- Surname
- Initials
- Date of Birth
- Contribution Category
- Actual Amount (per Income Type)
- Calculated Amount (per Income Type)
If the Optional Types tick-box has been selected, the rest of the Income types linked to the Fund will be displayed.
