Skip to main content

What is the reconciliation queue?

Learn how to walk through reconciliation for a retirement plan in CX.

Written by Andrew Flowers

The reconciliation queue is the Reconciliation page under Retirement. It lists every plan that has a plan year in the year you pick, and shows where each plan's asset reconciliation stands. Use it to see how much work is left, find the plans that need attention, and open any plan's reconciliation in one click.

Navigating to the queue

  1. Click Reconciliation under Retirement in the side menu. The queue opens on last year's plan year. For example, in 2026 it opens on plan year 2025.

  2. To see a different year, click the plan year next to the Reconciliation title and pick the year you need. The page reloads for that year.

What's on the page

Status cards

Across the top, under Plan year 2025 (with your year), a row of cards counts the plans in each stage:

  • All Plans

  • Not Started

  • Census Received

  • Trust Data Received

  • Does Not Reconcile

  • Assets Reconciled

  • Reconciliation Approved

Click a card to show only the plans in that stage. The card stays highlighted. Click All Plans to see every plan again.

If a count shows an asterisk (*) and the note "Counts may be incomplete.", CX could not load every plan's status. Refresh the page in a minute.

What each status means

Status

What it means

Not Started

No reconciliation exists yet, or CX has not received a census or a record keeper report for it.

Census Received

The plan year's census has at least one participant, but no record keeper report has finished processing.

Trust Data Received

A record keeper report has been read and mapped, but the comparison isn't complete yet.

Does Not Reconcile

The comparison is done, and the record keeper's figures differ from the census.

Assets Reconciled

Every plan asset that can be compared ties to the census.

Reconciliation Approved

Someone confirmed and locked the plan year.

Columns

The table shows these columns:

Column

What it shows

Plan Name

The plan's name in CX.

Plan Code

The plan's code in CX.

Plan Type

The plan type, such as 401(k).

PYE

The plan year-end date.

Record Keeper

The record keeper linked to the plan in CX.

Reconciliation Status

The plan's stage, from the table above.

Method

Cash or Accrual. Blank until a reconciliation exists.

Schedules

How many asset schedules (record keeper reportS) the reconciliation has.

Updated

When the reconciliation last changed.

Click Plan Name, Plan Code, Plan Type, PYE, or Record Keeper to sort by that column. Click it again to reverse the order.

The queue shows 50 plans per page. Use the page controls at the bottom to move between pages.

Filtering and search

The filter bar sits above the status cards.

  1. Click Search and type part of a plan name. You can also press the / key anywhere on the page to jump to the search box. The table narrows as you type.

  2. Click Client to show plans for one or more clients.

  3. Click Status to pick one or more reconciliation statuses.

  4. Click Method to show only Cash or only Accrual reconciliations.

  5. Click More filters to add a Type filter (plan type) or a Record Keeper filter.

Save a filter set

If you check the same view often, save it.

  1. Set the filters you want.

  2. Click the bookmark icon at the left of the filter bar.

  3. Click Save filters and give the set a name. The saved set appears in the same menu next time.

The same menu has Clear all to remove every filter, and Reset default to go back to the standard view.

Show or hide columns

  1. Click Configure columns.

  2. Turn columns on or off, and drag them into the order you want.

  3. Apply your changes. CX remembers your columns on this computer.

Opening a plan's reconciliation

There are three ways to open a plan's reconciliation.

From the queue

  1. Click the plan's row. The plan's reconciliation opens on the Schedules tab.

You can also open the row's menu for two choices: Open opens the reconciliation, and Go to plan opens the plan record on its Assets tab.

From the plan's Assets tab

  1. Click Plans under Retirement, then open the plan.

  2. Click the Assets tab.

  3. Click Asset Reconciliation. The plan's reconciliation opens for last year's plan year.

If you need a different year, use the plan year picker at the top of the reconciliation.

From a Reconcile Assets task

Your firm can add a Reconcile Assets task to a project template, so reconciliation becomes a step in your annual workflow.

Set up the task in a template:

  1. Open the project template and add or open a task.

  2. In Internal Task Type, select Reconcile Assets.

  3. In Plan Year, select the plan year to reconcile. This field is required for this task type.

Use the task in a launched project:

  1. Open the task in the project.

  2. Click the box that reads "Click here to open the PY 2025 asset reconciliation." (with your year). The plan's reconciliation opens in a new browser tab.

Starting a reconciliation

You don't need to click anything to start a reconciliation. When you open a plan that has no reconciliation for that year, CX creates one and shows "Reconciliation started for PY 2025" (with your year).

Starting is safe. Nothing is written to the census or the Form 5500 until you confirm and lock the year.

To go back to the queue from a reconciliation, click ← All plans next to the plan year, or press Esc.

Bulk actions

If you have a folder of record keeper files for many plans, click Bulk upload RK files on the queue. CX reads each file and routes it to the right plan's reconciliation. This button only appears if you have write access to Retirement, and it is turned off when the queue has no plans for the year. See Bulk Uploading Record Keeper Files for the full steps.

Best practices

  • Start each season from the cards. Click Not Started to see which plans still need a record keeper report, and Does Not Reconcile to see which need a closer look.

  • Save your working views. For example, save one filter set per record keeper or per team member's clients.

  • Clear filters before a bulk upload. That way every plan for the year is available when CX routes your files.

  • Use the Reconcile Assets task in your annual compliance template so reconciliation is tracked with the rest of the plan's work.

Related articles

  • Asset Reconciliation Overview

  • Adding an Asset Schedule from a Record Keeper File

  • Bulk Uploading Record Keeper Files

  • Confirming and Locking a Reconciliation

  • Reconcile a Plan's Assets from Start to Finish

  • Asset Reconciliation Troubleshooting and FAQ

Related Articles
Did this answer your question?