Auto-Generate Monthly Revenue Forecast from Pipeline
The problem
Finance builds revenue forecasts by hand, applying historical close rates to current pipeline. It eats hours every month.
Implementation steps
- 1
Pull Salesforce pipeline report (all open opportunities)
- 2
Import to Google Sheets with stage, amount, close date, age in stage
- 3
Apply close rate by stage (e.g., Demo: 25%, Proposal: 50%, Negotiation: 80%)
- 4
Calculate weighted revenue by month
- 5
Add historical vs. forecast comparison chart
Template outline
The structure to recreate in your own workspace. Field names and thresholds are starting points.
Google Sheets Setup:
1. Zapier: Daily sync of Salesforce opportunities
2. Sheet 1: Raw pipeline data
3. Sheet 2: Close rate reference table by stage
4. Sheet 3: Forecast calculation
- Formula: =SUMIFS(weighted_amount, close_month, target_month)
- Weighted amount: deal_amount * close_rate
5. Chart: Forecast vs. quota by monthKeep going
More Finance/FP&A playbooks
- Finance/FP&ABeginner
Automate Stripe Revenue Recognition in QuickBooks
Finance teams manually export Stripe transactions and re-key them into QuickBooks weekly, risking errors.
ZapierStripeQuickBooksEstimate: 6 hrs/week - Finance/FP&AIntermediate
Parse Receipt Emails and Auto-Create Expense Reports
Employees manually forward receipts to finance. Someone re-keys them into expense software.
ZapierGmailGoogle Sheets+1Estimate: 5 hrs/week - Finance/FP&ABeginner
Send Automated Invoice Payment Reminders
AR team manually checks which invoices are overdue and sends canned reminder emails. Pure busywork.
QuickBooksZapierGmailEstimate: 4 hrs/week
Need help implementing a playbook?
Our team builds custom Clay workflows and AI automations for revenue teams.
Get it built for you