The Woodard Report

13-Week Cash Flow Forecast: A Practical Guide for Advisors

Written by Derek Goldstein | Jul 30, 2026, 4:35:45 PM

Most of your clients can tell you exactly how much cash is in the account right now. Almost none of them can tell you where it will be in six weeks. They are running businesses worth millions and forecasting their single most important metric entirely in their heads.

It almost seems crazy on paper, but it is surprisingly common. Equally common is its ability to bring an otherwise healthy business to its knees (and become the source of many emergency client calls). As an advisor, you can add real value by taking the guesswork out of it.

The root cause is that founders assume their recent burn will hold as long as they are not planning material changes to the business, which ignores how many events outside their control can derail the picture. A customer shifts payment terms from net 30 to net 60, an annual insurance premium comes due, a shipping lane gets expensive overnight, or a million other things. Without the proper tools in place, any one of them can send your client into a panic and land a very urgent email in your inbox.

The two gauges most clients are flying on

Ask a client how they track financial health, and you will usually hear two answers. The bank balance, which is a fuel gauge, and the P&L, which is a rearview mirror. Both matter, and neither tells you anything about what is coming. Every real cash problem lives in the space those two instruments do not cover, which is the road ahead. A short forecast is the windshield.

I watched the cost of a missing ‘windshield’ up close while I was working in VC during the 2023 collapse of Silicon Valley Bank, when a bank, run straight out of It's a Wonderful Life, froze thousands of startup accounts overnight. The freeze lasted only a few days, but it was a clean natural experiment in which companies had their house in order, and which were running on ‘vibes’. The ones who handled it best were not the biggest or the best funded. They already knew, to the dollar, how much cash needed to leave the building over the next two weeks. They knew their exposure because they were already looking.

The Silicon Valley Bank run was loud. The quiet version, where a surprise creeps up with no news alert attached and nobody looking for it, is more common and more dangerous, and it is the one you can help a client see coming.

A forecast is a flashlight, not a prediction

When you raise the idea of forecasting, expect pushback. Some founders hear forecasting and say, “I have a million things to do to grow my business, why would I spend my time on projections that I know are going to be wrong?” They are right about one thing; the forecast will be wrong. What they are missing is that a forecast is not meant to be a prediction; it is meant to be a flashlight. Its job is to illuminate a cash swing before it lands on the bank statement.

Take the client whose largest customer moves from net 30 to net 60. On its own, that is a sentence in an email. Dropped into a forecast, it becomes a visible dip on a specific week, and a decision to make while there is still time. Maybe the customer keeps net 30 in exchange for a small discount. Maybe the client has enough standing with a supplier to ask for terms on the payables side. Either way, they are choosing from a position of time rather than panic, because the forecast has handed them the one thing that lets them solve the problem, which is lead time.

How to build one that stays useful

Use a 13-week horizon, which is one quarter. Four weeks forward does not give a client enough runway to act on what they see. Fifty-two weeks forward is guessing dressed up as planning. Thirteen weeks is long enough to catch what matters and short enough to hold some real precision. The near-term weeks should be sharper than the further away ones. You will often know the exact day a customer pays in week two, while week eleven is a reasonable estimate, and that is fine.

The build is not the hard part. The discipline is. A forecast built once and left alone is worthless within a month; the value is in keeping it alive. Pick a standing day, sit down with the client’s actuals, reconcile what came in against what the forecast expected, and roll the whole thing forward one week. For most small businesses, this is 30 minutes, not a day of work.

Here is the part worth telling clients directly. Half the value is not the forecast. It is the 30 minutes spent looking at the business closely enough to update it.

Where AI takes the friction out

The reason most advisors never build one of these has nothing to do with the concept; it is the blank page. Structuring the model and remembering every line item is tedious, and tedious work gets skipped when the close gets busy.

This is what an AI assistant is built for. Describe the client in a couple of sentences, the industry and roughly how money moves through the business, and it will scaffold the full 13-week structure with line items tailored to that company, not a generic template. A landscaping business and a Shopify brand run on completely different cash calendars, the tool will reflect that if you ask it to.

Where it earns its keep is in remembering what everyone else forgets. Ask it for the recurring and periodic costs a business in that industry tends to overlook, and it will come back with the quarterly estimated tax payment, the annual insurance renewal, the software that bills once a year, and the payroll tax deposits that never make it into anyone’s mental model. Those are exactly the surprises a forecast exists to catch.

With the bones set, the tweaking can begin. Walk through the model with your client and make sure it reflects how their business actually runs; there is no one-size-fits-all forecast, and AI can only take it so far. The real value arrives once the model captures the true nature of the business, and getting it there is a conversation, not another prompt.

Why this belongs in your advisory offering

Compliance work looks backward by nature; you are closing a period that already happened. The forecast is the cleanest way to add something that looks forward, and forward-looking work is what clients recognize as advisory and are willing to pay for. You already hold the raw material, since you are closest to their numbers. Turning that into a recurring 30-minute review is a natural engagement that repositions you from the person who tells a client what happened, into the person who tells them what is about to happen.

The pattern I saw in venture has held everywhere since. The clients who end up short on time are the ones who saw a problem the day it arrived, not the day it became visible. A forecast does not make a client more cash. It makes them more time, and time is the one thing in business nobody can buy the moment they need it. Being the advisor who hands a client that time is a good place to be.