Template · free download

Sales pipeline tracker

Manage your deals from quote to signature: status, follow-ups, weighted forecast and close rate.

A lightweight CRM in a spreadsheet, so you never lose a deal for lack of follow-up again. One row per prospect: quote amount, status, next follow-up, probability. The weighted value and a Summary tab (deal count, weighted forecast, signed amount, close rate, breakdown by status) calculate automatically, with dropdown menus and colour alerts by status. Excel version with formulas, flat CSV version.

What's inside

  • One row per deal: amount, status, next follow-up, probability
  • The weighted value of each deal, calculated automatically
  • A Summary tab: weighted forecast, signed amount, close rate
  • Dropdown menus (channel, status) and colour alerts by status

Preview

ProspectChannelAmountStatusProb.Weighted value
Maple Ridge CabinetryGoogle Ads$8,500Negotiation50%$4,250
Harbourview DentalReferral$3,200Signed100%$3,200
Lakeshore Auto CareLocal SEO$1,500Followed up25%$375