How to Forecast Sales

Trying to predict your future sales can feel like looking into a crystal ball. But a good sales forecast is less about guesswork and more about using the right data to make informed decisions for your business. This guide will walk you through manageable forecasting methods and the practical steps to build a reliable sales forecast, turning uncertainty into a strategic advantage.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Sales Forecasting Is More Than Just Guesswork

A sales forecast isn't just about knowing what revenue to expect. It’s a foundational document that helps drive strategic decisions across your entire company. When you have a solid idea of future sales, you can plan more effectively.

• Better Budgeting: Align your spending with anticipated revenue. Knowing what's likely coming in helps you decide what can go out for marketing campaigns, new software, or other expenses.
• Smarter Staffing: A forecast can signal when it’s time to hire more salespeople to handle incoming leads or customer support staff to manage new clients.
• Realistic Goal Setting: Set achievable quotas and targets for your sales team based on data, not just ambition. This keeps motivation high and prevents burnout.
• Inventory and Operations Planning: For e-commerce and retail businesses, a forecast is essential for managing stock levels - preventing both stockouts on popular items and overspending on slow-movers.
• Reduced Risk: Identify potential shortfalls ahead of time. If your forecast shows a slow quarter coming up, you have time to launch a new marketing initiative or sales promotion to close the gap.

A forecast turns raw sales data into a roadmap, helping you steer your business proactively instead of reacting to results after the fact.

Common Sales Forecasting Methods: Choose Your Approach

There are several ways to build a forecast, and the best one depends on your business model, sales cycle, and the data you have available. Here are a few of the most common methods, from simple to more complex.

1. Opportunity Stage Forecasting

This is a popular method for businesses with a defined sales pipeline, especially those using a CRM like Salesforce or HubSpot. It works by looking at the deals currently in your pipeline and assigning a close probability to each stage.

For example, your pipeline stages and their historical close rates might look like this:

• Lead/Initial Contact: 5% probability
• Discovery Call Completed: 20% probability
• Demo Scheduled: 50% probability
• Proposal Sent: 80% probability

To calculate your forecast, you multiply the potential value of the deals in each stage by the stage's close probability. If you have $50,000 in the "Demo Scheduled" stage (50% probability), you can forecast $25,000 from that group. Summing the forecasted value from all stages gives you your total opportunity forecast.

Best for: B2B companies or any business with a measurable multi-step sales process.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

2. Length of Sales Cycle Forecasting

This method focuses on when deals are likely to close. It uses your average sales cycle length to predict revenue. For example, if your average sales cycle — from first contact to a closed-win — is 90 days, you can look at the leads generated today and forecast that they will convert into revenue in approximately three months.

This approach requires you to accurately track how long deals take to close. It’s particularly useful for predicting cash flow and understanding how today’s marketing efforts will impact revenue next quarter.

Best for: Businesses with longer, consistent sales cycles where the time-to-close is a reliable metric.

3. Historical Forecasting

This is the most straightforward method. It assumes that your future sales will follow past patterns. If your sales grew by 20% last year, you might forecast another 20% growth for the coming year. You can also look at more specific timeframes, like an average from the last three months (a "moving average") to project the next month.

While simple, this method's accuracy depends on market stability. It doesn't account for major market shifts, new competitors, or the impact of a significant new marketing campaign you’re about to launch. It’s often best used as a baseline to be adjusted with other insights.

Best for: Established businesses with several years of consistent sales data and a relatively stable market.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

4. Lead-Driven Forecasting

This is a more sophisticated method that ties sales directly to marketing efforts. It involves looking at your marketing lead sources and applying historical conversion rates to predict sales revenue.

Here’s how it works:

1. You identify your main lead sources (e.g., Organic Search, Facebook Ads, Webinars).
2. You determine the average number of leads per month from each source.
3. You calculate the historical lead-to-customer conversion rate for each source.
4. You find the average revenue per customer (or average deal size).

The formula would be: (Leads per month x Conversion Rate x Average Revenue per Customer) = Monthly Forecasted Revenue. By doing this for each channel, you can build a detailed, bottoms-up forecast that shows which marketing channels are driving the most value.

Best for: Companies that are actively investing in different marketing channels and have the data to connect marketing activities to sales outcomes.

Your Step-by-Step Guide to Creating a Sales Forecast

Ready to build one? Here’s a basic framework to get you started, perfect for creating your first spreadsheet-based forecast.

Step 1: Gather Your Data

You can't forecast without data. Before you do anything else, identify where your key information lives and bring it together. You'll likely need data from multiple places:

• CRM Data (Salesforce, HubSpot): Deal stages, lead sources, close dates, and deal values.
• Sales Platform Data (Shopify, Stripe): Revenue, orders, average order value, customer lifetime value.
• Marketing Analytics (Google Analytics, Google/Facebook Ads): Website traffic, lead volume by channel, campaign performance.

The more organized and accurate your data is, the more reliable your forecast will be. Consistent data entry from your sales team is crucial here.

Step 2: Choose Your Method

Refer to the methods above. If you're just starting, Historical Forecasting is often the easiest entry point. If you have a CRM with clear pipeline stages, Opportunity Stage Forecasting is a great choice. You don’t have to stick to just one — many businesses use a historical baseline and then layer on a pipeline forecast to see how they compare.

Step 3: Build a Simple Model (The Spreadsheet Way)

Spreadsheets like Excel or Google Sheets are perfectly fine tools for building your first forecast. Let’s create a simple historical forecast as an example.

Create a sheet with your historical monthly sales data. Then, add columns for forecasting.

Example: A Simple Growth-Based Forecast

Let's say you want to calculate your 2024 forecast based on 15% growth over 2023.

Your table might look like this:

The formula in your "2024 Forecast" column would be simple:

=[2023 Sales] * [Growth Rate]

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Step 4: Analyze and Refine

A forecast is a living document, not a stone tablet. Once it's built, your job is to monitor it. Each month, compare your forecasted sales to your actual sales. This process, often called a "variance analysis," helps you see how accurate your assumptions were.

If your actuals are consistently higher than your forecast, maybe your growth assumption was too conservative. If they're lower, you might need to investigate what's causing the slowdown. Use these insights to adjust your forecast for the coming months.

Step 5: Account for Real-World Factors

No business operates in a vacuum. Once you have a data-driven baseline, layer in qualitative adjustments based on what you know is happening inside and outside your company.

• Seasonality: Does your e-commerce store see a massive spike during the holidays? Does your B2B service see a dip in August when people are on vacation? Adjust your monthly forecasts accordingly.
• Marketing Campaigns: Planning a big product launch in Q3? Allocate a higher sales target for that period.
• Market Trends: Are economic conditions affecting your customers' buying power? Is a new competitor entering the market? These external factors can impact your performance.
• Sales Team Changes: Are you hiring three new reps? Their ramp-up period and eventual contribution should be factored into the forecast.

Common Sales Forecasting Pitfalls to Avoid

As you build and refine your forecast, watch out for these common mistakes:

• Relying on "Garbage" Data: If your CRM is a mess of duplicate contacts and incomplete deals, your forecast will be inaccurate. Data cleanliness is the first step.
• Being Overly Optimistic: It's tempting to project huge growth, but a forecast should be based on realism. Don't let your "best-case scenario" be your only scenario.
• Forgetting About the Past: Neglecting historical data, especially seasonality, is a fast track to a wildly inaccurate forecast. The past is a powerful teacher.
• Using a "Set It and Forget It" Approach: The market changes, campaigns flop, and star salespeople leave. If you aren't reviewing and adjusting your forecast regularly (at least monthly), it will quickly become irrelevant.

Final Thoughts

Sales forecasting transforms data from a backward-looking report into a forward-looking tool for strategy. By choosing a method that fits your business, gathering clean data, and consistently refining your assumptions, you can build a reliable forecast that guides smarter decisions on everything from hiring to marketing spend.

We know that the hardest part of forecasting is often the busy work - manually pulling data from your CRM, Shopify, Google Analytics, and ad platforms, then wrangling it all in a spreadsheet. At Graphed, we created our platform to eliminate this exact frustration. We centralize all your marketing and sales data, so instead of spending hours building reports, you can get answers and create live dashboards in seconds just by asking questions in plain English. This gives you back the time to focus on what the numbers mean and how to act on them, not just how to find them.