How to Build a 13-Week Cash Flow Forecast (With Template)

Why 13 Weeks? (Not 4, Not 52)

Before we build the thing, let's talk about why 13 weeks is the magic number.

A 4-week forecast is too short. By the time you spot a problem, it's already right on top of you. Four weeks only gives you reaction time, not planning time.

A 12-month forecast is too long. The further out you go, the less accurate your predictions become. A six-month projection is mostly fiction.

13 weeks is the sweet spot. Here's why:

1. 1. It's a quarter. You're looking at one full business quarter at a time. This aligns naturally with quarterly taxes and how most businesses think about time.
2. 2. It's actionable. If you see a cash gap in Week 7, you have six weeks to do something about it. That's enough time to accelerate a collection, delay a payment, or line up your credit line.
3. 3. It's accurate enough to trust. Your predictions for Week 2 will be very accurate. Week 13, reasonably accurate. You're not trying to hit exact numbers — you're trying to see the shape of what's coming.
4. 4. It's the industry standard. Banks, investors, and turnaround consultants all use 13-week cash flow models.

The Step-by-Step Build: Your First 13-Week Forecast

Let's build this thing. Grab a spreadsheet (Google Sheets works great), and follow along.

Step 1: Start with Your Current Cash Balance

This is your foundation. Open your bank account right now and write down the balance. If you have multiple accounts, add them together. That's your "Week 0" number — where you're starting from.

Step 2: List All Expected Cash IN

What money do you expect to come in over the next 13 weeks? This isn't revenue. This isn't what you've invoiced. This is when the cash will actually hit your bank account. That distinction matters.

• Customer Collections: What invoices are outstanding, and when will they actually pay? Be honest. If a customer always pays 45 days late, don't pretend they'll pay in 30.
• Deposits and Retainers: Do you collect deposits on new projects? When are those coming?
• Other Income: Insurance reimbursements, loan proceeds, equipment sale proceeds, tax refunds.

Step 3: List All Expected Cash OUT

Now the money going the other direction. Focus on when the cash actually leaves your account, not when the expense is "incurred."

• Payroll & Payroll Taxes: Regular payroll plus employer taxes
• Rent/Lease Payments: Building rent, equipment leases
• Materials & Supplies: For contractors: materials; for practices: supplies
• Subcontractors: When are their invoices due?
• Insurance: Monthly premiums, annual renewals
• Loan Payments: Equipment loans, SBA loans, vehicle loans
• Quarterly Estimated Taxes: The big ones people forget (April, June, September, January)
• Credit Card Payments: When does the bill get paid?
• Other Regular Expenses: Software, utilities, professional services

Step 4: Calculate Weekly and Running Balances

Now the math. For each week:

That ending balance for Week 1 becomes the beginning balance for Week 2. And so on. The running balance is what you're watching. When it goes negative, or dangerously low, you've identified a cash gap — and you've identified it with enough time to do something about it.

Step 5: Lay Out Your Template Structure

Here's what your spreadsheet layout looks like:

Real Examples: Seeing the Forecast in Action

Let me show you what this looks like in practice with two clients I've worked with.

The Contractor Who Avoided a $47,000 Problem

Mike runs a commercial construction company doing about $2.8 million in revenue. Good work, good reputation, and profitable on paper.

But when we built his first 13-week forecast, here's what we saw:

• Week 4: Big material purchase for an upcoming project: $62,000
• Weeks 5-6: Payroll, subs, normal expenses: another $45,000 out
• Week 7: Client payment on completed project: $89,000 in

See the problem? Between Week 4 and Week 7, Mike was going to burn through about $107,000 while only bringing in his normal small receivables (maybe $15,000). His ending balance in Week 6 was going to be negative $47,000.

Without the forecast, Mike would have paid everyone, then discovered he couldn't cover something. Scrambling, calling the bank for an emergency LOC increase, maybe delaying a sub payment.

With the forecast, he saw this five weeks in advance. Here's what he actually did:

1. 1. Called the client on the completed project and asked for payment by Week 5 instead of Week 7. They said yes (they just needed an email reminder).
2. 2. Negotiated Net 30 with the material supplier instead of COD, pushing the payment to Week 6.
3. 3. Drew $30K from his line of credit as a buffer, just in case.

By the time Week 6 arrived, he had plenty of cash. No scrambling. No stress. No damaged relationships with subs. That's a 13-week cash flow forecast doing its job.

The Dentist Who Stopped Being Surprised by Taxes

Sarah owns a successful dental practice doing $1.4 million annually. She's profitable. She's growing. And every quarter, she's blindsided by her estimated tax payments.

"I know they're coming," she told me. "I just... forget to plan for them."

When we built her 13-week forecast, we put the quarterly tax payment right there in Week 9: $38,000. Looking at her running balance, she could see that without planning, she'd have maybe $12,000 left after making that payment.

Once she could see it, she could plan for it:

• She started setting aside $10K per month into a separate account for taxes
• Her Week 9 balance would now be $42,000 (comfortable)
• She scheduled the payment in advance instead of scrambling on April 14th

The forecast also helped her with equipment decisions. A $65,000 digital scanner in Week 3 would create a cash crunch overlapping with taxes. Buying it in Week 11 (after the tax payment) kept her balance healthy. Same purchase. Different timing. No stress.

How to Actually Use This Thing

Building the forecast is Step 1. Using it is where the value comes from.

The Friday Afternoon Ritual

Every Friday afternoon, spend 15-20 minutes updating your forecast:

1. 1. Roll the week forward. Week 1 is now in the past. Delete it, add a new Week 13.
2. 2. Update with actuals. What actually happened? Replace estimates with real numbers.
3. 3. Revise projections. Did that collection not come in? Move it forward. New expense? Add it.
4. 4. Look at your running balance. Where are the low points? Where are the gaps?

This takes 15 minutes once you've done it a few times. The discipline of updating weekly keeps the forecast accurate. A forecast you trust is a forecast you act on.

Identify Cash Gaps Early

When you see your running balance dropping dangerously low, or going negative, you've found a gap. Now what?

• Option 1: Delay an expense. Can you push that equipment purchase to a later week? The forecast shows you exactly how much a delay would help.
• Option 2: Accelerate a collection. Who owes you money that week? Can you get paid faster? Offer a small discount for early payment?
• Option 3: Use your line of credit. This is what LOCs are for: smoothing out short-term cash fluctuations. If you can see the gap coming, you can draw proactively instead of desperately.
• Option 4: Adjust your plans. Maybe this isn't the right time for that hire, that project, that expansion. Better to know now than after you've committed.

Make Decisions Proactively

Beyond just avoiding crises, the forecast helps you make better decisions:

• Hiring: What does adding a $65K salary do to your cash flow over the next quarter?
• Equipment: When can you actually afford that new truck without stressing the business?
• Pricing: If you need to improve cash flow, what happens if you require deposits?
• Collections: Which clients are creating the biggest cash flow drag?

As I explain in our guide to why profitable businesses run out of cash, profit and cash are not the same thing. The 13-week forecast is how you manage cash specifically, separate from your P&L.

Common Mistakes (And How to Avoid Them)

After building hundreds of these with clients, I've seen the same mistakes over and over.

Mistake 1: Being Too Optimistic About Collections

This is the big one. You invoice someone $50,000 and expect payment in 30 days. But your actual average collection time is 45 days. And this particular customer historically pays in 60.

Optimism feels good when you're building the forecast. But it makes the forecast useless for planning.

Fix: Look at your actual AR aging. What do customers really do, not what your terms say they should do? Use real collection patterns. Keeping your books reconciled weekly makes this data readily available.

Mistake 2: Forgetting Quarterly Taxes

Quarterly estimated taxes are large, lumpy expenses that don't feel "real" until they're due. They're not in your regular AP. They're not on your credit card. They just... appear four times a year.

Fix: Put all four quarterly payment dates into your forecast template (hard-coded reminders). And ideally, set aside money monthly so the payments are funded well in advance. Our proactive tax planning guide covers this in detail.

Mistake 3: Not Updating Regularly

A forecast you built six weeks ago and haven't touched is worse than no forecast at all. It gives you false confidence. The world changes. Customers pay late. Expenses pop up. Projects get delayed. A stale forecast doesn't reflect reality.

Fix: The Friday ritual. 15 minutes a week. Make it a habit.

Mistake 4: Making It Too Complicated

Some people build forecasts with 50 line items, trying to predict every single transaction. That level of detail takes forever to maintain and creates a false sense of precision.

Fix: Group small stuff. You don't need a line for "office supplies" and another for "printer ink." You need a line for "operating expenses." The goal is seeing the big picture, not tracking pennies.

Software & Tools

No. You don't need special tools. Google Sheets or Excel works great.

There are cash flow forecasting tools out there (Float, Pulse, Dryrun, and others). Some integrate with your accounting software and pull in data automatically.

Frequently Asked Questions