MestraMestra
All posts

Sales Plan: How to Build, Calculate and Hit It — an Example and a Free Template

Sales13 min read

How to build a sales plan: types, calculation methods from revenue to requests, an example by manager, tracking progress, 7 mistakes and a free Excel template.

M
Mestra Team
A sales plan in Mestra: the monthly target and progress by manager

A sales plan is a concrete target for revenue or number of deals over a set period, broken down by manager, product and week.

It's built by calculating backwards: from the desired revenue through the average bill to the number of deals, and through conversion to the number of requests you need to receive.

For a plan to work, the numbers are checked against past results and seasonality, and progress is tracked every week.

What a sales plan is

A sales plan is a document or spreadsheet that records how much the company must sell over a period, through which channels and with which people.

A sales plan answers four questions: how much (revenue, deals), when (month, week), who (managers, branches) and from what (requests, repeat sales, average bill).

It's important not to confuse a plan with a forecast.

A sales forecast shows how much the company will sell if everything stays as it is. A plan is a target the company deliberately moves towards and allocates resources to: advertising, people, time.

Why you need a sales plan

While the company has one seller — the owner — you can do without a formal target. As soon as a second and third manager appear, without a shared number you lose sight of who drives revenue and who is just busy chatting. A plan solves four practical tasks:

  • Financial stability. If the target is below the cost of salaries, rent and advertising, you see it in advance, not at the end of the quarter.
  • Marketing. Knowing conversion, it's easy to see how many requests you need and whether the current budget for advertising and platforms like Avito is enough.
  • Team management. One employee falling behind in week two can still be fixed; in week four it can't.
  • Motivation. A clear number and a transparent calculation turn the abstract "we need to sell more" into a concrete task.

Types of sales plan

Type What it measures Who it suits
By revenue Total payments for the period, ₽ Almost everyone
By number of deals Number of closed sales Services with similar bills
By manager Each employee's personal target Teams of two or more
By product and line of business Revenue by service or category Companies with several lines
By channel Sales from the website, Avito, messengers, repeat clients Those investing in several sources
By activity Calls, meetings, viewings, measurements New employees on probation

By timeframe, plans are annual (strategy and budget), quarterly (seasonality and big projects), monthly (the team's main working target) and weekly (checkpoints). For most companies the best combination is an annual benchmark for the owner and a monthly target broken down by week for the team.

Which metrics to include in the plan

  • Revenue — the main bottom-line metric.
  • Number of requests — how many enquiries will come from all channels: messengers, website, marketplaces, calls.
  • Conversion — the share of requests that turn into payment. More on calculating it by stage in our article on the sales funnel.
  • Average bill — revenue divided by the number of deals.
  • Share of repeat sales — how much revenue regular clients bring in.
  • Margin — so hitting the plan doesn't mean selling at a loss because of discounts.

4 methods for building a sales plan

1. Top-down

The owner sets the overall target based on the company's financial goals: covering costs, reaching the required profit, funding growth. The number is then distributed across departments and managers.

Pro — the plan is linked to strategy. Con — without checking against real data, the target often turns out to be unachievable.

2. Bottom-up

Each manager estimates how much they can sell based on their base and pipeline. The numbers add up to the overall plan.

Pro — the team believes in the target. Con — employees tend to lowball estimates to make sure they hit the plan.

3. By funnel (calculating backwards)

The most accurate method. Go from money to requests:

  1. The revenue we want — for example, 1,200,000 ₽.
  2. Average bill — 40,000 ₽. So you need 1,200,000 / 40,000 = 30 deals.
  3. Request-to-deal conversion — 15%. So you need 30 / 0.15 = 200 requests.

If 140 enquiries came in last month, it's immediately clear: without extra advertising, work with the old base or higher conversion, the target won't be met. The calculation shows the bottleneck before the month even starts.

4. From past periods

Take the results of the same month last year and the last 3–6 months, then adjust for seasonality and planned changes: new advertising, a new employee, a price increase. This method is good as a check on the first three.

In practice, a combination works best: a top-down target, checked against the funnel and past data, discussed with the team.

How to build a sales plan: 7 steps

Step 1. Gather data

Revenue, number of deals and requests for at least 6–12 months. If records were kept in a notebook or messengers, reconstruct at least the last three months — without this base, any number is pulled out of thin air. How to put your base in order is covered in our article on client tracking.

Step 2. Account for seasonality

Most niches have peaks and troughs: renovation in summer, travel before holidays, education in September. Compare the same months in previous years. The "+10% every month" mistake means the team is guaranteed to miss the target in the low season and lose motivation.

Step 3. Calculate the target by funnel

Revenue → average bill → deals → conversion → requests. Check where resources fall short.

Step 4. Identify the sources

How many requests will come from advertising, Avito, the website and referrals, and how much revenue from repeat clients. Repeat sales are almost never included, even though they're the cheapest source of money.

Step 5. Distribute the target among managers

Don't split the total equally. Take experience, workload and past months' results into account. A newcomer's first-month target is 50–70% of an experienced colleague's.

Step 6. Break the month into weeks

If less than 40% is done by the middle of the period, that's a signal — not a reason to wait for a "final push".

Step 7. Discuss the numbers with the team

A plan a manager considers unrealistic doesn't work. Show the calculation: how many requests will come in, what the conversion is, what the average bill is. When the logic is clear, people argue about specific numbers, not about "why bother".

Example sales plan by manager

An apartment renovation company with three managers: the October target is 1,200,000 ₽, the average bill 40,000 ₽ and conversion 15%.

Manager Target, ₽ Deals Requests needed Week 1 Week 2 Week 3 Week 4
Anna (experienced) 520,000 13 87 130,000 130,000 130,000 130,000
Igor 440,000 11 73 110,000 110,000 110,000 110,000
Olga (newcomer) 240,000 6 40 60,000 60,000 60,000 60,000
Total 1,200,000 30 200 300,000 300,000 300,000 300,000

You'll find the same table with formulas in the template: change the revenue, average bill and conversion, and the rest calculates itself; on the second sheet you can track actuals by week.

Sales plan template in Excel: target, deals and requests by manager

Download the sales plan template (Excel)

Plan specifics for different types of business

Services: salons, clinics, renovation

The main unit is a booking or a measurement. Calculate how many bookings you need at average specialist or crew utilisation, and include repeat visits: in salons and clinics they bring up to half of revenue. Plan evening and weekend enquiries as a separate line — services get a lot of them.

Retail and online stores

Targets are easier to set by revenue and number of orders, with the average bill split by product category. Account for marketplace promotions and holiday peaks: in retail, December and March often bring 15–20% of annual revenue each.

B2B sales

The deal cycle is longer, so besides revenue you plan intermediate stages: meetings, proposals sent, approvals. The monthly plan here relies on past months' pipeline: deals closing in October started back in August.

Real estate

Agencies plan the number of viewings and deals for each agent, and calculate commission by property type. The key factor is how quickly requests from Avito and CIAN are answered: a client writes to several agencies at once.

Calculation formulas

Metric Formula
Number of deals Revenue target / Average bill
Requests needed Number of deals / Conversion
Percentage achieved Actual / Target × 100%
End-of-month forecast Actual to date / Working days elapsed × All working days
Average bill Revenue / Number of deals
Conversion Deals / Requests × 100%

The forecast formula is especially useful: by the tenth working day you can see where the month is heading, and there's still time to change something.

Annual, quarterly and monthly plans: how to break them down

  1. Year. Start from the financial goal and last year's results, and distribute revenue across months in proportion to seasonality, not in equal shares.
  2. Quarter. Refine the annual plan based on actual results and new inputs: a new branch, a new service, a price change.
  3. Month. The team's working target, calculated by funnel and distributed by manager.
  4. Week. A checkpoint: 25% of the target by the end of week one, 50% by week two. If you're more than 10–15% behind, action is needed.

How to track plan progress

A plan doesn't work if it's only remembered on the last day of the month. The minimum tracking rhythm:

  • Daily — new requests and unanswered conversations.
  • Weekly — plan vs actual by manager, the end-of-month forecast, a review of 3–5 lost deals.
  • Monthly — results, reasons for deviations, adjusting next month's plan.

How to run reviews without total surveillance is covered in our article how to manage sales managers.

Why a sales plan isn't met: 7 reasons

Revenue follows the formula requests × conversion × average bill. If the plan isn't met, at least one multiplier is falling short.

  1. Too few requests. Advertising and platforms deliver fewer enquiries than the calculation requires.
  2. Slow replies. A client writes to three companies, and your manager replies two hours later.
  3. Evening and weekend requests go unanswered. A large share of enquiries arrives when nobody is around.
  4. Conversations on different phones. MAX on one employee's phone, WhatsApp* on another's, Avito checked once a day — some messages simply go unseen.
  5. No next step. The manager answered the question but didn't suggest a meeting or a quote, and the conversation fizzled out.
  6. Weak objection handling and discounts instead of value. Conversion and the average bill fall. The method is in our article handling objections.
  7. A number without a calculation. "+20% this month" without accounting for requests, conversion, seasonality and newcomers' experience.

What to do if the month is already under way

  1. Calculate the forecast and the real gap.
  2. Find the stage that's falling short: requests, handling, conversion or average bill.
  3. Check all unanswered conversations — some "lost" clients are still waiting.
  4. Write to your old base: those who were interested but didn't buy, and those due a repeat purchase. Ready texts are in our article how to win back a client.
  5. Cover evenings and weekends with a staff member on duty or an AI assistant.
  6. Revise next month's plan based on real numbers.

How Mestra helps hit the plan

In Mestra, everything that makes up the result is visible in one window:

  • All enquiries in one feed. MAX, Telegram, WhatsApp*, VKontakte, Avito, CIAN — no request gets lost between apps.
  • Analytics without manual reports. New leads, conversion, revenue, request sources and each employee's conversion.
  • Finance next to clients. Invoices and payments are linked to the card, so actual revenue matches the money in the account.
  • An AI assistant on the front line. Answers clients at night and at weekends, books meetings and creates a task for the manager itself.
  • Repeat sales reminders and mailings to your base.

Analytics in Mestra: revenue, conversion and request sources

Plans start from 390 ₽ per user per month (CRM and all messengers). The AI assistant and marketplaces are included in Standard for 1,090 ₽. The first 15 days are free, no bank card needed.

Related reading: department goals and OKRs, revenue forecast.

FAQ

How do you build a sales plan if the business has only just opened?

Use the break-even point as the basis: how much you need to sell to cover costs. After two or three months you'll have real data — then move to calculating by funnel.

What period should a sales plan cover?

For the team — a month broken down by week. The year and quarter are benchmarks for the owner and the budget.

How is a sales plan different from a forecast?

A forecast shows how much you'll sell under current conditions. A plan is a target for which you change the conditions: add advertising, people or work with the old base.

How do you distribute the plan among managers?

By experience, past months' results and workload. Splitting it equally is a common mistake.

What if the plan hasn't been met for several months in a row?

Recalculate it from real data: requests, conversion and average bill. The number may have been unachievable from the start, or the company may be losing requests at the reply stage.

Should you fine people for missing the plan?

Fines usually make things worse: managers start hiding problems. It's more effective to review deals and remove obstacles.

Do you need a CRM for sales planning?

A spreadsheet is enough for one or two employees. When there are more managers and clients write in several messengers, it's easier to collect actuals automatically — otherwise reconciliation takes hours.

Bottom line

A good sales plan is built from data, not wishes: revenue → average bill → deals → requests.

Combine calculation methods, account for seasonality, distribute the target by experience and track weeks, not months. And for the plan to be met, make sure requests don't get lost along the way. The Excel template will help you start today, and Mestra will collect actuals automatically.

*WhatsApp is owned by Meta, which is recognised as extremist and banned in Russia.

Keep reading

Sign up for a demo and see it in action

Niche analysis with ready scenarios and fields

Sign up for a demonstration

Leave your contacts and we will schedule a short demo.

We use cookies

Cookies keep Mestra running, remember your preferences and help us understand how the site is used. See our Privacy Policy, Terms of Service and Consent Form.