Your banker asks a simple question: "What does the next quarter look like for you?"
And you freeze. You know this month is fine. You think next month is fine. But a big job finishes in week six, a quarterly tax payment lands somewhere in there, and a customer who owes you a lot has been slow lately. You give a confident-sounding answer and hope it's true.
Driving home, you realize you're running a business worth hundreds of thousands, maybe millions, of dollars, and you can't see more than about two weeks ahead.
You don't have a profit problem. You have a visibility problem.
Most owners manage cash by looking at the bank balance. That's like driving by looking in the rearview mirror: it tells you exactly where you've been, and nothing about the curve ahead.
Your monthly P&L doesn't help much either. It arrives weeks after the month ends, and as we covered in Profitable but Broke, profit and cash aren't the same thing.
What you need is a simple, forward-looking view of cash: what's coming in, what's going out, and what your balance will be each week for the next three months. That's a 13-week cash flow forecast.
Why 13 weeks?
Thirteen weeks is one quarter. It's long enough to see trouble coming in time to do something about it: chase a slow payer, delay a purchase, call your banker, adjust a hiring plan. And it's short enough that your numbers can be reasonably accurate, because most of what happens in the next 13 weeks is already in motion: invoices you've sent, bills you owe, payroll you know, jobs on the schedule.
Weekly beats monthly because cash crises happen in weeks. A month can look fine on average and still contain the one Friday when payroll and a big supplier bill land together.
What goes in the forecast
The forecast is just a table: 13 columns, one for each week, and a handful of rows.
| Row | What it includes |
|---|---|
| Beginning cash | What's in the bank at the start of the week (week 1 = today's balance) |
| Cash in: customer collections | Payments you expect to receive that week, based on when customers actually pay |
| Cash in: deposits and new sales | Up-front deposits and cash sales you expect |
| Cash in: other | Loan draws, refunds, owner investment |
| Cash out: payroll | Wages, payroll taxes, benefits, on the actual pay dates |
| Cash out: rent and fixed costs | Rent, insurance, software, utilities |
| Cash out: suppliers and materials | Bills due that week |
| Cash out: loan and lease payments | The full payment, including principal |
| Cash out: taxes | Estimated taxes, sales tax, on their due dates |
| Cash out: owner draw | What you pay yourself |
| Net cash flow | Total cash in minus total cash out |
| Ending cash | Beginning cash plus net cash flow (this becomes next week's beginning cash) |
| Minimum cash line | The lowest balance you're comfortable with |
The free tool: build your forecast in one afternoon
Here's what the first few weeks look like for a sample business (the numbers are illustrations, not benchmarks):
| Week 1 | Week 2 | Week 3 | Week 4 | … Week 13 | |
|---|---|---|---|---|---|
| Beginning cash | $42,000 | $35,500 | $47,300 | $22,800 | … |
| Customer collections | $18,000 | $26,000 | $9,500 | $31,000 | … |
| Deposits and new sales | $3,000 | $0 | $4,000 | $2,500 | … |
| Payroll | ($21,000) | $0 | ($21,000) | $0 | … |
| Rent and fixed costs | ($6,500) | $0 | $0 | ($1,200) | … |
| Suppliers and materials | $0 | ($9,200) | ($6,000) | ($8,500) | … |
| Loan payments | $0 | ($5,000) | $0 | $0 | … |
| Taxes | $0 | $0 | ($11,000) | $0 | … |
| Ending cash | $35,500 | $47,300 | $22,800 | $46,600 | … |
| Minimum cash line | $25,000 | $25,000 | $25,000 | $25,000 | … |
See week 3? Payroll and a tax payment land in the same week as light collections, and the balance dips below the minimum line. On the bank balance alone, you'd find that out in week 3. On the forecast, you see it today, three weeks early, with time to act.
To build yours:
- Start with what you know for certain. Enter payroll on its actual dates, rent, loan payments, insurance and software. These are your fixed cash outflows.
- Add your bills. Pull your accounts payable list and enter each bill in the week you'll actually pay it.
- Forecast collections honestly. Pull your accounts receivable aging report. For each open invoice, enter it in the week the customer actually tends to pay, not the due date. If a customer always pays 15 days late, forecast 15 days late.
- Add expected new business. Use deposits and sales you're confident in. When in doubt, leave it out. A forecast that's slightly pessimistic will never hurt you.
- Add taxes and your own pay. These are the two items owners most often forget.
- Set your minimum cash line. Pick a balance you never want to drop below, often enough to cover at least one payroll and one month of fixed costs.
- Look for the dips. Any week where ending cash falls below your minimum line is a problem you can now solve early.
A spreadsheet is all you need. Your accounting software can export the receivables and payables lists that feed it.
The 30-minute weekly routine
A forecast built once and never updated is just a nice spreadsheet. The value comes from the weekly rhythm. Same time every week, Monday morning works well:
- Enter actual results for last week: what really came in and went out.
- Compare to the forecast. Where were you off? Why? (A slow payer, an unexpected bill, a job that slipped.)
- Roll forward. Drop the past week, add a new week 13, so you always see a full quarter ahead.
- Update collections from the current receivables report.
- Decide what to do about any dips: chase specific invoices, move a purchase, ask for a deposit, talk to your banker.
After a few weeks, your forecasts get noticeably more accurate, because you're learning how your customers and your business actually behave.
Make it a team habit, not an owner habit
Here's where most owners stall: they build the forecast, update it for a few weeks, then get busy and stop. The forecast dies because it depends on one person.
Hand the weekly update to your bookkeeper or office manager. Your job is the 15-minute review: look at the dips, make the calls only you can make, and ask good questions. That's the difference between a task you delegated and a decision you kept, covered in How to Delegate Decisions, Not Just Tasks.
Share it with your banker
When my first company was growing faster than its cash could keep up, the thing that saved us was meeting with our banker every week to walk through sales growth and receivables. He could see what was happening before it became a crisis, and that made him willing to help.
A 13-week forecast is the modern version of that habit. Bankers rarely say no to an owner who can show them exactly what the next quarter looks like and how they plan to handle the tight weeks. They often say no to an owner who calls in a panic.
Frequently asked questions
What is a 13-week cash flow forecast? A week-by-week projection of the cash coming into and going out of your business over the next quarter, showing your expected bank balance at the end of each week.
How is a cash flow forecast different from a budget? A budget sets targets for revenue and expenses, usually monthly and on a profit basis. A cash forecast predicts actual money in and out of the bank, week by week, so you can see shortfalls before they happen.
How accurate does it need to be? Accurate enough to spot the tight weeks. Start conservative, update weekly, and accuracy improves quickly as you compare forecasts to actual results.
Who should maintain the forecast? Ideally your bookkeeper or office manager updates it weekly, and the owner reviews it and makes the decisions it surfaces.
Back to the banker's question
Imagine that conversation again. "What does the next quarter look like?" This time you slide a single page across the desk. "Weeks one and two are strong. Week seven is tight because a big project finishes and our quarterly taxes are due the same week. Here's how we're handling it."
That answer changes how your banker sees you. More importantly, it changes how you sleep. The next time someone asks about the next quarter, you won't need to guess. You'll just turn the page.
Go further: build your forecast and banker scorecard with Greg
This guide gives you the forecast layout and the weekly routine. In The Great American Business Owner Workshop, you'll build your own 13-week cash view, choose the weekly numbers your banker, partner and team should see, and fold it into your 90-Day Owner Plan.
Not ready for the workshop? Take the 3-minute Owner Scorecard.
Previous guide: Profitable but Broke · Next guide: How to Write Operating Playbooks Your Team Will Actually Use
Related: How to Bulletproof Your Business · The Owner Bottleneck