Sales plan template: from your revenue target to each month’s leads

Free sales plan template in Excel: work out how many leads, meetings and proposals you need each month and track actuals against target.

The template's “Example” tab, completed using the case of an employment consultancy.

The template in numbers

12 months with target and actual figures
5 stages, from contact to revenue
1 one sheet for the whole year
Leave us these three details and the download will appear right here, immediately.
Name *
Business email *
Company *

What the sales plan template includes

A single sheet that goes from the figure management is asking for to what needs to happen each month to reach it.

The funnel in reverse

The new revenue target determines the number of customers, proposals, meetings, and contacts needed per year and per month.

Twelve months, target and actual

Each month has its target and a column for the actual figure. The actual figure automatically turns green or red.

Year to date

At the top, how much you have achieved, whether you are on track, and how much remains, so you can answer management without preparing anything.

A completed example

A one-year plan for a labor consultancy, with its figures, so you can see how to fill it in before you start.

How to create a sales plan step by step with the template

Twenty minutes the first time. After that, five minutes at the end of each month.

Enter the target

What you want to invoice this year from new customers and the average revenue generated by a new customer in their first year.

Enter your percentages

Out of every 100 contacts, how many lead to a meeting; out of every 100 meetings, how many lead to a proposal; out of every 100 proposals, how many are won. If you do not know them, start with the example figures.

Break it down by month

By default, the year is divided evenly; adjust the strong and weak months if your sales are seasonal.

Enter the actual figures each month

Contacts, meetings, proposals, customers, and revenue. The sheet tells you whether you are above or below target.

Correct it in time

If a stage stays red for two months in a row, that’s where the problem is: not enough contacts, meetings, or closed deals.

Frequently asked questions about the sales plan

Answers to your most common questions

What is a sales plan template for?

To know how many contacts, meetings, and proposals you need each month to reach the annual target, spot early if you are falling behind, identify where the funnel is failing, and have an answer when management asks how the year is going.

What is a sales plan?

It is the document that translates a revenue target into specific sales activity: how many new customers, proposals, meetings, and contacts are needed, and in which months. Without it, the target is just a number.

How do I calculate how many contacts I need?

You work backwards: divide the revenue target by the revenue per customer to get the number of customers; divide the number of customers by the percentage of proposals won to get the number of proposals; and continue this way back to contacts. The template does the calculations and rounds up.

What percentages should I use if I don’t know them?

Start with those in the example and update them after three months using your actual data: the sheet calculates the actual year-to-date rates so you can compare them with the assumed rates.

Is there an example of a sales plan?

Yes, the template includes a completed one-year plan for an employment consultancy, with its target, percentages, and several months of actual data.

Does it work for service companies?

Yes, it is designed for companies that sell to other businesses through meetings and proposals, where each customer is won through several conversations.

What do I need to use the template?

Excel. It comes with instructions and a completed example, so you can see how to use it before getting started.