了解财务团队如何利用 Codex 构建可用于月度业务回顾、报告、差异分析和规划的审核就绪资产。
借助 Codex，财务团队只需构建即可。从您已有的结账工作簿、收入和支出仪表板、预测更新、之前的 MBR 以及负责人备注开始。Codex 可帮助将这些背景信息转化为您的团队可以审核、完善和分享的有形输出——无需编码。花更少的时间整理初稿，更多的时间塑造故事、验证数字并为未来的决策做准备。
在我们的点播网络研讨会中了解更多关于在日常工作中使用 Codex 的信息。
财务团队的 Codex 主要用例
准备好用真实的财务工作尝试 Codex 了吗？从一个入门提示词开始，然后探索一个完整构建的示例，该示例展示了相同的工作流程在结合真实文件、系统、约束条件和审核期望后如何变得更加强大。每个用例还包含建议的技能和插件，以帮助 Codex 在您的技术栈中工作，从而使您的团队能够更快地获得可审核的初稿，并将更多时间花在重要的判断、分析和决策上。
- 月度业务回顾报告
何时使用：您需要一份面向 CFO 的说明，以解释结账后的业绩、关键差异、风险和后续行动。
您提供的内容 | Codex 返回的内容 结账工作簿、收入和支出仪表板、预测更新、之前的 MBR、负责人备注、财务结账背景 | 一份审核就绪的 MBR 报告文档，包含关键差异、风险、CFO 准备问题、来源引用和负责人后续行动
建议的插件：Google Drive、SharePoint、Box、电子表格、演示文稿、文档、Slack、Teams、Gmail、Outlook 邮件。
工作原理
- Codex 审查结账工作簿、仪表板、预测更新、之前的 MBR 和负责人备注。
- 它识别关键差异、自预测以来的变化、风险以及 CFO 准备问题。
- 它创建一份审核就绪的报告文档，其中包含有来源支持的数据和负责人后续行动。
入门提示词
试试看
准备 [月份/季度] 针对 [业务/团队] 的管理层业务回顾报告。使用我提供的结账工作簿、收入和费用仪表板、预测更新、上一期管理层业务回顾报告、负责人备注以及财务结账背景信息。起草一份面向高管的叙述性报告，包含关键差异、自预测以来的变化、风险、CFO 准备问题以及按负责人划分的后续行动。对于每个重要数字，需注明其来源的工作簿标签页、仪表板或源文件备注。
真实案例
为 Acme 公司的企业销售团队准备四月份的管理层业务回顾报告。使用“四月结账工作簿.xlsx”、“四月收入仪表板”、“四月预测更新”、“三月管理层业务回顾报告.pptx”、“四月管理层业务回顾负责人输入”中的负责人备注、4月22日至4月30日期间 #finance-close 频道中的信息，以及我提供的任何相关结账背景资料。
起草一份面向高管的叙述性报告，包含关键收入和费用差异、自预测以来的变化、风险、CFO 准备问题以及按负责人划分的后续行动。对于每个重要数字，需注明其来源的工作簿标签页、仪表板或源文件备注。将草稿创建为一个名为“月度业务回顾报告”的 Microsoft Word 文档。
- 财务模型清理与分析
适用场景：你需要在一次高风险的审查前，通过检查公式、结构、数据来源和假设，来提高模型的可靠性。
你提供的内容：财务模型、支持的源文件、审查受众、优先检查的标签页、清理规则以及需要财务负责人审查的假设。Codex 返回的内容：一个在安全范围内清理后的工作簿，以及一份按严重程度排序的质量保证备忘录，其中包含发现的问题、已修复的内容、剩余的假设以及需要审查的单元格或标签页。
建议使用的插件：Spreadsheets、Google Drive、SharePoint、Box、Documents、Slack、Teams、Gmail、Outlook Email。
工作原理
- Codex 会审查工作簿的结构、公式、硬编码数值、链接、检查项、数据源核对以及输出标签页。
- 它会在适当的情况下进行安全的清理修改，并标记出需要财务负责人审查的假设。
- 它会在安全范围内创建一个清理后的模型，以及一份质量保证备忘录，其中包含高风险问题、已修复的内容以及剩余的审查项。
入门提示词
试试看
在将[模型名称]交付给[受众]之前，对其进行清理和审查。检查工作簿结构、公式、硬编码、断开的链接、循环引用、符号约定、期间标签、数据源核对、模型检查以及输出选项卡。在适当的情况下进行安全的清理修改，但除非明确指出，否则不得更改业务假设。如果安全，则返回清理后的模型，并附上一份质量保证备忘录，其中包含高风险问题、已修复内容、剩余假设以及需要财务负责人审查的单元格或选项卡。
真实案例
在将“FY27运营计划模型.xlsx”提交给领导团队之前，对其进行清理和审查。检查工作簿结构、公式、硬编码、断开的链接、循环引用、符号约定、期间标签、数据源核对、模型检查以及输出选项卡。
在适当的情况下进行安全的清理修改，但除非明确指出，否则不得更改业务假设。如果安全，则返回清理后的工作簿，并附上一份质量保证备忘录，其中包含高风险问题、已修复内容、剩余假设以及需要财务负责人审查的单元格或选项卡。请特别注意“收入驱动因素”、“人员编制计划”、“现金预测”和“高管摘要”选项卡。
- 定期CFO和董事会报告包
使用场景：通过根据最新的源材料刷新指标、评论和待解决问题，加快定期高管报告的生成速度。
您提供的内容 | Codex 返回的内容 最新预测模型、KPI仪表盘、上一期报告包、现金流视图、预测说明、负责人输入信息以及待解决问题 | 一份刷新后的报告包，包含更新的指标、差异、图表、评论、待定假设、需要负责人输入的信息以及高管审查意见
建议插件：演示文稿、电子表格、Google Drive、SharePoint、Box、文档、Slack、Teams、Gmail、Outlook邮件。
工作原理
- Codex 审查最新的预测模型、KPI仪表盘、上一期报告包、现金流视图、预测说明以及负责人输入信息。
- 它更新指标、差异、图表、评论以及待解决问题。
- 它创建一份刷新后的CFO或董事会报告包，其中包含变更摘要、仍需输入的内容以及需要高管审查的部分。
起始提示词
尝试一下
刷新 [CFO/董事会] 报告包，用于 [月份/季度]。使用最新的预测模型、KPI 仪表盘、上一期报告包、现金视图、预测说明、负责人输入信息以及我提供的未决问题。更新关键指标、差异、图表和评论。创建一个报告包摘要，说明哪些内容发生了变化、哪些需要负责人输入、哪些假设仍未确定，以及哪些幻灯片或章节需要高管审阅。
真实案例
刷新 Acme 公司 5 月份的 CFO 报告包。使用“5月预测模型.xlsx”、“5月 KPI 仪表盘”、“4月董事会报告包.pptx”、“5月现金视图”、“预测说明 - 5月”、“CFO 报告包未决问题”中的负责人输入信息，以及来自 #cfo-staff 频道的相关讨论。
更新关键指标、差异、图表和评论。创建一个可供 CFO 直接使用的报告包摘要，说明自 4 月董事会报告包以来哪些内容发生了变化、哪些仍需要负责人输入、哪些假设仍未确定，以及哪些幻灯片或章节需要高管审阅。不要凭空捏造指标。标记任何无法追溯到预测模型、KPI 仪表盘、现金视图或负责人说明的数字。
- 差异驱动因素分析
使用场景：当您需要解释收入、费用、现金或 KPI 各条线在实际数、预算和预测之间的变动驱动因素时。
您提供的内容：实际数、预算、预测、上一期预测、KPI 仪表盘、差异阈值、负责人说明及相关源文件。Codex 返回的内容：一份差异分析交付物，包含按驱动因素排序的变动、有来源依据的解释、标记的异常、未决问题以及负责人后续跟进事项。
建议插件：电子表格、文档、演示文稿、Google Drive、SharePoint、Box、Slack、Teams、Gmail、Outlook 邮件。
工作原理
- Codex 会比较实际数、预算、预测、上一期预测、KPI 数据和负责人说明。
- 它会识别出最大的驱动因素、异常情况、有来源依据的解释以及未决问题。
- 它会创建一份差异分析交付物，包含按重要性排序的驱动因素、评论、负责人后续跟进事项，以及可选的图表或幻灯片就绪摘要。
起始提示词
试试看
解释[实际/预算/预测/先前预测]之间的[期间]差异。使用我提供的结账工作簿、预算文件、先前预测、收入仪表板、运营支出追踪器、现金视图以及财务负责人备注。在相关情况下，构建涵盖收入、毛利率、运营支出、EBITDA、自由现金流和资产负债表驱动因素的差异桥接。起草可供负责人审阅的问题，核对数据源断点，并标记任何缺乏数据源支持的差异。
实际案例
解释 Acme 公司四月份预测与实际的变动情况。使用“四月结账工作簿.xlsx”、“FY26 预算.xlsx”、“三月预测.xlsx”、“四月收入仪表板”、“四月运营支出追踪器”、“四月现金视图”以及来自 #finance-close 频道的财务负责人备注。
在相关情况下，构建涵盖收入、毛利率、运营支出、EBITDA、自由现金流和资产负债表驱动因素的差异桥接。起草可供负责人审阅的后续问题，核对数据源断点，并标记任何缺乏数据源支持的差异。引用每个关键驱动因素背后的工作簿标签页、仪表板、追踪器或负责人备注。
- 预测刷新与情景规划
适用场景：当你需要根据新假设更新预测、比较不同情景，并将结果转化为可供审阅的规划文档时使用。
你提供的内容：预测模型、最新实际数据、假设更新、业务负责人输入、情景规则、规划日历以及先前预测。Codex 返回的内容：一份刷新后的预测与情景规划交付物，包含基准、乐观和悲观情景；假设变更；关键敏感性因素；风险以及审阅备注。
建议使用的插件：电子表格、文档、演示文稿、Google Drive、SharePoint、Box、Slack、Teams、Gmail、Outlook 邮件。
工作原理
- Codex 会审阅先前预测、最新实际数据、假设更新、负责人输入以及情景规则。
- 它会在安全范围内更新预测，构建或比较不同情景，并识别关键敏感性因素、风险以及待定的假设。
- 它会创建一份刷新后的预测与情景规划交付物，包含审阅备注、有数据源支持的假设变更，以及可选的图表或幻灯片格式摘要。
启动提示词
试试看
刷新【业务】的【预测或运营计划】。使用我提供的运营模型、收入驱动模型、人员编制计划、现金预测、最新实际数据、已批准的规划假设以及领导层笔记。创建基准、下行和上行三种情景，涵盖关键驱动因素、现金影响、招聘影响、触发点以及一项建议。包含一个敏感性分析表，并列出在计划分享前需要获批的假设。
实际案例
刷新 Acme 企业业务的 FY27 预测。使用“FY27 运营计划模型.xlsx”、“收入驱动模型.xlsx”、“人员编制计划.xlsx”、“13 周现金预测.xlsx”、四月实际数据、“FY27 规划假设”中已批准的规划假设，以及来自 #fy27-planning 频道的领导层笔记。
创建基准、下行和上行三种情景，涵盖关键的收入、利润率、招聘和现金驱动因素。总结现金影响、招聘影响、触发点以及你的建议。包含一个敏感性分析表，并列出在计划分享前需要获批的假设。在未标记审查的情况下，不得覆盖业务假设。
更多资源
继续探索 Codex 在工作中的应用，请参考以下资源：
Codex 工作中心 Codex 日常工作点播网络研讨会 Codex 在工作中的十大用途
See how finance teams can use Codex to build review-ready assets for monthly business reviews, reporting, variance analysis, and planning.
With Codex, finance teams can just build things. Start with the close workbooks, revenue and expense dashboards, forecast updates, prior MBRs, and owner notes you already use. Codex helps turn that context into tangible outputs your team can review, refine, and share—no coding required. Spend less time assembling the first pass and more time shaping the story, validating the numbers, and preparing for the decisions ahead.
Learn more about using Codex for everyday work in our on-demand webinar .
Top Codex use cases for finance teams
Ready to try Codex with real finance work? Start with a starter prompt, then explore a fully built example that shows how the same workflow becomes more powerful with real files, systems, constraints, and review expectations. Each use case also includes suggested skills and plugins to help Codex work across your tech stack, so your team can get to a reviewable first pass faster and spend more time on the judgment, analysis, and decisions that matter.
- Monthly business review narrative
Use this when:You need a CFO-ready story that explains performance, key variances, risks, and follow-ups after close.
What you bringWhat Codex returns Close workbook, revenue and expense dashboards, forecast update, prior MBR, owner notes, finance close context A review-ready MBR narrative document with key variances, risks, CFO prep questions, source citations, and owner follow-ups
Suggested plugins:Google Drive, SharePoint, Box, Spreadsheets, Presentations, Documents, Slack, Teams, Gmail, Outlook Email.
How it works
- Codex reviews close workbooks, dashboards, forecast updates, prior MBRs, and owner notes.
- It identifies key variances, changes since forecast, risks, and CFO prep questions.
- It creates a review-ready narrative document with source-backed numbers and owner follow-ups.
Starter prompt
Try it out
Prepare the [month/quarter] management business review story for [business/team]. Use the close workbook, revenue and expense dashboards, forecast update, prior MBR, owner notes, and finance close context I provide. Draft an executive-ready narrative with key variances, what changed since forecast, risks, CFO prep questions, and follow-ups by owner. Cite a workbook tab, dashboard, or source note for every material number.
Real-world example
Prepare Acme’s April management business review story for the Enterprise Sales team. Use “April Close Workbook.xlsx,” “April Revenue Dashboard,” “April Forecast Update,” “March MBR Deck.pptx,” owner notes in “April MBR Owner Inputs,” #finance-close from April 22 through April 30, and any related close context I provide.
Draft an executive-ready narrative with key revenue and expense variances, what changed since forecast, risks, CFO prep questions, and follow-ups by owner. Cite a workbook tab, dashboard, or source note for every material number. Create the draft as a Microsoft Word document named “Monthly Business Review Narrative.”
- Finance model cleanup and analysis
Use this when:You need to improve a model’s reliability before a high-stakes review by checking formulas, structure, sources, and assumptions.
What you bringWhat Codex returns Financial model, supporting source files, review audience, priority tabs, cleanup rules, and assumptions that require finance-owner review A cleaned workbook where safe, plus a severity-ranked QA memo with issues found, fixes made, remaining assumptions, and cells or tabs needing review
Suggested plugins:Spreadsheets, Google Drive, SharePoint, Box, Documents, Slack, Teams, Gmail, Outlook Email.
How it works
- Codex reviews workbook structure, formulas, hardcodes, links, checks, source tie-outs, and output tabs.
- It makes safe cleanup changes where appropriate and flags assumptions that require finance-owner review.
- It creates a cleaned model where safe, plus a QA memo with high-risk issues, fixes made, and remaining review items.
Starter prompt
Try it out
Clean and review [model name] before it goes to [audience]. Check workbook structure, formulas, hardcodes, broken links, circulars, sign conventions, period labels, source tie-outs, checks, and output tabs. Make safe cleanup changes where appropriate, but do not change business assumptions without calling them out. Return a cleaned model if safe, plus a QA memo with high-risk issues, fixes made, remaining assumptions, and cells or tabs that need finance-owner review.
Real-world example
Clean and review “FY27 Operating Plan Model.xlsx” before it goes to the leadership team. Check workbook structure, formulas, hardcodes, broken links, circular references, sign conventions, period labels, source tie-outs, model checks, and output tabs.
Make safe cleanup changes where appropriate, but do not change business assumptions without calling them out. Return a cleaned workbook if safe, plus a QA memo with high-risk issues, fixes made, remaining assumptions, and cells or tabs that need finance-owner review. Pay special attention to the “Revenue Drivers,” “Headcount Plan,” “Cash Forecast,” and “Exec Summary” tabs.
- Recurring CFO and board reporting pack
Use this when:Speed recurring executive reporting by refreshing metrics, commentary, and open questions from the latest source materials.
What you bringWhat Codex returns Latest forecast model, KPI dashboard, prior reporting pack, cash view, forecast notes, owner inputs, and open questions A refreshed reporting pack with updated metrics, deltas, charts, commentary, open assumptions, owner-input needs, and executive review notes
Suggested plugins:Presentations, Spreadsheets, Google Drive, SharePoint, Box, Documents, Slack, Teams, Gmail, Outlook Email.
How it works
- Codex reviews the latest forecast model, KPI dashboard, prior pack, cash view, forecast notes, and owner inputs.
- It updates metrics, deltas, charts, commentary, and open questions.
- It creates a refreshed CFO or board reporting pack with a summary of what changed, what still needs input, and which sections need executive review.
Starter prompt
Try it out
Refresh the [CFO/board] reporting pack for [month/quarter]. Use the latest forecast model, KPI dashboard, prior pack, cash view, forecast notes, owner inputs, and open questions I provide. Update key metrics, deltas, charts, and commentary. Create a pack summary that explains what changed, what needs owner input, which assumptions remain open, and which slides or sections need executive review.
Real-world example
Refresh Acme’s May CFO reporting pack. Use “May Forecast Model.xlsx,” “May KPI Dashboard,” “April Board Pack.pptx,” “May Cash View,” “Forecast Notes - May,” owner inputs in “CFO Pack Open Questions,” and related discussion from #cfo-staff.
Update the key metrics, deltas, charts, and commentary. Create a CFO-ready pack summary that explains what changed since the April board pack, what still needs owner input, which assumptions remain open, and which slides or sections need executive review. Do not invent metrics. Flag any number that cannot be tied back to the forecast model, KPI dashboard, cash view, or owner notes.
- Variance driver bridge
Use this when:You need to explain what drove movement between actuals, budget, and forecast across revenue, expense, cash, or KPI lines.
What you bringWhat Codex returns Actuals, budget, forecast, prior forecast, KPI dashboard, variance thresholds, owner notes, and relevant source files A variance bridge deliverable with driver-ranked movements, source-backed explanations, flagged anomalies, open questions, and owner follow-ups
Suggested plugins:Spreadsheets, Documents, Presentations, Google Drive, SharePoint, Box, Slack, Teams, Gmail, Outlook Email.
How it works
- Codex compares actuals, budget, forecast, prior forecast, KPI data, and owner notes.
- It identifies the largest drivers, anomalies, source-backed explanations, and open questions.
- It creates a variance bridge deliverable with ranked drivers, commentary, owner follow-ups, and optional chart or slide-ready summary.
Starter prompt
Try it out
Explain the [period] variance between [actual/budget/forecast/prior forecast]. Use the close workbook, budget file, prior forecast, revenue dashboard, opex tracker, cash view, and finance owner notes I provide. Build a variance bridge across revenue, gross margin, opex, EBITDA, free cash flow, and balance-sheet drivers where relevant. Draft owner-ready questions, reconcile source breaks, and flag any variance that is not supported by a source.
Real-world example
Explain Acme’s April forecast-to-actual movement. Use “April Close Workbook.xlsx,” “FY26 Budget.xlsx,” “March Forecast.xlsx,” “April Revenue Dashboard,” “April Opex Tracker,” “April Cash View,” and finance owner notes from #finance-close.
Build a variance bridge across revenue, gross margin, opex, EBITDA, free cash flow, and balance-sheet drivers where relevant. Draft owner-ready follow-up questions, reconcile source breaks, and flag any variance that is not supported by a source. Cite the workbook tab, dashboard, tracker, or owner note behind each material driver.
- Forecast refresh and scenario planning
Use this when:You need to update a forecast with new assumptions, compare scenarios, and turn the results into a review-ready planning artifact.
What you bringWhat Codex returns Forecast model, latest actuals, assumption updates, business-owner inputs, scenario rules, planning calendar, and prior forecast A refreshed forecast and scenario planning deliverable with base, upside, and downside cases; assumption changes; key sensitivities; risks; and review notes
Suggested plugins:Spreadsheets, Documents, Presentations, Google Drive, SharePoint, Box, Slack, Teams, Gmail, Outlook Email.
How it works
- Codex reviews the prior forecast, latest actuals, assumption updates, owner inputs, and scenario rules.
- It updates the forecast where safe, builds or compares scenarios, and identifies key sensitivities, risks, and open assumptions.
- It creates a refreshed forecast and scenario planning deliverable with review notes, source-backed assumption changes, and optional chart or slide-ready summary.
Starter prompt
Try it out
Refresh the [forecast or operating plan] for [business]. Use the operating model, revenue driver model, headcount plan, cash forecast, latest actuals, approved planning assumptions, and leadership notes I provide. Create base, downside, and upside scenarios with key drivers, cash impact, hiring implications, trigger points, and a recommendation. Include a sensitivity table and list assumptions that need approval before the plan is shared.
Real-world example
Refresh Acme’s FY27 forecast for the Enterprise business. Use “FY27 Operating Plan Model.xlsx,” “Revenue Driver Model.xlsx,” “Headcount Plan.xlsx,” “13 Week Cash Forecast.xlsx,” April actuals, approved planning assumptions in “FY27 Planning Assumptions,” and leadership notes from #fy27-planning.
Create base, downside, and upside scenarios with the key revenue, margin, hiring, and cash drivers. Summarize cash impact, hiring implications, trigger points, and your recommendation. Include a sensitivity table and list assumptions that need approval before the plan is shared. Do not overwrite business assumptions without flagging them for review.
More resources
Keep exploring Codex for work with these resources:
Codex for work hub Codex for everyday work on-demand webinar Top 10 uses for Codex at work