Reconciliation Manager dashboard (Legacy)
Menu location: Dashboards menu, View Reconciliation Manager (Legacy)
The legacy Reconciliation Manager provides information about how well released claims are moving through payer processing. It focuses on claims that might be in trouble by showing counts amounts of claims that have not been acknowledged by their payers. Only payers configured in the legacy Payer Reconciliation Profile Maintenance are included on this dashboard.
Exceptions are measured in days since release. The column for Day 1 is one day after the actual release. When claims are flowing well, the exceptions will be clustered in low-numbered days. Unacknowledged claims are expected to spill into older columns each day. As files and claims are acknowledged by the payers, they are no longer exceptions and are removed from the table. Exception claim numbers begin to spill into the oldest columns only if payer issues arise.
Milestone events
The milestone events tracked in Reconciliation Manager are:
- Batch Receipt - Has the payer acknowledged receipt of the claim file?
- Claim Receipt - Has the payer accepted individual claims into its adjudication system?
Tracked data is distributed in the following sections on the dashboard:
- Released
Released reflects an accepted claim sent to the clearinghouse for transmission to the payer, for printing, and/or for archive. Electronic Claims - This section shows the total number of electronic claims tracked for reconciliation that were released from one to six days ago. It does not include printed or Direct Entry claims. Compare these values to against what is being reconciled by other methods. - Payer Batch Exceptions - Claims are placed in the Payer Batch Exceptions section if they are released to a reconciliation payer who sends batch-level 277 acknowledgment. As payers acknowledge file receipt, the claims from the acknowledged file are removed from the Payer Batch Exceptions section. Claims sent to payers who cannot return an acknowledgement or who are not in your reconciliation profile are not included in the Payer Batch Exceptions section.
- Payer Claim Exceptions - Claims are placed in the Payer Claim Exceptions section if they are released to a reconciliation payer who sends claim-level 277 acknowledgment. As payers acknowledge claims, the acknowledged claims are moved out of the Payer Claim Exceptions section. Claims sent to payers who cannot return an acknowledgment or who are not in your reconciliation profile are not included in the Payer Claim Exceptions section.
If a payer returns a claim-level acknowledgment for a claim that is currently counted in Payer Batch Exceptions because no batch acknowledgment has been returned, the claim will also be removed from Payer Batch Exceptions because if the payer is acknowledging the claim, by definition, it has received the claim file.
Aging thresholds (Color zones)
The dashboard shows claim numbers in days since release, counting all days, including weekends and holidays. To highlight claims that may not be moving as expected through the process, Reconciliation Manager uses colored backgrounds to quickly identify aging thresholds.
- The WHITE zone - If the background for claim numbers is white, nothing is happening yet. No payer has returned a response, but no responses are expected. You need do nothing with these claims.
- The GREEN zone - If the background for claim numbers is green, claims are beginning to be acknowledged. At least one payer has returned a response. The acknowledged claims have been removed from the dashboard. The elapsed time is also within the comfort zone you have set. You need do nothing about these claims.
- The RED zone - If the background for claim numbers is red, something may have gone wrong in your claim movement. For at least one claim in the group, the elapsed time for acknowledgement has exceeded your comfort level. You should drill down into the red numbers and investigate the claims.
The colors of the backgrounds compare elapsed time without payer response against the threshold for acceptable turnaround set in the legacy Payer Reconciliation Profile Maintenance. Because payers are not likely to respond on weekends and holidays, the color change is based on a formula that starts with the threshold set in Payer Reconciliation Profile and counts only business days. For instance, if for claims released on Friday, on Wednesday the numbers are in Day 5 because it has been five days since release (Sat., Sun., Mon., Tues., Wed.). However, the color of the cell is does not include the two weekend days.
Dashboard drill-down pages
From the Reconciliation Manager, you can drill down to see claims by date, by payer, and finally, by claims themselves. Each successive drill-down level is reached by clicking links or lines at the previous level. The four drill-down levels are as follows:
- By date: Release date list.
- By payer: The Summary section is the release date line clicked in By Date. The Detail Section is a list, by payer, of all unacknowledged claims released that day (Batch or Claims). You can manually reconcile claims by payer from this level.
- By claim: The Summary section is the payer line clicked in By Payer. The Detail Section is all unacknowledged claims for the selected payer. You can manually reconcile by payer or by individual claims from By Claim. You can also open claims in CFI
Claim Form Interface (CFI) is the claim display in Assurance. CFI represents the selected claim so that users can review, change, validate, or delete it. CFI contains multiple tabs (pages).. - CFI (Claim Display): The selected claim opens in CFI at the History tab to allow you to see events in the claim's history. This is a fully-functional display of a released claim. You can view any part of the claim. You can also manually reconcile the claim using the same manual reconciliation drop downs that are on the Reconciliation Manager's By Payer and By Claim drill-down pages.
In addition to the claim you selected, all of the other claims in the claims table of the By Claim page are loaded into CFI. You can navigate through the entire set of claims to check claim information.
Drilling down from the dashboard
To begin the drill-down process, click on one of these dashboard links:
- Payer Batch Exceptions opens the By Date drill-down in the Batch Exceptions tab and displays a list of all days that contain claims sent to payers in unacknowledged files.
- Payer Claim Exceptions opens the By Date drill-down in the Claim Exceptions tab and displays a list of all days that contain claims that the payers have not yet acknowledged as accepted into their adjudication systems.
- Day numbers 1-6 or claim count in a day: Because days 1-6 each represent only a single date, clicking a link in one of these columns skips the By Date drill-down and opens the day directly in By Payer in the Batch Exceptions tab and displays all payers to whom unacknowledged claims have been sent.
- Day number 7+ or claim count in 7+: Because 7+ contains multiple dates, clicking a link in this column opens the By Date drill-down in the Batch Exceptions tab and displays dates from 7 to 90 days old. (Claims 91 days old and older are not included in the counts.)
- It is important to understand that all legacy reconciliation can do is report on payer responses. If a payer delays sending responses, Reconciliation Manager will show claim numbers in the high date ranges even though the claims may be processing correctly.
- Do not try to correlate numbers between Payer Batch Exceptions and Payer Claim Exceptions. The two sections measure two different things.
- Payer acknowledgment of a claim is not the same as an agreement to pay the claim. Claim acknowledgement means that the claim passed the front-end payer checks and was accepted into the payer's system for adjudication.
- Information from the payer is returned each time you release claims. Therefore, best practice is to review your exceptions for count changes shortly after release jobs finish processing.
- If you are not scheduled to release claims, but you feel that a payer may have sent acknowledgment information since your last release, use Send/Receive Mail on the Claims menu to pull any status information from the clearinghouse or payer into the product.