The Cash Flow Forecast Every Owner Should Run (13 Weeks, 20 Minutes a Week)

There is a particular kind of Wednesday that every business owner recognises. Payroll runs Friday, the deposit you were counting on hasn't landed, and the next hour goes on deciding which supplier can be told "next week." What makes that Wednesday so galling is that it was never a surprise in the data — the invoices were already issued, the payroll date was on the calendar, the tax filing had a deadline printed on it. Nobody had put them side by side.

Putting them side by side is all a cash flow forecast does. Where the statement of cash flows explains a period that has finished, a cash flow forecast projects the bank balance forward one week at a time, so a tight patch in November becomes visible in September. Below: what belongs in the grid, why a quarter is the right length, six steps to assemble it from reports you already have, and four weeks of a worked example.

What Belongs in the Grid — and What Doesn't

The structure is deliberately plain. Weeks across the top, and down the side three blocks: money arriving, money leaving, and the balance that results. Every figure represents actual funds crossing your bank account on a particular date, which is what separates this document from everything else on your desk.

A budget it is not. Budgets are annual, organised by category, and written in accrual language — the month a cost is incurred. A forecast speaks only in cash and only in dates. An annual $6,000 insurance premium is a tidy $500 a month in the budget and a single $6,000 crater in week seven of the forecast. Both descriptions are honest; only the second one tells you whether wages clear.

Nor is it a sales projection. Sales are speculation about the future; collections are mostly settled history, because the bulk of the money arriving in the next four weeks has already been invoiced. That is why owners are so often surprised by how solid their first forecast turns out to be.

Why a Quarter Is the Right Length

Thirteen weeks has become the default horizon for small business cash planning, and it earns the position for two reasons.

It is wide enough to catch the lumps. Quarterly estimated taxes, sales tax remittances, insurance renewals, annual software and licence fees, the slow fortnight after a holiday — all of them fall inside a quarter, and all of them are precisely the payments that ambush a business, because they never appear in the familiar monthly rhythm.

It is also narrow enough to stay factual. Through the first six weeks you are mostly placing invoices that already exist and bills that have already arrived. You are timetabling, not forecasting. Stretch the grid to twelve months and it turns into a planning exercise; hold it at a quarter and it stays something you act on.

How far ahead should a small business forecast cash flow?

A quarter, rolled forward weekly, suits most businesses. When money is genuinely tight the sensible move is to narrow rather than widen: six weeks, with week one broken down day by day, so you know not merely whether you run short but on which morning. Seasonal trades — landscapers, tax preparers, businesses in tourist towns — should keep the 13-week grid and hang a rough monthly view of the two quarters behind it, so the quiet season is never news.

Six Steps to Assemble It

Step 1 — Open from a reconciled balance

Everything downstream inherits the accuracy of the first cell. Take the figure from your most recent bank reconciliation and adjust for anything cleared since. Resist the banking app's balance, which happily ignores cheques you have written but nobody has cashed. Where several accounts exist, forecast the operating account alone and keep the others in a footnote — money set aside for tax is not money available for wages.

Step 2 — Timetable collections from the aging report

This step carries the forecast, and it is the one people hurry. Open your receivables aging and drop each unpaid invoice into the week you genuinely expect the money — not the week the terms say. A customer who has taken 45 days on every invoice for two years belongs at 45 days, whatever the invoice states. Anything sitting in the 90-plus column goes in at zero until it lands; optimism there is how a forecast quietly starts misleading you.

Step 3 — Place the fixed outflows on their real dates

The straightforward part, and it should be exact rather than smoothed. Payroll on its genuine pay dates, rent on the first, loan instalments on their scheduled days, insurance, sales tax remittances, estimated taxes, and every subscription renewing inside the window. Then take your outstanding supplier bills and assign each to the week you intend to settle it — a choice, not a fact, and one of the very few levers entirely within your control.

Step 4 — Estimate what moves with the workload

Materials, subcontractors, fuel, card processing fees, freight. These rise and fall with activity, so derive them from a percentage of expected revenue or from the last quarter's actuals on your income statement. Round upward. A forecast that errs towards pessimism on spending remains useful; one that errs the other way sets a trap.

Step 5 — Include the cash that never reaches the P&L

Here is where a first attempt usually goes astray. Loan principal, equipment purchases, stock buys, owner draws, distributions — each empties the bank account without ever surfacing as an expense. Build the grid from the profit and loss alone and you will omit every one of them, leaving a projected balance that reads thousands of dollars too comfortable.

Step 6 — Roll it forward each week

Book twenty minutes on Monday morning. Overwrite last week's estimates with the real figures, add a fresh week 13 to the tail, and revise whatever you have learned — the customer who has promised Friday, the supplier who has moved you to net 15. Built once and shelved, it is a document. Rolled weekly, it becomes an instrument, and within a couple of months you will be calling your own bank balance with faintly eerie accuracy.

Four Weeks of a Working Forecast

Below are the opening four weeks for "Ridgeline Mechanical," a nine-person HVAC contractor. The owner keeps a $10,000 floor — the balance she has decided never to go beneath.

Week 3 is why the grid exists. A payroll run and the quarterly sales tax remittance collide inside the same seven days, just as collections thin out because two sizeable jobs were invoiced late. The balance drops to $3,470 — a long way beneath the $10,000 floor — and it is still below it at the end of week 4. The business is perfectly profitable. This is a scheduling clash, and it is legible three weeks ahead of time.

Three weeks of notice buys genuine choices: ring the two customers sitting in the 31–60 day column and ask to be paid by the 12th; push the $4,400 materials order in week 4 back a few days; or lean briefly on the credit line rather than incur the cost of paying wages late. Without the grid, the same owner meets week 3 on the Wednesday before payday, by which point only the expensive option is left.

Is a cash flow forecast the same as a cash flow statement?

They point in opposite directions. Your statement of cash flows is a formal, GAAP-defined account of a period that has closed, and it is what a lender or accountant will request. The forecast is an internal working sheet: no set format, built on estimates, rewritten weekly. Both belong in the business, but only the forecast can alter what you do on Thursday.

Two Habits That Keep It Alive

The difference between a forecast that gets used and one that fades away comes down to two routines.

The first is comparing forecast with actual. Each Monday, before touching anything, look at what you predicted for the week just gone against what really occurred. The exercise is not self-assessment — it is hunting for the assumption that is consistently wrong. Almost always it is customer payment timing, and once the grid reflects how your customers pay rather than how they were asked to, accuracy climbs sharply.

The second is keeping the books beneath it current. A forecast resting on a nine-week-old reconciliation and a stale aging report is worse than none at all, because it lends false confidence to real decisions. Think of the forecast as the reward for a disciplined monthly close, never a replacement for one.

It is worth adding a floor too, drawn as a line across the grid the way Ridgeline drew $10,000. Two payroll cycles is a common benchmark. The floor turns the forecast from a set of numbers you interpret into a rule you obey: any week that dips below the line gets a plan written against it before Monday ends.

The Takeaway

Of every financial model a small business might build, the cash flow forecast is the least clever and the most valuable. Thirteen columns, three blocks of rows, twenty minutes a week. No mathematics worth the name — the whole benefit comes from writing known amounts against the calendar dates they will actually move.

Build a rough one this week; it does not need to be elegant. Then roll it forward each Monday and watch the change: inside a month or two you stop reacting to the bank balance and start steering it, and the Wednesday-before-payroll scramble becomes something that used to happen here.

Frequently Asked Questions

What are the steps to build a cash flow forecast?

Six steps. Begin from a reconciled bank balance rather than the figure in your banking app. Schedule expected customer collections week by week using your receivables aging, dated by how each customer actually pays. Drop in the fixed outflows on their real dates — payroll, rent, loan payments, insurance, tax remittances. Estimate the variable spending that moves with workload. Add the cash items that never appear as expenses, such as loan principal, equipment, inventory, and owner draws. Then refresh the whole grid once a week.

Why is 13 weeks the usual forecasting horizon?

Thirteen weeks is a quarter, which is long enough for the irregular payments that catch owners out — estimated taxes, sales tax filings, insurance renewals, annual licence fees, a seasonal lull — to appear while there is still time to respond. It is also short enough that most of the numbers are real: the invoices are already issued and the bills already received, so you are scheduling known amounts rather than predicting unknown ones.

Is a cash flow forecast the same as a cash flow statement?

No. The statement of cash flows is a formal report on a period that has already ended, and it is what a bank or accountant will ask to see. The forecast is an internal working document that looks ahead, has no prescribed layout, and gets revised constantly. Only the forecast can change a decision, because it is the only one that speaks about weeks that have not happened yet.

How precise will my forecast actually be?

The coming week should be nearly exact, the following few weeks close, and the far end of the quarter approximate. That is a perfectly good result. Precision improves quickly if each week you compare what you projected against what happened and correct the single assumption that keeps missing — for most businesses that assumption is how quickly customers pay.

Do I need software, or will a spreadsheet do?

A spreadsheet handles the grid perfectly well. What determines whether the forecast is any good is the quality of what you feed it: a reconciled cash balance, a current receivables aging, a complete list of outstanding supplier bills with due dates, and your known fixed costs. Pull those from books that are properly kept and the weekly refresh takes about twenty minutes.

The forecast shows I run short in week seven. Now what?

Take the cheapest actions first. Phone the biggest overdue accounts and ask for payment, part payment if necessary. Move discretionary spending out of the tight week — equipment, owner draws, stock orders that can wait. Talk to important suppliers about a short extension in advance rather than simply paying late. Borrowing comes last. All four options are far more available to you seven weeks out than seven days out, which is the entire argument for keeping the forecast.

Related Articles

• How to Read a Cash Flow Statement (And Find Out Where Your Profit Went)
• The Accounts Receivable Aging Report: Your Weekly Five-Minute Cash Check
• How a Supplier Bill Should Move Through Your Books: The Accounts Payable Process
• How to Close Your Books Every Month: A Small Business Month-End Routine
• Financial Ratios for Small Business: 8 Numbers to Check Before Your Banker Does
• How to Reconcile a Bank Statement (Without Losing an Evening)
• Cash Basis or Accrual Basis? A Small Business Owner's Guide to Picking the Right Method
• Best Accounting Software for Small Business 2025