HCSIS Compare

The HCSIS Compare process reviews consumer information in Provider Management against HCSIS data. The report compares:

  • Facility/Location
  • Service Codes
  • Units
  • Effective Dates
  • Rates

Any differences between the systems will be listed on the report. These differences should be reviewed and corrected before billing is submitted.

Recommendation: Run this process weekly to stay up to date with authorization changes and reduce denied claims.

Download HCSIS Service Authorization Files

Required Step: Files must be downloaded from HCSIS and saved to your computer.

  1. Log into HCSIS.
  2. Navigate to: Tools > Notices > Service Authorization Notice
  3. In the filter section, download the file for each county you work with.
  4. Save each file as a .csv on your computer.
  5. Multiple Counties:
    1. You may combine all county files into one CSV file
    2. If not combined, you will need to run the HCSIS Compare process multiple times
  6. You can also request a single file with all counties and it will be emailed to you the next day.

Run the HCSIS Compare Process

NAVIGATION:  ANALYSIS menu > HCSIS Compare

  1. In the Select File field, click the paperclip icon.
  2. Select the .csv file you downloaded from HCSIS.
  3. Enter the Begin and End Dates
  4. Typically: 7/1 ? 6/30 (fiscal year)
  5. If your file includes a county column, check:
  6. ?County column inserted to csv?
  7. Check the Notify box.
  8. Click Process.
  9. Once complete, you will receive a message that the process is finished. Click OK.
  10. A report will generate showing any differences between HCSIS and Provider Management.

Review the HCSIS Compare Report

The report is divided into sections to help identify issues.

  1. Error Finding Match
    These items require action:
    1. Consumer not found in Horizon
      Action Step: Add the consumer to the Consumer Master
    2. Service plan in Horizon but not in HCSIS
      Action Step: Delete Consumer Master service authorization if it is not valid
    3. Facility fee not found in Horizon
      Action Step: Add the service code to the Facility Master > Fee for Service tab
    4. Service plan not found in Horizon
      Action Step: Add or update the consumer's service authorization
  2. Record Found
    1. No Highlight - All data matches between HCSIS and Provider Management
    2. Highlighted in Yellow - A difference exists and must be reviewed
    3. Common Differences
      1. Rate
        Action Step: Update in Facility Master
      2. Units
        Action Step: Update in Consumer Master Service Authorization
      3. Start Date
        Action Step: Update Consumer Master Service Authorization to match HCSIS authorization start date
      4. End Date
        Action Step: Update to match HCSIS authorization end date

Re-Run the Process

  1. After making corrections, run the HCSIS Compare process again
  2. Continue reviewing and correcting
  3. Repeat until:
    1. All records show Record Found
    2. No items are highlighted in yellow

VIDEO:  HCSIS Compare

3/2026

NEED MORE HELP?  Submit a ticket to the Help Desk or call (814) 535-7810 or (800) 889-3388