💰 Finance Prompt
Stop Missing Early Warning Signals from Costing You — Gemini Prompts for Treasury Managers
Extract the key financial insights buried in your data and build a KPI dashboard that gives the board early warning before problems become crises
The Prompt
You are a specialist in treasury analytics and financial intelligence systems with 11 years of experience building KPI dashboards for CFOs and board reporting teams. Help me extract the key financial insights buried in our data so I can build stronger board confidence and stop missing early warning signals before they become cash crises.
My situation:
- Treasury function scope: [CASH MANAGEMENT ONLY / ALSO INCLUDES HEDGING / INVESTMENT PORTFOLIO / FULL TREASURY]
- Current KPI dashboard status: [NONE / BASIC SPREADSHEET / EXISTING TOOL — DESCRIBE]
- Data sources available: [BANK FEEDS / ERP SYSTEM / MANUAL SPREADSHEETS / COMBINATION]
- Warning signals missed recently: [e.g., "cash crunch surprised us in Q2" / "FX exposure not visible until month-end"]
- Who the dashboard is for: [CFO ONLY / FULL BOARD / FINANCE TEAM / ALL THREE]
- How often board reviews this data: [MONTHLY / QUARTERLY / WEEKLY]
Deliver:
1. A KPI selection framework — the 8 treasury metrics with the highest early warning value and why each belongs on a board-facing dashboard
2. A dashboard layout specification — how to arrange the KPIs visually so the most critical signals appear in the top-left quadrant where board attention lands first
3. An alert threshold table — specific numerical thresholds for each KPI that trigger a yellow or red flag before a problem becomes a crisis
4. A data source map — which system each KPI should pull from and the refresh frequency required to make the signal meaningful
5. A board narrative template — a 4-sentence commentary format for presenting treasury KPI results in board packs without technical jargon
6. A missed signal root cause checklist — 5 structural reasons treasury teams miss early warning signals and the dashboard design fix for each
7. A 90-day build plan — week-by-week steps to go from current state to a live, board-ready KPI dashboard
Design every recommendation so a non-treasury board member can look at the dashboard and understand the company's financial health status in under 60 seconds.
💡 How to use this prompt
- Start with output 3 (the alert threshold table) — defining your red and yellow thresholds before building the dashboard forces the analytical thinking most treasury teams skip, and it separates a reporting tool from a genuine early warning system.
- The most common mistake is building a dashboard that shows everything rather than highlighting what matters. A board pack with 20+ metrics has no hierarchy — the early warning signals disappear in the noise. Output 2 (the layout specification) solves this directly.
- Gemini's real-time web access gives it an edge here — use it when you need current benchmarks for KPI thresholds such as industry-standard liquidity ratios. For the final narrative polish, paste Gemini's research output into Claude for cleaner professional language.
Best Tools for This Prompt
🤖 Best AI Productivity Tools for This Prompt
Tested & reviewed — run this prompt with the best AI tools
Related Topics
About This Finance AI Prompt
This free Finance prompt is designed for Gemini and works with any modern AI assistant including ChatGPT, Claude, Gemini, and more. Simply copy the prompt above, paste it into your preferred AI tool, and customize the bracketed sections to fit your specific needs.
Finance prompts like this one help you get better, more consistent results from AI tools. Instead of starting from scratch every time, you can use this tested prompt as a foundation and adapt it to your workflow. Browse more Finance prompts →
