Finance Forecast Variance, Cash Runway, and Decision Review

Public field comparison

Finance Forecast Variance and Cash Risk Review

Finance Forecast Variance, Cash Runway, and Decision Review

Analyze budget variance, forecast changes, cash runway risk, operating drivers, and owner-specific corrective actions for finance and leadership reviews.

Reconcile actuals, budget, and forecast; explain operating and accounting drivers; test cash runway scenarios; and produce evidence-linked actions, review gates, and executive decisions.

Use this for reviewing finance forecast variance, cash runway risk, budget drivers, controllable actions, owner follow-ups, and executive-ready finance updates.

Use this prompt to turn management-reporting data into a traceable forecast variance and cash runway review with reconciliations, scenario triggers, owner actions, and executive decision points.

Monthly forecast variance review
Cash runway risk assessment
Budget owner follow-up planning
Finance business partner review
Executive finance update preparation
Runway sensitivity review
Operating spend control planning

Monthly actual-versus-budget and actual-versus-forecast reconciliation
Prior-to-current forecast bridge analysis
Cash roll-forward and liquidity threshold review
Evidence-based runway scenario and trigger assessment
Budget-owner action and approval-gate planning
Executive operating review preparation with unresolved exceptions

Actuals, budget, and forecast
Time period and comparison basis
Revenue and expense drivers
Cash balance and runway assumptions
Known one-time items or anomalies
Budget owners and decision deadline
Reporting constraints and review gates

Actuals, budget, and forecast
Time period and comparison basis
Revenue and expense drivers
Cash balance and runway assumptions
Known one-time items or anomalies
Budget owners and decision deadline
Reporting constraints and review gates

Fill in the variables with actuals, budget, forecast, time period, revenue and expense drivers, cash balance, runway assumptions, known one-time items, budget owners, decision deadline, and reporting constraints. Then run the complete prompt on ChatGPT. Have finance leadership validate the numbers, assumptions, and recommendations before sharing with executives or taking action.

In ChatGPT, replace every bracketed variable with the corresponding finance information. Provide the actual, budget, and forecast extracts; source or control totals; forecast versions; dated cash records; cash-flow assumptions; driver schedules; anomaly support; owner commentary; deadlines; and applicable reporting or approval rules. Redact unnecessary sensitive data, attach or paste the evidence ChatGPT may inspect, and run the prompt. Finance leadership and the relevant accounting, treasury, tax, legal, payroll, or executive reviewers must resolve exceptions and approve consequential actions.

A startup CFO needs to explain a negative forecast variance, assess cash runway sensitivity, identify controllable spend, and decide which corrective actions to discuss at the monthly operating review.

A startup CFO provides the monthly management accounts, approved budget, current and prior forecasts, bank-derived cash total, thirteen-week cash schedule, headcount and vendor drivers, and operating-review deadline. ChatGPT reconciles the source totals, bridges the forecast downgrade, separates recurring operating misses from accrual timing and one-time costs, tests collection-delay and spend-control scenarios, and returns a conditionally ready decision brief because an unapproved cost reduction and a disputed receivable remain unresolved.

Expert

Expert

ChatGPT

ChatGPT

analytics review

analytics review

finance
forecasting
variance-analysis
cash-risk
fp-and-a
budget
runway
executive-brief
risk-management
human-review
cash-flow
budget-owners
operating-review

finance
fp-and-a
forecasting
variance-analysis
cash-runway
cash-flow
financial-reconciliation
scenario-analysis
budget-owners
executive-review
liquidity-risk
management-reporting

Finance Forecast Variance and Cash Risk Prompt

Finance Forecast Variance and Cash Runway Review Prompt

Review forecast variance, cash runway risk, budget drivers, cash-flow sensitivity, owner follow-ups, and FP&A action plans with human finance review gates.

Analyze forecast variance, reconcile cash runway scenarios, trace evidence, and prepare owner actions and executive finance decisions in ChatGPT.

Prompt-body line comparison

Removed Added Unchanged context

−You are a senior FP&A analyst preparing a forecast variance and cash risk review for finance, operating, and executive leaders.
+Analyze the supplied finance evidence and prepare a forecast variance, cash runway, and decision review. Keep reported facts, calculated results, assumptions, hypotheses, conflicts, and unresolved questions distinct.
 
−Analyze the supplied actuals, budget, forecast, cash context, known one-time items, and business drivers. Explain what changed, why it matters, what is controllable, what requires review, and which owner-specific actions should be considered.
+## Input package
 
−The goal is to help finance and operating leaders understand variance, cash risk, runway sensitivity, decision deadlines, and practical corrective actions without overstating certainty.
+Use only information supplied through these variables or files and records provided with the prompt:
 
−## Context Placeholders
+- [Actuals, budget, and forecast]
+- [Time period and comparison basis]
+- [Revenue and expense drivers]
+- [Cash balance and runway assumptions]
+- [Known one-time items or anomalies]
+- [Budget owners and decision deadline]
+- [Reporting constraints and review gates]
 
−Use the context below. If actuals, budget, forecast, time period, or cash context are missing, ask for them before producing the review. If other inputs are missing, continue only with clearly labeled assumptions.
+ChatGPT may analyze text, tables, and files available in the conversation. It cannot access an ERP, planning platform, bank account, payroll system, contract repository, or current external data unless corresponding records are provided. It may propose entries, controls, communications, or actions but must not claim to post, approve, send, execute, or verify them outside the supplied evidence.
 
−* [Actuals, budget, and forecast]
−* [Time period and comparison basis]
−* [Revenue and expense drivers]
−* [Cash balance and runway assumptions]
−* [Known one-time items or anomalies]
−* [Budget owners and decision deadline]
−* [Reporting constraints and review gates]
+## Input threshold and missing-data handling
 
−## Important Constraints
+The minimum basis for a reliable variance review is:
 
−* Do not invent facts, metrics, accounting entries, cash balances, revenue figures, expense figures, runway months, contracts, approvals, forecasts, or stakeholder decisions.
−* Separate confirmed financial data from assumptions, estimates, data-quality questions, and recommendations.
−* Label confidence level and uncertainty for every major conclusion.
−* Treat numbers as management reporting inputs, not audited results, unless explicitly stated.
−* Do not present this output as legal, tax, accounting, investment, fundraising, insolvency, or regulatory advice.
−* Do not recommend irreversible actions such as layoffs, vendor termination, debt actions, fundraising terms, customer contract changes, or major spend cuts without finance and leadership review.
−* Include human review gates for finance, accounting, tax, legal, board, investor, bank covenant, payroll, or executive decisions where relevant.
−* Separate accounting questions, data-quality issues, and timing differences from operational performance issues.
−* Avoid false precision. If inputs are incomplete, provide ranges, sensitivity logic, and required inputs instead of pretending the calculation is exact.
−* Make recommendations specific to the supplied actuals, budget, forecast, period, cash context, business drivers, budget owners, constraints, and decision deadline.
+1. Actual, budget, and current forecast values for the same period, entity or scope, currency, and line-item structure.
+2. The comparison period, forecast version or as-of date, and sign convention.
+3. Source totals or control totals against which material figures can be reconciled.
 
−## Step-by-Step Instructions
+A reliable cash review additionally requires:
 
−1. Summarize the finance context:
+1. Cash balance with an as-of date and identification of restricted versus available cash.
+2. Expected cash inflows and outflows by period, including payroll, taxes, debt service, committed spend, and known collection or payment timing where applicable.
+3. A defined burn and runway convention, scenario horizon, and financing assumptions.
 
−   * time period
−   * actuals
−   * budget
−   * forecast
−   * comparison basis
−   * cash balance
−   * known one-time items
−   * budget owners
−   * decision deadline
−   * reporting constraints
+If the period, scope, currency, actuals, budget, or forecast is absent or irreconcilably ambiguous, ask focused clarification questions before calculating affected variances. If cash timing, available cash, or the runway convention is missing, complete only the supported variance work and mark runway calculations BLOCKED. Useful but non-blocking context includes operational explanations, prior forecast versions, owner commentary, and known anomalies; proceed without it only by recording the gap and lowering confidence.
 
−2. Analyze forecast and budget variance:
+When sources conflict, preserve both values, identify their source and as-of date, quantify the difference when possible, and mark the affected conclusion UNRESOLVED. Never silently choose a value. Do not infer missing financial values from narrative commentary.
 
−   * revenue variance
−   * volume variance
−   * price variance
−   * mix variance
−   * timing variance
−   * churn or retention impact
−   * pipeline or bookings impact
−   * COGS or gross margin impact
−   * headcount variance
−   * payroll variance
−   * vendor variance
−   * cloud or infrastructure spend
−   * marketing spend
−   * one-time items
−   * accrual or accounting timing
−   * data-quality issues
+## Evidence and calculation rules
 
−3. Separate variance types:
+- Assign each supplied source a short evidence ID and record its title or description, period, version or as-of date, scope, currency, and whether it is management-reported, system-exported, owner-provided, or assumed.
+- Cite evidence IDs for every material figure and major conclusion. A statement without support must be labeled ASSUMPTION, HYPOTHESIS, or UNKNOWN.
+- Treat all figures as management reporting unless the source explicitly establishes another status. Do not call results audited, approved, final, or verified without evidence of that status.
+- Preserve supplied units, currency, entity scope, period granularity, and rounding. Flag mixed currencies, inconsistent signs, duplicate records, stale versions, mapping gaps, and inconsistent period definitions.
+- State the variance formula and sign convention before presenting results. Unless the input specifies otherwise, calculate numeric variance as actual minus comparator, then assess favorable or unfavorable based on economic effect rather than arithmetic sign alone.
+- Keep actual versus budget, actual versus current forecast, and current forecast versus prior forecast separate. Do not populate a comparison that lacks a supported comparator.
+- Decompose material movements only where the data supports the method. Distinguish volume, price, mix, churn or retention, bookings or pipeline, gross margin, headcount, payroll, vendor, cloud, marketing, foreign exchange, timing, accrual, classification, and one-time effects without double counting.
+- Separate recurring from one-time, controllable from non-controllable, cash from non-cash, and timing from structural effects. Record any disputed classification.
+- Use the materiality threshold supplied in the reporting constraints. If none is supplied, do not invent one; rank movements by absolute and percentage size, state that materiality is undefined, and request management confirmation.
+- Calculate simple runway as available unrestricted cash divided by representative net cash burn only when the burn basis and its representativeness are supported. Otherwise use a period-by-period cash roll-forward or mark the result unavailable. State whether runway means months until zero cash, a minimum liquidity buffer, or another supplied threshold.
+- Do not treat booked revenue, EBITDA, accounting profit, or non-cash savings as cash without evidence of timing and collectability. Do not count proposed savings until their timing, feasibility, approval status, and cash effect are supported.
+- Give each major conclusion a confidence rating: HIGH when directly supported and reconciled; MEDIUM when supported but subject to an identified limitation; LOW when substantially dependent on assumptions, incomplete mappings, or unresolved conflicts.
 
−   * actual vs budget
−   * actual vs forecast
−   * current forecast vs prior forecast
−   * recurring vs one-time
−   * controllable vs not controllable
−   * cash impact vs non-cash impact
−   * timing issue vs structural issue
+## Analysis workflow
 
−4. Assess cash risk:
+### 1. Establish the reporting basis
 
−   * current cash position
−   * burn pattern
−   * runway sensitivity
−   * committed spend
−   * avoidable spend
−   * receivables timing
−   * payables timing
−   * payroll obligations
−   * tax or statutory obligations if supplied
−   * debt or covenant risk if supplied
−   * fundraising or financing dependency if supplied
−   * decision deadlines
+Normalize the period, entity scope, currency, units, forecast versions, source hierarchy, sign convention, materiality basis, cash definition, and decision deadline. Record ambiguities before analysis.
 
−5. Identify owner-specific actions:
+### 2. Reconcile the source data
 
−   * finance actions
−   * budget owner actions
−   * revenue owner actions
−   * expense owner actions
−   * executive decisions
−   * data cleanup actions
−   * accounting review items
−   * external advisor review items if relevant
+Tie actual, budget, forecast, and cash totals to supplied control totals. Recompute key subtotals and detect missing periods, duplicates, mapping differences, inconsistent formulas, and unexplained residuals. Do not force a reconciliation; retain each exception with its amount and affected conclusions.
 
−6. Prepare an executive-ready brief:
+### 3. Build the variance and forecast bridges
 
−   * what changed
−   * why it changed
−   * cash risk
−   * forecast confidence
−   * key decisions needed
−   * recommended actions
−   * unresolved questions
+Calculate supported comparisons and identify the drivers of each material movement. For a prior-to-current forecast bridge, show that the prior forecast plus individually identified changes and any explicit unexplained residual equals the current forecast. Prevent the same effect from appearing in multiple driver categories.
 
−## Output Format
+### 4. Assess cash exposure
 
−### 1. Missing Context
+Build a dated cash view using available cash, collections, committed and discretionary outflows, payroll, statutory obligations, debt service, financing dependencies, and minimum liquidity requirements. Identify concentration, timing, covenant, payroll, tax, receivables, payables, and committed-spend risks only when relevant evidence is supplied.
 
−List missing inputs needed before a reliable finance review can be completed. If enough context is available, say so.
+### 5. Test scenarios and triggers
 
−### 2. Finance Snapshot
+Create a base case plus only decision-relevant downside or management-action cases supported by stated assumptions. Keep opening cash, horizon, and accounting scope consistent across cases. Show incremental cash effects, lowest cash point, threshold-breach date, runway effect, dependencies, reversibility, and trigger conditions. Do not present illustrative scenarios as forecasts.
 
−Use this table:
+### 6. Develop owner actions and decisions
 
−| Area | Current View | Evidence | Risk or Uncertainty |
−| ---- | ------------ | -------- | ------------------- |
+Separate data correction, accounting review, operating action, cash preservation option, and executive decision. For each item, identify the accountable owner role, evidence, expected cash or forecast effect, timing, dependency, reversibility, approval gate, and consequence of delay. Treat savings and forecast effects as estimates until validated.
 
−Cover actuals, budget, forecast, time period, cash balance, known anomalies, and decision deadline.
+Do not authorize layoffs, delayed statutory payments, covenant actions, debt or fundraising terms, vendor termination, customer contract changes, accounting entries, or material spending commitments. Escalate these for the appropriate finance, accounting, tax, legal, treasury, payroll, board, investor, lender, or executive review. If the evidence suggests an imminent inability to meet payroll, statutory obligations, debt service, covenant requirements, or minimum liquidity, flag the timing prominently and stop short of prescriptive legal, tax, insolvency, investment, or regulatory advice.
 
−### 3. Variance Driver Table
+Protect sensitive data: use aggregated or redacted employee, customer, vendor, bank, and investor information unless record-level detail is necessary and authorized. Do not reproduce bank credentials, tax identifiers, personal payroll data, or other secrets.
 
−Use this table:
+## Required deliverable
 
−| Line Item or Driver | Actual | Budget | Forecast | Variance | Likely Driver | Cash Impact | Owner Role | Confidence |
−| ------------------- | -----: | -----: | -------: | -------: | ------------- | ----------- | ---------- | ---------- |
+Produce the following sections in order. Use NOT PROVIDED, NOT CALCULABLE, BLOCKED, or UNRESOLVED instead of fabricated content.
 
−If exact numbers are not supplied, use qualitative descriptions and state what data is needed.
+### 1. Review status and blocking questions
 
−### 4. Forecast Change Review
+State the overall handoff state as READY FOR FINANCE REVIEW, CONDITIONALLY READY, or BLOCKED. List each blocking question, why it matters, the affected calculation or decision, and the owner role expected to resolve it.
 
−Use this table:
+### 2. Reporting basis and evidence register
 
−| Change | Prior View | Current View | Driver | Recurring or One-Time | Action Needed |
−| ------ | ---------- | ------------ | ------ | --------------------- | ------------- |
+| Evidence ID | Source or Record | Period and As-of Date | Scope and Currency | Evidence Status | Limitation or Conflict |
+|---|---|---|---|---|---|
 
−### 5. Cash Risk Assessment
+Then state the comparison formulas, sign convention, materiality basis, cash definition, runway definition, rounding, and forecast versions used.
 
−Use this table:
+### 3. Reconciliation ledger
 
−| Cash Risk | Evidence | Timing | Severity | Owner Role | Mitigation or Decision Needed |
−| --------- | -------- | ------ | -------- | ---------- | ----------------------------- |
+| Reconciliation Check | Source Total | Recomputed Total | Difference | Expected Condition | Actual Observation | Evidence ID | Status | Resolution Owner |
+|---|---:|---:|---:|---|---|---|---|---|
 
−### 6. Runway Sensitivity Review
+Include actual, budget, forecast, prior forecast when supplied, and opening or current cash controls. Explain every non-zero or non-tolerated difference; do not conceal residuals in an “other” category.
 
−Use this table:
+### 4. Material variance register
 
−| Scenario | Key Assumption | Cash Effect | Runway Effect | Confidence | Decision Trigger |
−| -------- | -------------- | ----------- | ------------- | ---------- | ---------------- |
+| Line Item or KPI | Comparison | Actual | Comparator | Variance Amount | Variance Percent | Favorability | Driver Classification | Recurring or One-Time | Cash or Non-Cash | Controllability | Evidence ID | Confidence |
+|---|---|---:|---:|---:|---:|---|---|---|---|---|---|---|
 
−If runway inputs are incomplete, explain what inputs are required before calculating runway.
+After the table, explain the supported causal chain for each material item and identify alternative hypotheses or missing driver evidence. Mark percentage variance not meaningful when the comparator is zero, near zero, or sign-changing.
 
−### 7. Corrective Action Plan
+### 5. Forecast revision bridge
 
−Use this table:
+| Forecast Metric | Prior Forecast | Revenue Changes | Cost Changes | Timing or Accounting Changes | One-Time Changes | Unexplained Residual | Current Forecast | Bridge Check | Evidence ID |
+|---|---:|---:|---:|---:|---:|---:|---:|---|---|
 
−| Action | Owner Role | Expected Impact | Deadline | Review Gate | Risk |
−| ------ | ---------- | --------------- | -------- | ----------- | ---- |
+Omit this section only if no prior forecast exists, and explicitly state that limitation.
 
−### 8. Accounting, Data, and Reporting Questions
+### 6. Cash roll-forward and liquidity risks
 
−List accounting questions, data-quality issues, timing questions, missing owner inputs, and checks needed before executive sharing.
+| Period | Opening Available Cash | Expected Inflows | Committed Outflows | Discretionary Outflows | Financing Flows | Net Cash Movement | Closing Available Cash | Minimum Liquidity Buffer | Headroom or Shortfall | Evidence ID |
+|---|---:|---:|---:|---:|---:|---:|---:|---:|---:|---|
 
−### 9. Executive Review Notes
+Follow with a risk register:
 
−Provide a concise executive-ready summary covering the headline variance, cash risk, key drivers, recommended actions, decisions needed, and unresolved questions.
+| Cash Risk | Exposure and Timing | Supporting Evidence | Early Warning Indicator | Decision Trigger | Owner Role | Required Review | Confidence |
+|---|---|---|---|---|---|---|---|
 
−### 10. Human Review Gates
+Do not combine restricted cash with available liquidity. Clearly label uncommitted financing, uncertain collections, and unapproved spend reductions.
 
−List finance, accounting, tax, legal, executive, board, investor, payroll, or external advisor reviews required before action.
+### 7. Runway and scenario decision matrix
 
−## Verification Checklist
+| Scenario | Purpose, Not Status | Changed Assumptions | Monthly or Period Cash Effect | Lowest Cash and Date | Runway or Threshold Date | Trigger | Dependency | Reversibility | Evidence Basis | Confidence |
+|---|---|---|---|---|---|---|---|---|---|---|
 
−Before finalizing, confirm that:
+Show the base case and only supported alternatives. Explain the calculation method, identify assumptions held constant, and reconcile each scenario to the base case. If runway cannot be calculated, list the exact missing values and decisions affected.
 
−* actuals, budget, forecast, and time period are clearly separated
−* uncertain calculations are labeled
−* one-time and recurring drivers are separated
−* cash-impact and non-cash items are separated
−* owner roles are assigned for follow-up actions
−* runway sensitivity does not use invented inputs
−* accounting and data-quality questions are separated from operating actions
−* major financial actions require human finance and leadership review
−* executive notes do not present unaudited numbers as final results
−* missing inputs and human checks are clearly listed
+### 8. Owner action and decision register
 
−## Final Instruction to Begin
+| Item | Type | Owner Role | Evidence or Rationale | Expected Forecast Effect | Expected Cash Effect and Timing | Deadline | Dependency | Approval or Review Gate | Reversibility | Status |
+|---|---|---|---|---|---|---|---|---|---|---|
 
−Begin now. First review the supplied actuals, budget, forecast, time period, revenue and expense drivers, cash context, known one-time items, budget owners, reporting constraints, and decision deadline. If required context is missing, ask for it. Otherwise, produce the full finance forecast variance and cash risk review in the requested markdown format.
+Allowed statuses are PROPOSED, VALIDATION REQUIRED, APPROVAL REQUIRED, BLOCKED, and CONFIRMED COMPLETE. Use CONFIRMED COMPLETE only when supplied evidence proves completion; analysis or recommendation alone is not completion.
+
+### 9. Accounting, data, and control exceptions
+
+| Exception | Category | Amount or Scope | Affected Output | Evidence Conflict or Gap | Required Check | Owner Role | Due Date | Resolution State |
+|---|---|---|---|---|---|---|---|---|
+
+Keep accounting classification and timing questions separate from operational underperformance. Do not propose a journal entry as final accounting treatment.
+
+### 10. Verification and acceptance report
+
+Perform and report these checks when the required evidence exists:
+
+| Check | Method | Expected Observation | Actual Observation | Evidence | Status | Unresolved Consequence |
+|---|---|---|---|---|---|---|
+
+Include:
+
+1. Actual, budget, and forecast totals tie to their supplied controls for the same period, scope, currency, and units.
+2. Each material variance recomputes from displayed values under the stated formula and sign convention.
+3. Variance-driver components equal the total movement or expose a quantified residual.
+4. Prior forecast plus bridge movements equals current forecast.
+5. Opening cash plus inflows minus outflows and financing flows equals closing cash for every modeled period.
+6. Closing cash from one period equals the next period’s opening cash unless a documented scope adjustment explains the difference.
+7. Restricted cash, non-cash items, uncommitted financing, and unapproved savings are not included as available liquidity.
+8. Each scenario reconciles to the base case and changes only its disclosed assumptions.
+9. Runway or threshold dates reproduce from the displayed cash schedule and stated definition.
+10. One-time and recurring effects, and timing and structural effects, are not double counted.
+11. Every material conclusion, proposed action, and claimed completion has an evidence ID or an explicit uncertainty label.
+12. Required finance, accounting, treasury, payroll, tax, legal, executive, board, investor, lender, or external-advisor gates are identified where applicable.
+
+Use PASS only when the expected observation is met and supported by evidence; FAIL when tested evidence contradicts it; BLOCKED when required evidence is missing; and NOT APPLICABLE with a reason. If a supplied tolerance governs reconciliation, apply and cite it. If no tolerance is supplied, report exact differences without declaring them immaterial.
+
+The deliverable is READY FOR FINANCE REVIEW only when core source totals reconcile, material variances recompute, the forecast bridge and cash roll-forward pass when applicable, major conclusions are evidence-linked, and no unresolved issue could materially change the headline or near-term liquidity decision. Use CONDITIONALLY READY when exceptions are quantified and bounded but still require review. Use BLOCKED when missing or conflicting evidence prevents a reliable headline variance, cash position, or decision deadline assessment.
+
+### 11. Executive decision brief
+
+Provide a concise brief containing:
+
+- the period, scope, currency, and management-reporting status;
+- the headline actual-versus-budget and actual-versus-forecast movements;
+- the forecast revision and primary recurring, one-time, timing, and structural drivers;
+- available cash, lowest projected cash point, runway or threshold range, and confidence;
+- decisions required by date, with owner and approval gate;
+- proposed reversible actions and their validated or unvalidated cash effects;
+- unresolved exceptions that could change the conclusion; and
+- the handoff state and required human reviewers.
+
+Do not describe the analysis, recommendations, reconciliations, scenarios, actions, or decisions as approved, executed, audited, or final unless supplied evidence establishes that status.