^{Reconciliation Dashboard → Reconciliation}

Reconciliation

Use the Reconciliation screen to compare two sets of data and produce a report of mismatched details (Fig. 1).

To open the Reconciliation screen:

• Click on the Reconciliation Dashboard link located in the left-side navigational menu. The Reconciliation Dashboard screen appears (Fig 1).
• Click on the Reconciliation option. The Reconciliation screen appears Fig. 2).

^{[Fig. 1]}

^{[Fig. 2]}

Filtering / Searching for Records

By default, the reconciliation table will show results for the past month. The user can search for different data, or filter existing data, by entering different search parameters:

• From Date: Click within the From Date field and choose a date.
• To Date: Click within the To Date field and choose a date.
• Facility: Click within the Facility field and select your facility. This refers to your company facilities. For instance, if you have several subsidiaries that your company owns that use this application, select the internal facility for your company that this filter applies to so that the right selections (i.e., clients & jobs) and hence table results appear based on that company's information. Conversely, depending on how you have your internal databases set up and configured with the RoboDX™ application, you may choose the "All" option.
• Client: Click within the Client field and select your client. You may make more than one selection here. Just keep clicking on selections until you are done.
• Jobs: Click within the Jobs field and select your job(s). You may make more than one selection here. Just keep clicking on selections until you are done.

• Buttons: Click on one of the following buttons when ready:

  • Search: To generate table results.
  • Clear: To clear filter input and start again.
  • Back: To return to the Reconciliation Dashboard page.

Primary Table

Once you have entered your filters (above), and then clicked on the Search button, the table will produce results based on your filter parameters. NOTE: Several of the table columns contain cells that you can interact with for more information. We describe these tables in the Secondary Tables section. It is within these tables that the columnar data will provide you with a comparison between what the agency shows versus what the client shows, if different.

Primary Table Columnar Definitions

• #: Refers to the table row number.
• Facility: Refers to your company's internal division. For instance, if you have more then one business using the RoboDX™ solution, you would want to know which business identifies with a specific job or file.
• Job ID: Unique number given to a job.
• Received: Date a job was first received by the facility.
• Processed: Date a job was processed by the facility.
• File Name: The name of a file. NOTE: The file is part of a job, but not necessarily the entire job. A job may have more than one file with a differnt file name.
• Client Name: The name of the client that we are communicating with on a job.
• Total: The number of records included in the file.
• Not in Agency: A reconciliation job takes a client listing of accounts and compares that to the list of accounts listed within the facility for that client. If the list a client sent has an account listed that is not in the agency's listing for that client, it will be counted in this field. If you click on the number within this table's cell, you can view a listing of accounts located below this table for all the Not in Agency listings. Generally, reconciliation jobs will be set up with other supporting jobs that take this list and generate an account creation file for the accounts that the client shows should be listed in ARTrail but are not. The information from the account creation file would then be dropped into account staging ARTrail's Account Staging screen.
• Not in Client: A reconciliation job takes a client listing of accounts and compares that to the list of accounts listed within the facility for that client. If the list a client sent does NOT have an account listed that is in the agency's ARTrail® listings for that client, it will be counted in this field. If you click on the number within this table's cell, you can view a listing of accounts located below this table for the Not in Client listings. Generally, reconciliation jobs will be set up with other supporting jobs that take this list and generate an account creation file for the accounts that the client shows are not listed in ARTrail.
• Balance Difference: Show the difference in the number of records between source & target.
• Balanced: Shows the number of records that are balanced in source & target.
• Action: The Action column contains an

Secondary Tables

When you interact with a cell's number link in the reconciliation table, a secondary table representing those details will appear below this table. The reconciliation table columns that provided linked information are:

• Total
• Not in Agency
• Not in Client
• Balance Difference
• Balanced

Columnar Definitions for Secondary Table: Total

The secondary table for the Total column shows agency information (Agency), that is being compared with the client's file information (FI). Columnar definitions for this table are:

• Rout ID: -----
• Unique ID: -----
• Recon Date: -----
• Recon Code: -----
• FI Debtor Number: -----
• FI Guarantor Address 1: Responsible party's street address according to client.
• FI Guarantor Address 2: Responsible party's mailing address, if different than street address according to client.
• FI Guarantor City: Responsible party's city for mailing address according to client.
• FI Guarantor DOB: Responsible party's date of birth according to client.
• FI Guarantor Name: Responsible party's full name according to client.
• FI Guarantor Name: Responsible party's full name according to client - Used when there is more than one responsible party.
• FI Guarantor Phone: Responsible party's phone number according to client.
• FI Guarantor SSN: Responsible party's social security number according to client.
• FI Guarantor State: Responsible party's state for mailing address according to client.
• FI Guarantor Zip: Responsible party's zip code for mailing address according to client.
• FI Guarantor Amount Referred: Amount referred according to client according to client.
• FI Guarantor Self Pay Payments: -----
• FI Guarantor Self Pay Adjustments: -----
• Transaction Date: -----
• FI Employee Address: Guarantor's employer's address according to client.
• FI Employee City: Guarantor's employer's address according to client.
• FI Employee State: Guarantor's employer's state according to client.
• FI Employee Phone: Guarantor's employer;s phone number according to client.
• FI Employee Zip: Guarantor's employer zip code according to client.
• Agency Client Number: Refers to the unique identifier given to an agency's client.
• Agency Account: Refers to the unique identifier that the agency gives to an individual consumer account.
• Agency Status Code: Refers to the agency's status for a specific account.
• Agency Client Debtor Number: -----
• Agency Guarantor: Guarantor's name according to agency.
• Agency Date of Referral: Date of referral according to agency.
• Agency Principal Balance: Principal balance according to agency.
• Agency Cancel: -----
• Agency Amount Referred: Amount referred according to agency.
• Agency Paid Principal: -----
• Cancel Status: -----
• All Column Data: -----
  
  

Columnar Definitions for Secondary Table: Not in Agency

The secondary table for the Not in Agency column shows agency information (Agency), that is being compared with the client's file information (FI). Results show accounts that are listed with the client, but not the agency. In other words, the client shows they have assigned these accounts to the agency, but the agency does not show them as being listed.

Columnar definitions for this table are:

• FI Debtor Number: -----
• FI Guarantor Address 1: Responsible party's street address according to client.
• FI Guarantor Address 2: Responsible party's mailing address, if different from street address according to client.
• FI Guarantor City: Responsible party's city for mailing address according to client.
• FI Guarantor DOB: Responsible party's date of birth according to client.
• FI Guarantor fname: Responsible party's first name according to client.
• FI Guarantor lname: Responsible party's last name according to client.
• FI Guarantor Phone: Responsible party's phone number according to client.
• FI Guarantor SSN: Responsible party's social security number according to client.
• FI Guarantor State: Responsible party's state for mailing address, if different from street address according to client.
• FI Guarantor Zip: Responsible party's zip code for mailing address, if different from street address according to client.
• FI Amount Referred: Amount referred according to client.
• FI Self Pay Payments: -----
• FI Self Pay Adjustments: -----
• Transaction Date: -----
• FI Employee Address: Guarantor's employer's address according to client.
• FI Employee City: Guarantor's employer's address according to client.
• FI Employee State: Guarantor's employer's state according to client.
• FI Employee Phone: Guarantor's employer;s phone number according to client.
• FI Employee Zip: Guarantor's employer zip code according to client.
  
  

Columnar Definitions for Secondary Table: Not in Agency

The secondary table for the Not in Client column shows agency information (Agency), that is being compared with the client's file information (FI). Results show accounts that are listed with the agency, but not the client. In other words, the agency shows they have recieved and listed accounts assigned by the client, but the client does not show they were listed.

Columnar definitions for this table are:

• FI Debtor Number: -----
• FI Guarantor Address 1: Responsible party's street address according to client.
• FI Guarantor Address 2: Responsible party's mailing address, if different from street address according to client.
• FI Guarantor City: Responsible party's city for mailing address according to client.
• FI Guarantor DOB: Responsible party's date of birth according to client.
• FI Guarantor fname: Responsible party's first name according to client.
• FI Guarantor lname: Responsible party's last name according to client.
• FI Guarantor Phone: Responsible party's phone number according to client.
• FI Guarantor SSN: Responsible party's social security number according to client.
• FI Guarantor State: Responsible party's state for mailing address, if different from street address according to client.
• FI Guarantor Zip: Responsible party's zip code for mailing address, if different from street address according to client.
• FI Amount Referred: Amount referred according to client.
• FI Self Pay Payments: -----
• FI Self Pay Adjustments: -----
• Transaction Date: -----
• FI Employee Address: Guarantor's employer's address according to client.
• FI Employee City: Guarantor's employer's address according to client.
• FI Employee State: Guarantor's employer's state according to client.
• FI Employee Phone: Guarantor's employer;s phone number according to client.
• FI Employee Zip: Guarantor's employer zip code according to client.
  
  

Columnar Definitions for Secondary Table: Balance Difference

The secondary table for the Balance Difference column shows a listing of the accounts that have a balance difference between what the agency shows and what the client is reporting.

Columnar definitions for this table are:

• Agency Account Number: Unique identifier assigned to each and every account by the agency.
• Client Debtor Number: Number that client has on file for consumer.
• Client Payment: Total amount client has reported as a direct payment.
• Client Adjustment: Total amount client has reported as an adjustment.
• Client Total Current Balance: What the client shows as the current balance left owing of the original amount assigned.
• Agency Status Code: Refers to the status code given to an account by the agency.
• Agency Principal Current Balance: Refers to what the agency shows is left owing of the original total amount assigned by the client.
• Payments Made Within 30 Days: -----
• Payments Made Within 60 Days: -----
• Amount Referred: SHows the original amount referred by the client.
• Difference Amount: Reflects the difference between the Client Total Current Balance and the Agency Principal Current Balance.
• Last Payment Made: -----
• Last Payment Date: Refers to the date of the Last Payment Made.
  
  

Columnar Definitions for Secondary Table: Balanced

The secondary table for the Balanced column shows a listing of the accounts that both the agency and client have in balance (i.e., there is no difference between what the agency shows and what the client is reporting.)

Columnar definitions for this table are:

• FI Client Debtor Number: -----
• FI Guarantor Name:
• FI Patient Name:
• FI Date of Last Payment:
• FI Account Balance:
• Agency Record Number: -----
• Agency Consumer ID:
• Agency Status Code:
• Agency Forwarded:
• Agency Balance:
• Agency Last Paid ??: -----
• Agency Last Paid Amount: -----
• Agency Client Number: -----
• Agency Client Number:
• Agency Client Debtor Number:
• Agency Guarantor Last Name:
• Agency Guarantor First Name:
• Agency Date of Referral:
• Route ID:
• Unique ID:
• Recon Date:
• Recon Code: