13-Week Cash Flow Forecast for Small Business

“Am I going to run out of money?” is a question a lot of business owners type into a search bar late at night. The profit and loss report says the business made money. The bank balance says otherwise. Payroll is Friday.

The honest answer is that nobody can tell from last month’s numbers. You find out by looking forward, week by week. The tool finance teams use for this is called a 13-week cash flow forecast. It’s a spreadsheet, not software, and you can build a usable one in an afternoon.

Why profit doesn’t tell you if you’ll run out of cash

Profit counts a sale when you invoice it. Cash counts it when the money lands. In between sit customers who pay in 45 days, inventory you paid for in advance, loan payments that never show up on the P&L, and a quarterly tax payment you forgot was coming. We go through the usual causes in why profitable businesses still run out of cash. The forecast is how you see them coming.

What a 13-week cash flow forecast is

It’s one row per type of cash in or out, and one column per week for the next 13 weeks. Thirteen weeks is one quarter: far enough ahead to see trouble, close enough that your guesses are still decent. Each week you update the actual numbers for the week that just ended and roll the forecast forward by one week.

	Week 1	Week 2	Week 3	…
Opening cash	$42,000	$38,500	$51,200
Customer receipts	$18,000	$31,000	$9,500
Payroll and payroll taxes	($14,000)	$0	($14,000)
Rent	($6,500)	$0	$0
Suppliers	($1,000)	($18,300)	($4,000)
Loan payment	$0	$0	($2,800)
Closing cash	$38,500	$51,200	$39,900

Each week’s closing cash becomes the next week’s opening cash. The number you watch is the lowest closing balance in the 13 weeks, not the last one.

How to build one in six steps

1. Start with today’s real bank balance

Use the actual balance across your operating accounts this morning, not the balance in your accounting software. If the two are far apart, your books need reconciling first.

2. List what customers will actually pay, and when

Go through your open invoices and put each one in the week you expect the money, based on how that customer really pays, not your payment terms. A customer who always pays at 52 days goes in at 52 days. Add expected new sales separately and keep them conservative.

3. Put in the fixed payments

Payroll on its actual dates, rent, loan and lease payments, insurance, software subscriptions. These rarely move, which makes them the easiest part.

4. Add supplier payments from your bills

Open bills go in the week they’re due. Add expected new purchases, especially inventory.

5. Don’t forget the lumpy ones

Quarterly estimated taxes, annual insurance premiums, sales tax remittances, owner draws, equipment purchases, annual software renewals. These are the payments that turn a fine-looking month into a crisis. Our note on the quarterly estimated tax deadline is a reminder of one that catches many owners.

6. Find the low point and decide what to do now

Look for the week with the lowest closing cash. If it drops below the cushion you’re comfortable with (many owners use two payrolls), you now have weeks to act instead of days:

• Chase specific late invoices or offer a small early-payment discount
• Ask a key supplier for longer terms on one big bill
• Move a planned purchase or owner draw by a few weeks
• Talk to your bank about a line of credit while your numbers still look healthy

Mistakes that make the forecast useless

• Using invoice dates instead of payment dates. The forecast then looks exactly like your P&L and tells you nothing new.
• Building it once. A forecast you don’t update every week is out of date by the second Friday.
• Never comparing forecast to actual. Checking last week’s guess against what really happened is how the forecast gets more accurate.
• Working from messy books. If receivables and bills aren’t up to date, neither is the forecast. Clean monthly bookkeeping comes first.

When it’s time for outside help

If the forecast shows a gap you can’t close with the steps above, or you’re making payroll decisions from it every week, that’s the point where a part-time finance lead earns their fee. A fractional CFO builds and runs this forecast with you, ties it to your budget and taxes, and helps you have the bank conversation before you need the money.

Frequently asked questions

How do I know if my business is going to run out of money?

Build a 13-week cash flow forecast. Start with today’s bank balance, add expected customer payments by week, subtract every payment due, and look for the week with the lowest closing balance.

Why is my business profitable but always broke?

Profit records sales when you invoice and costs when you incur them. Cash moves on different dates. Slow-paying customers, inventory, loan payments and tax payments can drain cash while the profit report still looks fine.

Why 13 weeks?

Thirteen weeks is one quarter. It’s long enough to spot trouble early and short enough that weekly estimates stay reasonably accurate.

How often should I update a cash flow forecast?

Every week. Replace last week’s estimate with the actual figures, then add a new week at the end so you always see 13 weeks ahead.

Want a second pair of eyes on your numbers? Book a call and we’ll help you build your first 13-week forecast from your own data.