Run the Premium Reconciliation Report to support the monthly benefits billing reconciliation process. This report compares monthly premium amounts to standard rates and element entries by pay period, for all participants enrolled during the reporting period.

Use this report as an error check for employees with no rates, rates that differ from element entries, and rates and element entries that do not equal monthly premium amounts. In addition, you can use this report as an account of monthly premium payments by sending it to the benefits provider.

You run reports from the Submit Requests window.

   To run the Premium Reconciliation Report:

1. Select Reconciliation of Premium Contributions to Element Entries in the Name field.

2. In the Parameters window, enter the Reporting Start Date and the Reporting End Date to limit the premium reconciliation to this pay period.

   Note: If you select dates beyond the pay period, the report result will not display the reconciliation details.

3. Select other criteria to limit the report results to a particular employee, such as:

   • Employee Name

   • National Identifier

   • Employee Name Format: this limits the report result to the selected employee.

     Note: The default format is the default Employee Name Format you configured during implementation. If you select Japanese, the report result displays the participant details in the full name format as per Japanese legislation requirements.

   • Program: this limits the report to the specific program.

     Note: The list of values contains all active programs in the business group.

4. Select the Plan to limit the report results to data elements contained in the plan.

   Note: If you select a healthcare plan, the report displays details of healthcare options. Similarly, if you select an insurance plan, the report displays details of coverage options.

5. You can also select other criteria to limit the results of the report, such as:

   • Person Selection Rule

   • Organization

   • Location

   • Benefits Group

   • Reporting Group

   • Payroll

   • Premium Type

6. The default value for Output Type is Text. Select Comma Separated Values if you have many premium, rate, and element entry values.

7. Indicate if you want to view report results, such as:

   Note: The default value for the following is Yes:

   • Display Plan Reconciliation Report: provides total participant monthly premiums, standard rates, element entries, and discrepancy amounts for each payroll frequency in the reporting period.

   • Display Plan Discrepancies Report: lists all participant records with a discrepancy due to monthly premiums, standard rates, or element entries per pay period.

   • Display Life Event Report: lists all participants whose life event caused a change to plan premiums in the reporting period. If there are no such participants, the report result does not display this section.

   • Display Plan Participant Details Report: lists all the participants enrolled in the plan including option/coverage, monthly premium, and coverage start and end date.

   • Display Participant Details: displays the Plan Reconciliation and Plan Discrepancies sections of the report.

8. Choose OK.

9. In the Submit Request window, verify the parameters you selected, set the schedule and the options for running the report.

10. Choose the Submit button.

11. Close the Submit Requests window.

12. Open the Find Requests window.

13. Click Find.

14. Select your Request ID and click View Output.

    The Discrepancy column highlights the amounts that do not reconcile for a person. The following codes indicate the reason for the discrepancy:

    S = Element entries (per pay period) for total contributions subtracted from the standard rate pay period total do not equal zero.

    P = Element entries (per pay period) for total contribution subtracted from the participant monthly premium do not equal zero.

    SP = Both standard rates and the participant monthly premium do not reconcile with element entries for the period.