{{organization_name}}
Organization Name
Example: Example: Atlas Regional Operations
Enter the organization, region, or business unit being reconciled.
Ready to Use
Complete Prompt
This prompt has variables that can be replaced with your own information. Copy and use it with your preferred LLM, or try it out in the LearnerBox Prompt Playground.
Act as a senior FP&A professional facilitating reconciliation between top-down targets and bottom-up forecasts.
Analyze and reconcile the two planning views provided below.
Organization:
{{organization_name}}
Planning period:
{{planning_period}}
Top-down targets:
{{top_down_targets}}
Bottom-up forecast:
{{bottom_up_forecast}}
Assumptions and drivers:
{{assumptions_drivers}}
Strategic and operational constraints:
{{constraints}}
Analysis requirements:
1. Confirm that both views use consistent:
- periods;
- currencies;
- units;
- accounting definitions;
- scope;
- organizational structure; and
- treatment of eliminations.
2. Build a reconciliation bridge from the top-down target to the bottom-up forecast.
3. Quantify variances by:
- revenue;
- volume;
- price;
- mix;
- margin;
- headcount;
- productivity;
- OPEX;
- capital expenditure;
- working capital;
- cash flow; and
- other material drivers.
4. Separate variances caused by:
- different assumptions;
- timing;
- scope;
- methodology;
- ownership;
- strategic ambition;
- operating constraints;
- data quality; and
- unidentified residuals.
5. Identify where top-down expectations are unsupported by current operational capacity or evidence.
6. Identify where bottom-up forecasts may contain conservatism, slack, duplicated cost, omitted opportunity, or inconsistent assumptions.
7. Create a challenge log showing:
- issue;
- owner;
- evidence;
- proposed adjustment;
- decision required;
- deadline; and
- status.
8. Develop reconciliation options:
- accept bottom-up forecast;
- enforce top-down target;
- phased convergence;
- targeted initiatives;
- scope change; or
- revised assumptions.
9. For each option, assess feasibility, financial impact, timing, risk, and accountability.
10. Do not force an artificial reconciliation by using unsupported balancing items.
11. Do not invent savings, growth, capacity, or management commitments.
12. Clearly identify unresolved gaps and decisions requiring executive intervention.
Present the result as:
{{output_format}}
Include:
- comparability check;
- reconciliation bridge;
- variance table;
- assumption-gap analysis;
- operational feasibility assessment;
- challenge log;
- reconciliation options;
- recommended actions;
- ownership and deadlines;
- unresolved decisions; and
- executive summary.Customization Variables
Replace each variable shown in double curly brackets with accurate information from your own professional context.
{{planning_period}}
Planning Period
Example: Example: FY2027 budget
Specify the budget or forecast period.
{{top_down_targets}}
Top-Down Targets
Example: Paste leadership targets for revenue, margin, cost, cash flow, capex, and strategic outcomes.
Include target definitions, scope, and key assumptions.
{{bottom_up_forecast}}
Bottom-Up Forecast
Example: Paste operational forecasts by business unit, product, department, or geography.
Provide detailed operational forecasts and supporting calculations.
{{assumptions_drivers}}
Assumptions and Drivers
Example: List volume, price, headcount, productivity, cost, timing, and capacity assumptions for both views.
The reconciliation depends on understanding which assumptions differ.
{{constraints}}
Strategic and Operational Constraints
Example: Describe capacity, contracts, hiring, supply, systems, funding, and regulatory constraints.
Constraints help assess whether targets are operationally achievable.
{{output_format}}
Output Format
Choose the format appropriate for analysis, workshops, or executive decisions.
Expected Output
A transparent reconciliation between top-down targets and bottom-up forecasts, including variance bridges, assumption gaps, feasibility assessment, challenge logs, reconciliation options, ownership, and unresolved decisions.
💡 Important:
The quality of the result depends on the
completeness, accuracy, and relevance of the
information supplied to the AI.
Prompt Characteristics
These characteristics describe the type of thinking, customization, and output structure involved in using this prompt effectively.
Prompt Anatomy
This breakdown explains how the prompt’s major components work together to guide the AI toward a useful, reliable, and well-structured response.
Role
Positions the AI as a senior FP&A facilitator for target and forecast reconciliation.
Context
Provides top-down targets, bottom-up forecasts, assumptions, drivers, constraints, and period.
Task
Requires a quantified reconciliation and decision-oriented challenge process.
Constraints
Prevents forced balancing, invented savings, unsupported growth, and hidden unresolved gaps.
Output Structure
Requires bridges, variance analysis, feasibility, challenge logs, options, ownership, and decisions.
Input Variables
Organization, planning period, top-down targets, bottom-up forecast, assumptions, constraints, and output format.
Customization Tips
- Ensure both views use the same periods, scope, currency, and accounting definitions.
- Provide driver-level detail rather than only total variances.
- Document who owns each assumption and what evidence supports it.
- Avoid balancing items that conceal unresolved differences.
- Use the challenge log during budget workshops and update it after management decisions.
Responsible Professional Use
Review Before Applying the Output
AI-generated responses can contain errors, omissions, unsupported assumptions, outdated information, or recommendations that do not reflect your jurisdiction or professional context.
Verify calculations, evidence, regulations, standards, policies, and professional recommendations before relying on the result. The qualified professional remains responsible for the final decision.