Sales Plan Template: A Free Google Sheet That Starts From Your Reachable Market

Publish date: Nov 12, 2026
A sales plan template is only as good as the number it starts from. This one starts from how many companies you can reach. It sets a target per segment and works it back to deals, meetings and accounts, then checks each against the market and rep capacity. To start, Make a copy of the Sheet and type five numbers per segment; the sheet does the arithmetic.
The Market size tab comes loaded with Spona's count: 10,797,816 US companies and 40,309,177 verified contacts, in four size bands. Apollo's and HubSpot's templates ask for a target market and never count it. The sheet is in English and downloads as .xlsx with its formulas.
Get thousands of leads in 4 minutes.
Stop stitching tools together.
Start with verified sales data, delivered in minutes.
No contracts · No setup · No onboarding
Sales plan template: start from your reachable market
Salesforce calls a sales plan a blueprint for hitting revenue targets. Its parts are goals, customer segments, territories, resources and a reporting plan. Most templates collect those parts as text. HubSpot's, behind a form, runs ten sections from Company History to Budget.
Text cannot tell you whether a segment is big enough to carry its target. A count can. So this template opens with a count: US companies by size, and the verified contacts you can reach at them.
| Company size (staff) | Companies | Verified contacts | Verified contacts per company | Share of companies | Share of contacts |
| 1 to 9 | 7,517,212 | 11,915,803 | 1.6 | 69.6% | 29.6% |
| 10 to 49 | 2,424,033 | 9,499,592 | 3.9 | 22.4% | 23.6% |
| 50 to 249 | 702,143 | 10,001,601 | 14.2 | 6.5% | 24.8% |
| 250 or more | 154,428 | 8,892,181 | 57.6 | 1.4% | 22.1% |
| All bands | 10,797,816 | 40,309,177 | 3.7 | 100% | 100% |
The counts are Spona data: every industry, all of the US, deduplicated across Spona's ICP groups. A company is one legal entity, counted at its headquarters.
A verified contact is a named work email that passed verification within the previous 90 days. Catch-all domains are left out. The bands do not overlap, so they add up.
Two readings matter for a plan, both computed from Spona's counts. First, small firms dominate the company count, with 69.6% under ten staff.
Reach runs the other way: 70.4% of verified contacts work at companies with ten or more staff. That is 3,280,604 companies and 28,393,374 contacts.
The second reading is depth per account: a company with 250 or more staff averages 57.6 verified contacts. The smallest band averages 1.6, so one large account offers 36 times the reach of one small account. There are 49 times as many small companies as large ones, though. A small-firm plan is about breadth, a large-account plan about depth.
What goes in the plan, then, and where:
| Part of a sales plan | Tab in the sheet |
| Targets by segment, motion and owner | Targets |
| Whether each segment exists at that size | Market size |
| Weekly accounts, contacts, touches and reps | Activity plan |
| Review cadence and what to change | Quarterly review |
| Positioning, messaging and process | Not here: they belong in a sales playbook |
The plan turns the segments of your go-to-market strategy into numbers. If the board wants a TAM, SAM and SOM slide, size it bottom-up first. The Market size tab is a segment check, not a market model.
UK readers switch Market for band counts to UK (DBT counts). The Department for Business and Trade counts 1,150,875 UK employers in the smallest band and 8,335 in the largest. It publishes no contact counts, so the Verified contacts per company (Spona US average) column stays blank for the UK.
How many accounts does your sales target need?
Work backwards. Take the sheet's first example segment: small firms in the US East with 10 to 49 staff. Its target is $240,000 of new business for the year at an average deal of $8,000. That is 30 deals.
At an 18% win rate, those deals need 167 opportunities. If 60% of first meetings become opportunities, that is 279 meetings. And if 6% of the accounts you contact take a meeting, you must contact 4,650 accounts.
Two of those rates come from published data. Ebsta's analysis of $48bn of opportunities puts the win rate on new customers at 18%.
The Bridge Group's SDR study puts the median monthly quota at 10 meetings held. The median quota for first-stage opportunities is 6. The example uses their ratio, 60%, as the share of meetings that become opportunities.
The 6% meetings-per-account rate is invented, like the target and the deal size. Published reply rates use different bases, so type your own from last year's CRM.
Now the question no document template asks: do 4,650 accounts exist? Spona counts 2,424,033 US companies in that size band.
If 2.0% of them fit the example ICP and sit in the US East, the segment holds 48,481 accounts. Contacting 4,650 of them is 9.6% of the segment in one year. The Market size tab marks it OK.
The sheet's second example fails that check. Small firms, US West has an ICP share of 0.3%, so the segment holds 7,272 accounts. Its $180,000 target needs 3,567 of them.
That is 49.1% of the segment in one year. The Check reads "Over the limit: widen the segment or lift conversion".
Burn through half a segment in a year and next year's plan has nowhere to go.
Then capacity: over 48 selling weeks, the US East segment needs 96.9 new accounts a week. With two contacts per account and a six-step sequence, that is 1,163 touches a week. The Bridge Group's median SDR logs 112 activities a day, or 560 a week. One rep cannot carry this segment, and the Activity plan tab says so with "Over capacity: needs 2.1 reps".
Four ways out: add a rep, shorten the sequence, lift the meetings-per-account rate with tighter targeting, or lower the target. Type any of them and the sheet shows what it costs elsewhere.

Sales plan template Excel and Google Sheets: five tabs
How do I write a sales plan? Set a target per segment and check it against the market and your reps' capacity. Then write down the weekly activity and the review dates.
This free sales plan template does that in five tabs. Use File > Make a copy to Make a copy of the Sheet, then work through the tabs in order. Yellow cells are inputs, grey cells are formulas, and the grey italic example rows are invented.
- Instructions. Set the plan settings first: Company target for the year (all motions), the four quarter shares, Selling weeks per quarter and Touches per contact (sequence steps). Then the limits: Touches one rep can make per week, Most of a segment to contact in a year and Most over-assignment of segment targets. Last, Watch band for the quarterly review and Market for band counts. The Plan check below them adds up the segment targets and compares them with the company target. The dropdown lists live here too, so you rename Rep A to Rep D once.
- Targets. One row per segment. Type Segment, Motion, Size band (the four bands of the table above), Territory or region and Owner. Then the five numbers: Annual target (revenue), Average deal size, Win rate (opportunities won), Meetings that become opportunities and Meetings per account contacted. The grey columns return Deals needed, Opportunities needed, Meetings needed and Accounts to contact this year. The Check column names the input that is missing. Existing customers skip the three rates: the sheet counts their deals only. To split a region into balanced territories, use the sales territory planning template; here Territory or region is a label.
- Market size. Rows follow Targets. For each new-business segment, type ICP share of the band, or Your own account count (optional) if you have a list already. Companies in band comes from the Spona table on the same tab. When the market is UK, it comes from the DBT counts. Define the ICP first with the ideal customer profile template; the share is your estimate, not a Spona output. The Check flags a segment over the yearly share limit. It also flags one that plans more contacts per account than Spona averages for its band.
- Activity plan. Type Reps on segment and Contacts per account. The tab returns Accounts per week, Contacts per week, Touches per week, Touches per rep per week, Meetings per week and Reps needed at capacity. Coverage by owner, on the right, adds up each rep's segments, target and weekly touches.
- Quarterly review. After each quarter, pick Quarter and Segment from the dropdowns and type Revenue actual and Meetings actual. Revenue plan and Meetings plan come from Targets and the quarter shares. Status is a formula, explained below. Change for next quarter is a dropdown of seven: Keep the plan, Add activity, Fix conversion, Widen the segment, Narrow the segment, Move coverage or Reset the target.
Two limits apply. Quarterly review runs to row 200, enough for four quarters of 40 segments. Targets, Market size and Activity plan hold 40 segments each. A plan with more segments than that has outgrown a sheet.
Most dropdowns read from ranges on Instructions, and Google rejects a value that is not on the list. The Owner column only warns, so a new rep's name goes in before you add it to the list.
Sales targets that hold: three checks before you commit
Xactly's planning guide says it in one line: quota planning needs to be realistic, not just optimistic. The sales plan template runs three checks before you commit a number.
Over-assignment under 5%
The Alexander Group advises keeping over-assignment to less than 5% of the company's fiscal objective. The Instructions tab adds the segment targets, $1,520,000 in the example, and compares them with the company target of $1,450,000. That is 4.8% over, so the Status reads OK. Push the segments to $1,530,000 and it turns red.
At least 60% of sellers at goal
The same guide asks for at least 60% of sales personnel to reach or beat goal. It notes that most companies prefer 66%.
In The Bridge Group's SDR study, 60% of SDRs reached quota. That is the lowest share the study has reported. A plan where two reps in five can hit their number is a plan built on hope.
Quarter totals on the review tab counts Segments reviewed and On plan. With one segment per owner, On plan divided by Segments reviewed is your share of sellers at goal.
Allocate before the year, and split the motions
The Alexander Group's third rule is to begin and complete quota allocation before the fiscal year starts, allowing at least two months. Split new and existing business while you do it, because Ebsta finds a 45% win rate on existing customers against 18% on new ones. Expansion deals also close in 52 days against 91. That is why Targets has a Motion column and skips the market check for Existing customers.
Selling weeks per quarter defaults to 12 rather than 13, and holidays are only part of the gap. The US has 11 federal holidays a year, and England and Wales have 8 bank holidays. Salesforce counts 15 to 17 effective selling days in December.
Salesforce also advises lower quotas for reps still ramping. The Bridge Group puts SDR ramp at 3.0 months. A rep hired at the start of the year ramps through the first quarter and sells for the other three. Enter 0.75 in Reps on segment for that year.
Quarterly sales plan review: what to change when a segment slips
How often should you update a sales plan? Pipedrive's answer is to review quarterly and refresh fully once a year. Salesforce agrees: a formal plan once a year, reviewed through the year, and at least every quarter for a startup. The Quarterly review tab is built for that cadence.
The review is the Check step of PDCA. ASQ describes PDCA as a four-step model for carrying out change. Its Check step: review the test, analyze the results and identify what you learned. The tab does the first two with a formula and leaves the third to you.
Status reads revenue first, then meetings. Revenue actual at or above Revenue plan is On plan. Below plan but inside the watch band, 90% of plan by default, it is Close.
Below the band, the tab looks at meetings. Fewer than 90% of Meetings plan gives Behind: activity. Meetings at or above 90% of plan, with revenue short, give Behind: conversion.
The split matters because the fixes differ. Behind: activity means the reps did not reach enough accounts. Add a rep, shorten the sequence or widen the segment.
Behind: conversion means they reached them and lost. Fix the pitch, the ICP share or the deal size. Then pick one change from the dropdown and write a note.
In the example first quarter, the team booked $300,000 against a plan of $304,000. That is 98.7% of plan, and it hides two problems.
| Segment | Revenue plan | Revenue actual | Meetings plan | Meetings actual | Status | Change for next quarter |
| Small firms, US East | 48,000 | 44,000 | 56 | 41 | Close | Add activity |
| Small firms, US West | 36,000 | 24,000 | 43 | 30 | Behind: activity | Widen the segment |
| Mid-market, all US | 90,000 | 96,000 | 33 | 35 | On plan | Keep the plan |
| Enterprise, named accounts | 80,000 | 80,000 | 9 | 10 | On plan | Keep the plan |
| Existing customers | 50,000 | 56,000 | On plan | Keep the plan |
US East is Close, and its meetings explain why: 41 held against 56 planned, from the one rep the Activity plan already flagged.
US West is Behind: activity. Its plan already contacts 49% of the segment in a year, so the change is Widen the segment rather than Add activity. Quarter totals shows three of five segments On plan. That is 60%, right at the Alexander Group's floor.

Where Spona fits in a sales plan, and where it does not
The band counts on Market size come from Spona's index, so the sheet's market check is a Spona check. Once a segment passes, Spona builds the account list for it. You describe the segment in a chat. The AI mines 40+ sources, verifies every lead and delivers a scored list in about 4 minutes.
You pay per lead, from $0.008 to $2.00, depending on the search type and plan. New leads that match a finished search appear every week, at the same price per lead. That weekly flow is what the Activity plan's Accounts per week column asks for.
The limits are just as plain. Spona does not set quotas, design territories, forecast or track activity; the sheet sets the quotas, and your CRM tracks the rest. The counts are US only. UK readers switch to the DBT counts, and other markets choose Own counts only and type their national figures.
The counts cover Spona's index, not every US business. The ICP share is your estimate, not a Spona output. For quota allocation across a large team, a planning suite or a consultancy such as the Alexander Group beats a sheet.
Get thousands of leads in 4 minutes.
Stop stitching tools together.
Start with verified sales data, delivered in minutes.
No contracts · No setup · No onboarding
Sales plan template FAQ
What is a sales strategy in a business plan?
It is the part of the plan that says how you will win and keep customers. The SBA's guide calls it the marketing and sales section. There you describe how you'll attract and retain customers and how a sale happens. UK guidance says a business plan covers objectives, strategies, sales, marketing and financial forecasts, and the Targets tab turns that into numbers per segment.
How to write an action plan?
An action plan translates strategies and objectives into specific work. Each step says what happens, who does it, by when, with what resources, and how you will know it is done. The Activity plan tab is that for outbound: accounts, contacts and touches per week, per segment, per owner. Add the owner in Targets and the Coverage by owner table does the rest.
What are the 7 steps to creating a sales plan?
Salesforce's seven steps are: connect your plan data with your CRM, understand your team's capacity and work with stakeholders. Measure the gap between reality and the goal, find the actions that fill it, present to leadership and execute, then keep adjusting. The sheet covers capacity (Activity plan), the gap (Targets and Market size), the actions (Change for next quarter) and the adjusting (Quarterly review). The CRM connection and the stakeholders are on you.
How does a sales plan differ from a sales forecast?
A sales plan says what you intend to sell and how: targets, segments and activity. A forecast says what you expect to close from the pipeline you hold today. The plan sets the number; the forecast tells you, during the quarter, whether you will reach it. Keep them in separate sheets, because the plan changes four times a year and the forecast every week.
Does the template work in Excel?
Yes. Google Sheets downloads a copy as Excel. The sales plan template uses common functions only, such as IF, INDEX, MATCH, SUMIFS, COUNTIFS and ROUNDUP, with no QUERY and no scripts. The file downloads as .xlsx with its formulas, and we recalculated it in LibreOffice with no errors.
Share this article
GET FREE LEADS





