← All prebuilt solutions
Planning & Finance

Sales Pipeline Tracker

Track every deal, forecast with confidence and see who and what is really winning

£20

Secure checkout. Your download link is sent as soon as payment clears.

Sales Pipeline Tracker

Overview

Most sales teams know roughly what's 'in the pipeline' – but not what it's really worth, when it will land, which deals have gone quiet or which marketing actually pays for itself. This tracker turns a simple list of deals and a log of calls, emails and meetings into a weighted forecast, win rates, a conversion funnel, a stale-deal list, a ranked rep leaderboard against target and a return-on-investment table for every lead source. Everything updates the moment you change a deal.

Price
£20
Who it’s for
Planning & Finance
Works with
Microsoft Excel for Windows and Mac
Buy now

See how it works

A walk through the main sheets

The sheets you will use most, in the order you will use them – shown with the sample data every workbook comes with.

Step 1

Opportunities

The main register – one row per deal, with automatic status, weighting, health and data checks. What you do: add and update deals here.

Opportunities
Activities

Step 2

Activities

Log of every call, email, meeting, demo or proposal against a deal. What you do: add a line for every customer touch.

Step 3

Pipeline

Open pipeline by stage, deals closed in the period and the stage conversion funnel. What you do: nothing to enter.

Pipeline
Forecast

Step 4

Forecast

Best case, commit and weighted forecast for the next 12 months, and won vs target for the last 12. What you do: nothing to enter.

Who it is for

Made for people like you

  • Example – text
  • Owner-managed businesses selling B2B – A clear view of every deal, what it's worth and when it should close – without buying a CRM.
  • Sales managers – Rep-by-rep targets, win rates, activity levels and a list of deals that need chasing.
  • Marketing – Leads, wins and gross profit by source against what each source cost.
  • Directors and investors – A weighted 12-month forecast and a one-page dashboard.

Quick start

Up and running in minutes

  1. Example – text
  1. Settings – general – Enter your business name, the month your financial year starts and how many days without contact makes a deal 'stale'. Leave the report date blank so everything is measured to today.
  2. Settings – stages – Check the pipeline stages and their default win probabilities suit the way you sell. Keep the open stages in order, then Won and Lost.
  3. Settings – team, sources, products – List your sales reps with their monthly targets, your lead sources with what you spent on each, and your products or services with their gross margin %.
  4. Opportunities – Add one row per deal: an Opp ID, company, source, rep, product, value, created date, expected close date and stage. Add the next action and its date.
  5. Activities – Every time someone calls, emails or meets a prospect, add a line with the date and the Opp ID. This is what tells the tracker a deal is still alive.
  6. Close deals properly – When a deal is won or lost, change the Stage, add the won / lost date and – for lost deals – the reason and the stage it was lost at.
  7. Review weekly – Work through the Stale Deals list, then check the Dashboard, Forecast and Leaderboard. Fix anything the Data check column flags.

Key features

  • Opportunity register for up to 1,200 deals and an activity log for 3,000 calls, emails and meetings – with automatic health checks on every deal.
  • Pipeline by stage, weighted, commit and best-case forecasts for the next 12 months, and won sales against target for the last 12.
  • Win rates, average deal size and sales cycle by rep, lead source and product, plus a stage conversion funnel and lost-reason analysis.
  • Stale and overdue deal list, a ranked rep leaderboard against target and a lead source ROI table based on your marketing spend.

What’s included

  • Dashboard – Pipeline and performance at a glance
  • Settings – Stages, team, targets, sources and products
  • Opportunities – Every deal – the main input sheet
  • Activities – Calls, emails and meetings log
  • Pipeline – By stage, closed deals and conversion funnel
  • Forecast – Next 12 months and last 12 vs target
  • Win Rates – By rep, source and product; lost reasons
  • Stale Deals – Deals that need a nudge
  • Leaderboard – Reps ranked against target
  • Source ROI – Return on marketing spend
  • Guide – How to use this workbook

How buying works

Your file is only released once payment has cleared.

1

Click Buy now

You are taken to our secure checkout.

2

Pay securely

Checkout takes a minute and you get a receipt by email.

3

Download your file

Your download link arrives as soon as payment clears.

Explore the range

Need it tailored to your business?

We can adapt any prebuilt solution or build something bespoke, with a lifetime bug-free guarantee.

Part of AML Finance Group

Need an accountant too?

Our sister firm, AML Accountancy Solutions, is an award-winning accountancy practice helping businesses and individuals across the UK with their accounts, tax, bookkeeping and payroll.

Visit AML Accountancy Solutions