Using Receivables Intelligence

Receivables Intelligence is a reporting service that retrieves information directly from the fiscal intermediary (FI)Medicare Administrative Contractor (MAC) to provide reports on the progress of episode and hospice claims through the FIMAC system. The reports reveal the status of your claims at your FIMAC, which allows you to reconcile your software system, understand your Remittance Advices (RAs), and have the information to make important business decisions.

Each night, Receivables Intelligence checks for updates with the FIMAC. It then creates reports with this data and posts the reports to your Business Intelligence (BI) ~~FSD~~ Web page. New reports are available daily, Monday through Friday, not including holidays.

If you have modified your claims online without making the corresponding changes in your software, some information in your reports may not match the data in your software. The Receivables Intelligence reports reflect current information from your FIMAC.

Additionally, Receivables Intelligence reports cannot reconcile data that exists outside of the contracted reporting dates. As stated in your contract, we can pull data as far back as October 1, 2000, the beginning of Prospective Payment System (PPS).

To open Receivables Intelligence, you must first be logged into your firstHOMECARE Enterprise Edition account.

1. On the firstHOMECARE Main Menu, click Tools>Business Intelligence.

2. On the BI main menu, click Reports>Receivables Intelligence, and select the report you want to view.

Open the Receivables Intelligence Legacy Reports

Once you have downloaded the files, open them on your workstation:

1. Launch Microsoft Excel.

2. Select File > Open.

3. Go to the location where you saved your reports.

4. Double-click the name of the report file.

View Field Descriptions in Reports

View Hidden Columns in Legacy Reports

Sort Legacy Report Data

To print the Legacy reports from Excel:

1. Open the reports in Excel.

2. Select File > Print.

3. Choose a Print What option:

● Selection prints the highlighted cells.

● Active Sheet(s) prints the open report.

● Entire Workbook prints all Receivables Intelligence reports in the file.

4. Click OK.

You can print the Receivables Intelligence reports from within the Business Intelligence (BI) portal itself. After selecting the report from which you would like to print:

1. Click Print.

2. Click the printer icon ().

Patient names are hyperlinked in most Receivables Intelligence reports. Clicking a hyperlink displays pertinent information about the specified patient. Patient hyperlinks only function within a specific Excel file. If a patient is not hyperlinked in the Provider file, refer to the All file for additional information. To return to the previous report, press ALT + Left Arrow.

You can also display Excel’s Back button to return to previously viewed reports:

1. Click View > Toolbars.

2. Select Web.

Use the web navigation toolbar to move through the reports.

The Next and Previous buttons only work if you are using the links within the reports to navigate.

Before modifying a report, we strongly recommend that you save a copy of the original report. Based on your knowledge of Excel, you can make the following modifications:

● Cells can be formatted for size, font, color, data type, and so on.

● Rows and columns can be formatted as cells and can be hidden when not needed.

● Specific rows and/or columns of data can be copied into other spreadsheets or documents.

● Graphs can be created based on specific data ranges in the reports.