Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesSales & CRMPipeline & OpportunitySales Pipeline CRM

SpreadsheetPipeline & OpportunityFree

Sales Pipeline CRM

Deals by stage with weighted forecast, deal age, overdue follow-ups, win rate and a scorecard for every rep.

Shown with sample data

Colour

Sales Pipeline CRM

Deals by stage with weighted forecast, deal age, overdue follow-ups, win rate and a scorecard for every rep.

Open pipeline
$270,400
Weighted forecast
$89,550
Won
$18,000
Win rate
60%
Need attention
8
Overdue, stalled or no next step
Pipeline value by stage
  • Lead$101,000
  • Qualified$68,000
  • Proposal$54,400
  • Negotiation$47,000
  • Won$18,000
  • Lost$21,700
Weighted forecast by rep
  • Dana$54,05060%
  • Mia$25,15028%
  • Leo$10,35012%

How to use it

  1. 1Set your stages and their win probability on the Stages sheet.
  2. 2Add each deal with account, owner, stage, value, created date, expected close and next step.
  3. 3Every day, work the deals flagged Overdue or Stalled first.
  4. 4When a deal closes, set the stage to Won or Lost and record the lost reason.
  5. 5Use the Reps and Stages sheets in your weekly review.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

A spreadsheet CRM built the way sales teams actually run a pipeline review. Each deal has an owner, stage, value, expected close and next step; win probability comes from your stage settings, so the weighted forecast is always consistent. Deal age, overdue follow-ups and stalled deals are flagged every day, the stage funnel shows where value sits, and a rep scorecard compares pipeline, wins and win rate.

Who it’s for

  • Small sales teams without a paid CRM
  • Weekly pipeline reviews
  • Founders doing sales themselves

What’s included

  • Deals sheet: Every opportunity, open and closed.
  • Stages sheet: Your stages, win probability and the value sitting in each.
  • Reps sheet: Pipeline, wins and follow-up discipline for each rep.

How to use it

  1. 1Set your stages and their win probability on the Stages sheet.
  2. 2Add each deal with account, owner, stage, value, created date, expected close and next step.
  3. 3Every day, work the deals flagged Overdue or Stalled first.
  4. 4When a deal closes, set the stage to Won or Lost and record the lost reason.
  5. 5Use the Reps and Stages sheets in your weekly review.

Tips

  • Every open deal needs a dated next step; a deal without one is not really in the pipeline.
  • Calibrate stage probabilities each quarter against your real win rates.
  • Clean out deals that have not moved in 60 days.

Questions

How is the weighted forecast worked out?

Each open deal's value multiplied by its stage probability from the Stages sheet, added up.

What does Stalled mean?

An open deal older than the stall limit for its stage on the Stages sheet.

How is win rate calculated?

Deals won divided by deals closed (won plus lost).

Related searchessales pipelinecrm templatedeal trackerweighted pipelinesales forecastwin rateopportunity tracker

Details

Format
Spreadsheet
Category
Pipeline & Opportunity
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetPipeline & OpportunityFree

Sales Pipeline CRM

Deals by stage with weighted forecast, deal age, overdue follow-ups, win rate and a scorecard for every rep.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Pipeline & Opportunity
Sheets
3
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More pipeline & opportunity templates

View all
Deal Qualification Scorecard (MEDDIC)2 sheets

Open pipeline

$384,000

Qualified pipeline

$172,000

Strong deals

3

Qualified value by stage
$88k
$84k
ProposalNegotiation
SpreadsheetPipeline & Opportunity

Deal Qualification Scorecard (MEDDIC)

Score every open deal on the six MEDDIC questions and see which are real and which need work.

10 min setupPreview

Annual Sales Plan: FY2027

Company: Company name Owner: Name, VP Sales Version: 1.0 Approved by: CEO / CFO Date: Date

1. Executive summary

In FY2027 we will grow bookings from $8.4M to $11.0M (+31%). Growth comes from three places: expanding the mid-market segment where win rates are highest, a new partner channel, and a dedicated expansion motion for

Keep this to one paragraph: the number, where it comes from and what it needs.

2. Last year in review

MetricFY2026 targetFY2026 actual
Bookings$8.0M$8.4M
New customers140128

What worked: Discovery training lifted win rates; mid-market outbound pod booked 40% of new pipeline. What did not: SMB inbound volume fell 18%; partner deals were ad hoc with no registration process.

DocumentPipeline & Opportunity

Annual Sales Plan

Turn next year’s revenue number into targets by segment, quarterly phasing, coverage, initiatives and a budget.

60 min setupPreview

Sales Playbook

Company: Company name Owner: Name, Head of Sales Version: 2.1, January 2027

1. How to use this playbook

This is how we sell at Company name. New team members should read it in their first week; everyone should know sections 3–5 by heart. If something here no longer matches how we win, tell owner and we will change it.

2. What we sell and why customers buy

One-line positioning: Company name helps multi-site operations teams replace spreadsheets and paper checklists so they can see every site’s performance in real time and fix problems before customers notice.

Top three reasons customers choose us

  • 1.Live in under 30 days, with templates for their industry
  • 2.Multi-site dashboards that operations leaders use daily
  • 3.Works offline on the shop floor and in vehicles
DocumentPipeline & Opportunity

Sales Playbook

One source of truth for how your team sells: ICP, personas, stages with exit criteria, discovery and objection handling.

90 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ