Excel financial model skill

Sample skill for building an editable and reconcilable workbook from Control actuals, plan values, and cash flow.

Use this sample with an AI client that can create or edit Excel-compatible workbooks in addition to calling Control MCP.

Copy this skill

---
name: excel-financial-model
description: Build an editable financial workbook from reconciled Control actuals, budget values, and cash-flow data.
---

# Excel financial model

1. Confirm the source workbook or template, a distinct destination path, group or entity scope, date range, statement layout, currency, plan, and requested model outputs. Reject a destination that resolves to the source path.
2. Copy the source workbook to the destination path before editing. Make all changes only in that destination copy.
3. Fetch actuals with `get_group_statement_actuals` or, for explicitly named legal entities, `get_entity_statement_actuals`.
4. Resolve the selected plan with `list_budgets` and fetch it with `get_budget_plan_values` when budget or forecast data is requested.
5. Fetch `get_group_cash_flow_monthly` when the model includes cash flow.
6. Reconcile source totals before writing the workbook.
7. Keep imported values in clearly labeled source sheets and put assumptions, calculations, outputs, and checks in separate sheets.
8. Use formulas for derived values. Do not hard-code a calculated result that can reference source or assumption cells.
9. Add checks for statement totals, budget-versus-actual alignment, period coverage, and balance or cash bridges.
10. Preserve an existing workbook's layout and formulas unless the user asks for a redesign.

## Rules

- Control remains the source of truth for imported financial values.
- Record the tenant label, scope, layout, currency, period, plan id, and refresh timestamp inside the workbook.
- Do not silently combine group and entity scopes or local and group currencies.
- Treat missing months or plan rows as missing data, not zero.
- Never overwrite the original workbook. The destination path must be different from the source workbook path, and the completed model must be saved only to that destination.
- Visually distinguish inputs, formulas, linked source values, and validation failures.

## Output

Return the workbook path, a summary of sheets and checks, reconciliation results, and any assumptions or missing data.

Try it

Build an editable Excel model with monthly P&L actuals, budget, variance, and cash flow for January through June 2026.

Populate this board-model template with Q2 group actuals. Preserve its formatting and formulas, and add a reconciliation sheet.

Create a three-statement workbook with actuals as the historical base and a separate assumptions sheet for the forecast.

The workbook is created by the AI client’s spreadsheet capability. Control MCP supplies governed financial data; it does not make an unreviewed workbook authoritative.