Revenue Forecasting for Businesses Under $1M

Most small business owners know last month’s revenue. Very few know next month’s.

That gap costs money. You hire too slow. You buy too much inventory. You pull a salary the business cannot afford. Then a slow month hits and you scramble.

Revenue forecasting fixes that. Not the complex 40-tab spreadsheet version. The simple version — built for businesses under $1M.

Here is how to do it in under an hour.

---

Why Most Small Businesses Do Not Forecast

Three reasons:

1. They think it requires an accountant. It does not.
2. They tried once and the number was wrong. So they stopped. (The number will always be off. The point is direction, not perfection.)
3. They are too busy. 60 minutes per month is the actual time commitment.

A forecast does not need to be right. It needs to be useful. A useful forecast tells you whether you are likely to hit payroll, whether you can afford to hire, and whether a bad month is coming.

That is worth 60 minutes.

---

The 3 Numbers You Need Before You Start

Pull these from your accounting software (QuickBooks, Wave, or even a spreadsheet):

1. Average monthly revenue — last 6 months Add up the last 6 months of revenue. Divide by 6. That is your baseline.

Example: $47K + $52K + $39K + $61K + $55K + $44K = $298K ÷ 6 = $49,667/month average

2. Your biggest revenue source What percentage of last month’s revenue came from your top 3 clients or top product/service?

If 80% of your revenue comes from 2 clients, your forecast is mostly about those 2 clients.

3. Your pipeline number What revenue is confirmed, likely, or possible in the next 30–60 days?

• Signed contracts = confirmed
• Proposals out = likely (multiply by your close rate)
• Leads in conversation = possible (use 20% unless you have real data)

---

The 3-Model System

Do not build one forecast. Build three.

Model 1: Conservative Assume everything at 80% of average. Slow month. A client pauses. One deal falls through.

Model 2: Base Assume performance similar to your trailing 6-month average. No big wins. No disasters.

Model 3: Optimistic Assume everything at 120% of average. A big proposal closes. A repeat client reactivates.

Now you have a range instead of a guess.

Example using the $49,667 average from above:

• Conservative: $39,734
• Base: $49,667
• Optimistic: $59,600

That range tells you something important. Even in a bad month, you likely clear $39K. Even in a great month, you probably stay under $60K. Plan accordingly.

---

How to Build Your Monthly Forecast (Step by Step)

This takes 45–60 minutes at the start of each month.

Step 1: Pull Last Month’s Actuals (5 minutes)

Open your accounting software. Get total revenue for last month. Compare it to your forecast from last month (if you had one). Note the gap. That gap teaches you something.

Step 2: List All Confirmed Revenue (10 minutes)

Write down every dollar you know is coming in this month:

• Retainer clients with signed contracts
• Subscriptions or recurring revenue
• Projects already started that will invoice this month

This is your floor. You know this money is coming.

Step 3: Estimate Pipeline Revenue (15 minutes)

List every active proposal or deal in progress. For each one:

• Deal value
• Probability of closing this month (be honest — not wishful)
• Expected amount × probability = weighted value

Example:

Deal	Value	Probability	Weighted
Client A proposal	$8,000	70%	$5,600
Client B discovery	$5,000	30%	$1,500
Client C verbal yes	$12,000	85%	$10,200

Pipeline total: $17,300 weighted

Step 4: Add Historical Patterns (5 minutes)

Does your business have seasonal patterns? January slow? December dead? Summer spike?

Adjust your base model for the current month based on what you know from the same month last year.

Example: March historically runs 15% above average for your business. Multiply base by 1.15.

Step 5: Build Your Three Numbers (5 minutes)

Add confirmed revenue + weighted pipeline + seasonal adjustment. That is your base.

• Conservative = base × 0.80
• Base = confirmed + weighted pipeline + seasonal
• Optimistic = base × 1.20

Write all three numbers down. You now have your forecast.

Step 6: Compare to Fixed Costs (10 minutes)

Pull your monthly fixed costs:

• Rent/office
• Payroll
• Software subscriptions
• Loan payments
• Contractor minimums

Subtract fixed costs from your conservative forecast. If that number is positive, you are likely okay. If it is negative, you have a problem to solve before the month starts — not after.

---

The One Metric That Beats Everything Else

If you only track one thing, track this:

Monthly Recurring Revenue (MRR)

MRR is the revenue that comes in automatically — retainers, subscriptions, contracts. It requires no new sale.

The higher your MRR as a percentage of total revenue, the more predictable your business.

Under $1M, most service businesses aim for 40–60% MRR. That means even a slow month for new sales does not crater you.

If your MRR is under 20%, start there. Convert one-time project clients to retainers. Even a $500/month retainer for ongoing support adds $6,000 to your annual baseline.

---

How to Make Forecasting Faster Each Month

The first time you do this, it takes 90 minutes. By month 3, it takes 30 minutes.

Three shortcuts:

1. Build a simple template once. A Google Sheet with 6 columns: Month, Confirmed, Pipeline (weighted), Adjustment, Base Forecast, Conservative, Optimistic. Fill it in once a month.

2. Update your pipeline in real time. The hardest part of forecasting is remembering where every deal stands. Keep a running pipeline list — even a Google Doc works. Update it every time you get off a sales call.

3. Do your forecast on the same day each month. First Monday. Last Friday. Whatever works. When it becomes a habit, it takes 20 minutes.

---

The Forecast Review: 10 Minutes at Month End

At the end of each month, compare forecast to actual.

Three questions:

1. How far off was my conservative estimate?
2. What deals did I expect to close that did not? Why?
3. What came in that I did not see coming?

The answers improve your next forecast. After 3 months, your accuracy rate jumps. After 6 months, you can plan 90 days out with reasonable confidence.

---

Common Mistakes in Small Business Forecasting

Mistake 1: Using Optimistic as Your Plan

Optimistic is a ceiling, not a target. Build your actual budget on conservative. Hire on base. Celebrate when you hit optimistic.

Most small businesses plan on optimistic numbers and get crushed when base hits.

Mistake 2: Ignoring Timing

A $20,000 project that starts April 15 does not help your April cash flow if it does not invoice until May 1. Forecasting revenue and forecasting cash flow are different.

Track both. Know when money actually hits the bank, not just when work is done.

Mistake 3: Forgetting Seasonality

If you run a landscaping company and you build a March forecast based on November numbers, you will be wrong. Pull same-month data from prior years whenever possible.

Mistake 4: Over-Complicating It

A revenue forecast does not require financial modeling software. A Google Sheet and 45 minutes per month is enough. Start simple. Improve over time.

---

A Real Example: How a $420K/Year Consultant Used This System

A management consultant in Detroit ran her business for 3 years without forecasting. She described her cash flow as “always a surprise.”

She implemented this 3-model system in January. By March, she had 3 months of data.

What she found:

• Her conservative estimate averaged $4,200 below actual. Her conservative model was too pessimistic.
• Two clients who had verbal commitments did not close that month — twice. She learned to apply a 60% probability to verbal yeses, not 85%.
• Her March revenues always ran 22% above average. She had never noticed the pattern before.

By July, she had hired a part-time assistant — a decision she had delayed for 18 months because she “wasn’t sure” about revenue. The forecast gave her the confidence to act.

She crossed $500K annualized by September.

---

Where to Start This Week

You do not need perfect data to start. You need to start.

Do this today:

1. Open a Google Sheet.
2. Pull last 6 months of monthly revenue.
3. Calculate the average.
4. Multiply by 0.80, 1.00, and 1.20.
5. List your confirmed revenue for next month.

You now have the beginning of a forecast.

It will be imperfect. Do it anyway. The second month will be better. The third month will be better still.

The goal is not a perfect number. The goal is to stop being surprised.

---

One Last Thing

A forecast does not predict the future. It forces you to think about the future before it arrives.

That thinking — 45 minutes per month — is the difference between a business that reacts and a business that plans.

Plan the month before it starts. Adjust as it unfolds. Review when it ends.

Three steps. Every month. Under $1M, that habit alone can add 10–15% to your take-home by avoiding the decisions you make when you are surprised.