A 13-week cash flow forecast is a week-by-week projection of the cash you expect to collect and pay out over the next quarter. You start with today's bank balance, add expected receipts, subtract expected payments, and roll the ending balance forward each week. Built this way, it shows you the specific week cash gets tight, usually early enough to do something about it.
This guide is for owners who have been surprised by a thin bank balance at least once and want a tool that sees it coming. You'll get the row structure, a build process you can follow in a spreadsheet this afternoon, a worked example with a cash dip, and a simple weekly routine for keeping the forecast honest.
Why 13 weeks instead of a monthly or annual forecast?
Thirteen weeks is one quarter. It is short enough that you can estimate most of it from facts you already have: invoices that are out, bills that are scheduled, payroll dates, loan payments. It is long enough to catch problems that a two-week view would miss, like a quarterly insurance premium or a large equipment deposit sitting six weeks out.
Weekly granularity matters more than most owners expect. A monthly forecast can show a healthy ending balance while hiding a week in the middle where payroll and rent land together before a big customer pays. Your bank account doesn't average itself across the month. If it drops below zero on a Thursday, that's the day you have a problem.
An annual budget answers "Will we be profitable this year?" A 13-week forecast answers "Will we have enough cash on each Friday this quarter?" Our explainer on why a profitable business can still run out of money covers the difference.
What goes into a 13-week cash flow forecast
The layout is simple: weeks run across the columns, and categories run down the rows. Keep the categories few enough to maintain. Most small businesses need no more than 12 to 15 rows.
| Section | Typical rows | Where the numbers come from |
|---|---|---|
| Opening cash | Bank balance at the start of the week | Prior week's ending balance (week 1 uses today's actual balance) |
| Cash in | Customer collections, cash or card sales, other receipts | Accounts receivable aging, sales history, deposit schedules |
| Cash out: people | Payroll, payroll taxes, contractor payments | Payroll calendar and last few runs |
| Cash out: operations | Rent, suppliers, utilities, software, insurance | Accounts payable, recurring bills, vendor terms |
| Cash out: one-time | Equipment deposits, tax payments, owner draws | Your calendar and commitments |
| Cash out: financing | Loan and lease payments, credit line interest | Loan statements |
| Net cash flow | Total in minus total out | Formula |
| Ending cash | Opening cash plus net cash flow | Formula, carried to next week's opening |
| Minimum balance | Your floor, shown as a fixed line | Your own rule (explained below) |
Notice what is missing: depreciation, accrued expenses and anything else that doesn't move money. This forecast tracks cash only. A sale you made today on 30-day terms shows up in week 5, not week 1.
How to build the forecast, step by step
- Start with your actual bank balance. Use the combined balance of your operating accounts as of today. Leave out money you can't touch, like a reserve you've committed not to spend.
- Map known outflows first. Payroll dates, rent, loan payments, insurance premiums and subscription charges are the most predictable numbers you have. Put each one in the exact week it leaves the account.
- Load your payables. Pull open bills from your accounting software and place each in the week you actually intend to pay it, not necessarily its due date.
- Forecast collections from your receivables. Don't assume customers pay on the due date. Look at how they actually pay and apply that pattern (more on this in a moment).
- Add new sales you haven't invoiced yet. For weeks 5 through 13, most of your cash in will come from work you haven't done yet. Estimate it from recent weekly averages and adjust for known seasonality.
- Add one-time items. Equipment purchases, estimated tax payments, annual renewals, owner distributions. These are the items that usually cause the surprise.
- Set a minimum balance line. A common rule of thumb is enough to cover one full payroll plus one month of rent, though you should set it based on how lumpy your receipts are.
- Look for the lowest week. Scan the ending cash row for the minimum. That week, and the weeks leading up to it, are where you focus.
Forecasting collections realistically
The most common source of forecast error is collections. Review a few months of payment history and note what share of invoices are paid in the week they're due, the week after and later. Suppose your pattern is 60% on time, 30% one week late and 10% two weeks late. Then $10,000 of invoices due in week 5 becomes $6,000 in week 5, $3,000 in week 6 and $1,000 in week 7. That spread is far more accurate than dropping the full $10,000 into week 5. If collections are consistently slow, our guide on getting paid faster on your invoices covers the fixes.
Worked example: a commercial printing shop
Suppose a hypothetical printing shop starts the quarter with $42,000 in the bank. The owner has set a minimum balance of $25,000, roughly one payroll plus rent and a small cushion. Here are the first four weeks.
| Line | Week 1 | Week 2 | Week 3 | Week 4 |
|---|---|---|---|---|
| Opening cash | $42,000 | $40,000 | $45,000 | $23,500 |
| Collections | $18,500 | $16,000 | $9,500 | $12,000 |
| Payroll | ($14,200) | – | ($14,200) | – |
| Rent | ($4,800) | – | – | – |
| Paper and ink supplier | – | ($7,600) | – | ($7,600) |
| Equipment lease | – | ($1,900) | – | – |
| Insurance (quarterly) | – | – | ($3,300) | – |
| New press deposit | – | – | ($12,000) | – |
| Loan payment | – | – | – | ($2,100) |
| Other operating costs | ($1,500) | ($1,500) | ($1,500) | ($1,500) |
| Net cash flow | ($2,000) | $5,000 | ($21,500) | $800 |
| Ending cash | $40,000 | $45,000 | $23,500 | $24,300 |
Check week 3: outflows are $14,200 + $3,300 + $12,000 + $1,500 = $31,000. Collections of $9,500 minus $31,000 gives a net of −$21,500, and $45,000 − $21,500 = $23,500. Collections dipped that week because one large client typically pays about two weeks late.
The shop is never overdrawn, but it sits below its $25,000 floor for two straight weeks. The monthly view would have hidden this: across the four weeks, collections total $56,000 and outflows total $73,700, so the month shows a drop from $42,000 to $24,300 without revealing that the timing crunch is concentrated in week 3.
The owner now has three concrete options, each with a number attached:
- Ask the press vendor to take the $12,000 deposit in week 5 instead of week 3. That alone keeps week 3 at $35,500.
- Call the slow client in week 1 about the invoice due in week 3. Pulling even $4,000 forward lifts both weeks above the floor.
- Arrange a credit line draw ahead of time, so it is ready rather than requested in a panic.
To see how long your current cash would last under a steady burn, run the figures through our cash runway calculator alongside the forecast.
How to keep the forecast accurate week after week
A forecast you build once and never touch goes stale within a month. The value comes from a short weekly routine, ideally on the same day each week.
- Replace last week's forecast with actuals. Enter what really came in and went out.
- Record the variance. If you forecast $18,500 in collections and collected $16,900, the variance is −$1,600, or about 8.6% short. Note why.
- Roll forward. Drop the completed week and add a new week 13 at the end, so you always see a full quarter ahead.
- Update the next three weeks in detail. These should be close to certain. Weeks further out can stay rougher.
- Recheck the low point. Has it moved? Is it deeper? Decide on any action now.
If collections run short nearly every week, bake that haircut into future weeks rather than hoping it improves.
When should you worry about what the forecast shows?
Use a simple decision rule. If the lowest projected balance is above your minimum, carry on and keep watching. If it dips below your minimum but stays positive, act on timing: shift payments, accelerate collections, delay discretionary purchases. If it goes negative in any week, treat it as urgent. Line up financing, talk to key vendors, and reconsider large commitments before that week arrives.
If the dips follow a yearly pattern rather than one-off events, the fix is structural. Our guide to handling seasonal cash flow swings covers building reserves and timing expenses around your busy months.
Common mistakes with 13-week forecasts
- Forecasting collections on due dates. Customers rarely pay exactly on time. Use their actual payment history, or you will overstate cash in every early week.
- Forgetting irregular payments. Quarterly insurance, annual software renewals, estimated taxes and property taxes are easy to miss. Scan last year's bank statements for anything that isn't monthly.
- Mixing profit items into a cash tool. Depreciation and accruals don't belong here. Neither does revenue you've earned but won't collect this quarter.
- Leaving out owner draws. If you take regular distributions, they are real outflows. Excluding them makes the balance look healthier than it will be.
- Building it and never updating it. A forecast only works as a rolling tool. Twenty minutes a week keeps it useful.
- Too many rows. Forty line items feel precise but are painful to maintain. Group small items and keep the detail where the dollars are.
Where AI can help
An AI assistant can speed up the setup considerably. Export three to six months of bank transactions and ask it to group them into your forecast categories, list recurring payments with their typical dates and amounts, and flag irregular charges you might forget. You can also paste in an accounts receivable aging report and ask it to estimate each customer's average days late. For more on this, see our piece on using AI to forecast cash flow.
Review everything it produces. It won't know that a customer's payment habits changed last month, that you negotiated new terms with a supplier, or that a large deposit is coming. The forecast's accuracy depends on judgment about the future, and that part is yours.
Frequently asked questions
Is a 13-week cash flow forecast only for businesses in trouble?
No. Lenders and turnaround advisors use it heavily, which gives it that reputation, but it is just as useful for healthy businesses. It helps you time equipment purchases, hires and owner distributions so they don't collide with a thin week.
Should I use the direct or indirect method?
For a 13-week forecast, use the direct method, which lists actual cash receipts and payments by category. The indirect method starts from net income and adjusts for non-cash items. It suits annual financial statements, but it's hard to act on week to week.
How accurate should my forecast be?
Aim for the next two or three weeks to be within a few percent. Weeks further out will be less precise, and that's fine. The goal is to spot the timing and rough size of shortfalls, not to predict every dollar.
What minimum cash balance should I set?
Start with one full payroll plus one month of rent and required debt payments, then adjust. Businesses with lumpy receipts or a few large customers usually want a higher floor than those with steady daily card sales.
Key takeaways
- A 13-week forecast tracks cash in and out by week, starting from your real bank balance.
- Weekly detail catches timing crunches that monthly totals hide.
- Forecast collections using how customers actually pay, not invoice due dates.
- Set a minimum balance and focus on the week where cash is lowest.
- Update weekly: swap in actuals, note variances, and roll forward a new week 13.
- When a dip appears, act on timing first: move payments, pull collections forward, and arrange financing early.
Comments
Post a Comment