Skip to content
English
Sign in
  • There are no suggestions because the search field is empty.

Billing Receivables Forecasting Dashboard

Helps with forecasting what payment amounts are to be expected on open A/R within the specified date of service range, with an optional ending transaction date to return data only on receivables collected within a specified time frame.

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. 
  • The Estimated Collection Percentage Range is noted in the header of the report output for context.

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.

When running the report without an Ending Transaction Date, the aging is determined based on the current date.

However, if an Ending Transaction Date is entered when this report is ran, the aging is based on that date instead.

Select to either preview the report or download it to one of the Export format options available. Report output is switched to landscape orientation automatically. 

Payer Table

The Payer Table provides a forecast of how your current outstanding Accounts Receivable is likely to resolve, broken down by payer category. It does this by analyzing how bills have historically resolved (what percentage was collected, written off as contractual allowances, or written off as bad debt) and applying those percentages to your current outstanding balances.

Payer Category lists 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 is the total unpaid balance for the date of service range entered, calculated as of the date the report is run or the ending transaction date if one is entered in the report criteria.

Historical Percentage Columns

The next three columns — Estimated C/A %, Estimated Bad Debt %, and Estimated Collection % — are calculated from historical billing data. By default, the system analyzes bills from the 12-month span prior to the report's Start date. If an Estimated Collection Percentage Range is entered in the report criteria, that custom range is used instead. Only zero-balance (fully resolved) bills are included in the calculation, except for the Patient category, which includes all bills regardless of balance.

The date range used for these calculations is displayed in the report header as "Estimated Collection % Based on" for reference.

Estimated C/A % is the historical contractual allowance percentage for each payer category, calculated as contractual allowances divided by charges.

Estimated Bad Debt % is the historical bad debt percentage for each payer category, calculated as bad debt divided by charges.

Estimated Collection % is the historical collection percentage for each payer category, calculated as payments divided by charges. This represents what each payer category has historically paid relative to what was billed.

Note: These three percentages will not likely add up to 100% because bills are often submitted to multiple payers over their lifecycle.

Forecasted Amounts

Estimated Balance Based on Collection % applies the historical collection percentage to the current outstanding balance to estimate what is likely to be paid. Outstanding Balance × Estimated Collection % = Estimated Balance Based on Collection %.

Total Estimated C/A is the sum of each payer category's Outstanding Balance × Estimated C/A %. This estimates how much of the current receivable is likely to be resolved through contractual allowances.

Total Estimated B/D is the sum of each payer category's Outstanding Balance × Estimated Bad Debt %. This estimates how much of the current receivable is likely to be written off as bad debt.

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.