Cash Flow Forecast

You're running a solid business. Jobs are booked. Invoices are going out. But then you hit mid-month and realize you don't have enough cash to cover payroll - even though you know you're profitable on paper.

That gap between "profitable" and "can I pay my crew this Friday?" is exactly what a cash flow forecast solves.

A cash flow forecast isn't fancy. It's a simple map of money coming in and going out over the next few weeks or months. It shows you when you'll have cash and when you won't. And it gives you time to act before you're stuck.

Here's what you'll learn: how to build one in a spreadsheet, what numbers go where, when to use software instead, and how to spot trouble before it happens.

What Is a Cash Flow Forecast?

A cash flow forecast is a financial management tool used by finance and treasury professionals to estimate future cash inflows and outflows over a defined period. In plain terms, it's the process of predicting near-future cash flows, both money coming in and money going out, based on how your business is running right now and how it's run in the past.

That's different from your profit and loss statement (P&L), which shows revenue minus expenses on an accrual basis. You can be profitable on your P&L and still run out of cash. Why? Timing. If you invoice a roofing job today but don't get paid for 30 days, your P&L shows the revenue now - but your bank account doesn't see it for a month.

A business can look highly profitable on an accrual basis, but still run out of cash if major client payments trail payroll obligations by even a few weeks. A cash flow forecast fixes that. It tracks when money actually hits your account and when it actually leaves.

Here's why this matters for your business:

Avoid overdrafts. You see a cash crunch coming three weeks out and arrange a line of credit before you need it - instead of scrambling when payroll is due.

Make hiring decisions. You know whether you can afford to bring on a new technician or if you need to wait until next quarter.

Get loans. Banks want to see a cash flow forecast. It proves you understand your business and can service debt.

Most owners use a 13-week rolling forecast (updated weekly), a monthly forecast (for quarterly planning), or an annual forecast (for tax and loan applications). The 13-week version is the most useful for day-to-day operations because it's accurate enough to act on.

What Are the Key Components of a Cash Flow Forecast?

Every cash flow forecast has three parts: opening balance, inflows, outflows. The math is simple.

Opening Balance + Total Inflows − Total Outflows = Closing Balance

That closing balance becomes next period's opening balance, and you repeat.

Inflows: Where Cash Comes In

Here are the common categories:

For a pest control business with net-30 payment terms, you'd forecast this month's revenue as next month's inflow - not this month's. That's the accrual-to-cash conversion. Your invoice goes out today; the cash arrives 30 days later.

Outflows: Where Cash Goes Out

The biggest mistake: forgetting tax payments. You owe quarterly estimated taxes or sales tax, and if you don't forecast it, you'll be short when it's due.

How to Build a Cash Flow Forecast in 6 Steps

Step 1: Choose Your Forecast Period

13-week rolling forecast: Updated every week. You always see 13 weeks ahead. Best for active cash management and spotting problems early. Takes 30–45 minutes to set up and update weekly.

Monthly forecast: Covers 3–12 months. Good for quarterly planning and loan applications. Takes an hour or two to build.

Annual forecast: Full 12 months. Useful for tax planning and annual budgeting. Takes a few hours.

For most owners, start with a 13-week rolling forecast. It's accurate enough to act on and doesn't require guessing too far into the future.

Step 2: Set Your Opening Cash Balance

Look at your bank statement right now. What's your actual cash balance? That's your opening balance.

Write it down. That's where you start.

Step 3: Project Cash Inflows

List every source of cash coming in over the next period.

Example: HVAC service company

You do $45,000 a month in service calls and maintenance contracts. Most customers pay within 30 days of invoice. Some pay on the spot (about 20%). So:

• Week 1 inflows: $9,000 (cash jobs from this week + payments from invoices issued last month)
• Week 2 inflows: $9,000
• Week 3 inflows: $9,000
• Week 4 inflows: $9,000

Total monthly inflows: $36,000 (not $45,000, because you're still waiting on invoices issued this month).

If you have a line of credit or expect a loan draw, add that too.

Step 4: Project Cash Outflows

List every dollar going out.

Example: Same HVAC company

• Payroll (2 technicians + 1 office): $18,000
• Rent (shop + office): $6,500
• Supplier payments (parts, refrigerant, etc.): Varies
• Payroll taxes (quarterly, averaged monthly): $1,800
• Vehicle fuel and maintenance: $2,400
• Insurance: $1,200
• Utilities: $800
• Loan payment: Varies

Total monthly outflows: approximately $42,000

Step 5: Calculate Net Cash Flow and Closing Balance

Month 1:

• Opening balance: $50,000
• Inflows: $36,000
• Outflows: $42,000
• Net cash flow: $36,000 − $42,000 = −$6,000
• Closing balance: $50,000 − $6,000 = $44,000

You're fine. You have cash.

Month 2:

• Opening balance: $44,000
• Inflows: $36,000
• Outflows: $42,000
• Net cash flow: −$6,000
• Closing balance: $44,000 − $6,000 = $38,000

Still okay.

Month 3:

• Opening balance: $38,000
• Inflows: $36,000
• Outflows: $42,000
• Net cash flow: −$6,000
• Closing balance: $38,000 − $6,000 = $32,000

You're burning $6,000 a month. At this rate, you'll hit zero in about five months. That's a signal: either increase inflows (more jobs, faster collections) or cut outflows (renegotiate supplier terms, reduce overhead).

Step 6: Review Assumptions and Update Weekly

Your forecast is only as good as your assumptions. Every week, compare what you forecasted to what actually happened.

Did inflows come in as expected? Did a supplier payment hit earlier than planned? Did you hire someone mid-month?

Update the forecast. Shift things forward or backward. If your actual cash is more than 5% off your forecast, stop and ask why. Maybe your payment terms are shorter than you thought. Maybe a big customer is paying late. Maybe seasonal work is hitting differently this year.

The forecast gets better the more you use it.

Worked Example: 3-Month Forecast for a Services Business

Here's a real scenario: a roofing contractor doing about $50,000 a month in revenue.

January and February are tight. February is especially tight - closing balance drops to $42,000. That's still above the minimum buffer (roughly 4–8 weeks of operating expenses for this crew), so you're okay. But it's a warning.

Why the dip? February is slower for roofing (weather), so inflows drop. But outflows stay the same - payroll doesn't shrink. March picks up, and you recover.

If February's closing balance had dropped below that minimum buffer, you'd need to act: negotiate a payment plan with a supplier, arrange a short-term line of credit, or delay a non-urgent expense.

That's the whole point. The forecast gives you time to decide, not panic.

Manual Spreadsheet vs. Software: Which Should You Use?

You can build a forecast in Google Sheets or Excel for free. Or you can use dedicated forecasting software. Here's the trade-off: You can also explore LocalRestart.

Think about your time:

If you spend a couple of hours a week updating a spreadsheet, that adds up fast over a year. Dedicated software costs a modest monthly fee but largely runs itself once connected to your bank and accounting tools. For many owners, the time saved pays for it.

But here's the catch: If your cash flow is simple - one bank account, straightforward inflows and outflows, no investors - a spreadsheet is fine. You'll spend a few hours building it once, then 30 minutes a week updating it. That's reasonable.

If you have multiple bank accounts, multiple revenue streams, or you're applying for a loan and the bank wants to see monthly updates, software is worth it. Tools like Float, Pulse, and Spotlight Reporting handle that automatically.

Decision rule:

• Simpler business, straightforward cash flow? Spreadsheet.
• Multiple accounts, multiple revenue streams, or investor reporting? Software.

How Accurate Is a Cash Flow Forecast and What Affects Reliability?

A 13-week forecast is usually pretty accurate if your assumptions are solid. A 12-month forecast? Much less reliable - too many unknowns creep in the further out you go.

Four things drive accuracy:

1. Quality of historical data. If you don't know your actual payment terms or how long collections take, your forecast will be off. Spend a week looking at your last ten invoices. How many days until you got paid? That's your Days Sales Outstanding (DSO). Use that number to sharpen your inflow assumptions.

2. Payment term consistency. If most customers pay net-30 but one big customer pays net-60, your forecast needs to account for that. If you're not sure, ask them.

3. Seasonality. Pest control is busier in spring and summer. Roofing is slower in winter. If you're forecasting February for a roofing company, don't assume January's revenue - look at last year's February. Most businesses face predictable peaks and valleys throughout the year, and failing to plan for them is one of the most common forecasting mistakes.

4. Economic volatility. A recession, a supply chain disruption, or a local economic shock can blow up your assumptions overnight. You can't predict that, but you can plan for it.

The variance rule: Track your forecast against actuals every week. If actual cash flows vary significantly from your forecast, revisit your assumptions. Something changed.

Scenario planning: Build three versions of your forecast.

• Base case: Your best guess. Most likely outcome.
• Downside: Revenue drops noticeably. Outflows stay the same. What happens?
• Upside: Revenue grows. Same outflows. What happens?

For the HVAC company above, a downside scenario might show the closing balance dropping below your minimum buffer by week eight. That tells you: if business slows, I need a backup plan - cut costs, draw on a line of credit, or both.

Free Cash Flow Forecast Template: What to Include

You don't need to download anything. Here's the structure you can replicate in Google Sheets or Excel right now:

Columns:

Week/Month | Opening Balance | Sales Receipts | Other Inflows | Total Inflows | Payroll | Rent/Lease | Suppliers | Taxes | Other Outflows | Total Outflows | Net Cash Flow | Closing Balance

Rows:

One row per week (or month). Start with this week and go 13 weeks out.

Color coding:

• Green: Closing balance above your minimum buffer.
• Yellow: Closing balance within 10% of your minimum buffer.
• Red: Closing balance below your minimum buffer.

At a glance, you see where the danger is.

Minimum cash buffer:

Aim to build a dedicated cash reserve that covers three to six months of core operational expenses. Pick a number that feels safe for your business. If you have a line of credit, you can go lower. If you're risk-averse or have lumpy revenue, go higher.

Once you've built the template, update it every Friday or Monday. Takes 20 minutes. You'll know your cash position for the next 13 weeks.

Frequently Asked Questions About Cash Flow Forecasting

How far ahead should a cash flow forecast go?

Direct Answer: 13 weeks for operational management, 12 months for annual planning and loans.

The 13-week horizon is the sweet spot. It's far enough out to spot problems and plan, but close enough that your assumptions are still reliable. Beyond 13 weeks, too many variables change. For loan applications or annual budgeting, go 12 months - but understand that the back half of the year is mostly educated guessing. Update those later months quarterly as you learn more.

What is the difference between a cash flow forecast and a cash flow statement?

Direct Answer: A cash flow statement is historical (what happened last month). A cash flow forecast is predictive (what will happen next month).

A cash flow statement is part of your formal financial statements. It shows actual cash movement in the past. A forecast is a planning tool. You use the statement to build the forecast - it shows you patterns - but they're different documents serving different purposes.

How much does cash flow forecasting software cost?

Direct Answer: Typically a modest monthly subscription, varying by features and the number of accounts or users you need.

Tools like Float, Pulse, and Spotlight Reporting each sit at different price points. Most offer a free trial, so test one before committing. For a small-to-mid-sized business, the annual cost is usually well within reach - and often pays for itself in time saved.

How often should you update a cash flow forecast?

Direct Answer: Weekly for a 13-week rolling forecast; monthly for a longer-term forecast.

Weekly updates keep your forecast sharp and catch surprises early. Businesses with irregular income - those relying on seasonal sales or large one-off contracts - generally need more frequent updates than those with stable, predictable revenue. If you're using a monthly forecast, update it at the end of each month. The more often you update, the more useful it becomes.

What is a 13-week cash flow forecast and when do you need one?

Direct Answer: A rolling 13-week forecast shows your cash position for the next three months, updated every week. You need one if you're managing tight cash flow, applying for a loan, or want to spot problems before they happen.

The 13-week format is the go-to for active cash management. Every week, you drop the oldest week and add a new future week, so you always have 13 weeks of visibility. It's accurate, actionable, and not too much work to maintain.

Can a cash flow forecast predict insolvency?

Direct Answer: Yes. If your forecast shows a closing balance that stays negative and you have no way to cover it, that's an insolvency warning.

A forecast projecting negative cash for multiple weeks without a financing solution - line of credit, loan, owner investment - is a serious red flag. It doesn't mean you're insolvent yet, but it means you need to act: cut costs, speed up collections, or arrange financing. The earlier you see it, the more options you have.

What are the biggest limitations of a cash flow forecast?

Direct Answer: It's only as good as your assumptions, and it can't predict unexpected shocks.

A forecast assumes your revenue, payment terms, and expenses stay reasonably consistent. If a major customer stops paying, a supplier raises prices sharply, or you face an emergency repair, the forecast is wrong. That's not a failure of the tool - it's a reminder to update weekly and build scenario plans so you're not blindsided when something unexpected hits.

Wrapping Up

A cash flow forecast is the difference between running your business and being run by it.

You don't need fancy software or an accountant to build one. A spreadsheet and 30 minutes gets you started. The real work is updating it weekly and acting on what it tells you.

Here's what happens when you do:

You see a cash crunch coming and arrange a line of credit before you need it. You know whether you can afford to hire that new technician. You walk into a bank meeting with a forecast that proves you understand your numbers. You sleep better on Friday knowing you can make payroll Monday.

That's worth the 20 minutes a week.

If you want to skip the spreadsheet work entirely, LocalRestart sets up a cash flow forecast for you - showing you what's coming in and going out over the next 13 weeks, updated weekly, so you always know where you stand. But whether you build it yourself or have someone else handle it, the point is the same: know your cash before it becomes a crisis.

Start this week. Pick your period (13 weeks), grab your last three months of bank statements and invoices, and build the template. By next Friday, you'll have a map of your cash for the next quarter.

That's all you need.