Builds the 13-week forecast.
AR with collection probability by customer. Retention release tied to job completion. AP commitments by week. Backlog conversion off the WIP. Stated vs risk-weighted, side by side.
Forecasting Analyst
A 13-week cash forecast that updates itself. Every Monday.
Builds your rolling cash forecast from AR, retention timing, and AP commitments. Runs scenarios on collection risk and backlog burn. Flags the gap before it shows up in the bank account.
A cash forecast that moves with the work.
Runs the scenarios.
What if Cedar Grove pays 30 days late? What if the new MEP package lands a week behind? Sensitivity on each input. Top three drivers ranked.
Flags collection risk before it bites.
Customer aging plus payment history plus current sentiment from PM calls. The customer drifting from 45 days to 60 surfaces with a name, not a percentage.
Updates as the data moves.
New billing posted, new draw received, new PCO approved. The forecast moves. Controller sees the delta from last cycle without re-running anything.
13 weeks. 9 customers. $1.2M gap surfaced.
FORECASTING ANALYST · RUN #104 · MONDAY 6:45AMLive
Inputs collected
- AR aging$9.4M outstanding, weighted average DSO 47 days.
- Retention$1.6M held across 9 jobs, releases scheduled by completion %.
- AP commitments$7.2M in open POs, weekly payment schedule built.
- Backlog$42M signed, conversion modeled off the WIP.
Outputs produced
- 13-week forecastStated cash position vs risk-weighted. $1.2M gap in week 9.
- ScenariosThree runs: base, 30-day collection slip, MEP package delay.
- Risk register3 customers flagged for collection follow-up.
- DeliveredCash forecast to CFO, controller. Customer-specific notes to AR lead.
Questions about the Forecasting Analyst.
It uses information such as accounts receivable, expected collection timing, retainage, accounts-payable commitments, backlog, and current WIP data to build a rolling 13-week view.
The agent can update the forecast as new billings, collections, commitments, and project changes enter your connected systems. It can also deliver a refreshed forecast on a recurring schedule.
Yes. It can compare a base forecast with scenarios such as a delayed collection, a shifted project start, or a change in backlog conversion, then show which assumptions drive the difference.
No. It prepares the forecast, monitors changes, and surfaces risks. Your finance leaders review the assumptions and use the analysis to make decisions.
See the gap. Before it shows up in the bank.
A 20-minute walkthrough where we run the forecasting analyst on a sample of your jobs. You decide whether you'd want it running every Monday.