An annual operating plan template is a spreadsheet that turns next year's growth target into a committed plan: targets by quarter, the people and sales capacity to deliver them, the pipeline they need, the budget and the resulting P&L. ORM's free Excel template does this for SaaS, starting from ARR, retention and rep ramp.
Get the annual operating plan template
Standard .xlsx, eleven tabs, four quarters and a full-year column, no macros. Opens in Excel, and in Google Sheets through Drive (Open with > Google Sheets) or File > Import. Yellow cells are inputs. Everything else is a formula.
Quick check: can your sales team book next year's target?
A simplified version of the template's Targets and Capacity tabs. It works out the new-logo ARR your growth target needs after churn and expansion, then compares it with what your reps can book. Defaults are illustrative.
| Line | Amount |
|---|
To grow ARR from $10,000,000 to $13,000,000 (30%), you lose $1,200,000 to churn and contraction (88% GRR) and gain $1,300,000 from expansion (101% NRR), so new customers must bring $2,900,000 of new ARR. Your 5 ramped AEs and 2 Q1 hires can be expected to book about $2,637,000 at 75% attainment, 91% of what the plan needs. The gap is $263,000. Closing it with sellers takes about 2 more AEs hired at the start of the year, or the target comes down to about 27.4% growth. At a 25% dollar win rate the year needs $11,600,000 of new-logo pipeline.
Get The Forecast Brief
You just checked next year's plan. The Forecast Brief is a short email from Pete Furseth, ORM's COO, built on what ORM sees in its customers' forecasts.
What is an annual operating plan template?
It is the working file behind the plan the board approves for next year. The plan itself is a commitment: the revenue and spending targets for the fiscal year, phased by quarter, with owners. ORM's glossary entry on the annual operating plan covers what that commitment means and why it stays fixed once approved. The template is where you build it and prove it adds up.
Most free templates in the search results are goal grids: an objective, an owner, a KPI, a deadline. That is one tab of a real plan. A SaaS operating plan also has to answer four money questions on one workbook: what ARR and revenue are we committing to, who will book it, what pipeline has to exist first, and what will the people and spend cost. If those four live in separate files, they drift apart by February.
What should an annual operating plan include?
A plan the board can trust covers targets, assumptions, capacity, pipeline, people, budget, initiatives and a way to track progress. Each part answers a question the board will ask, and each one lives on its own tab in the template.
| Part of the plan | Question it answers | Tab |
|---|---|---|
| Targets | What ending ARR, new-logo ARR, expansion, churn and revenue do we commit to, by quarter? | Targets |
| Assumptions | Which retention, quota, attainment, win rate, cycle, seasonality and ramp numbers is the plan betting on? | Assumptions |
| Capacity | Can the AEs we will have, after ramp, book the new-logo target? | Capacity |
| Pipeline | How much pipeline does each quarter need, and by what date must it exist? | Pipeline |
| People | Who do we employ and hire, in which department, at what cost? | Headcount |
| Budget | What do we spend on programs, tools, rent and services beyond people? | Budget |
| Financial result | What gross margin, operating income and Rule of 40 does all of that produce? | P&L |
| Initiatives | What must change this year to deliver the numbers, who owns it, and what is the milestone each quarter? | Initiatives |
| Tracking | Where is reality splitting from the plan, and by how much? | Plan vs actual |
What is in the template, tab by tab
The workbook has eleven tabs. Six take inputs, and the rest calculate. The order matches the order you build a plan in.
| Tab | What it does | What you enter |
|---|---|---|
| Start here | Fill-in order, every formula in words, three rules | Nothing |
| Plan on a page | The year's targets, margins and Rule of 40 against Benchmarkit medians, ten checks with a status, and a quarter-by-quarter summary for the board | Nothing |
| Assumptions | All drivers in one place, a notes column for why each changed, plus seasonality, ramp and pipeline source tables | 15 inputs and 3 small tables |
| Targets | Top-down target, the new-logo ARR it needs, the quarterly ARR bridge and revenue | Nothing |
| Capacity | 30 rows of AEs and open roles: ramp factor and expected new-logo ARR by quarter, the gap to target, and the hires needed to close it | Name, segment, tenure, start quarter, quota |
| Pipeline | Pipeline and opportunities needed per quarter, the date each must exist, and the split by source | Nothing |
| Headcount | 40 rows of roles: loaded cost and heads by quarter, rolled up to COGS, S&M, R&D and G&A | Role, department, count, start quarter, base, variable |
| Budget | 25 rows of non-people spend by department and quarter | Line, department, amounts |
| P&L | Subscription and services revenue, four COGS lines, gross margin, opex by department, operating income, % of revenue and benchmarks | Nothing |
| Initiatives | 15 rows: initiative, owner, KPI, target, four quarterly milestones, budget line, status | All of it |
| Plan vs actual | The locked plan against actuals by quarter and year to date for 11 lines | Actuals and quarters closed |
How do you build an annual operating plan?
Start with the top-down target, turn it into new-logo ARR, then test it bottom up against capacity, pipeline and cost before anyone signs it. With the template, that is nine steps, and most of the work is getting honest assumptions.
- Set the drivers. On Assumptions, enter the fiscal year start, starting ARR from your year-end ARR bridge and the growth target. Add GRR, NRR, quota, attainment, dollar win rate, deal size and cycle from the last four quarters, not from last year's plan.
- Set seasonality from your own history. The share of new-logo ARR each quarter booked over the last two or three years. Equal quarters are almost never right.
- Read the target. Targets shows the new-logo ARR the growth goal needs after churn and expansion, by quarter, and the revenue it produces.
- List every seller. On Capacity, each AE and open role with tenure at the start of the year and start quarter. The sheet applies your ramp curve and seasonality and shows the gap.
- Check the pipeline dates. Pipeline shows how much each quarter needs and the date it must already exist. For Q1, that date is usually in the current year.
- Add the people. On Headcount, every team as a row with count, start quarter, base and variable pay. The AE hires you added on Capacity belong here too. If you plan hires by driver, ramp and attrition over two years, build them in the headcount planning template and carry the totals here.
- Add the spend. On Budget, programs, tools, rent, legal and contractors by department and quarter.
- Read the result and close the gaps. Plan on a page shows margins against benchmarks and flags any capacity gap. Close it by hiring earlier, changing the plan or calling the number down, and record the choice on Assumptions.
- Lock it, then track it. Save the approved file as read-only. During the year, type actuals into Plan vs actual and set Quarters closed. The plan columns never change. To explain how the actuals moved from one month to the next, run a flux analysis during the close.
Annual operating plan example: a $10M ARR SaaS company plans FY2027
This is the worked example inside the example file. The company and every number are illustrative, made up to show the mechanics. It starts the year with $10,000,000 of ARR, and the board wants 30% growth. It assumes 88% GRR and 101% NRR, the medians in Benchmarkit's 2025 SaaS benchmarks, which are based on 2024 data.
Step 1, the target. Ending ARR of $13,000,000 means $3,000,000 of net new ARR. Churn and contraction take $1,200,000 (12% of the base) and expansion adds $1,300,000 (101% minus 88%), so new customers must bring $2,900,000. Phased by the company's seasonality (20%, 26%, 22%, 32%):
| Quarter (illustrative) | Starting ARR | New logo | Expansion | Churn and contraction | Ending ARR | Revenue |
|---|---|---|---|---|---|---|
| Q1 | $10,000,000 | $580,000 | $325,000 | -$300,000 | $10,605,000 | $2,725,625 |
| Q2 | $10,605,000 | $754,000 | $325,000 | -$300,000 | $11,384,000 | $2,898,625 |
| Q3 | $11,384,000 | $638,000 | $325,000 | -$300,000 | $12,047,000 | $3,078,875 |
| Q4 | $12,047,000 | $928,000 | $325,000 | -$300,000 | $13,000,000 | $3,280,875 |
| FY | $10,000,000 | $2,900,000 | $1,300,000 | -$1,200,000 | $13,000,000 | $11,984,000 |
Revenue is $11,384,000 of subscription revenue (average ARR in each quarter, divided by four) plus $600,000 of services. Ending ARR grows 30%, but revenue for the year is only 19.8% above the $10,000,000 run rate the company started with, because new ARR arrives through the year.
Step 2, the capacity check. The company has four fully ramped AEs, one AE nine months in, two hires starting in Q1 and one in Q3. Quota is $600,000 of new ARR a year, planned attainment is 75%, and quota follows the same seasonality.
| Quarter (illustrative) | New-logo target | Sales capacity | Gap |
|---|---|---|---|
| Q1 | $580,000 | $441,000 | -$139,000 |
| Q2 | $754,000 | $637,650 | -$116,350 |
| Q3 | $638,000 | $603,900 | -$34,100 |
| Q4 | $928,000 | $964,800 | $36,800 |
| FY | $2,900,000 | $2,647,350 | -$252,650 (91.3% covered) |
The gap is 0.56 of a ramped AE's year. It takes two more Q1 hires to close it, not one, because a seller hired in January delivers only 0.432 of a ramped year: the ramp curve (10%, 30%, 50%, 70% in the first four quarters) weighted by seasonality. Bottom up, this team supports 27.5% growth, not 30%. That is the conversation to have before the board meeting.
Step 3, the pipeline dates. At a 25% dollar win rate and a $50,000 average deal, with a 90-day cycle:
| Quarter (illustrative) | Pipeline needed | Opportunities | Must exist by |
|---|---|---|---|
| Q1 | $2,320,000 | 47 | Oct 3, 2026 |
| Q2 | $3,016,000 | 61 | Jan 1, 2027 |
| Q3 | $2,552,000 | 52 | Apr 2, 2027 |
| Q4 | $3,712,000 | 75 | Jul 3, 2027 |
| FY | $11,600,000 | 235 |
Q1's pipeline had to exist by October 3, before the plan was even approved. A plan finished in December cannot create it. The Pipeline tab also splits each quarter's need by source (50% marketing, 25% SDR outbound, 15% AE self-sourced, 10% partners in the example), which becomes the marketing team's creation target.
Step 4, the P&L. 57 people at the start of the year and 60 by Q3, plus $2,480,000 of non-people spend, produce this result:
| FY2027 line (illustrative) | Plan | % of revenue | Benchmarkit 2025 median |
|---|---|---|---|
| Total revenue | $11,984,000 | 100% | |
| Gross profit | $9,926,320 | 82.8% | 77% gross margin |
| Sales and marketing | $5,889,900 | 49.1% | 37% |
| Research and development | $4,259,600 | 35.5% | 34% |
| General and administrative | $1,921,000 | 16.0% | 24% |
| Operating income | -$2,144,180 | -17.9% | |
| Rule of 40 (30% ARR growth + operating margin) | 12.1% |
Benchmarks are the medians in Benchmarkit's 2025 report, based on 2024 data, when its median company grew 26%. A plan for 30% growth that spends 49.1% of revenue on sales and marketing is a choice the board should see next to that 37% median, not discover in Q3. Expansion is 31% of new ARR in this plan, against Benchmarkit's 40% median, which is a fair question for the customer success team.
Step 5, the first quarter. In the example, Q1 closes with $520,000 of new-logo ARR against $580,000 planned (-$60,000), $340,000 of expansion against $325,000, and $310,000 of churn against $300,000. Ending ARR is $10,550,000, $55,000 behind plan. The plan columns stay as approved. The forecast for Q2 to Q4 is a separate number.
Top down vs bottom up: how to close the gap
The top-down number is what the board wants. The bottom-up number is what your sellers, after ramp and at a realistic attainment, can book. The gap between them is the planning decision, and the template shows it on Plan on a page so nobody can close it silently.
Pete Furseth, ORM's COO, is specific about how to close it:
- Plan average attainment, not hope. Pete thinks about quota as a normalized curve: "You want to determine what average attainment should be, maybe 75% to 80%," with a tail below and a tail above. Then: "You have to set productive capacity to your business goals."
- Add heads before you raise quotas. "If you don't want to crush your team and give them quotas that take the average down to 50%, then you need to add heads to make up the difference." He sees SaaS AE quotas between $500,000 and $1 million, and enterprise reps at $1 million plus, and his advice is to keep quotas relatively consistent and hire in markets that can support more heads.
- Ramp is longer than most plans assume. In ORM's data it can take a seller 15 to 18 months to confidently hit quota. ORM measures tenure in six levels of about three months each, by role and region, instead of one blended curve. That is why the template's ramp table has six quarterly levels.
- Check the market, not only the math. Pete's rule of thumb is at least three times a rep's quota in addressable market, since only about a third of the market is likely to buy in a given year. Ten new reps with nowhere to sell do not close a gap.
- Sometimes the number comes down. "Sometimes you have to call down your number or not sign up for a larger number with the board." Other options are a product that needs work before more sellers will help, or a price increase if the market will bear it.
The cost of skipping this step is measurable. Benchmarkit's 2025 data, published with Maxio, found B2B SaaS companies planned for 35% median growth in 2024 and achieved 26% (Maxio, 2025). A nine-point miss is what a plan built only top down looks like at year end.
Why four equal quarters break the plan
Splitting the year 25% a quarter makes Q1 look like an execution failure and Q4 look easy. In ORM's customer base, Q4 is usually the largest quarter, followed by Q2, then Q3, then Q1, and within a quarter the third month is always the largest and the first month the smallest. Pete's warning: without that seasonality in the model, "you will not be able to tell if you are ahead or behind."
The template applies one seasonality table to two places: the new-logo target and each AE's quota. That keeps the capacity check honest. A January hire spends its slowest ramp quarter in Q1, the smallest quarter of the year, and reaches 70% only in Q4, which is part of why one hire covers less of the gap than a simple quota calculation suggests. Use your own last two or three years. If you have under a year of history, use equal weights and replace them once you have data.
The annual operating plan formulas, in Excel and Google Sheets
Every formula uses functions both apps share. References are from the template, and the examples come from the worked example.
| Measure | Formula | Excel or Sheets | Example (illustrative) |
|---|---|---|---|
| Target ending ARR | Starting ARR x (1 + growth) | =B5*(1+B6) | $10,000,000 x 1.30 = $13,000,000 |
| Churn and contraction | Starting ARR x (1 - GRR) | =B5*(1-Assumptions!B8) | $10,000,000 x 12% = $1,200,000 |
| Expansion | Starting ARR x (NRR - GRR) | =B5*(Assumptions!B9-Assumptions!B8) | $10,000,000 x 13% = $1,300,000 |
| New-logo ARR needed | Target - start + churn - expansion | =B7-B5+B8-B9 | $13.0M - $10.0M + $1.2M - $1.3M = $2,900,000 |
| New-logo ARR in a quarter | Year's new logo x that quarter's seasonality | =$B$10*Assumptions!$B$24 | $2,900,000 x 32% = $928,000 in Q4 |
| Subscription revenue | (Starting ARR + ending ARR) / 2 / 4 | =(B13+B17)/2/4 | ($10,000,000 + $10,605,000) / 8 = $2,575,625 |
| Ramp factor | Ramp table at the rep's tenure level, capped at 6 | =INDEX(Assumptions!$B$28:$B$33,MIN(6,$C5+F$3-$D5+1)) | Tenure 3 quarters, Q1: level 4 = 70% |
| Expected ARR per AE | Quota x seasonality x attainment x ramp | =$E5*INDEX(Assumptions!$B$21:$B$24,J$3)*Assumptions!$B$11*F5 | $600,000 x 20% x 75% x 70% = $63,000 |
| Q1 hires to close the gap | Gap / (ramped year x year-one output of a Q1 hire), rounded up | =ROUNDUP(MAX(0,-N38)/(B41*B43),0) | $252,650 / ($450,000 x 0.432) = 1.3, so 2 |
| Pipeline needed | New-logo target / dollar win rate | =B5/B6 | $580,000 / 25% = $2,320,000 |
| Pipeline must exist by | Quarter start - sales cycle days | =B11-Assumptions!$B$14 | Jan 1, 2027 - 90 days = Oct 3, 2026 |
| People cost per quarter | Count x (base x (1 + load) + variable) / 4 | =$C5*($E5*(1+Assumptions!$B$18)+$F5)/4 | 14 x ($160,000 x 1.22) / 4 = $683,200 |
The blank file returns zeros, not errors, until you add inputs. Both files were evaluated formula by formula and matched an independent model of the same plan.
How this template connects to ORM's other planning tools
The operating plan is the company view for one year. Other ORM templates go deeper on one part of it or look further out, and the numbers should move between them, not be typed twice. The FP&A team usually owns the file that ties them together.
| Tool | Scope | How it connects to the operating plan |
|---|---|---|
| Sales plan template | One year, sales only: segments, territories, quotas, actions | The sales team's detail. Its targets and roster feed the Targets and Capacity tabs here; this file adds the rest of the company, the budget and the P&L. |
| Sales budget guide and template | One year of bookings, revenue and sales team cost | Its bookings, rep capacity and sales expense lines feed the Targets, Capacity and S&M rows here. |
| Headcount planning template | Two years of hires by team and quarter, with ramp, attrition and loaded cost | Builds the people lines. Its cost by department becomes the Headcount tab here. |
| Sales capacity planner | How many reps a target needs, with ramp | A fast way to test the Capacity tab before you list every seller. |
| Financial forecast template | 36 months: ARR, P&L, headcount and cash in Low, Base and High cases | The operating plan is the locked first year. The forecast keeps moving and shows the range around it. |
| Cash flow forecast template | 24 months of cash from billings, collections and payroll | Operating income is not cash. Annual upfront billing and commission timing change when the money arrives, so runway comes from the cash forecast. |
| Profit and loss template | Monthly and annual P&L with subscription and services margin | Tracks the actual income statement month by month once the year starts, in the same line structure as the P&L tab here. |
What Pete Furseth checks before a plan goes to the board
- One number, everywhere. "If you show one number on one slide, that number better show up on the next, or there should be a clear explanation for why it changed." Plan on a page reads from the same cells as every other tab for that reason.
- Traceable to the detail. Pete wants to be able to drill from the total to how each number came together. Every target in the template traces to an assumption, a seller or a headcount row.
- A range around the commitment. The plan is one number, but Pete wants the board to see a low case, an on-target case and an upper bound too. The financial forecast template runs those three around the same spending plan.
- Assumptions written down. Pete says assumptions "should be documented clearly from year to year with notation on why you changed them," starting with ramp rates by position and region. That is the Notes column on Assumptions.
- Close enough, then execute. In Pete's view, once the assumptions are about 80% right and the operating plan is sound, results depend on execution: sellers selling, managers coaching, marketing creating demand. Do not spend February perfecting the file.
Common annual operating plan mistakes
- Growth target with no ARR bridge. A 30% target means one new-logo number at 88% GRR and another at 80%. Without churn and expansion on the page, sales gets the wrong number.
- Counting assigned quota as capacity. Eight AEs at $600,000 of quota is $4,800,000 on paper. After ramp and 75% attainment, the example team books $2,647,350.
- Pipeline the calendar has already missed. A 90-day cycle means Q1 pipeline exists by early October or it does not exist. Pete notes that pipeline for future quarters is often built 6 to 12 months before the quarter begins.
- Revenue equal to ending ARR. ARR added in Q4 earns only a few weeks of revenue in the year. The example ends at $13,000,000 of ARR but recognizes $11,384,000 of subscription revenue.
- Budget built separately from targets. Marketing's budget should match the pipeline it is asked to create, and the AE hires on Capacity should be the same people on Headcount.
- Re-basing the plan to match the forecast. If the plan moves every time the forecast moves, the board loses the ability to see whether the year is on track. Re-plan only when an assumption underneath breaks, and keep the original next to the new one.
ORM's take: plan the year, then forecast against it
An operating plan is a set of bets: these sellers, at this ramp, with this pipeline, by these dates. A spreadsheet is a good place to make the bets explicit. It is a poor place to find out in week six that deals are slipping, because the file only knows what you typed into it.
Pete separates the two jobs. Planning puts the right people in the right seats with the right incentives, and it is both a top-down and a bottom-up exercise. Prediction is about execution: what is in the pipe, what will show up this quarter and what will close. ORM does both. It builds capacity and ramp from each rep's own history by role and region, then forecasts new, expansion and renewal revenue against the plan, so the gap shows up while there is still time to act. ORM targets 95% forecast accuracy on the forecasts it builds.
Common questions
What are the 7 things an operational plan should contain?
Seven parts cover most plans: targets for the year by quarter, the assumptions behind them, the people and capacity that will deliver them, the pipeline or demand they need, the budget by department, the initiatives with owners and milestones, and how progress will be measured against plan. For a SaaS company the targets are ARR, new-logo and expansion bookings, retention and revenue, and capacity means quota-carrying reps after ramp.
What is an annual operational plan?
An annual operational plan, usually called an annual operating plan or AOP, is the company's committed plan for the next fiscal year. It sets the targets, the headcount and the budget, phases them by quarter and gives each part an owner. The board approves it before the year starts. After that it stays fixed, so it can serve as the baseline for plan vs actual reporting all year.
Can you provide an example of an annual plan?
The example file on this page is one. An illustrative SaaS company with $10,000,000 of starting ARR plans to reach $13,000,000 in FY2027. At 88% GRR and 101% NRR it needs $2,900,000 of new-logo ARR, phased 20%, 26%, 22% and 32% by quarter. Its sales team can be expected to book $2,647,350 of that, so the plan shows a $252,650 gap before the year starts.
What is the standard format for an operational plan?
There is no single required format, but most operating plans follow the same order: a plan on a page, the targets, the assumptions, the resources (headcount and budget), the initiatives with owners and dates, and the measures used to track progress. Financial plans usually live in a spreadsheet with one tab per part. The board version condenses it to a few slides that tie back to that spreadsheet.
How do you write an operating plan?
Start from the target and work down. Set the growth goal, split it into new-logo ARR, expansion and churn, and phase it by quarter. Then check it bottom up: the reps you will have after ramp, the pipeline that must exist a sales cycle earlier, and the people and spend behind it. Close any gap openly, give each initiative an owner, and lock the approved version.
What is the difference between an annual operating plan and a budget?
The budget is one part of the operating plan: what the company will spend, by department and quarter. The operating plan also holds the targets that spending is meant to produce, the headcount and capacity behind them, the initiatives and their owners. A budget without targets cannot show whether the spend is enough, and targets without a budget cannot show whether they are affordable.
See whether this year's plan is still on track
The template sets the plan. ORM forecasts against it every week, by segment, from your own CRM history.
Schedule a Demo