CLER for Carriers

Viewing Reconciliation Summary (Report 11)

The Reconciliation Summary (Report 11) option on the Reports Selection page allows users to view the Reconciliation Summary report. This report provides information regarding the progress that has been made to reconcile the discrepancies found in a single quarter.

To View a Reconciliation Summary Report:

1. Select the Reports tab at the top of the CLER Federal Employees Health Benefits, Centralized Enrollment Clearinghouse System Main Menu.

   

2. The Reports Selection page is displayed.

   

3. Click the drop-down menu on the Reports Selection page and select Reconciliation Summary.
4. Click GO to display the Reconciliation Summary (Report 11) page.

   

5. Complete the fields on the Reconciliation Summary (Report 11) page.

   Field	Instruction/Description
   Payroll Office ID*	Required Select the payroll office identification number from the drop-down menu.
   Year*	Required, default Select the reconciliation year from the drop-down menu. If no year is selected, this field automatically defaults to the current reconciliation year.

   Quarter*	Required default Select the reconciliation quarter from the drop-down menu. If no quarter is selected, this field automatically defaults to the current reconciliation quarter.
   Reconciliation Date From	Optional This is the date that begins the range of reconciliation dates. To select this date, select the month from the first drop-down menu, select the day from the second drop-down menu, and select the year from the third drop-down menu.
   Reconciliation Date To	Optional This is the date that ends the range of reconciliation dates. To select this date, select the month from the first drop-down menu, select the day from the second drop-down menu; and select the year from the third drop-down menu.
   Agency	Optional, alphanumeric, 4 positions Enter the Agency ID code of the office where the enrollee is employed (example: AG90 for U.S. Department of Agriculture, Office of the Chief Financial Officer).
   Personnel Office ID	Optional, alphanumeric, 4 positions Enter the POI number.
   Carrier	Optional Select the carrier code from the drop-down menu.
   Enrollment Code	Optional Select the enrollment code from the drop-down list.
   Order By: 1st	Optional, default Defaults to the Carrier option. This field allows users to sort search results by the options listed below. To choose a sort option, select one of the following options from the drop-down menu to display the selected criteria in first sort search order: Agency - Search by Agency code. Carrier - Search by carrier code. Enrollment Code - Search by enrollment code. Personnel Office ID - Search by POI number.
   Order By: 2nd	Optional Select one of the following options from the drop-down menu to display the selected criteria in second sort search order: Agency - Search by Agency code. Carrier - Search by carrier code. Enrollment Code - Search by enrollment code. Pers. Office ID - Search by POI number.
   Order By: 3rd	Optional Select one of the following options from the drop-down menu to display the selected criteria in third sort search order: Agency - Search by Agency code. Carrier - Search by carrier code. Enrollment Code - Search by enrollment code. Pers. Office ID - Search by POI number.
   Order By: 4th	Optional Select one of the following options from the drop-down menu to display the selected criteria in fourth sort search order: Agency - Search by Agency code. Carrier - Search by carrier code. Enrollment Code - Search by enrollment code. Pers. Office ID - Search by POI number.
   Check box to create report without totals	Optional Select this check box to omit totals from the report.

6. Click 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
7. Click Submit to display the Reconciliation Summary report in the selected format.

   OR

   Click Reset to clear all data entered.

   

To return to the Reconciliation Summary (Report 11) page, close the report.