Sales & Revenue

Build sales tracking tools, pipeline managers, commission calculators, and revenue dashboards to drive your sales performance.

Common Sales Spreadsheets

Sales Pipeline

Track deals through stages with probability weighting and expected close dates.

Revenue Forecasting

Project future revenue based on pipeline data and historical conversion rates.

Commission Calculator

Calculate sales commissions with tiered rates, quotas, and bonus structures.

Performance Dashboard

KPI tracking for sales metrics, targets vs actuals, and team performance comparisons.

Example Prompts

Sales Dashboard

"Create a sales performance dashboard with monthly targets, actual sales, win rate, and average deal size. Include charts for trends and a leaderboard for top performers. Show regional breakdown."

Pipeline Tracker

"Build a sales pipeline tracker with stages: Lead, Qualified, Proposal, Negotiation, Closed Won/Lost. Include deal value, probability, weighted value, and expected close date. Add a funnel chart."

Commission Tracker

"Create a commission calculator with tiered rates: 5% up to quota, 8% for 100-150% of quota, 12% for above 150%. Include deal list, sales rep, and monthly/quarterly summaries."

Tip
Include your specific commission structure and quota periods to get accurate calculations for your team.

Key Features for Sales

  • Pipeline value calculations with probability weighting
  • Commission formulas with tiered rates
  • Conversion rate and win rate tracking
  • Year-over-year comparisons
  • Territory and product breakdowns
  • Forecast accuracy tracking

Other Use Cases