Back to Cookbook

Board Deck Builder

CRO-ready forecast packages without the 2-day spreadsheet marathon

Build a board-ready forecast package from revenue snapshots, pipeline exports, and billing data. Best when finance and sales ops already have the numbers, but packaging them takes too long.

House RecipeWork10 min setup

INGREDIENTS

📄Google Docs💬Slack

PROMPT

Create a skill called "Board Deck Builder". Generate a board-ready forecast package from my revenue data, exports, and saved reports. Include: ARR waterfall (beginning, new, expansion, contraction, churn, ending), pipeline coverage ratios by segment, win rates by segment and deal size, rep productivity metrics (pipeline created, quota attainment, activity), forecast breakdown (commit / best case / upside with probability estimates), and a 3-paragraph executive narrative summarizing key trends, risks, and opportunities. Format as a presentation-ready document. Support scenario analysis: let me model best/base/worst outcomes. Generate monthly or on-demand.

How It Works

Connect your revenue systems and the skill generates a board-ready forecast package:

ARR waterfall, pipeline coverage, rep productivity, win rates, and a narrative summary.

Built from the latest data you provide or sync, and formatted for leadership review.

What You Get

  • ARR waterfall: beginning balance, new, expansion, contraction, churn, ending balance
  • Pipeline coverage by segment and quarter
  • Win rates by segment, deal size, and rep
  • Rep productivity: pipeline generated, quota attainment, activity metrics
  • Forecast confidence: commit vs. best case vs. upside with AI-assessed probabilities
  • Executive narrative: AI-generated summary of key trends and risks
  • Scenario analysis: best case / base case / worst case outcomes

Setup Steps

  1. Connect CRM and billing/subscription data
  2. Define your board reporting template (or use the default)
  3. Set generation schedule (default: 3 days before board meeting)
  4. Review and add qualitative commentary before presenting

Tips

  • Generate weekly during the last month of quarter for real-time leadership visibility
  • The AI narrative captures trends you might miss when buried in spreadsheets
  • Always add 2-3 qualitative bullet points — boards want data + judgment
  • Archive every package for quarter-over-quarter trend comparison
Tags:#forecasting#reporting#executive#sales