Cash flow forecasting: the 13-week model every owner should run

If you’re like most owners, you can tell me last month’s profit without looking. But if I ask, “How much cash will be in the bank six Fridays from now?” you’d have to guess. That gap is where avoidable panic lives: surprise tax bills, payroll stress, delayed vendor payments, and rushed financing.

The fix isn’t a 60-tab spreadsheet or a once-a-year budget. It’s a simple weekly rhythm: a rolling 13-week cash flow forecast that you update every week in 15–20 minutes. Once you run it for a month, you stop managing your business by vibes and start managing it by cash runway.

Why your P&L can look great while your cash feels tight

Profit and cash are related, but they’re not the same thing. Your P&L is built on accounting timing (when revenue is earned and expenses are incurred). Your bank account is built on reality (when money actually moves).

• Accounts receivable (AR): You book revenue today, but cash may arrive in 14, 30, or 60 days.
• Accounts payable (AP): You record an expense this month, but you might pay it next month (or next week).
• One-time hits: Annual insurance, equipment deposits, tax payments, or a large refund can swing cash without “changing” profitability.

That’s why cash flow forecasting small business owners do well is usually boring: it’s about getting the timing right, not predicting the future perfectly.

The 13-week model: what it is (and why 13 weeks is the sweet spot)

A 13-week cash forecast is a week-by-week view of:

• Starting cash (what’s in the bank on day 1)
• Cash in (collections from customers, other receipts)
• Cash out (payroll, rent, vendor payments, taxes, debt payments)
• Ending cash (starting cash + in − out)

Thirteen weeks is long enough to see problems before they hit, but short enough that the inputs are knowable. A quarterly horizon forces you to think about timing (payroll cycles, customer payment habits, quarterly taxes) without pretending you can forecast next year’s demand to the dollar.

It also creates a simple habit: every week you add a new Week 13, and the model always stays relevant.

Build it in 30 minutes: the exact layout I recommend

You can do this in a spreadsheet, inside your accounting stack, or in a tool like VezmoCashflow. The structure matters more than the software.

1) Create four sections

• Assumptions & notes (top): anything you might forget in two weeks.
• Cash in: list the sources, not every invoice line.
• Cash out: group expenses by how they behave.
• Totals: starting cash, net cash change, ending cash, and your minimum cash threshold.

2) Keep the “Cash in” section tied to AR aging

Most forecasts fail because owners guess collections. Don’t guess—start from your receivables and be conservative.

• Put your AR into buckets: Current, 1–30 days, 31–60, 61–90, 90+.
• Assign collection timing: For example, maybe you collect 80% of “current” within 2 weeks, 60% of 1–30 within 3–4 weeks, and only 30% of 31–60 within 5–8 weeks.
• Schedule the cash: Drop those expected collections into the weeks they will likely land.

Worked example: if you have 50,000 in current AR and your typical pattern is 80% collected within two weeks, you’d schedule 40,000 across Week 1 and Week 2 (say 20,000 each). The remaining 10,000 becomes a later-week assumption, not a promise.

3) Make “Cash out” brutally honest about timing

Owners often under-forecast outflows because they think in monthly totals. The 13-week model forces you to think in dates.

• Payroll: enter it every pay period, including taxes/benefits (don’t bury those as “later”).
• Rent & fixed bills: schedule on actual due weeks.
• Vendors: use AP due dates (or your real payment behavior), not invoice dates.
• Owner draws: treat them like payroll—if you don’t schedule them, you’ll still take them.
• Taxes: put quarterly estimates on the exact week they leave the account.

If your business runs payments through a client portal (for example, invoice links and reminders), make sure you account for processor settlement timing and any payout holds. Those small lags can matter when you’re tight.

How to read the forecast: runway, not perfection

Your goal isn’t a perfect prediction. Your goal is to spot the weeks where you’ll drop below a safe minimum cash balance—and decide what to do while you still have time.

Pick a minimum cash threshold

Set a floor that protects the business. A common rule of thumb is one payroll cycle plus two weeks of essential bills. If payroll is 18,000 every two weeks and essential fixed costs are 7,000 per month, a conservative threshold might be:

• 18,000 (payroll)
• + 3,500 (two weeks of fixed costs)
• = 21,500 minimum cash

This number is personal to your risk tolerance and business model, but you need one. Without it, every ending cash number “feels fine” until it isn’t.

Turn dips into decisions

When the forecast shows you falling under the threshold in Week 6, you have options that are cheap in Week 1 and expensive in Week 6:

• Pull cash in: tighten follow-ups on late invoices, offer a small discount for early payment, or ask for a deposit on new work.
• Push cash out: renegotiate vendor terms, split a large payment, or delay non-essential spend.
• Reduce burn: pause discretionary tools, overtime, or low-ROI campaigns for a month.
• Plan financing early: if you truly need it, start the process before you’re desperate.

This is what “cash runway” actually means: how many weeks you can operate before you hit your minimum cash threshold, assuming the plan holds.

The weekly cadence that makes it work (15–20 minutes)

The magic is the ritual. Put a recurring 20-minute block on your calendar every Monday or Friday.

1. Update starting cash from your bank balance.
2. Review AR: move expected collections based on what customers actually did this week.
3. Review AP: pull in upcoming payments and delete anything you already paid.
4. Add a new Week 13: rough is fine; it will get sharper as it gets closer.
5. Write 2–3 notes: what changed, what’s risky, and what you’ll do next.

If you use VezmoBooks to keep your books current and a client portal to keep invoices moving, your forecast update becomes faster because your inputs are cleaner and more timely.

Common mistakes (and how to avoid them)

• Mixing accrual and cash: keep it cash-only. The forecast is about bank movements.
• Forecasting revenue instead of collections: schedule cash when you expect to get paid, not when you send the invoice.
• Hiding categories: too much detail makes updates painful; too little detail makes the model useless. Aim for 8–15 lines of inflows/outflows total.
• Ignoring “lumpy” expenses: annual renewals, taxes, and big vendor payments should be visible months ahead.
• Not comparing forecast vs actual: each week, glance backward. If you consistently overestimate collections by 20%, fix the assumption.

Closing: calm beats clever

Owners don’t get into trouble because they can’t read a P&L. They get into trouble because cash problems show up late and loud. A rolling 13-week forecast makes those problems show up early and quietly—when you still have choices.

If you want a lighter way to maintain the model (without living in spreadsheets), VezmoCashflow is designed to keep your weekly forecast current using the same numbers you already run the business on. The goal is simple: fewer surprises, more control.