Cash flow forecasting when your revenue is subscription-based

Michael Dean
Sales and Marketing Director
Data Driven Insights
Financial Reporting
Business Intelligence in Accounting

Subscription businesses have an advantage in cash forecasting that most companies would envy: a large proportion of next quarter's receipts are already contracted. The difficulty is that recognised revenue and cash receipts follow completely different rhythms, and forecasting from the P&L produces confident nonsense.

Why revenue is the wrong starting point

A customer signing a $120,000 annual contract billed upfront generates $120,000 of cash in month one and $10,000 of revenue per month for twelve months. A customer on monthly billing generates $10,000 of each.

Same ARR, entirely different cash profile. If your forecast starts from revenue and applies an average collection assumption, it will be wrong in a direction that depends on your billing mix — and the error grows as the mix shifts.

Cash forecasting for subscription businesses has to start from the billing schedule, not the revenue schedule.

Building the receipts side

Work forward from contracts:

  • Contracted invoices not yet raised. You know the amount and the date from the billing schedule. This is the most reliable component of the entire forecast.
  • Invoices raised, not yet paid. Apply collection behaviour by cohort rather than a single average — enterprise accounts on 60-day terms behave predictably differently from card-paying customers.
  • Renewals. Weight by likelihood. A contract with a signed renewal is different from one in negotiation, which is different from one whose champion has left.
  • Expansion. Forecast conservatively. Expansion is the component most likely to be optimistic.
  • Usage-based revenue. The genuinely variable part. Base it on trailing consumption with a haircut, and reforecast frequently.
  • Churn. Model it as a reduction in future receipts with the right timing — a customer churning at renewal still pays out the current term.

The payments side is easier and often neglected

Most outflows are more predictable than teams assume: payroll and superannuation on known dates, rent and subscriptions on known cycles, supplier payments driven by your own payment run schedule.

The forecastable items people miss are the lumpy ones — BAS and PAYG instalments, income tax, annual insurance renewals, bonus payments, and the annual prepayment on your own software stack. These are known well in advance and are exactly the items that cause a surprise in an otherwise accurate forecast.

Thirteen weeks, rolling

The standard for operational cash management is a rolling 13-week direct forecast — actual expected receipts and payments by week, not an indirect derivation from the P&L.

Thirteen weeks is long enough to see a problem with time to act and short enough to be genuinely forecastable. Rolling means it is updated weekly rather than rebuilt quarterly, so accuracy improves through repetition.

Keep a variance log. Comparing forecast to actual each week, and understanding why they differed, is what turns a forecast into a reliable instrument. Without it you have a spreadsheet that nobody trusts by week six.

Currency

If you invoice in USD and pay costs in AUD, your cash position has an FX exposure that a single-currency forecast hides entirely. Forecast by currency first, then translate — and be explicit about the rate assumption, because a forecast that quietly assumes a fixed rate will surprise you.

This connects to the broader treatment covered in foreign currency translation under AASB 121.

What the system should provide

The forecast should be substantially built from data you already hold — contracted billing schedules, open receivables with ageing, the payment run schedule, and known recurring obligations. If building it requires exporting four reports and rekeying them, it will be rebuilt monthly rather than maintained weekly, and it will be less accurate for it.

Cash and treasury management connected to bank feeds and the billing schedule turns this from an exercise into a report.

Where Cynder fits

We connect billing schedules, receivables and bank data so cash forecasting draws on live information rather than a monthly reconstruction. For companies managing a runway, that difference is material.

Get in touch, or see cutting DSO for the collections side of the same problem.