原文核对：2026-10-13 · 中文正文 · 英文提示词与演示
场景定位
将实际数据映射到预算、计算差异、标记勾稽问题，并区分有证据的解释与待确认财务问题。
- 难度
- 入门
- 时间跨度
- 30 分钟
适合用于
- 比较预算与实际支出的月结审阅。
- 根据总账、支出或部门实际数据准备管理层解读的团队。
- 需要审阅分类映射、勾稽和无依据解释的工作簿。
相关工具
检查输入、清理映射行、建立差异表并生成可审阅工作簿。
起步提示词
英文原文 · 可复制后按实际材料修改
Use $spreadsheets to update the budget vs. actuals review from the attached files.
Compare actuals to plan, map actuals to the right budget categories, summarize the major variances, and prepare a clean review view as an editable .xlsx workbook.
Preserve the raw inputs, use formulas for dollar and percentage variance calculations, and flag categories that do not map cleanly instead of forcing a match. Use account type to determine favorable or unfavorable variance: revenue above plan is favorable, while expense above plan is unfavorable.简介
ChatGPT 可帮助建立能实际使用的预算差异审阅工作簿。
上传预算、实际导出和结账说明，保留原始输入、建立映射、计算差异并生成可查看摘要。
创建审阅工作簿
- 上传预算、实际和结账说明，或提供准确来源引用。
- 运行提示词，要求可编辑 .xlsx。
- 全屏查看原始输入、映射、差异公式和摘要。
- 继续修正分类、增加部门切分或起草财务总结。
连接插件中的文件应准确指定文件或文件夹，不要泛搜整个 Drive 或工作区。生成后先全屏检查输入、映射、公式和摘要，再提出修改。
检查差异
分享前审计分类、公式及差异解释。
官方提示词
英文原文 · 可复制后按实际材料修改
Check the budget vs. actuals review before I share it.
List:
- the most material unfavorable variances by dollar impact
- the most material favorable variances by dollar impact
- categories that may be mapped incorrectly
- accounts where the favorable or unfavorable sign convention is unclear
- explanations supported by the close notes
- explanations that need human review
- formula or tie-out issues in the workbook
Fix safe formatting or formula issues, then list anything finance should resolve before leadership review.展开英文原文对照
Give ChatGPT a budget, actuals export, and close notes, then ask it to map actuals to plan, calculate variances, flag reconciliation issues, and separate supported explanations from open finance questions.
Introduction
If you’re working on a budget and want to review the variances or inspect any issues, ChatGPT can help you create a fully functional review workbook you can work with.
Attach the budget plan, actuals export, and close notes, then ask ChatGPT for an editable review workbook. ChatGPT can preserve the raw inputs, map actuals to plan, calculate variances, and create a summary view you can inspect in the chat.
Create the review workbook
- Attach the budget plan, actuals export, and close notes, or provide exact file references along with the source.
- Run the starter prompt and ask for an editable .xlsx workbook.
- Open the workbook in ChatGPT. Expand it into the full-screen view to inspect the raw inputs, mappings, variance formulas, and summary tab.
- Continue in the same chat to fix category mappings, add department cuts, or draft the finance summary.
If the source files are in a connected plugin, mention the exact files or folder. Avoid asking ChatGPT to search a broad Drive or workspace when the review should use specific finance sources. When the workbook appears in the chat, open it and expand it full-screen to review the raw inputs, mappings, variance formulas, and summary tab before asking for revisions.
Check the variances
Before sharing the workbook, ask ChatGPT to audit the categories, formulas, and variance explanations.
官方提示词
英文原文 · 可复制后按实际材料修改
Check the budget vs. actuals review before I share it.
List:
- the most material unfavorable variances by dollar impact
- the most material favorable variances by dollar impact
- categories that may be mapped incorrectly
- accounts where the favorable or unfavorable sign convention is unclear
- explanations supported by the close notes
- explanations that need human review
- formula or tie-out issues in the workbook
Fix safe formatting or formula issues, then list anything finance should resolve before leadership review.