Web Procedure Manual

Viewing Payroll Office Reconciliation (Report 3)

The 3. Payroll Office Reconciliation option on the Reports Selection page allows users to view the Payroll Office Reconciliation report. This report lists each enrollee record that has a discrepancy and indicates whether that discrepancy has been reconciled.

To View a Payroll Office Reconciliation Report:

1. Select the Reports tab on the CLER Federal Employees Health Benefits, Centralized Enrollment Clearinghouse System Main Menu. The Reports Selection page is displayed.

   

2. On the drop-down menu on the Reports Selection page, select 3. Payroll Office Reconciliation.
3. Select the GO button to display the 3. Payroll Office Reconciliation page.

   

4. Complete the following fields on the 3. Payroll Office Reconciliation page:

   Payroll Office ID

   Year

   Quarter

   Fail Count From

   Fail Count To

   Reconciliation Date From

   Reconciliation Date To

   SSN From

   SSN To

   Agency

   Personnel Office ID

   Carrier

   Enrollment Code

   User ID

   Other ID From

   Other ID To

   Order By 1st

   Order By 2nd

   Order By 3rd

   Order By 4th

   Order By 5th

   Order By 6th

   Check Box to Create Report Without Totals

5. Select the drop-down menu at the bottom of the page and select one of the following format options:
   • Display the report.
   • Save report as a spreadsheet.
   • Save report as a text file.
6. Select the Submit button to display the Payroll Office Reconciliation report in the selected format. The Payroll Office Reconciliation report is displayed.

   OR

   Select the Reset button to clear all data entered.

   

   The data in the Payroll Office Reconciliation report is categorized into the following fields:

   SSN

   Name

   Carrier

   Agency

   POI

   Code

   The following fields are displayed on the Reconciliation section of the Payroll Office Reconciliation report:

   Reason

   Date

   User ID

   Action

   Fail Count

   With Errors

   Without Errors

   Total Records

   If 24900002, 24900003, or 160099XX was entered in the Payroll Office ID field on the Payroll Office Reconciliation (Report 3) page, the Payroll Office Reconciliation (Other ID) report is displayed.

   

   The data in the Payroll Office Reconciliation (Other ID) report is categorized into the following fields:

   Other ID

   SSN

   Name

   Carrier

   Code

   The following fields are displayed on the Reconciliation section of the Payroll Office Reconciliation (Other ID) report:

   Reason

   Date

   User ID

   Action

   Fail Count

   With Errors

   Without Errors

   Total Records

7. Close the report to return to the 3. Payroll Office Reconciliation page.