Percent to goal, also called percent to plan or percent to target, is how much of a target you have reached, as a percentage: divide the actual result by the goal or plan and multiply by 100. Closing $720,000 against a $1,000,000 quota is 72% to goal, with $280,000 left. In sales, read it next to the calendar, because 72% in week 4 and 72% in week 12 mean different things. Updated October 2026: added steps, percent over goal, lower-is-better goals, Excel formulas and quota pacing.
Get The Forecast Brief
You just checked your pace to goal. The Forecast Brief is a short email from Pete Furseth, ORM's COO, built on what ORM sees in its customers' forecasts.
Percent to goal formula
The formula is simple:
Percent to Goal = (Actual / Goal) x 100
Worked example (illustrative): a rep with a $250,000 quarterly quota has closed $180,000. Divide 180,000 by 250,000 to get 0.72. Multiply by 100, and the rep is 72% to goal. The gap is Goal - Actual, so $70,000 is left to close and 28% of the goal remains.
The same math works for one rep against one quota: put the quota in the goal field and closed bookings in the actual field.
Need attainment for a whole sales team, rep by rep? The team quota attainment calculator takes each rep's quota and closed amount, then shows team attainment and the share of reps at quota.
Every variation people search for is the same division with the terms moved around. The examples below use made-up numbers.
| Measure | Formula | Excel (B2 = actual, C2 = goal) | Example (illustrative) |
|---|---|---|---|
| Percent to goal | Actual / Goal x 100 | =B2/C2 | $720,000 / $1,000,000 = 72% |
| Gap to goal | Goal - Actual | =C2-B2 | $1,000,000 - $720,000 = $280,000 |
| Percent over goal | (Actual - Goal) / Goal x 100 | =B2/C2-1 | $1,150,000 closed on a $1,000,000 goal = 15% over (115% to goal) |
| Percent to plan | Actual / Plan x 100 (same math) | =B2/C2 | $430,000 on a $500,000 plan = 86% |
| Lower is better | Goal / Actual x 100 | =C2/B2 | Churn goal 2%, actual 2.5% = 80% |
| Pace to goal | Actual / (Goal x Expected share by today) x 100 | =B2/(C2*D2), D2 = expected share | $600,000 on a $2,000,000 goal, 34% expected = 88% |
How to calculate percent to goal, step by step
Five steps, using the same rep.
- Match the period. The actual and the goal must cover the same dates. Quarter to date bookings against a full-year quota give a number that means nothing.
- Divide the actual by the goal. $180,000 / $250,000 = 0.72.
- Multiply by 100. 0.72 x 100 = 72% to goal.
- Find the gap. $250,000 - $180,000 = $70,000 left to close.
- Check it against the calendar. If half the quarter is gone, 72% is ahead of a straight line. If 90% is gone, it is behind. The pacing section below shows how to use a real curve.
How to calculate percent over goal
When the result beats the goal, the percent to goal formula still works and gives a number over 100%. Closing $1,150,000 against a $1,000,000 goal is 115% to goal.
To state only the part above the goal, use Percent Over Goal = (Actual - Goal) / Goal x 100. Here that is $150,000 / $1,000,000, or 15% over goal. Both numbers describe the same result, so label the one you report. A deck that shows 115% on one slide and 15% on the next will get questions.
Is percent to plan the same as percent to goal?
Yes. Percent to plan, percent of target and actual to goal all use the same math: Actual / Plan x 100. Only the label changes. Finance teams tend to say plan or budget. Sales teams say quota or goal.
Example (illustrative): a region with a $500,000 monthly plan has booked $430,000. It is 86% to plan, with $70,000 to go. Make sure the plan and the actual cover the same period and the same scope, such as new bookings only, or new plus expansion.
How to calculate percent to goal when lower is better
Some goals are wins when the number is small: cost per lead, churn, CAC, average handle time. Here the standard formula points the wrong way. With a churn goal of 2% and actual churn of 2.5%, Actual / Goal gives 125%, which reads as a beat. It is a miss.
Flip the ratio: Percent to Goal (lower is better) = Goal / Actual x 100. Now 2.5% churn against a 2% goal scores 80%, and 1.5% churn scores 133%.
Some teams use a second version: (2 x Goal - Actual) / Goal x 100. It moves in even steps, so 2.5% churn scores 75% and 1.5% scores 125%. It hits 0% when the actual is double the goal. The flipped ratio is softer on misses and climbs fast as the actual nears zero. Both are fine. Pick one, write it down, and use it every period so the scores compare.
Why the percentage alone can mislead you
A number like 72% feels reassuring until you anchor it to time. Hitting 72% of an annual goal in November is a miss in the making. Hitting 72% by the end of Q2 is ahead of pace. The percentage is only meaningful against the calendar, so always read it next to how much of the period has elapsed.
The gap matters more than the percentage for planning. A rep at 72% of a $1M quota and a rep at 72% of a $4M quota are both "at 72 percent," but the second one needs to close more than three times the dollars to land the year. When you manage to the gap in dollars, you allocate coverage where the revenue risk actually sits, not where the percentage looks worst.
How do you calculate pacing to goal?
Compare what you have closed with what you should have closed by this point in the period. The formula is Pace to Goal = Actual / (Goal x Expected share closed by today) x 100. A result of 100% means on pace, even when raw attainment looks low.
The simplest expected share is a straight line by day: days gone divided by days in the period. On day 45 of a 91-day quarter, 49% of the time is gone, so a straight line expects 49% of the goal. That is the difference between pacing and attainment. Attainment says how much of the goal is done. Pace says whether that is enough for today's date.
The expected share is the part most teams get wrong. Revenue does not arrive in a straight line. ORM breaks every customer's quarter into 13 weekly weights, and in one example curve the quarter runs well behind a straight line until the final three weeks:
| End of week | Expected share closed (example curve) | Straight-line expectation |
|---|---|---|
| 4 | 21.0% | 30.8% |
| 6 | 34.0% | 46.2% |
| 8 | 49.7% | 61.5% |
| 10 | 61.4% | 76.9% |
| 12 | 82.5% | 92.3% |
| 13 | 100% | 100% |
In this curve, 66% of the quarter closes after week six. Pete Furseth, ORM's COO, sees the same shape across customers. The third month of a quarter is the largest and the first is the smallest. A striking share of business closes in the last week. Why your quarter is back-loaded covers how much of that is real.
Worked example: a team with a $2,000,000 quarterly goal has closed $600,000 by the end of week six. Raw attainment is 30%. Against the straight line it is at 65% of pace, which reads as a crisis. Against the example curve it is at 88% of pace ($600,000 divided by $680,000), which is behind but recoverable. Use your own history to build the curve. The full example is in the 13-week quarter.
The same math gives a projected finish. Divide what you have closed by the expected share: $600,000 / 0.34 projects about $1.76 million, or 88% of goal. The straight line projects $1.3 million, or 65%. Pace to goal and the projected finish as a share of goal are the same number.
Review it weekly. A monthly check in a 13-week quarter leaves only two useful checkpoints before it is too late to change anything.
What should you do at 70% at mid-quarter?
First, check which 70% you have. Seventy percent of the goal at week six is well ahead: a straight line expects 46% by then, and the example curve expects 34%. Protect it. Make sure the closed deals are real bookings and keep the open ones moving.
Seventy percent of pace is the hard case. On the example curve, the rest of the quarter now has to close about 15% more than it normally does. On a straight line it is about 26% more. Do not count on the deals already dated for this quarter. ORM sees only about 20% of the pipeline value dated to close in a quarter on day one actually close in that quarter.
At week six the answer is better focus, and more activity rarely helps. "Sell harder" and "grind it out" do not work halfway through a quarter. Pete works through it in three steps:
- Find the gap. Is it deal size, win rate, deal count, time to close, or a combination? Pressure on deal size or win rate usually points to competition. A low deal count points to pipeline generation, so look at marketing and BDRs. In 2026, longer cycles have been the most common cause across ORM customers.
- Decide what can still be sold this quarter. Focus on open deals with a credible path to close, and stop spending time on the rest. Force a decision on stuck deals: a no today is better than a no three months from now. Deals you can pull forward without significant discounting are on the table too.
- Put executive support where it moves the most. Remove a blocker, get to the right decision-maker, reinforce value, or create urgency on the deals that matter.
Be careful with pull-ins. A deal pulled forward usually closes at a discount, and it comes out of next quarter's starting pipeline, which is built 6 to 12 months ahead. See the real cost of pulling deals forward.
If the math says the quarter will miss, say so early. As Pete puts it, bad news does not get better with time. The full method is in how to diagnose a mid-quarter revenue shortfall.
Why can a team fall behind when the pipeline is there?
Because pace depends on velocity as much as volume. One ORM customer had a quarter where the forecast fell apart with coverage tight but sufficient. Deals did not move through the quarter the way the forecast assumed. More of them slipped, fewer were won or lost than expected, and too much stayed stuck in the middle. It was Q1, the team was not focused early, and by the time the problem was obvious there was little room to recover.
Three questions catch this before percent to goal does. Are deals moving? Are close dates holding? Are you winning and losing opportunities at the expected rate? When those signals break, the forecast is in trouble well before the top-line number shows it.
What is a good percent to goal?
At period end, 100% is the line for a single rep or team. For planning, expect most reps to land below it. Pete plans for average quota attainment of 75% to 80%, with a tail below and a tail above. If the company number only works when average attainment falls to 50%, you have a capacity problem. Raising quotas will not fix it.
Misses are common. Ebsta and Pavilion's 2025 benchmarks put missed quota rates at 78%, up from 69% (Ebsta and Pavilion, 2025). To see how attainment spreads across a team, read what is a good quota attainment rate.
Percent to goal in Excel and Google Sheets
Put the actual in column B and the goal in column C, starting in row 2.
- In D2, type
=B2/C2and press Enter. - Format D2 as a percent. In Excel, use the % button on the Home tab. In Google Sheets, use Format, then Number, then Percent.
- Wrap it as
=IFERROR(B2/C2,"")so a blank or zero goal shows an empty cell in place of #DIV/0!. - Copy the formula down for each rep or month.
For the gap, use =C2-B2. For percent over goal, use =B2/C2-1. For a metric where lower is better, use =C2/B2. For pace by day, put days gone in E2 and days in the period in F2, then use =B2/(C2*E2/F2). If the goal itself is negative, Exceljet gives =(actual-goal)/ABS(goal)+100% (Exceljet).
ORM's take: attainment is the question, not the answer
This calculator gives you a clean read on where you stand today. What it cannot do is tell you whether you will close the gap, which deals or segments will get you there, or what to change if the pace is off.
That is what ORM's custom prescriptive models do. We forecast each rep, segment, and territory to period-end, flag who lands short and by how much, and prescribe the specific moves to recover the gap. Percent to goal is the diagnostic. The prescription is where the number gets closed.
Common questions
How do you calculate percent to goal?
Divide the actual result by the goal and multiply by 100. A rep who has closed $180,000 against a $250,000 quarterly quota is at 0.72, or 72% to goal. The gap is the goal minus the actual, here $70,000. In sales, also check pace: compare the result with how much of the period has passed, because 72% in week 4 and 72% in week 12 call for different moves.
How do you calculate percent over goal?
Subtract the goal from the actual, divide by the goal, and multiply by 100. Closing $1,150,000 against a $1,000,000 goal is 15% over goal. The plain percent to goal formula still works past 100%, so the same result also reads as 115% to goal. Pick one way to say it and use it every time, because 15% and 115% describe the same quarter.
How do you calculate percent to goal when lower is better?
Flip the ratio: divide the goal by the actual and multiply by 100. With a churn goal of 2% and actual churn of 2.5%, the score is 80%, a miss. At 1.5% churn it is 133%, a beat. Some teams use (2 x Goal - Actual) / Goal instead, which moves in even steps (75% and 125% here). Pick one, write it down, and keep it.
How do you calculate an achievement percentage against a target?
Divide what was achieved by the target and multiply by 100. That is the same as percent to goal or percent to plan; only the label changes. A region that booked $430,000 against a $500,000 plan is at 86%, with $70,000 to go (illustrative). Make sure the target and the actual cover the same period and scope.
How do I calculate percent to goal in Excel?
Put the actual in B2 and the goal in C2, type =B2/C2, and format the cell as Percent. Use =IFERROR(B2/C2,"") so a blank goal does not show #DIV/0!. For percent over goal, use =B2/C2-1. For a metric where lower is better, use =C2/B2. The same formulas work in Google Sheets.
How do you calculate pacing to goal?
Divide what you have closed by what you should have closed by today. That target to date is the goal times the share of the period your history says should be done. 100% means on pace. A straight line uses days gone divided by days in the period, but most B2B quarters close late, so build the share from your own history.
What should you do when a team is behind pace?
Diagnose before you push. Behind pace with healthy coverage is a conversion problem. Behind pace with thin coverage is a generation problem, and the two need opposite responses. Find which lever is off: deal size, win rate, deal count or cycle length. Then put time and executive help on the deals that can still close this quarter.
See the forecast behind the number
This tool shows your attainment. ORM shows whether you will close the gap and what to do about it.
Schedule a Demo