How to Build a 13-Week Cash Flow Forecast (Step-by-Step Guide)

Some of the most stressful calls I get come from owners whose businesses are growing and profitable on paper, but who can’t make next Friday’s payroll without a scramble. Growth eats cash. Customers pay late, inventory has to be bought up front, and a single loan payment or tax deposit can land in the wrong week.

A 13-week cash flow forecast is the tool that prevents those surprises. It’s the first thing we build when a client’s cash feels tight, and in a year when borrowing costs are rising again, it’s one of the most valuable hours a finance team can spend each week.

Key takeaways

• A 13-week cash flow forecast projects cash in and out week by week for the next quarter.
• You need one when cash is tight, growth is fast, a lender is involved or a big decision is coming.
• Build it from your real bank balance, expected collection dates and every scheduled payment.
• A simple four-week example shows how the forecast flags a shortfall weeks before it happens.
• When it shows a gap, you have time to act: collect faster, re-time spending or line up financing.

What is a 13-week cash flow forecast?

A 13-week cash flow forecast is a week-by-week projection of the cash your business will collect and pay out over the next quarter. It starts from your actual bank balance and shows your expected ending cash for each of the next 13 weeks.

Why 13 weeks? It covers a full quarter, which is far enough out to see problems coming and still act on them. And it’s weekly, which catches the timing issues a monthly view hides: two payrolls landing in the same month, a big customer paying on the 45th day instead of the 30th, or a quarterly tax payment right after a slow week.

It’s different from your budget. Your annual business budget is a plan for profit over the year. The 13-week forecast is a short-term view of cash, updated every week as reality changes. Most growing businesses need both.

When you need one

Not every business needs a weekly cash forecast all year. You almost certainly need one if any of these are true:

• Cash feels tight even though revenue is growing
• Your business is seasonal or has large, lumpy customer payments
• You have a line of credit, term loan or covenants to manage
• You’re planning a big hire, purchase, expansion or acquisition
• Customers have started paying slower
• A lender, investor or buyer is asking for a cash outlook
• You’re working through a turnaround or restructuring

How to build a 13-week cash flow forecast in 6 steps

1. Start with your real cash balance

Use the balance in your bank accounts today, not the cash balance in your accounting system. Outstanding checks and deposits in transit can make the book balance look better or worse than reality. If your books aren’t reconciled, start there. Our bookkeeping services keep this clean every week.

2. Forecast collections by when customers actually pay

Start with your accounts receivable aging. For each large customer, use their real payment history, not the due date on the invoice. Then add expected new sales, timed to when that cash will land. Be conservative: optimistic collections are the most common reason forecasts miss.

3. Map every payment to its week

List everything that leaves the bank: payroll and payroll taxes on their actual pay dates, rent, loan payments, vendor bills based on their terms, software, insurance, estimated taxes, capital purchases and owner distributions. Recurring items are easy. The big, irregular ones are where surprises hide.

4. Lay it out week by week

For each week, show beginning cash, total collections, total payments, net cash flow and ending cash. Add a row for your minimum cash balance, the cushion you never want to go below, and a row for available credit on your line. Now you can see exactly which weeks are at risk.

5. Roll it forward every week

Each week, replace the week that just ended with actual results, add a new week 13 and update anything that changed. Compare what you forecast to what actually happened. Over time, that comparison makes the forecast more accurate and shows you which assumptions to trust.

6. Use it to make decisions

A forecast only pays off when it changes what you do. Review it weekly with whoever controls spending and collections, and agree on actions for any week that dips below your minimum.

A simple example

Here’s a simplified four-week view for a services company with a $150,000 minimum cash target. Two payrolls, a vendor catch-up and a quarterly tax payment land close together:

On a monthly report, this company looks fine. Week by week, it dips below its cushion in weeks 3 and 4. Seeing that today gives the owner three weeks to act, instead of finding out the day payroll runs.

What to do when the forecast shows a gap

The point of seeing a shortfall early is that you still have options:

• Speed up collections. Invoice the day work is delivered, follow up on large balances before they’re late, and offer ACH or card autopay.
• Re-time payments. Move discretionary spending and capital purchases a few weeks out, and talk to key vendors before you stretch terms, not after.
• Line up financing early. Banks lend more readily to companies that show a forecast and ask ahead of time than to those asking in a crisis.
• Ask for deposits. For project work, upfront deposits or milestone billing can close a gap entirely.
• Review pricing and terms. If you’re consistently funding your customers, it may be time to change payment terms or pricing.

Common mistakes to avoid

• Forecasting profit instead of cash. Depreciation and accruals don’t move money. Timing does.
• Starting from the book balance. Always start from what’s actually in the bank.
• Assuming customers pay on time. Use each customer’s real payment history.
• Forgetting the irregular items. Quarterly taxes, annual insurance and loan payments cause most surprises.
• Building it once. A forecast that isn’t rolled forward weekly is out of date within a month.

What to watch by industry

The bottom line

A 13-week cash flow forecast won’t create cash, but it gives you the one thing you can’t buy in a crunch: time. Owners who review one every week make calmer decisions, have better conversations with their bank and almost never get surprised by a payroll they can’t cover.