Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesSales & CRMPipeline & OpportunityWin/Loss Analysis

SpreadsheetPipeline & OpportunityFree

Win/Loss Analysis

Record why deals were won or lost and see win rate by reason, competitor and deal size.

Shown with sample data

Colour

Win/Loss Analysis

Record why deals were won or lost and see win rate by reason, competitor and deal size.

Win rate (deals)
57%
Win rate (value)
51%
Average cycle, won
42
Days
Average cycle, lost
86
Days
Deals by main reason
  • Price2
  • Product fit2
  • Relationship1
  • Competitor feature1
  • No decision1

How to use it

  1. 1Log every closed deal, won or lost, within a week.
  2. 2Ask the buyer for the main reason, not the rep.
  3. 3Review reasons and competitors each quarter.
  4. 4Pick one change to test and watch the win rate.

In this workbook

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

About this template

Lost deals are your cheapest market research. Log each closed deal with its outcome, main reason, competitor and sales cycle; the sheet gives win rate by count and value, average cycle for wins and losses, and ranks the reasons so pricing, product and messaging changes are based on evidence.

Who it’s for

  • Quarterly business reviews
  • Feeding product and pricing decisions
  • Sharpening competitor positioning

What’s included

  • Closed deals sheet: One row per closed deal.
  • By main reason sheet: Value and Won value and the number of entries for each main reason.

How to use it

  1. 1Log every closed deal, won or lost, within a week.
  2. 2Ask the buyer for the main reason, not the rep.
  3. 3Review reasons and competitors each quarter.
  4. 4Pick one change to test and watch the win rate.
Related searcheswin loss analysiswin ratelost deal reasonscompetitive analysissales review

Details

Format
Spreadsheet
Category
Pipeline & Opportunity
Sheets
2
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetPipeline & OpportunityFree

Win/Loss Analysis

Record why deals were won or lost and see win rate by reason, competitor and deal size.

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
2
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More pipeline & opportunity templates

View all
Sales Pipeline CRM3 sheets

Open pipeline

$270,400

Weighted forecast

$89,550

Won

$18,000

Pipeline value by stage
$101k
$68k
$54k
$47k
$18k
LeadQualifiedProposalNegotiationWon
SpreadsheetPipeline & Opportunity

Sales Pipeline CRM

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

10 min setupPreview
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

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