AR Analysis File Specifications

Your 21st Century Solution to Gaining & Maintaining Strong Revenue Cycle Performance

AR Analysis - File Data Elements

Your Excel or CSV file should contain the data elements listed below: 

Patient Account Number (Do not use Patient SSN or Medical Record #)

Admit Type (separate help file to support codes with definitions for each)

Patient Type (separate help file to support codes with definitions for each)

Financial Code (separate help file to support codes with definitions for each)

Insurance Plan (separate help file to support codes with definitions for each)

Account Status (Unbilled, DNFB, Billed, Pre Collect/BD)

Admit Date                         mm/dd/yyyy

Discharge Date                  mm/dd/yyyy

Final Bill Date                     mm/dd/yyyy

Current Date of File        mm/dd/yyyy

Aging of current balance               9999

Total Charges                    

Final Billed Charges

Total Payments

Date of last Payment      mm/dd/yyyy

Total Adjustments

Date of last Adjustment mm/dd/yyyy

Current Balance

Other data if already a part of a predefined extract file from current Patient Accounting system. Do not include and PHI information. 

The file must be password protected and should be either in MS Excel (2003 or 2007) format or CSV for importing.

Report of findings will be provided in MS PowerPoint (2003/2007), MS Excel (2003/2007).