CLER for NFC

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. The Reports Selection page is displayed.

   

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

   

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

   Field	Instruction
   Payroll Office ID*	Required Select the payroll office identification number from the drop-down menu.
   Year*	Optional, 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*	Optional, 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 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. This is the date that begins the range of reconciliation dates.
   Reconciliation Date To	Optional 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. This is the date that ends the range of reconciliation dates.
   Agency	Optional, alphanumeric, 4 positions Enter the Agency identification 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 personnel office identification 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 personnel office identification 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 personnel office identification 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 personnel office identification 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 personnel office identification number.
   Check box to create report without totals	Optional Select this check box to omit totals from the report.

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

   OR

   Click Reset to clear all data entered.

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

   

   Field	Description
   Payroll Office	System generated Displays the payroll office identification number.
   Carrier	System generated Displays the carrier code.
   Code	System generated Displays the enrollment code.
   Agcy	System generated Displays the Agency identification code. This code consists of the Department code and Agency code.
   POI	System generated Displays the personnel office identifier of the office where the enrollee’s records are maintained. Note: The Other ID field is displayed in lieu of this field when 24900002, 24900003, or 160099XX is entered in the Payroll Office ID field on the Payroll Office Enrollees page.
   Enrollees	System generated Displays the number of enrollee records that meet the criteria entered on the Reconciliation Summary page.
   Match	System generated Displays the number of matching records that meet the criteria entered on the Reconciliation Summary page.
   %	System generated. Displays the percentage of matching records to enrollee records.
   #	System generated Displays the number of discrepancies.
   Recon	Displays the number of reconciled discrepancies.
   %	System generated Displays the percentage of reconciled discrepancies to reported discrepancies.
   Unrecon	System generated Displays the number of unreconciled discrepancies.
   Validated	System generated Displays the number of discrepancies/reconciliation actions that were validated by the carrier.
   %	System generated Displays the percentage of discrepancies/reconciliation actions validated to total corrective actions.
   Unvalidated	System generated Displays the number of discrepancies/reconciliation actions that were not validated by the carrier.
   Code-Total	System generated Displays the sum of records by enrollment code. Note: If the check box used to omit totals from a report is selected, this field is not displayed.
   Carrier-Total	Displays the sum of records by carrier. Note: If the check box used to omit totals from a report is selected, this field is not displayed.
   Grand-Total	System generated Displays the sum of records by enrollment code and carrier. Note: If the check box used to omit totals from a report is selected, this field is not displayed.