Cash flow command center with automated runway projection and anomaly detection
Build a Cash Flow Command Center workflow and interface for a CFO. DATA SOURCES: - Pull daily transaction and invoice data from [NetSuite/QuickBooks/Stripe — specify your system] - Pull bank account balances from [banking API/Plaid] - Pull open AP/AR aging reports LOGIC: 1. Every morning at 7am, aggregate yesterday's transactions, current bank balances, and AP/AR aging. 2. Calculate a 30/60/90-day cash runway projection based on historical burn rate and known upcoming payables/receivables. 3. Flag anomalies: - Vendor invoices >20% higher than their trailing 3-month average - Duplicate invoice numbers or amounts within 7 days - Any single transaction over $[threshold] 4. For flagged anomalies, auto-draft a Slack/email approval request to the appropriate finance approver with context (vendor, amount, reason flagged, historical comparison) and require explicit approve/reject before it's marked resolved. 5. Log all flagged items, approvals, and resolutions to a running audit trail. INTERFACE: Build a vibrant, executive-facing dashboard interface with: - A hero section with today's cash position in large, bold typography, using a gradient background (deep indigo to purple) with the current balance in a glowing accent color (gold or mint) - A 30/60/90-day runway chart — clean line/area chart with vibrant contrasting colors (blue for optimistic, orange for at-risk, red for critical) and smooth gradient fills - A "Flagged This Week" card grid — each anomaly as its own card with a colored left-border indicator (red = high risk, gold = medium, green = resolved), vendor logo/initials, and one-line AI-generated explanation - A top-vendor spend leaderboard as a horizontal bar chart with distinct, saturated colors per vendor - Subtle animations/hover states on cards and charts to make it feel alive, not static - A single "Approve All Low-Risk" action button in a bold, high-contrast color (e.g., mint green) for quick triage - Dark mode by default, optimized for a CFO glancing at it on a large screen or TV in a boardroom TONE: The interface should feel like a modern fintech product (think Mercury, Ramp, or Brex dashboards) — punchy, colorful, confident — not a dry enterprise report. Tools used: NetSuite/QuickBooks/Stripe, banking API/Plaid, Slack, email, AI for anomaly explanations
What this prompt builds
This workflow automates daily cash flow oversight for CFOs by aggregating transaction, banking, and AP/AR data, calculating 30/60/90-day runway projections, and flagging financial anomalies such as inflated invoices, duplicates, and large transactions. Flagged items are routed to approvers via Slack or email with full context, and all decisions are logged to an audit trail. The workflow includes a vibrant, executive-facing dashboard that displays real-time cash position, runway charts, flagged risks, and vendor spend in a modern fintech-style interface.
The problem
CFOs and finance teams waste hours manually piecing together cash data from disconnected accounting, banking, and AP/AR systems, often catching cash shortfalls, fraudulent charges, or billing errors too late to act. This workflow automates the entire process: it pulls all transaction, bank, and payables data daily, projects 30/60/90-day cash runway based on historical burn and upcoming obligations, and flags anomalies like inflated invoices, duplicates, and large transactions against baseline patterns. High-risk items are automatically routed to the appropriate approver via Slack or email with full context, and every decision is logged to an audit trail. The result is a real-time, executive-ready dashboard that transforms cash management from reactive spreadsheet work into proactive, automated oversight with fraud detection built in.
Solution and impact
Finance teams eliminate hours of manual reconciliation and reporting, catch fraud or billing errors before they become costly, and provide the CFO with an always-current view of cash health instead of stale, backward-looking reports. Decision-making shifts from reactive firefighting to proactive control, with cash runway visibility at 30, 60, and 90 days, automatic anomaly detection, and a full audit trail that simplifies compliance and builds trust in every approval. The vibrant, executive-facing dashboard surfaces cash position, runway projections, flagged risks, and top vendor spend at a glance, designed to feel like a modern fintech product rather than a dry enterprise report.