Posted in

5 Free Sales Plan Templates in Excel

5 Free Sales Plan Templates in Excel – free download preview

Reviewed & updated by WordNExcel Team — Updated November 10, 2026

A sales plan template turns a revenue goal into a month-by-month target, a weekly list of activities and a pipeline you can forecast from. Instead of a vague goal such as “grow sales next year”, you get numbers your team can work toward and track. On this page you can download five free sales plan templates in Excel: an annual sales plan with monthly targets and actuals, a weekly sales activity plan and a sales pipeline forecast with weighted values, plus a territory quota plan and a win-loss sales review.

Each file is a real, editable .xlsx spreadsheet created for this page. Totals, percentages and weighted forecasts are calculated with formulas, and the input cells are shaded so you know where to type. The templates also open in Google Sheets and LibreOffice Calc.

Free download: 5 templates (.xlsx). Works in Excel and Google Sheets. No sign-up needed.

What Is a Sales Plan?

A sales plan sets out what a business intends to sell, to whom, by when and how. It typically includes revenue targets by month and by product or segment, the activities needed to reach those targets, such as calls, meetings and proposals, and a way to track progress. A good sales plan connects the big annual number to the daily work of the sales team.

Sales plans are useful for any size of business. A freelancer might plan the number of new clients needed each quarter, while a sales manager might set targets for each rep and product line.

Why Use an Excel Sales Plan Template?

  • Clear targets. Monthly targets by product or segment make the annual goal concrete.
  • Built-in tracking. Enter actual sales each month and see the percentage of target achieved.
  • Activity focus. The activity plan shows the weekly effort needed to hit the numbers.
  • Realistic forecasts. The pipeline forecast weights each deal by its stage, giving a more realistic view than the total pipeline value.
  • Easy to share. Spreadsheets are easy to share with managers and teams in Excel or Google Sheets.

Download the Free Sales Plan Templates

All five templates are hosted on this website and free to download. The preview shows each spreadsheet as it prints.

1. Annual Sales Plan

Annual sales plan template in Excel with monthly targets, actuals and percent of target

The annual sales plan has rows for up to eight products, services or segments and columns for each month of the year. Enter your monthly targets for each row, and the sheet calculates the yearly total for each product and the monthly total for all products. Below the targets, enter actual sales for each month, and the sheet shows the percentage of target achieved for every month and for the year.

The example rows show a modest monthly growth pattern; replace them with your own numbers. If your business is seasonal, enter higher targets for your busy months rather than spreading the annual goal evenly.

2. Sales Activity Plan

Weekly sales activity plan template in Excel with targets and conversion rate

The weekly activity plan lists the activities that lead to sales: prospecting calls, emails or social messages, meetings booked, demos or presentations, proposals sent and deals closed. For each activity, enter a weekly target, then record the actual count for the first and second half of the week. The sheet totals the activity and shows the percentage of target reached, plus the conversion rate from meetings to closed deals.

Activity targets are easier to control than revenue. If a rep knows that roughly one in six meetings becomes a deal, the activity plan shows how many meetings they need to book each week.

3. Sales Pipeline Forecast

Sales pipeline forecast template in Excel with stages and weighted values

The pipeline forecast lists open deals with the client, stage, value, expected close month and owner. Choose the stage from a drop-down list (lead, qualified, proposal, negotiation, won or lost), and the sheet applies a probability to each stage and calculates the weighted value of the deal. The totals at the bottom show the full pipeline value and the weighted forecast.

The default probabilities are 10% for leads, 25% for qualified opportunities, 50% for proposals, 75% for negotiation, 100% for won deals and 0% for lost deals. Adjust them to match your own history once you have a few months of data.

4. Territory Quota Plan

Territory quota plan template in Excel with annual quotas, YTD actuals, remaining and pace

Splits the annual sales target by rep or territory and shows who is on pace. Enter each annual quota and the year-to-date actual; the remaining figure and a pace percentage calculate, using how much of the year has passed. Pace under 90% is highlighted so a sales manager can step in early, and pace over 100% shows green. Team totals sit at the foot. Update the ‘as of’ date and the actuals every month, then use the pipeline forecast to see whether the gap can be closed.

5. Win-Loss Sales Review

Win-loss sales review template in Excel with deal value, result, primary reason and lessons

A short review of closed deals so the team learns why it wins and why it loses. Record each opportunity, its value, whether it was won or lost, the primary reason and one lesson; won and lost values total at the top. Choosing a single primary reason for each deal (price, fit, timing, an incumbent relationship) makes patterns visible after a quarter. Sales leaders use the review to change pricing, qualification or messaging. Open deals stay on the pipeline forecast, not here.

How to Write a Sales Plan in 7 Steps

  1. Review last year. Look at sales by month, product and customer type to understand patterns and seasonality.
  2. Set the annual target. Base it on past results, market conditions and business goals, not just a wish.
  3. Break it down. Split the target by product or segment and by month in the annual plan.
  4. Work out the activity needed. Use your conversion rates to calculate how many leads, meetings and proposals are needed.
  5. Assign responsibilities. Decide who owns each product, territory or segment.
  6. Track every week. Update the activity plan and pipeline weekly, and actual sales monthly.
  7. Adjust. If you fall behind, look at whether the problem is activity, conversion or deal size, and act on that.

Understanding Weighted Pipeline Forecasts

The total value of all open deals is usually much higher than what will actually close. A weighted forecast multiplies each deal’s value by the probability that it will close, based on its stage. For example, a 20,000 deal at the proposal stage with a 50% probability adds 10,000 to the forecast. Adding up the weighted values across all deals gives a more realistic estimate of future revenue. Over time, compare the forecast with actual results and adjust the stage probabilities to make the forecast more accurate.

Sales Planning Tips

  • Keep targets realistic. Stretch targets can motivate, but targets that feel impossible tend to be ignored.
  • Plan for seasonality. Put higher targets in months that are traditionally strong.
  • Focus on leading indicators. Activities and pipeline are early signs of future sales.
  • Clean the pipeline regularly. Remove deals that have stalled, or mark them as lost.
  • Review monthly with the team. Share the percentage of target and discuss what is working.

Setting Targets for Each Sales Rep

If you manage a team, split the annual target between reps based on territory size, experience and existing customers rather than dividing it equally. Give newer reps a ramp-up period with lower targets in their first months. Make a copy of the annual sales plan for each rep, or add a row per rep, and roll the totals into a team summary. Share each rep’s activity plan with them so they can see the weekly effort that leads to their number.

Common Sales Planning Mistakes

  • Top-down only. A target that ignores capacity and conversion rates is unlikely to be met.
  • No activity plan. Without activity targets, teams only learn they are behind when the month ends.
  • Optimistic pipelines. Counting every deal at full value makes forecasts unreliable.
  • Set and forget. A plan that is never updated quickly becomes irrelevant.
  • Ignoring existing customers. Repeat business and upsells are often easier to win than new customers, so include them in the plan.

Using the Templates Together

The five templates work best as a set. The annual plan sets the destination, the activity plan sets the weekly effort and the pipeline forecast shows whether you are on course. At the end of each month, enter actual sales in the annual plan, compare them with the weighted forecast from the pipeline and look at the activity totals to understand why results were above or below target.

Choosing Sales Targets for a Small Business

Small businesses often lack detailed history, so start with what you know: average order value, how many customers you serve each month and how many new customers you can realistically win. Multiply these to estimate monthly revenue, then set a target slightly above that level. Revisit the targets after three months, when you have real data from the activity plan and pipeline.

Connecting the Sales Plan to the Rest of the Business

A sales plan affects other parts of the business. Higher sales targets may need more stock, more staff hours or a bigger marketing budget, and lower targets may mean reducing costs. Share the monthly targets with whoever handles purchasing, production and finance, so they can plan cash flow and resources around the expected sales. A quick monthly review that compares targets, actual sales and the forecast helps everyone stay aligned and spot problems early.

You can also check these important templates like the sales report templates for reporting results, and the sales proposal templates for winning the deals in your pipeline.

You may also like the marketing budget plan templates for funding lead generation, and the cash flow projection templates for planning finances around your sales forecast.

Frequently Asked Questions

What should a sales plan include?

Revenue targets by month and product or segment, the activities needed to reach them, a pipeline of opportunities and a way to compare actual results with targets.

How is the weighted forecast calculated?

Each deal’s value is multiplied by the probability for its stage, and the weighted values are added up. The default probabilities can be changed.

Can I use the sales plan in Google Sheets?

Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. The formulas and drop-down lists work.

How often should I update the sales plan?

Update activities and the pipeline weekly, and enter actual sales at the end of each month.

Can I add more products or deals?

Yes. Insert rows inside the existing ranges so the totals include them automatically.

Rumaish is a professional computer designer with extensive experience navigating the demands of the corporate and business sectors. Combining a sharp eye for functional design with a deep understanding of office workflows, he crafts practical, high-quality Word and Excel templates that help professionals save time and streamline their daily operations.