13-Week Cash FlowForecast: AStep-by-Step GuideforSmallBusinesses (With Worked Example)

Key takeaways

• A 13-week forecast shows the timing of cash in and cash out rather than simply showing monthly revenue and expenses.
• Thirteen weeks is roughly one quarter: long enough to see major upcoming payables and seasonal patterns, but short enough to rely on more realistic data.
• Receivables should be forecast by expected collection week, not simply by invoice date.
• The most useful output is the week when cash falls below the minimum operating threshold, giving management time to act before a shortfall occurs.

What is a 13-week cash flow forecast?

A 13-week cash flow forecast is a rolling projection of your cash receipts and payments, week by week, for the next quarter. It uses the direct method: actual cash expected in, actual cash going out and the resulting bank balance each week.

It answers three questions every owner needs answered: can we make payroll every week, how much accounts payable can we pay down without creating a shortfall, and what is our real capacity to service existing debt?

Most trade contractors, including electrical, mechanical and plumbing businesses, run the business from the bank balance and a gut feeling. That works until it does not. A widely cited U.S. Bank study reports that 82 percent of small business failures involve poor cash flow management, which is why lenders in both the US and UK routinely ask for a rolling forecast.

Why 13 weeks and not 12 months?

Thirteen weeks is about one quarter. It is long enough to see seasonal patterns and large upcoming payables, and short enough that the forecast rests on known data instead of excessive speculation.

Anything longer can drift into guesswork. Anything shorter may not leave enough runway to identify a problem and take action before the cash shortfall arrives.

What should a 13-week cash flow forecast include?

1. A recurring payment calendar. Map every predictable outflow, including payroll, key vendor terms, loan payments, insurance and rent, to the specific week it hits rather than using a monthly average. Businesses do not pay evenly across a month, and the model should not pretend they do.
2. Accounts payable paydown analysis. Break payables down by vendor and due date, then model scenarios: pay everything on terms, accelerate to capture early-pay discounts, or stretch payables through a tight week.
3. Debt repayment capacity. For businesses carrying SBA or other term debt, layer the fixed repayment schedule against projected weekly cash so it is obvious which weeks can absorb the payment and which cannot.
4. Receivables timed realistically. An invoice being sent does not mean cash is coming in immediately. Use expected collection timing based on each customer’s payment history. A forecast built only on invoice dates is a wish list.

How do you build a 13-week cash flow forecast? A 6-step process

1. Start with the actual bank balance. Use the actual bank balance on the forecast start date. It is the one number that is not a projection.
2. Layer in every known outflow week by week. Include payroll, debt service, insurance and recurring vendor commitments in the specific week they are expected to hit.
3. Add receivables by realistic collection week. Forecast cash based on expected collection timing, not simply the date an invoice was issued.
4. Model AP paydown scenarios. Compare different payment strategies against the weekly cash position. This is where the forecast becomes a decision tool rather than just a report.
5. Flag weeks below the minimum cash threshold. Identify every week that goes negative or falls below the minimum operating cash target. This is often the single most useful output.
6. Roll it forward every week. Replace forecast figures with actual results as each week closes and add a new week 13 so the model always looks one full quarter ahead.

What does a 13-week cash flow forecast look like? A worked example

The illustrative model below assumes opening cash of $150K, weekly payroll of $45K, a minimum operating cash target of $50K and a large supplier payable landing in week 7. Figures are in thousands of dollars.

Illustrative example. The model shows the forecast falling below the $50K minimum during the tighter weeks.

The forecast shows something a bank balance never would: closing cash drops to just $7K in week 7 and stays under the minimum until week 10. Knowing that on day one gives you time to act, for example by chasing the two largest receivables, negotiating the week 7 supplier payment into week 9 or arranging a short line of credit at reasonable terms instead of an emergency advance.

What are the most common forecasting mistakes?

• Using invoice dates instead of expected collection dates.
• Averaging expenses across the month instead of placing them in the week they hit.
• Building the forecast once and never rolling it forward.
• Leaving out debt payments, taxes, insurance renewals or owner draws.
• Having no minimum cash threshold. Without a threshold, nothing triggers an alert when cash gets dangerously low.

The real value of a 13-week cash flow forecast

The output is not just a cash balance. It is the exact week, potentially six weeks from now, where cash will become tight. That gives you six weeks to do something about it instead of finding out on the day payroll does not clear.

A rolling forecast turns cash management from a reaction into a forward-looking decision process. It shows which commitments are fixed, which payments can move, which receivables need attention and how much cash is actually available for debt service or operating needs.