Wayfen Blog · 20 October 2026

Month-end sales forecast: how to know by mid-month if you will hit target

Most sales teams find out whether they hit target when the month is already over. A simple month-end sales forecast tells you by the middle of the month, while there is still time to act. You do not need a data team or complicated software: just your sales to date, your target and a calendar of working days.

Why "percent of target" can mislead you

On the 15th of the month, a report that says "48% of target" sounds worrying. But if only 10 of 22 working days have passed, the team should be at about 45%, so it is actually ahead. The opposite also happens: 60% of target on the 25th looks fine until you notice that almost every working day is gone.

The fix is to compare sales with the share of the month that has passed, counting working days, not calendar days. That number is your pace.

Step 1: count working days

List the days your field reps actually work this month: usually Monday to Friday, plus Saturday if your team often works then, and minus public holidays. Then count how many have passed. If today is a working day, count it as part-done.

Example: 22 working days in the month, 12 gone. Share of the month gone = 12 ÷ 22 = 55%.

Step 2: work out your pace

Pace = sales to date ÷ (monthly target × share of the month gone).

Example: target $250,000, sales to date $139,000. Expected by now = $250,000 × 55% = $136,400. Pace = $139,000 ÷ $136,400 = 102%. The team is slightly ahead of where it needs to be.

A simple traffic light works well: 98% or more is on track, 90–98% needs watching, below 90% needs action this week.

Step 3: forecast the month end

Sales per working day = sales to date ÷ working days gone. Month-end forecast = sales to date + (sales per working day × working days left).

Example: $139,000 ÷ 12 = about $11,600 a day. With 10 days left, the forecast is $139,000 + $116,000 = about $255,000, just over target.

Step 4: give the forecast a range

Daily sales go up and down, so one number can give false confidence. A range is more honest. Look at how much daily sales usually vary, and give a low and a high figure, for example "$251,000 to $259,000". If even the low end is above target, you can relax a little. If the target sits inside the range, every day counts. If the high end is below target, you need a different plan, not just more effort.

Step 5: what each field rep needs per day

The same calculation works for every field rep with a target. For each one, show their pace and the amount they need per working day from now to the end of the month. That turns a vague "we are behind" into a clear number someone can act on today:

Field rep A: pace 125%, already on course to beat target.
Field rep B: pace 85%, needs $560 a day for the rest of the month.

Rank field reps by pace, weakest first, so the manager's attention goes where it makes the biggest difference. Our guide to tracking field reps fairly explains how to use these numbers to coach rather than blame.

Step 6: add deals due to close

Your forecast so far assumes the team keeps its current pace. Big deals that close (or slip) can move the month either way. List the open quotes and deals due to close this month, with a realistic chance of winning each one, and add up the weighted value. Any deal past its close date needs a call this week: either agree a new date or mark it lost so it stops flattering the forecast. Our lead follow-up routine helps keep that list clean.

A 15-minute weekly forecast meeting

The answer in one line: "We expect to finish at $251,000 to $259,000 against a $250,000 target."
Pace by field rep and area: who is behind and by how much per day.
Deals due to close: what is needed to win each one.
Three decisions for the week: for example, coach one field rep, chase three overdue deals, visit regular clients who have stopped buying.

Keep the same format every week. After a month, the team will start asking about pace before you do. For the bigger picture, use the forecast alongside your budget vs actuals and the field sales KPIs you already track.

How Wayfen helps

Wayfen works this out for you from the sales your field reps log. The Executive brief gives the answer in one line, with the forecast range, the pace against target and three decisions for the week. The Month-end forecast report shows the day-by-day line against your target, pace and what is needed per day for every field rep, sales by area, and deals due to close with their weighted value. Saturdays count as working days only if your team actually works them. Every report downloads as a PDF or as an Excel file with live formulas, so you can change a target and see the effect immediately.

Frequently asked questions

How do you forecast month-end sales?

Divide sales to date by the working days gone to get sales per working day, then multiply by the working days left and add the sales you already have. That gives the month-end forecast if the team keeps its current pace.

What is sales pace?

Sales pace compares sales to date with where you should be by now. If 12 of 22 working days have passed, you should have about 55% of the monthly target. Sales of 60% of target means a pace of about 110%.

Why use working days instead of calendar days?

Field teams do not sell evenly every day of the week. Counting only the days the team actually works stops weekends and public holidays from making the forecast look worse or better than it really is.

What should a manager do if the forecast is below target?

Work out what is needed per working day to close the gap, look at which field reps and areas are furthest behind, and act this week: chase deals due to close, visit regular clients who have gone quiet and coach the field reps who are behind pace.

Try Wayfen free for 14 days with up to 5 people. No card needed.

Start free trial