Billing Receivables Forecasting Dashboard

Use the Billing Receivables Forecasting Dashboard to better understand how much of the open Accounts Receivable is likely to pay. This data can be pulled based on a set date of service range. 

Billing Receivables Forecasting Dashboard Report Criteria

Set a Date of Service range by entering a to-from date or selecting one of the standard date range buttons. After entering the Date of Service Range, choose if you would like to enter an Estimated Collection Percentage Range.

• Entering an Estimated Collection Percentage Range allows a custom range to be used to calculate the Estimated Collection Percentage. This is helpful when running the report for more than one year of dates of service. In this example, enter the same date range, but for the prior year, to accurately calculate the Estimated Collection Percentage. 
• Users can also leave the Estimated Collection Percentage Range blank to simply use the last calendar year for comparison. 

If applicable, you an enter an Ending Transaction Date and Transaction Date Type. Biller Generated will be the date entered by the user when posting a transaction. System Generated will be the date recorded by the system, regardless of what date the user entered.

Select to either preview the report or download it to one of the Export format options available.

Payer Table

Payer Category will list the high-level payer groups, based on how they were submitted. These are the same categories used for the Billing Receivables (Summary) report.

Outstanding Balance calculates the balance for the date of service range entered as of the date the repot is run, or the transaction date entered in the report criteria.

Estimated Collection % calculates what is likely to be paid for the current balance. In order to determine this, the system looks at a 12-month span prior to the Start date entered for the date range in the report criteria. Only bills with a zero balance are included in the calculation for all  payers except Patient. Patient will include all bills in the range, no matter the balance.

Estimated Balance Based on Collection % is the estimated balance based on what these payers have paid in the past. Outstanding Balance x Estimated Collection %= Estimated Balance Based on Collection %. 

Total Estimated C/A is the estimated C/A based on what the C/A for these payers has been in the past. Outstanding Balance - Estimated Balance=Total Estimated C/A.

Net Balance by Days Old

Shows the Estimated Balance (considered the Net amount likely to be paid) by aging days (based on date of service) of 0-29, 30-59, 60-89, and 90+. Split by Patient and Insurance categories, and then Total.

Days are determined by Date of Service.

Patient is the Estimated Balance from Patient Payer Category, Insurance is the Estimated Balance from all Payer Categories except Patient. Total is the total from the Patient and Insurance sections.
% Aged Calculation: Days Old Balance / Total Balance = % Aged

Gross Balance by Days Old

Shows the Actual Balance (doesn't factor in what is likely to pay) by aging days (based on date of service) of 0-29, 30-59, 60-89, and 90+. Split by Patient and Insurance categories, and then Total.

Days are determined by Date of Service.

Patient is the Actual Balance from Patient Payer Category, Insurance is the Actual Balance from all Payer Categories except Patient. Total is the total from the Patient and Insurance sections.
% Aged Calculation: Days Old Balance / Total Balance = % Aged

The bottom of each page of the report will contain the date/time the report was ran.