The operating problem
Start with a scheduled advisory forecasting cycle. A successful handoff produces a versioned forecast-input pack for adviser review. Define the accountable owner before connecting systems. A forecast is an assumption-driven scenario, not a prediction or assurance. A source event is a request to evaluate the current state; it is not permission to make an irreversible change.
Use your own working copy
The free workbook for this process opens in a browser and works offline after download. It includes editable checks and notes, a text export, and a print view. It is a planning resource: it does not send messages, read account data, or run actions in business systems. No vendor account is needed to use the workbook.
Map the process
1. Define the scenario
Record entities, horizon, currency, source cutoff, and the adviser-approved assumption set.
2. Gather source balances
Read approved cash balances, receivables, payables, and known commitments with timestamps.
3. Separate facts from assumptions
Label timing estimates, collection assumptions, and missing values explicitly.
4. Review the input pack
An adviser checks double counting, one-off transactions, and scenario plausibility.
5. Publish the reviewed version
Link the forecast to its exact inputs and limitations; do not overwrite an approved scenario silently.
Information to check
These reference fields describe the process. Use invented values while planning. Keep real records in an appropriate private system; the public website does not need them.
| Reference field | Working record | Check before progressing |
|---|---|---|
| scenario_id | scenario_id | Resolve the stable source reference in the correct client, entity, and engagement. |
| source_cutoff | source_cutoff | Validate the date, timezone, and approved reporting or review period. |
| assumption_version | assumption_version | Bind approval to this exact source version; changes require review. |
| reviewer_id | reviewer_id | Use the authorized owner or reviewed decision; unknown values stop the handoff. |
Acceptance checks
- Missing balances display unknown rather than zero.
- A new assumption creates a new scenario version.
- A repeated source event creates only one current review task.
- A changed source version invalidates an earlier approval.
Walk through a successful example, a duplicate, a missing item, an incorrect match, and an interrupted handoff with synthetic records. Record the expected result, observed result, owner, and recovery action. Checklists record your work; checking a box does not establish that an external action happened.
Ownership and review
Name the person responsible for the process and the person who can resolve an exception. Define which decisions require qualified professional review. Use stable references, limit access to private records, and document when work must stop. Educational material does not establish legal, accounting, tax, security, or regulatory compliance.
Run a measured pilot
Choose a small, reversible sample. Measure handling time, waiting time, review, rework, and errors before changing the process. Include the effort of maintaining the new method. Expand only when the observed result meets your acceptance criteria; a longer checklist is not proof of improved performance.
Use the free workflow planner to define your next step, or compare the assumptions in the opportunity calculator.