4 min read

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

Create a simple 13-week cash flow forecast for a service business with weekly receipts, payments, scenario planning, and a practical cash gap example.

A cleaning business owner reviews invoices and a cash forecast at a laptop.
Photo by StrollPlace · AI-generated image

Payroll can come due while a contractor is still waiting on several large invoices. A moving company can face the same squeeze in a slow month when insurance and vehicle payments continue. A 13-week forecast puts expected deposits and actual due dates on the same timeline so you can see how much cash will be available each week.

1. Start with available cash

Start Week 1 with the cash you can use today, based on reconciled bank and cash records.

Keep restricted funds or money you cannot use for operations separate. If several accounts support the business, determine which balances are genuinely available.

2. Estimate cash coming in each week

For every week, list receipts you reasonably expect to collect: customer payments, deposits, recurring service revenue, and other genuine cash inflows.

Enter receipts in the week you expect the money to arrive, even when you issued the invoice much earlier.

If a property manager usually pays thirty days after approving an invoice, don't assume that invoice will become cash tomorrow. If a customer deposit is refundable or subject to special terms, recognize those obligations appropriately.

Mark receipts as confirmed, likely, or uncertain so you can test what happens if any of them slip.

3. List cash going out

Include payroll, taxes, materials, subcontractors, rent, insurance, vehicle expenses, equipment payments, software, debt service, and planned owner distributions.

Put an annual insurance premium in the week you’ll pay it. A modest monthly expense in your books can still mean a big cash payment all at once.

Include expected tax payments based on appropriate professional advice. Don't treat money collected for taxes as unrestricted profit.

4. Use a simple weekly formula

For each week:

Ending cash = Beginning cash + Cash received − Cash paid

The ending balance becomes the next week's beginning balance.

A hypothetical four-week excerpt might look like this:

Week 1

Week 2

Week 3

Week 4

Beginning cash

$12,000

$11,000

$5,500

$500

Expected receipts

$5,000

$2,000

$1,500

$7,000

Planned payments

$6,000

$7,500

$6,500

$4,000

Ending cash

$11,000

$5,500

$500

$3,500

The figures are hypothetical.

Week 3 is the tight spot. The expected $3,500 at the end of Week 4 can’t cover an expense due a week earlier, when the projected balance is only $500.

5. Test what happens if a payment is late

Now imagine the $1,500 expected in Week 3 arrives two weeks later instead.

If all other amounts stay the same, the Week 3 balance drops to −$1,000. The business needs to close that $1,000 gap before its payments come due.

Consider reasonable responses such as confirming invoice approval, accelerating legitimate collections, rescheduling discretionary purchases, or reviewing an appropriate financing option with a qualified adviser.

Don't solve a cash gap by withholding legally required payroll or tax payments.

A hand moves an invoice on a paper weekly planner.
Move a late receipt to its expected payment week and recalculate the intervening balances. AI-generated illustration.

6. Build three scenarios

Use a base case for your most reasonable expectations, a cautious case for slower collections or fewer jobs, and an upside case for stronger receipts.

Base each scenario on explicit changes, such as a postponed job or customers taking an extra week to pay.

Find the lowest cash balance in each scenario. Try moving two receipts or a large job and see which week falls below your reserve.

That number can help you decide how much reserve the business needs and which commitments are safe to make.

7. Update the forecast every week

Set aside time each week to reconcile the forecast.

At the end of each week, compare actual receipts and payments with the forecast. Replace estimates with actual amounts, investigate significant differences, and add a new thirteenth week.

If the business has many small invoices, group them by expected collection week. For large receivables, track individual customers so one delay doesn't disappear inside a total.

8. Use cash visibility to improve business decisions

A forecast can reveal whether you can afford equipment, a new hire, a marketing campaign, or a larger contract with slow payment terms.

Check the payment schedule before committing to a bigger project. Upfront material or labor costs can drain cash for several weeks, even when the final job margin looks good.

For a related operational perspective, see How to Know Which Marketing Channels Actually Bring Customers.

Act on the first tight week

When a new week drops below the reserve you need, identify the payment or delayed receipt causing the gap and decide what you can do before the due date.

For a simple external reference, SCORE provides guidance on building a weekly cash forecast at score.org.

Related reading

More insights