A Rolling Forecast That Survives Month-End

A forecast can be beautifully designed and still stop being useful at month-end. The team pastes in new actuals, shifts a few formulas and loses track of what changed.

A rolling forecast needs two things at once: a current view of the future and a preserved record of what the business expected before the results arrived.

Update the outlook. Do not erase the evidence. Keep a dated version before replacing forecast periods with actuals.

Decide which horizon you are answering

An annual outlook asks how the current year is likely to finish. A rolling twelve-month forecast asks what lies ahead from the latest cut-off. They can both be useful, but their totals do not cover the same period.

Take a fictional business using a calendar-year management plan. After January closes, it has A$90,000 of actual revenue. Its current expectation for February to December is A$1.05 million, and the following January is expected to contribute A$110,000.

Two valid totals with different date ranges — illustrative A$000

View	Calculation	Revenue
Current calendar-year outlook	January actual 90 + February–December forecast 1,050	1,140
Next twelve forecast months	February–December forecast 1,050 + next January forecast 110	1,160

The difference is not a spreadsheet error. The rolling view replaces the completed January with the following January. Put the date range next to every total so nobody mistakes a horizon change for a performance improvement.

Your business may report on a July-to-June financial year or another cycle. The example uses a calendar year only to make the arithmetic easy to follow; apply the same distinction to your actual reporting periods.

Close the period before extending the model

Choose a consistent cut-off and confirm which accounts are reconciled. Where actuals are provisional, label them and document material estimates. A forecast cannot repair a missing bill or a misclassified transaction simply by extending it into the next month.

Before importing the new actuals, preserve the previous forecast with its preparation date, horizon and assumptions. Keep the approved budget separate. The budget-versus-forecast guide explains why those versions answer different questions.

Then replace the completed period with actuals. Check that opening and closing balances still connect and that the new actual period has not also remained in a forecast-only total.

Explain the variance before changing the driver

A customer receipt arriving late is different from a customer cancelling. A vacancy remaining unfilled is different from a permanent reduction in staffing. The model should preserve those distinctions because they imply different future movements.

Classify material variances as timing, amount or changed operating assumption. Write the evidence in a short note and identify the affected future periods. Do not spread every difference evenly over the remainder of the year.

For example, a delayed A$20,000 collection may belong in the following month's cash view without changing revenue. A lost renewal may change both future revenue and associated delivery costs. Check the relevant contract, invoice and operating schedule before changing the model.

Add the new period deliberately

When the horizon rolls forward, the extra month needs more than a copied formula. Review renewal dates, seasonal demand, planned hiring, financing commitments and known one-off payments that enter the window.

Mark assumptions that are extrapolated from history separately from confirmed commitments. Assign owners to the largest uncertain movements. The last month should be less detailed where evidence is limited, but it should not be an unexplained repetition of the month beside it.

For connected financial statements, apply the same driver changes across profit, cash and the balance sheet. Our three-way forecasting example provides the reconciliation checks.

Keep the review small enough to repeat

Use a consistent summary: latest outlook, movement from the previous version, lowest forecast cash point and the decisions that changed. Put the complete account-level detail behind that page.

The government budgeting guide recommends regularly reviewing results and updating forecasts more often than the annual budget. For a growing business, a monthly operating cycle is a practical starting proposal, not a universal rule.

Within that cycle, update urgent payment assumptions when new evidence arrives. Do not wait for month-end to correct a customer receipt that is already known to be late.

Measure whether the process is getting better

Compare each locked forecast with the result for the same dates. Look separately at receipts and payments so offsetting mistakes do not hide each other. Investigate repeated optimistic or pessimistic assumptions rather than judging the whole process by one percentage.

A useful rolling forecast should make the next decision clearer and the previous prediction explainable. More frequent editing is not the same as better forecasting.

Explore MagicHub for our approach to connecting plans, operating assumptions and accounting information.

General business education only, not accounting, tax, legal or financial advice. Worked examples are fictional and simplified, not customer results or industry benchmarks. Confirm the assumptions and obligations that apply to your business with your adviser.