Why sales projections need more than Excel spreadsheets

TL;DR: A spreadsheet projection is out of date as soon as the next deal moves, and testing a new scenario means rebuilding the model. Sales projections hold up when they run on live deal, engagement and renewal data, with scenarios that update in minutes and new business, expansion and renewal rolled into one number finance can stand behind.

Finance and revenue leaders own the number the board plans around, and for many teams that number still lives in a spreadsheet built on CRM downloads, a renewal list from customer success and a set of assumptions only one person fully understands. The spreadsheet holds up until someone asks a question it was not built to answer, like what happens if two large deals slip a quarter, or how much of next year depends on renewals.

A projection nobody can trace or update quickly turns every board conversation into a defense of the model. You will see what a good sales projection includes, where Excel projections break as the business grows, and what changes when projections run on live revenue data.

What is a sales projection?

A sales projection is an estimate of future revenue built from current pipeline, historical conversion rates and stated assumptions, used to plan hiring, spend and targets. It usually looks a year or more ahead and runs under several scenarios.

A projection and a forecast answer different questions. A sales forecast calls how the current period will land based on the deals in play. A projection asks where revenue could go under a given set of assumptions, such as a higher win rate, a new hiring plan or a change in renewal rates, so it can explore several possible outcomes at once. 

Building both on the same pipeline and renewal data means any gap between them comes from a changed assumption, which is exactly what finance wants to discuss.

What does a good sales projection include?

Whether it lives in a spreadsheet or a platform, a projection holds up when it has these seven inputs.

1. A starting point: Current annual recurring revenue or the bookings run rate. Every other input adds to or subtracts from this number, so confirm it matches what finance reports before building on it.
2. Pipeline by stage: Open deals by stage, weighted by historical conversion rates for each stage. Use rates from the last four to six quarters, so one unusual quarter does not distort the weighting.
3. Sales cycle length by segment: How long deals take to close, so the projection places revenue in the right quarter. An enterprise deal created today may not land for two quarters, while a small-business deal can close within the month.
4. The expansion and renewal base: Renewals coming due, historical retention and expansion rates by segment. For subscription businesses this line can outweigh new business, so it deserves the same rigor as new pipeline.
5. Capacity: Ramped reps, ramp time for new hires and quota per rep. A plan that counts ten new hires at full quota in their first quarter overstates revenue if those reps need two quarters to ramp.
6. An assumptions log: Every assumption, who set it and when it last changed. When the board asks why the number moved, the log answers in minutes instead of a week of reconstruction.
7. Scenarios: At least a base case, an upside case and a downside case. Each one should change a named input, such as win rate or renewal rate, so the gap between scenarios explains itself.

Each input answers a question the board will eventually ask, so a projection that includes all seven can explain its number as well as produce it.

Why do finance teams still build projections in Excel?

Excel has earned its place in finance teams, and any honest case for moving projections elsewhere starts with what it does well:

• Flexibility: Finance can model any structure, from a simple run-rate projection to a multi-entity plan, without waiting on a vendor's template.
• Control: The finance team owns the model end to end and decides who can edit each tab.
• Auditability: Every formula is visible, so a reviewer can trace a number back to its inputs cell by cell.
• Familiarity: Board members, auditors and lenders can all open the file and follow it without training.
• Connection to the rest of the plan: Projections feed straight into the budget, headcount and cash models that already live in spreadsheets.
• Low cost to start: There is nothing new to buy, and built-in functions handle simple trend projections.

For a young company with one product, a small team and a single revenue stream, that combination is often enough, and a well-built spreadsheet covers what an early-stage team needs before it is ready for dedicated sales forecasting software. 

The trouble starts as the business adds reps, segments, products and renewal revenue. Each addition means another export to paste in, another tab to link and another person editing the file, until the spreadsheet is carrying more than it was designed for.

Where do Excel sales projections break?

Spreadsheet projections tend to break in five predictable places, and each one gets worse as the business grows.

The data is out of date the moment you export it

A projection built from Monday's CRM export misses every deal that moved on Tuesday. Teams refresh weekly or monthly, so the model always describes a pipeline that no longer exists, and the people closest to the deals stop trusting it. The same staleness problem drives most of the cost of spreadsheet forecasting.

One broken formula can move the whole number

Spreadsheets mix data, logic and presentation in one file, so a single bad cell reference or pasted range can change the total without anyone noticing. A familiar version: this week's export has more rows than last week's, the SUM range still stops at the old last row, and the newest deals never reach the projection. 

Nothing looks broken, the number is simply lower than it should be, and it goes to the board that way. Sales projections carry that exposure every time someone pastes in a new export.

Version control turns into an email thread

Finance has one version, sales leadership has another, and the board deck has a third. Reconciling them takes a meeting, and nobody can say with certainty which assumptions changed between the version reviewed last month and the one presented today.

Corpay saw the same pattern before it consolidated on one platform: some sellers tracked activity in Excel, some in email and some in notes, and leaders could not make data-driven decisions from any of it.

Every new scenario means rebuilding the model

Asking what happens if win rates drop five points, or if two large deals slip a quarter, should take minutes. In a spreadsheet, each scenario means copying tabs, re-linking formulas and checking that nothing broke, so teams run fewer scenarios than they should.

Expansion and renewal live in a different file

New-logo pipeline usually sits in the CRM export, while renewals and expansion live in a customer success tracker or a finance system. Stitching them together by hand makes it hard to see how much of next year depends on retention, which is often the biggest number in the projection.

What changes when projections run on live revenue data?

Moving a projection onto a platform keeps the discipline that makes a good spreadsheet useful, and fixes the five breaks above.

1. Inputs refresh from deal and engagement activity

Stages, close dates and deal values update as reps work the deal, and engagement signals show which opportunities have an active buyer behind them. When AI recommends CRM updates from calls and emails and reps approve them, the data feeding the projection stays current without a weekly export.

2. AI projections sit alongside the team's own call

An AI projection estimates where the period will land based on won business, remaining pipeline and deals likely to pull in. Leaders compare it with the rep and manager commit, and the gap between the two becomes the conversation in the forecast call.

3. Scenarios run without rebuilding the model

Changing a win rate or a deal amount shows the bear case, the most likely case and the bull case in one view. Finance can answer the board's "what if" in the meeting, instead of promising a revised spreadsheet next week.

For example, a team with $40 million in weighted pipeline and a 25 percent win rate projects $10 million in bookings. Drop the win rate five points and the projection falls to $8 million, and the platform shows which segments and deals account for the difference, so the conversation moves straight to what to do about it.

4. New logo, expansion and renewal roll up in one view

When every revenue stream sits on the same data, the projection shows how much of the year depends on new business versus the existing base. That view supports retention and expansion planning as much as new-logo targets.

How do you move sales projections off spreadsheets?

Moving a sales projection off a spreadsheet usually takes one or two quarters, because the old and new versions need to run side by side until finance trusts the new number. 

The steps below cover that overlap, from agreeing on definitions before the first comparison to retiring the spreadsheet once the two numbers line up.

1. Agree on definitions first: Before any numbers move, finance and sales leadership sign off on stage definitions, what counts as committed, and how renewals and expansion are categorized. A platform projection built on definitions nobody agreed to gets argued over in the first review.
2. Run both in parallel for a quarter: Keep the spreadsheet and the platform projection side by side, and record where they differ. Review both in the same forecast meeting, so the team sees the differences while the deals behind them are still live.
3. Carry the assumptions log over: Every assumption in the spreadsheet should exist, with an owner, in the new process. Win rates, ramp time and renewal rates that sat in a hidden tab become visible inputs anyone can question.
4. Explain the variance: When the two numbers differ, trace the gap to a deal, an input or an assumption before trusting either one. Common causes are a stale export, a stage definition applied differently, or a manual override nobody documented.
5. Retire the spreadsheet once the variance is explained: Keep a frozen copy for audit, then make the platform the single source for the projection.

Finance will still build budgets, headcount plans and cash models in spreadsheets after the move. What changes is the revenue line feeding those models: it comes from the platform's projection, so it reflects the latest deal data instead of whatever export was pasted in last month.

How does Outreach support platform-based sales projections?

Outreach, the agentic AI platform for revenue teams, builds projections on the same engagement, conversation and deal data reps work in every day, so finance and revenue leaders plan from one source.

AI  projection and forecast rollup

AI Projection estimates where the period will finish based on business already won, the pipeline still open and the deals most likely to pull in from later quarters. That gives finance a number built from deal activity before anyone submits a call, and a check on how optimistic or cautious the team's own forecast is.

Forecast Rollup collects the calls reps, managers and leaders submit and rolls them up the hierarchy. With the AI projection and the rolled-up commit side by side, the gap between them sets the agenda for the forecast meeting: which deals explain the difference, and which assumptions need to change before the number goes to the board.

Scenario planner, parallel forecasting and multiple forecasting goals

Scenario Planner models the bear case, the most likely case and the bull case by adjusting inputs like win rate and deal amount. When the board asks what happens if two large deals slip or win rates drop a few points, finance can show the answer in the same meeting, with the deals behind each case visible.

Parallel Forecasting and Multiple Forecasting Goals let teams project new logo, expansion and individual product lines as separate numbers, then see them together. That separation shows how much of the year depends on keeping and growing existing customers, which a single blended spreadsheet total tends to hide.

Line item forecasting, multi-currency and opportunity splits

Line Item Forecasting projects revenue by product, so a quarter that looks healthy overall can still show one product line falling behind plan. Multi-Currency handles deals in different currencies for global teams, and Opportunity Splits credit shared deals correctly across owners. 

As the business adds products, regions and team structures, those details keep the projection accurate without new tabs or manual reconciliation.

Start with the projection the board questions most

Spreadsheets will stay useful for modeling; the inputs are what need to move. Start with the number most likely to be challenged at the next board meeting, often the renewal base or next quarter's expansion target, and rebuild it on live deal and engagement data.

Pick that number because it is where the spreadsheet struggles most. A renewal base built from a customer success list cannot show which accounts have gone quiet, and an expansion target built from last year's rates cannot show which customers are already in active buying conversations. 

Rebuilt on live data, the same number arrives with the accounts and deals behind it, along with the engagement signals that put it at risk.

Once finance can trace that one number back to the deals behind it, the case for moving the rest of the projection is easy to make. Add the next line the board questions, run each one alongside the spreadsheet until the variance is explained, and within a few quarters the projection that goes to the board is built on the same data the whole revenue team works from.

Frequently asked questions about sales projections

How do you make sales projections in Excel?

Start from current recurring revenue or the bookings run rate, add open pipeline by stage weighted by historical conversion rates, then layer in renewals and expansion. Keep assumptions on their own tab with an owner for each, and build base, upside and downside scenarios from the same inputs.

What is the difference between a sales projection and a sales forecast?

A sales forecast predicts how the current period will land from the deals in play. A sales projection models revenue further out under stated assumptions and scenarios, and it is used to plan hiring, spend and targets. Both should start from the same pipeline data.

How accurate should a sales projection be?

Track the variance between projection and actuals every quarter and trace each gap to a deal, an input or an assumption. Accuracy improves fastest when inputs refresh from live data, assumptions are documented, and the team picks forecasting methods that fit its sales cycle and deal volume.

How do you project expansion and renewal revenue?

Start with renewals coming due, then apply historical gross retention and expansion rates by segment. Adjust for account signals such as product usage, support activity and stakeholder engagement, since they show renewal risk earlier than the contract date does.

When should a team move projections off spreadsheets?

Consider it when several people update the model every week, when the projection covers more than one revenue stream, when it goes into board reporting, or when running a new scenario takes longer than the meeting where someone asks for it.