KPI Performance Calculator
Score performance with configurable KPI weights, targets, caps and higher/lower-is-better logic.
Sales Target Calculator
Enter your target, sales so far and selling days to see achievement, what remains, the daily sales you now need and where you are projected to finish.
Use the Sales Target Calculator
Loading tool…
How to use the Sales Target Calculator
- Enter the sales target for the period and what has been achieved so far.
- Add the total selling days and how many are complete.
- Read the achievement percentage, remaining target and required daily sales.
- Compare the current run rate with the required rate to decide whether to adjust.
About this tool
Required daily sales = remaining target ÷ selling days left. The current run rate is achieved sales ÷ days completed. If the run rate is lower than the required rate, the projection falls short. Sales teams use the gap between the two to decide where to focus in the remaining days.
Free to use. Your inputs are processed in your browser and are not sent to our servers. Results are estimates for general information; see the disclaimer.
Track the whole month, and your team, in Excel
The Sales Target & Daily Run-Rate Tracker template logs daily sales, works out selling days, required daily sales and a month-end projection with a chart, and tracks up to 25 salespeople. It works in Excel 2010 or later.
Want a target tracker for your whole team? I build sales target and run-rate trackers in Excel. See services and request a quote.
Sales target formulas
| Measure | Formula |
|---|---|
| Target achievement % | Achieved ÷ target × 100 |
| Remaining target | Target − achieved |
| Required daily sales | Remaining target ÷ selling days left |
| Current run rate | Achieved ÷ selling days completed |
| Projected sales | Run rate × total selling days |
Worked example: mid-month check
A team has a target of Rs 5,000,000 for a month with 26 selling days. After 15 days, it has sold Rs 3,200,000.
| Result | Figure |
|---|---|
| Target achievement | 64% |
| Remaining target | Rs 1,800,000 |
| Selling days left | 11 |
| Required per day | Rs 163,636 |
| Current run rate | Rs 213,333 per day |
| Projected month-end sales | Rs 5,546,667 |
| Projected achievement | 110.9% |
The team's run rate is above the rate it needs, so it's on track. If the run rate were lower than the required rate, the gap would show exactly how much more it needs to sell each day.
Using run rate for daily decisions
- Check it often: a gap is easier to close on day 10 than on day 25.
- Use true selling days: leave out weekly closures and public holidays, or the daily requirement will look too low.
- Break it down: run the numbers by region, team or salesperson to see where the gap sits.
- Compare two rates: if the required rate is rising each day, the target is slipping away.
Limits of a straight-line projection
The projection assumes the rest of the period will look like the days so far. Real sales often don't move evenly. Month-end pushes, promotions, payday patterns, seasons and stock shortages can all change the result, so treat the projection as an early signal and not a promise.
For a fuller explanation, read our guide to the daily run rate method. If sales is one measure among several, combine them with the KPI Performance Calculator.
Frequently asked questions
Should I count weekends as selling days?
Only if your team sells on those days. Use the number of working or selling days that actually apply to your route or channel.
Why does the projection differ from the required daily sales?
The projection assumes you keep your current daily average. The required figure is what you must average from now on to hit the target.
Can I use it for any currency or unit?
Yes. It works with any numbers, such as revenue, cases or units. The optional currency label is just text.
How do I calculate target achievement percentage?
Divide achieved sales by the target and multiply by 100. Selling Rs 3,200,000 against a Rs 5,000,000 target is 64%.
How do I calculate required daily sales?
Divide your remaining target by the selling days left. Rs 1,800,000 over 11 days is about Rs 163,636 a day.
What is a sales run rate?
It is your average sales per selling day so far. Multiply it by the total selling days to project where the period may finish.
Related tools
Percentage Calculator
Percentage of a number, percentage change, percentage difference and add/subtract a percentage.
Business Report Generator
Turn highlights, metrics and actions into a structured business report you can copy or download as PDF.
Related articles
Sales Target Tracking: Using the Daily Run Rate Method
Learn the daily run rate method for tracking sales targets: achievement, remaining target, required daily sales and projections, with simple examples.
4 min read
What Does a Sales Operations Team Actually Do?
A plain-English guide to sales operations: planning, data, reporting, process and coordination, and why strong sales ops makes sales teams faster.
4 min read