KiloClawPowered by OpenClaw
Back to Cookbook
OpenClaw recipe

Board-Ready Revenue Forecast Package

aka “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
Try in KiloClawFree 7-day trial

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

Related Recipes

Pipeline Review Autopilot

Your Monday morning pipeline deck, built overnight

Stop spending Sunday night in Salesforce. This skill auto-generates your weekly pipeline review — snapshots, deltas, risk flags, and talking points — delivered before you pour your coffee.

Work5 min setup

Forecast Modeler

Data-driven forecasts that replace gut feel

Forecasting shouldn't be rep opinions averaged in a spreadsheet. This skill builds forecasts from engagement signals, historical patterns, and stage conversion rates — producing confidence intervals, not guesses.

Work5 min setup

CLAWBITE AI

Local-first AI assistant that automates small daily tasks safely on your device

A personal, local-first AI assistant that automates small daily tasks—organizing files, setting reminders, and monitoring system events—without touching sensitive data or taking risky actions without your approval.

Personal5 min

The De-Botinator

Wikipedia-grade AI pattern removal

Comprehensive AI writing cleanup based on Wikipedia's WikiProject AI Cleanup guidelines. Catches 24+ distinct patterns including inflated symbolism, em dash overuse, rule of three, copula avoidance, and sycophantic tone.

Creative1 min