Cookie settings
Cash ObservationCASH / SCENARIOS / VISIBILITY

Observe the position.
Question the forecast.

Review

Explain forecast variance before scoring it

Classify differences so an actuals review leads to useful learning.

In this article

A difference between forecast and actual activity is a starting point for investigation. It is not automatically a verdict on the forecast process. Some differences reflect timing, some reflect amount, and others arise because the compared views do not cover the same population. Before calculating an accuracy score or assigning responsibility, establish that the comparison is meaningful. Then explain the drivers in a way that helps the next forecast improve.

Recover the right baseline

Use the forecast version available at the relevant earlier review point. The latest forecast may already incorporate information that was unknown then. Comparing actuals with that revised version can hide the uncertainty the earlier decision really faced. Record the version, preparation time, scope and assumptions of the saved baseline. If the baseline cannot be recovered, state that limitation rather than reconstructing it from memory and presenting the result as historical fact.

Confirm the actuals boundary as well. Ask whether the actuals population is complete for the period and whether any source remains delayed. An incomplete actuals view can create an apparent shortfall that disappears after a refresh. If review proceeds with limited coverage, identify the affected segment. The comparison may still be useful, but readers need to know which conclusions remain provisional and which can be supported by established records.

Classify the difference

A practical first pass distinguishes timing, amount, scope, classification and currency effects. Timing means an expected movement occurred in a different period under the chosen definition. Amount means the observed value differed from the modeled value for the comparable movement. Scope means the included population changed or did not match. Classification means the movement was assigned differently. Currency effects depend on the translation conventions used in the two views.

These categories can overlap. A receipt may be both later and different in amount. The reviewer should explain the treatment so the bridge does not count the same effect twice. Use the organization’s approved methodology for quantification and reconciliation. The categories here are a reasoning aid, not an accounting standard or a universal scorecard. Where the evidence does not support a clean classification, retain an unresolved category with an owner.

Examine a fictional delayed receipt

Suppose a fictional forecast expected a receipt in one reporting period and the corresponding observed activity appeared in the next. The first period shows a difference, but the combined horizon may tell a different story. Calling the entire first-period difference a permanent loss would overstate what the evidence establishes. At the same time, dismissing timing as harmless could ignore why that period mattered to the organization. Explain the timing effect without making either assumption.

Ask what information was available when the original timing was chosen. Was the assumption based on a controlled schedule, a historical pattern or an unsupported carry-forward? Did new information arrive after the baseline was approved? The answers help separate a process improvement from an unavoidable change in circumstances. The review should preserve what was known then, not judge the earlier owner as though later evidence had always been available.

Avoid a score that conceals the story

A single percentage can obscure offsetting errors across categories or periods. A favorable difference in one area may mask an unfavorable difference elsewhere. Near-zero denominators can also make percentage comparisons difficult to interpret. Select metrics through the organization’s reporting policy and explain their limits. This educational method does not prescribe a universal accuracy formula or a target that every treasury team should meet.

Pair any metric with a concise driver narrative and a list of unresolved evidence gaps. Explain which assumptions would change in the next cycle and why. Do not change an assumption merely because one observation differed. A one-time event, a classification correction and a repeated pattern deserve different responses. The owner should consider the evidence relevant to the specific driver and record the rationale for retaining or changing the assumption.

Turn review into a controlled improvement

Close each material review item with an action, owner and trigger for checking the result. An action might clarify a source definition, improve the timing evidence or narrow an assumption’s scope. It need not involve changing software or making a financial decision. In the next cycle, check whether the intended process change actually occurred. A variance review earns its value when it produces a better-supported forecast, not when it produces an impressive retrospective explanation.

Scope and source note

This is an original, independent educational method. It is not a Trovata operating manual, an account diagnosis, or a recommendation to move, borrow or invest money. The official source below supplies product context only; the examples and checklists are our own. Verify actual coverage, permissions and configuration with your organization and provider.

Continue the observation

Read a multicurrency cash view in two layers · Reconcile the cash view before explaining the story · Define the cash view before reading the total

Have a public source that changes this analysis? Suggest a correction. Please don’t send pay statements, tax forms, health or identity records, bank details or account credentials.