How Do You Forecast Cash Flow From Recurring Agency Revenue?

Build a rolling 90-day forecast from three inputs: your active MRR by renewal date, your A/R aging (what's promised but not yet paid), and your trailing collection rate — then subtract your historical churn rate from future renewals. Recurring revenue is the easiest revenue to forecast because it repeats on a known schedule; the real risk is almost always in collection timing, not future demand.

Forecasting cash flow for an agency with recurring clients is different from forecasting one-off project revenue: you already know most of what's coming, because it's sitting in a list of active subscriptions with known amounts and renewal dates. The hard part isn't predicting demand — it's correctly modeling collection timing, churn, and how much of "this month's revenue" is really still owed from last month. Get those three right and forecasting becomes a short monthly update, not a rebuild from scratch.

Why the answer is what it is

Start from committed MRR, not last month's revenue total

List every active subscription by renewal date and dollar amount instead of working from a lump revenue figure. That gives you a hard floor for what should hit your account in the next 30, 60, and 90 days before you adjust for anything else.

Separate billed from collected

An invoice going out is not the same as cash landing in your bank account. Calculate your actual trailing collection rate over the last 3-6 months and apply that rate forward instead of assuming every invoice gets paid on the due date.

Build your own churn and pause rate into the model

Even a stable agency loses some MRR every month to cancellations, pauses, or downgrades. Use your own historical rate as a straight-line reduction against future renewals rather than forecasting as if every client stays at full price forever.

Use A/R aging to correct the near-term number

Your aging buckets — current, 1-30, 31-60, 61-90, 90+ days — show how much of what looks like new cash is actually old, unpaid balance catching up. A forecast built only on new invoicing without checking aging will overstate near-term cash on hand.

Re-forecast on a fixed cadence, not just at quarter-end

A monthly refresh (biweekly if margins are tight) catches drift from churn, new deals, and late payers while it's still small. Waiting until quarter-end to reconcile means three months of small misses compound before anyone notices.

What to look for

  • Pull a list of active subscriptions with renewal date and dollar amount — not last month's lump revenue total
  • Calculate your trailing 3-6 month collection rate (cash actually received vs. amount billed)
  • Pull current A/R aging buckets (current, 1-30, 31-60, 61-90, 90+ days) before projecting the next month
  • Apply your own historical churn/pause rate to future renewals instead of assuming 100% retention
  • Build a rolling 90-day forecast, not a single-month snapshot
  • Flag accounts over 30 days late and forecast them separately from your reliable-payer baseline
  • Re-run the forecast on the same day every month so drift gets caught early, not at quarter-end

Related questions

What's the difference between revenue and cash flow for an agency?

Revenue is what you've billed or earned on paper; cash flow is what actually lands in your bank account, on whatever schedule clients actually pay. An agency can look profitable on revenue while running short on cash if invoices sit unpaid for 30-60 days.

How far out should an agency forecast cash flow?

Ninety days forward is the sweet spot for most agencies — long enough to cover one renewal cycle plus a typical collection lag, short enough to stay grounded in real data instead of speculation. Forecasting further out only holds up if you have unusually stable multi-year contracts.

Does HubWho forecast cash flow automatically?

Not yet. HubWho's reports pull together MRR trend, A/R aging, and cash flow on demand so you have the inputs for your own forecast without exporting to a spreadsheet, but automated revenue forecasting is listed on HubWho's public roadmap rather than available today.

How Roffik addresses this

Billing, ACH and card payments, recurring subscriptions, per-client margin tracking, and branded client portals for marketing agencies — built on Midnight + cyan. Learn more about HubWho.

Keep exploring