Analytics
Forecast
The Forecast screen projects cash collections from your current accounts receivable using a fixed formula and only your own payment history. Where that history is missing it says so and leaves the item out. It is a planning aid, not a statistical or machine-learning prediction.
Written for: Finance · Revenue cycle managers · Executives
The screen
Sidebar → Leadership Analytics → Forecast
| Field or control | What it means |
|---|---|
| Projection cards | 30-day and 90-day projections and the last 30 days' collections, above the tabs. |
| Cash Flow | Cash sources over 90 days and a cumulative cash-flow line. |
| AR Liquidation | Current A/R by aging bucket and an A/R liquidation curve. |
| Staffing Impact | Not available: there is no record of your staffing levels against your collections to derive an effect from. |
| Period Breakdown | Period-by-period projected collections, ending A/R and liquidation of the A/R that is forecast, with your historical performance figures from the last 12 months. |
How it is calculated
| Field or control | What it means |
|---|---|
| Collection rates | Each aging bucket's rate is what you collected over the last 12 months from accounts while they were in that bucket (by the account's age, from its opening date, on the day of each payment), as a share of the bucket's balance today. One 365th of that yearly rate is applied to the balance still left on each day of the forecast. A bucket with no payment history has no rate: its balance is listed as not forecast, and no default rate is used. |
| Seasonality | A multiplier per calendar month from your own payments, applied only when every month of the past year has payments. Otherwise no seasonal adjustment is made and the screen says so. |
| Denial recovery | Pending denials are counted as cash only at your own recovery rate and recovery time from the last 12 months. Without that history they are left out and the amount is shown. |
| New charges | New A/R per day from accounts opened in the last 90 days, once 90 days of account history exist. Otherwise ending A/R excludes new charges and says so. |
| Staffing simulation | Not available. It used to be a fixed curve, not a measurement of your team. |
| Ranges | Not shown: no record of past forecasts against actual collections exists to derive one. |