Free Guide: Getting started with Bottom-up Forecasting

What is bottom-up forecasting and how is it different from top-down forecasting?

Bottom-up forecasting builds the number from individual rep pipeline submissions, rolled up through managers and leadership into a unified model. Top-down starts with a revenue target and works backward to assign quotas. The difference matters because bottom-up gives you deal-level visibility and accountability — you can inspect why a number is what it is, not just accept it.

Do I need a dedicated forecasting tool or can I run this process in a spreadsheet?

You can start with a spreadsheet, but the guide specifically calls out automated data collection — call logging, email logging, deal signals like time in stage and close date changes — as critical to accuracy. A spreadsheet won't capture those signals automatically, which means reps are doing manual entry and your data quality will drift. A CRM with some automation layer is the practical minimum for this to work at scale.

Which parts of the data collection process should stay human-led versus automated?

Automate everything you can — call logs, email logs, deal signal tracking, and forecast snapshots. Keep humans in the loop for forecast call submissions, roll-up reviews, and meeting notes (the guide flags AI-generated notes as useful but worth checking for false entries). The goal is to reduce rep data entry burden while keeping manager judgment in the process where it actually matters.

What data and CRM hygiene do I need in place before this process will actually work?

At minimum, you need defined pipeline stages, a sales methodology applied to deals (the guide recommends starting with MEDDIC), and consistent opportunity fields that reps understand and can calculate themselves. If your stage definitions are fuzzy or reps are skipping fields, the roll-up in Step 4 will just aggregate bad data faster.

How do I know if my bottom-up forecast is actually accurate and not just a number reps are gaming?

The guide points to historical snapshots as the key quality check — if you're capturing weekly or monthly roll-up snapshots, you can compare forecast submissions against actual closes over time and spot patterns in rep sandbagging or over-calling. Deal signals like number of close date changes and opportunity age also give managers concrete data points to push back on during the weekly Thursday or Friday forecast meeting.

How often should I run the full roll-up, and when does the cadence actually need to change?

The guide lays out a four-layer cadence: weekly forecast meetings with reps, monthly roll-ups with leadership, quarterly business reviews with the full team, and an annual review. Start with monthly roll-ups if weekly feels like too much overhead, but move to weekly once your data collection is clean enough to make it worth the time. The cadence should tighten as your pipeline volume and deal complexity grow.