Generate Review-Ready Narratives and Reporting Packs

Finance teams draft executive narratives and refresh recurring CFO/board packs by uploading close workbooks, revenue/expense dashboards, prior MBRs/decks, forecast updates, cash views, owner notes, and Slack/email threads. Codex analyzes variances from forecast, risks, CFO prep questions, and changes since last period, producing Word docs or updated PPTs/PDFs with cited sources for every material number.

Core prompt structure: "Prepare period MBR/CFO pack for team/business. Use list files/context. Draft narrative/pack with key variances, changes since forecast, risks, questions, follow-ups. Cite tab/dashboard/note for each number. Flag missing support or open items."

Customization: Specify audience, priority metrics, unchanged sections, and output format (e.g., Word doc named 'Monthly Business Review Narrative'). Plugins like Google Drive, SharePoint, Spreadsheets, Presentations, Slack, Teams, Gmail/Outlook pull in files directly. Example for April Enterprise Sales MBR uses 'April Close Workbook.xlsx', 'April Revenue Dashboard', prior MBR deck, and #finance-close channel—outputs sourced narrative ready for owner review, saving hours on first drafts.

For packs: Refresh metrics, deltas, charts, commentary from latest KPI dashboard and forecast model; summarize changes and flag slides needing review. Do not invent metrics—unsupported numbers get flagged.

Clean Models and Build Variance Bridges

Before leadership reviews, Codex audits workbooks for structure issues (hardcodes, broken links, circulars, sign errors, period labels, checks) and makes safe fixes while flagging business assumptions for owners. Outputs cleaned .xlsx plus QA memo ranked by severity, focusing on key tabs like Revenue Drivers, Headcount Plan, Cash Forecast.

Prompt: "Clean/review model for audience. Check structure/formulas/etc.. Make safe changes, flag assumptions. Return cleaned model + QA memo with risks, fixes, review needs."

Customization: Prioritize tabs, define safe changes. Example for FY27 Operating Plan pays special attention to Exec Summary tab.

For variances: Bridge actuals vs. budget/forecast across revenue, gross margin, opex, EBITDA, FCF, balance sheet using close books, trackers, dashboards. Reconciles breaks, drafts owner questions, cites drivers. Prompt: "Explain period comparison variance. Use files. Build bridge across lines. Flag unsupported, cite sources." Example for April forecast-to-actual uses FY26 Budget.xlsx, March Forecast.xlsx, Opex Tracker—separates confirmed drivers from queries.

Refresh Forecasts with Scenarios

Update operating/driver models, headcount/cash plans against actuals and assumptions to build base/downside/upside cases. Outputs scenarios with sensitivities, cash/hiring impacts, trigger points, recommendations, and approval lists—includes sensitivity tables.

Prompt: "Refresh plan for business. Use models/actuals/notes. Create scenarios with drivers, impacts, triggers, rec. Include sensitivity table, flag assumptions."

Customization: Define scenarios, approval needs, leadership outputs. Example for FY27 Enterprise forecast uses Revenue Driver Model.xlsx, 13 Week Cash Forecast.xlsx, #fy27-planning notes—flags overwrites, summarizes implications. Plugins enable seamless spreadsheet/presentation handling, turning weekly updates into minutes of prompting.