How to Build a 13-Week Cash-Flow Forecast for a Small Business

A 13-week cash-flow forecast shows expected cash receipts, payments, and closing balances by week. It is detailed enough to expose near-term pressure while remaining short enough to update from current invoices, payroll dates, supplier commitments, and collection plans.

It is not the same as a profit forecast. Revenue can be recognized before cash is collected, and expenses can be paid in a different period from when they appear in the income statement.

The basic weekly structure

Section	Typical lines
Opening cash	Prior week’s closing available cash
Operating receipts	Customer collections, cash sales, refunds received
Operating payments	Payroll, suppliers, rent, tax, software, logistics
Investing cash flow	Equipment or asset purchases and proceeds
Financing cash flow	Loans, repayments, owner funding, distributions
Closing cash	Opening cash + receipts − payments

For each week:

Closing cash = opening cash + total receipts − total payments

The closing balance becomes the following week’s opening balance.

Step 1: establish available opening cash

Reconcile the opening balance to bank accounts and other genuinely available cash. Exclude restricted cash and clearly label overdraft or facility availability instead of combining it with cash on hand.

Step 2: forecast customer receipts

Start with individual material invoices and customer payment behavior, not simply weekly revenue divided by thirteen.

For each expected receipt, record:

• customer
• invoice or source reference
• amount
• contractual due date
• expected collection week
• confidence or scenario
• collection owner

Separate confirmed receipts from assumptions. If a customer has repeatedly paid late, use a realistic expected date and preserve the contractual date for comparison.

Step 3: schedule cash payments

Use known commitments first:

• payroll and employee costs
• supplier invoices
• rent and utilities
• taxes and regulatory payments
• debt service
• subscriptions and insurance
• approved equipment purchases
• owner distributions

Avoid spreading a monthly cost evenly when the payment occurs on a specific date. Weekly timing is the point of the forecast.

Step 4: calculate headroom and alerts

Define a minimum-cash threshold approved by management. Then calculate:

Cash headroom = forecast closing cash − minimum cash threshold

Flag the first week in which headroom becomes negative. That gives management time to accelerate collections, defer discretionary payments, adjust inventory purchases, arrange funding, or revise commitments.

Step 5: create scenarios

Maintain at least three cases:

• Base: current best estimate using confirmed information and realistic timing.
• Upside: faster collections or stronger receipts supported by identifiable opportunities.
• Downside: delayed collections, lower sales receipts, or higher critical payments.

Do not create the downside by applying an arbitrary percentage to every line. Model specific risks such as a named customer paying two weeks late or a supplier requiring an earlier deposit.

Step 6: update it every week

At each update:

1. replace the completed week with actual receipts and payments
2. reconcile actual closing cash
3. add a new thirteenth week
4. move delayed items to realistic dates
5. explain material forecast-versus-actual differences
6. refresh actions, owners, and deadlines

Track forecast accuracy so recurring optimism or omissions become visible.

Example of a variance explanation

Week 3 closing cash was $24,000 below forecast because Customer A’s $30,000 payment moved to Week 5, partly offset by a $6,000 supplier payment deferred under agreed terms. The controller will confirm Customer A’s payment status by Tuesday. The downside case falls below the minimum-cash threshold in Week 6.

This connects the number to specific evidence, timing, risk, and action.

Common errors

• treating invoiced revenue as collected cash
• omitting tax, payroll, debt, or annual renewals
• double-counting facility availability as both cash and financing
• using one optimistic collection date in every scenario
• failing to reconcile the opening balance
• overwriting the original forecast instead of measuring accuracy
• ignoring payments just beyond Week 13 that require action now

Why the process matters

The FDIC and SBA’s Money Smart for Small Business curriculum includes a dedicated cash-flow module covering the timing and management of business cash. A short-term forecast turns that principle into a weekly operating process.

Start with a structured template

Use the free cash-flow analysis template for balances, inflows, outflows, risks, actions, and owners. Connect the forecast to the monthly financial report checklist so liquidity decisions remain visible in management reporting.

This guide provides general educational information. Financing, insolvency, tax, payroll, and payment decisions should be reviewed with qualified advisers where appropriate.