name: Clean and review a financial model tagline: Check formulas, links, tie-outs, and assumptions before a high-stakes review. summary: Give ChatGPT a financial model and its supporting sources, then ask it to make safe cleanup changes and return a severity-ranked QA memo covering formula risks, broken links, source tie-outs, and assumptions that need an owner. skills:
-
token: $spreadsheets description: Inspect workbook structure and formulas, make safe edits, and render the cleaned model for review. bestFor:
-
Financial models that need formula and source QA before leadership, investor, or board review.
-
Workbooks with hardcodes, broken links, inconsistent periods, or unclear checks.
-
Teams that want safe cleanup separated from business-assumption changes. starterPrompt: title: Clean and review the model body: >- Use $spreadsheets to clean and review [model name] before it goes to [audience].
Inspect workbook structure, formulas, hardcodes, broken links, circular references, sign conventions, period labels, source tie-outs, model checks, and output tabs. Pay special attention to [priority tabs or outputs].
Make safe cleanup and formula fixes where the intended behavior is clear. Do not change business assumptions without approval. Return an editable cleaned workbook plus a severity-ranked QA memo with issues found, fixes made, remaining assumptions, and the exact cells or tabs that need finance-owner review. Preserve the original file as a separate input. suggestedEffort: high relatedLinks:
-
label: Agent skills url: /codex/build-skills
Introduction
Financial models often accumulate hidden hardcodes, stale links, inconsistent periods, and checks that no longer tie. ChatGPT can inspect the workbook systematically, make narrowly scoped fixes, and produce a QA memo that tells a finance owner where judgment is still required.
Define the review boundary
Attach the model and the source files it should tie to. Name the audience, priority tabs, expected outputs, and any assumptions ChatGPT must leave unchanged. Keep the original workbook available so you can compare every edit.
- Attach the model and its supporting source files.
- Identify priority tabs, expected checks, and protected assumptions.
- Run the starter prompt and request a cleaned copy plus a QA memo.
- Open the workbook in ChatGPT and inspect changed formulas, links, and output tabs.
- Resolve finance-owner questions before accepting assumption changes.
Check the cleanup
The QA memo should rank issues by severity and point to exact cells or tabs. Safe formatting, labeling, and clear formula repairs can be applied directly; ambiguous business logic should remain flagged for review.