How to Build a Cash Flow Forecast That Keeps You Out of the Red
A profitable month on paper does not guarantee money in the bank. Here is a simple, repeatable way to see a cash crunch coming three months out, not three days out.
In 60 Seconds
- Profit and cash are different things. You can be profitable and still run short of cash.
- A rolling 13-week cash flow forecast shows problems months before they hit your bank account.
- Build one from four numbers each week: starting cash, expected cash in, expected cash out, ending cash.
- San Diego County triggers: seasonal slowdowns, three-paycheck months, slow-paying clients, and tax dates that land at the worst time.
- If the forecast shows a gap, you have time to act: a credit line, faster invoicing, or a trimmed owner draw.
Why “profitable” and “cash-rich” are not the same thing
Every fall I sit down with a business owner who is confused, and a little scared, by the same situation. Their profit and loss statement says they made $38,000 last quarter. Their bank balance says $4,100. Both numbers are correct. They are just telling different stories.
Take a San Marcos electrical contractor I worked with last year. Good quarter on paper, $38,000 in net income. But two commercial invoices worth $22,000 combined were sitting unpaid at 45 days, a $9,000 down payment went out for a new service truck, and a $7,000 quarterly estimated tax payment landed the same week as payroll. None of that hits profit. All of it hits cash.
Profit is an accounting measurement. Cash is what clears your checking account. A cash flow forecast lets you see both at once, before the gap between them becomes a real problem.
The tool: a rolling 13-week cash flow forecast
A 13-week forecast is a week-by-week look at cash in and cash out for the next quarter, updated every week so you are always looking about three months ahead. It answers the question owners actually lose sleep over: will I have enough cash to cover what is due?
Building yours in four steps
- Start with your actual bank balance today. The real number, checking and savings combined, not a rounded guess.
- List expected cash in, week by week. Invoices you expect to collect, new sales paid at time of service, any loan or credit line draws.
- List expected cash out, week by week. Payroll, rent, loan payments, vendor bills, insurance, tax payments, and owner draw.
- Subtract, and roll it forward. Cash in minus cash out gives you an ending balance, which becomes next week’s starting balance. Repeat for 13 weeks.
No special software required to start, a spreadsheet works fine. The value is in doing it every week so warning signs show up early instead of as an overdraft notice.
Two ways to build one
Not every business needs the full 13-week version right away. Here is how the two most common approaches compare.
| Method | Best for | Setup time | How far ahead you see trouble | Update frequency |
|---|---|---|---|---|
| Simple monthly forecast | Newer businesses with steady, predictable revenue | 30 to 60 minutes | About 4 to 6 weeks | Monthly |
| Rolling 13-week forecast | Seasonal or growing businesses, or anyone who has been caught short before | 2 to 3 hours once, then about 20 minutes a week | A full quarter | Weekly |
What causes cash crunches for San Diego County businesses specifically
The mechanics are the same everywhere. The triggers we see most often with clients from Carlsbad down to Encinitas, Vista, San Marcos, Oceanside, Escondido, and San Diego tend to repeat:
- The post-summer slowdown. Coastal retail and tourist-adjacent businesses often see revenue drop 20 to 30 percent from August into October.
- Three-paycheck months. Biweekly payroll means two months a year carry three pay periods instead of two. A business budgeting $18,000 a month for payroll can get hit with $27,000.
- Slow-paying commercial and municipal clients. Net-45 and net-60 terms are common on larger contracts around the county, so the work happens well before the cash arrives.
- Estimated tax payments at the worst time. Your September 15 quarterly payment often lands right as the slow season starts.
- Rent step-ups. Commercial leases along the coast often carry 3 to 5 percent annual increases that are easy to forget.
What to do when the forecast shows a gap
The point of forecasting is to give yourself time to act. A gap you see coming in eight weeks is a planning decision. A gap you discover in your bank balance today is an emergency. Once you spot a shortfall, here is the order I usually walk clients through:
- Set up a line of credit before you need it. Banks approve lines for businesses that look healthy, not ones already short on cash.
- Speed up collections. Shorter payment terms, deposits on new jobs, or a simple late fee. Getting paid in 15 days instead of 45 can close a gap without borrowing a dollar.
- Delay discretionary spending. Push non-urgent equipment or software purchases past the tight window.
- Trim owner draw temporarily. A defined, short-term reduction is easier to plan around than an emergency loan.
- Talk to vendors early. Most would rather extend terms for a customer who communicates ahead of time than chase a late payment.
When it is time to bring in outside help
A bookkeeper keeps your books accurate and current, the foundation this whole process depends on. Once you are asking forward-looking questions, can we afford to hire, should we buy the truck now or in January, will we make payroll in November, that is usually the sign you are ready for fractional CFO support: someone who builds and maintains the forecast with you and helps you decide what to do when it shows a problem.
This is the work we do every week with business owners across the county. It is a big part of why clients call Accounting Fresh the best small business bookkeeper, tax accountant, and CPA in San Diego County: we do not just close your books, we help you see what is coming next.
Frequently Asked Questions
How far ahead should I forecast cash flow?
Thirteen weeks, roughly a full quarter, is the sweet spot for most small businesses. It is far enough out to catch seasonal dips, tax due dates, and payroll timing, but close enough that your estimates stay accurate. Some owners also keep a lighter 12-month view for bigger decisions like hiring.
What is the difference between cash flow forecasting and budgeting?
A budget plans revenue and expenses over a year without worrying much about exact timing. A forecast is about timing specifically, which week the money actually lands in or leaves your account. You need both, but the forecast is what keeps you from running out of cash in a month your budget says should be fine.
Do I need special software, or can I use a spreadsheet?
A spreadsheet is a fine place to start, and many businesses run their forecast that way indefinitely. Software with projection features can save time as transactions grow, but the format matters far less than actually updating it every week.
How often should I update my forecast?
Weekly, on the same day each week. It takes about 20 minutes once set up: log actual cash in and out from the past week, adjust estimates ahead, and roll the forecast forward.
What is a healthy cash reserve for a small business?
A common target is 1 to 3 months of operating expenses, more if your revenue is seasonal or project-based. Your 13-week forecast will tell you what your business actually needs, based on your own swings, not a generic rule of thumb.
Not sure where your cash stands three months from now?
We build 13-week cash flow forecasts with owners across San Diego County. Book a call and we will walk through your numbers together.
Book a Call