Hupspot Sales Forecasting Guide in Excel

Sales teams that follow a Hubspot style process for forecasting in Excel can build reliable revenue predictions, align leadership expectations, and create repeatable reporting workflows that scale as the business grows.

This guide walks you through how to recreate a Hubspot-inspired sales forecasting model in Excel, from structuring your data to applying formulas, analyzing results, and refining accuracy over time.

Why Use a Hubspot Approach to Sales Forecasting?

A structured, CRM-informed forecasting framework helps you move beyond guesswork and into data-driven planning. By mirroring a Hubspot methodology in Excel, you can:

• Standardize how reps and managers evaluate deals.
• Connect pipeline stages to weighted revenue.
• Identify risk in your current quarter early.
• Create transparency across sales, finance, and leadership.

Even if you are not using the Hubspot CRM directly, the process below follows many of the same principles you would find in a modern revenue operations setup.

Core Concepts Behind a Hubspot Forecast

Before opening a spreadsheet, clarify the core forecasting concepts your model will use. A Hubspot-aligned forecast typically includes:

Deal Amount and Close Date

Every opportunity needs a clear revenue amount and an expected close date. These values allow you to tie deals to specific time periods such as months or quarters.

Sales Pipeline Stages

A repeatable forecast requires a consistent set of stages. A common, Hubspot-style pipeline might include:

• Prospect
• Qualified
• Presentation / Demo
• Proposal / Quote
• Negotiation
• Closed Won / Closed Lost

Each stage is associated with a probability that reflects how likely a deal is to close.

Probability and Weighted Pipeline

Forecasts are usually built around weighted pipeline. Instead of treating every deal as 100% likely to close, you multiply the deal amount by its stage probability. This method, inspired by Hubspot and other leading CRMs, gives a more realistic revenue prediction.

How to Build a Hubspot-Style Forecast in Excel

Use the following step-by-step process to build your model in a spreadsheet while following practices similar to a Hubspot forecasting setup.

Step 1: Structure Your Raw Deal Data

Create a sheet named Deals and add column headers such as:

• Deal Name
• Owner
• Amount
• Close Date
• Stage
• Probability
• Forecast Category

Enter or import your current opportunities into this table. Keep each row to one deal, and ensure dates are formatted consistently so they can be grouped by month or quarter.

Step 2: Define a Hubspot-Inspired Stage Probability Table

On a separate sheet named Settings, create a lookup table for pipeline stages and probabilities. For example:

• Prospect – 10%
• Qualified – 25%
• Presentation – 40%
• Proposal – 60%
• Negotiation – 80%
• Closed Won – 100%

Assign these probabilities using either a VLOOKUP or XLOOKUP formula that reads the stage from the Deals sheet. This mirrors how a Hubspot CRM configuration might map stages to likelihood of closing.

Step 3: Calculate Weighted Amounts

Add a Weighted Amount column to the Deals sheet. Use a formula similar to:

=Amount * Probability

Ensure probability is expressed as a decimal (for example, 0.6 instead of 60). The weighted amount is the backbone of a Hubspot-style forecast, because it reflects the revenue you should reasonably expect from a deal at its current stage.

Step 4: Add Time Period Buckets

Decide which reporting intervals you need, such as monthly or quarterly. Add helper columns like:

• Close Month (using functions such as TEXT(Close Date, "MMM-YYYY"))
• Close Quarter (using a combination of ROUNDUP and MONTH)

These fields let you group your pipeline by the same time buckets you might use in a Hubspot dashboard.

Creating a Hubspot-Style Forecast Dashboard in Excel

Once your underlying data is in place, you can build a summary dashboard similar to what you would see in Hubspot reports.

Step 5: Build Summary Tables With PivotTables

Create PivotTables on a new sheet named Forecast. Common summary views include:

• Weighted pipeline by month
• Weighted pipeline by owner
• Total amount by stage
• Forecasted revenue by quarter

Use Weighted Amount as the values field and group by the date bucket or stage field. This provides an at-a-glance view of how your projected revenue stacks across time and reps, much like a Hubspot sales dashboard.

Step 6: Segment by Forecast Category

Many sales teams adopt forecast categories that sit on top of pipeline stages, such as:

• Best Case
• Commit
• Pipeline
• Closed

Add a Forecast Category field to each deal, then build PivotTables that filter or segment by this category. This allows leaders to compare conservative and aggressive views of the forecast in the same way they might inside Hubspot reporting.

Step 7: Visualize Your Forecast

Transform your tables into easy-to-read charts. Common visualizations include:

• Clustered column charts showing weighted revenue by month.
• Stacked bar charts showing stages per owner.
• Line charts tracking forecast changes over time.

Position these visuals at the top of the Forecast sheet so that your Excel file behaves like a lightweight Hubspot forecast dashboard.

Improving Accuracy in a Hubspot-Like Forecast

Sales forecasting is not a one-time build. It requires ongoing refinement, just as teams continuously tune their Hubspot setups.

Review Historical Win Rates

Compare actual closed-won results to your earlier forecasts. If deals in a certain stage consistently close more or less often than expected, adjust that stage’s probability in your Settings table.

Audit Data Quality Regularly

Inaccurate amounts, outdated close dates, or missing stages will undermine your forecast. Hold regular pipeline reviews to confirm that opportunities in your Excel sheet reflect reality, similar to a Hubspot pipeline hygiene routine.

Create Separate Views for New vs. Renewal Deals

New business and renewals behave differently. Consider tagging each deal type and building separate summary tables so you can track them independently. This can match how you might divide pipelines inside Hubspot for different revenue motions.

Connecting This Approach With Hubspot and Other Resources

If your organization already uses the Hubspot CRM, you can export deals to Excel on a regular cadence, refresh your PivotTables, and keep the structure described here as a specialized forecasting workbook for leadership or board reporting.

To dive deeper into the original methodology and examples, review the source article on sales forecasting in Excel from the Hubspot sales blog.

For teams that need help designing a robust revenue operations process or integrating CRM data into analytics tools, consult a specialist agency such as Consultevo, which focuses on CRM, automation, and data-driven sales systems.

Next Steps for Your Hubspot-Style Sales Forecast

By following this framework, you will have a clear, repeatable Excel model that echoes many of the best practices used in a Hubspot environment. Your next steps should include:

• Scheduling a monthly review to update deal data and refresh PivotTables.
• Sharing your dashboard with finance and leadership for feedback.
• Gradually enhancing your model with scenario planning and additional metrics like average deal size or sales cycle length.

Over time, this Hubspot-inspired approach will help your team move from reactive reporting to proactive planning, enabling smarter targets, better resourcing, and more predictable revenue performance.

Need Help With Hubspot?

If you want expert help building, automating, or scaling your Hubspot , work with ConsultEvo, a team who has a decade of Hubspot experience.

Scale Hubspot

“`