If I could hand every owner exactly one report, it would not be a fancy dashboard or a 40-page budget. It would be a plain grid: thirteen columns, one per week, showing cash in, cash out, and the bank balance at the end of each week, a quarter into the future.
That is the 13-week cash flow forecast. Lenders ask for it, turnaround people live in it, and CFOs at companies of every size run on it. Not because it is sophisticated. Because it answers the only question that ends businesses: will there be enough cash, and when won’t there be?
Here is the whole thing, explained without accountant-speak.
Why your P&L cannot answer the cash question
Your P&L says you earned a profit. Your bank account says otherwise. Both are telling the truth, because the P&L ignores timing.
A P&L books revenue when you earn it, not when the customer pays, and it books expenses when they happen, not when the money leaves. Loan principal, owner draws, equipment purchases, and inventory stock-ups barely show up on a P&L at all, and every one of them takes real cash out the door.
Profit is an opinion about the year. Cash is a fact about Friday. The 13-week forecast is built entirely on Friday facts.
Why thirteen weeks
Thirteen weeks is one quarter, and it hits the useful middle:
- Short enough to be honest. You can name most of what happens in the next 90 days: invoices already out, payroll dates, rent, the loan payment, the tax deadline. Beyond a quarter you are guessing and calling it planning.
- Long enough to act. A crunch you spot in week 9 is a problem you solve calmly: chase receivables, slow a payment, arrange the line of credit. The same crunch discovered on a Tuesday is a crisis.
- Weekly, because months lie. A month can look fine in total while week two inside it goes negative. Payroll does not wait for month-end averages.
How to build one
A spreadsheet is genuinely enough. Rows for each cash item, thirteen columns, one ending-balance row. The tool was never the hard part.
Reading it like a pro
The grid produces three numbers worth staring at:
The low point. The lowest ending balance across all 13 weeks. If it is comfortably positive, breathe. If it dips near zero in week 8, you just bought yourself eight weeks to fix a problem you did not know you had.
The trend. Compare week 13 to today. Structurally rising cash means the business fuels itself. Structurally falling cash means something needs to change, and the forecast usually shows you which line is doing the damage.
The gap between forecast and reality. After a month of weekly updates, you learn things no report ever told you: collections consistently land a week late, that one customer is always the reason, the “monthly” software spend is somehow weekly. Each gap is a fix with a name on it.
This is also the report that changes financing conversations. Walk into a bank with a maintained 13-week forecast and you are showing them the exact discipline they are trying to underwrite. It is a core piece of the package that gets a yes.
Where owners get stuck
Three honest warnings from building a lot of these:
- Optimism is the main defect. Every owner books receivables a week early and expenses a week late on the first draft. Use behavior, not hope. When unsure, push cash in later and cash out earlier.
- Messy books make it harder than it needs to be. If the bank feed is months behind or draws are tangled through everything, the inputs are mush. Books first, forecast second.
- The first version is wrong, and that is fine. It only becomes accurate through weekly updates. A forecast built once and abandoned is a spreadsheet, not a system.
A forward-looking 13-week cash view is also one of the deliverables inside the CFO Diagnostic, where it comes with the senior read of what your version is trying to tell you, and it is a big part of what owners walk away with.
Build the grid this weekend. Thirteen columns, Friday facts, one low point. You will know more about your business by Sunday night than the last three P&Ls told you combined.
