Business · the week the cash runs thin
13-Week Business Cash Flow Forecast
Short answer
A 13-week cash flow forecast is the next quarter, week by week, so you see the low balance before payroll bounces. Profit can still be a thin week. In the example, a business that makes $1,900 over the quarter still drops to $3,300 in week 1, under its $5,000 minimum. Let customers pay in 4 weeks instead of 2 and the same shop goes negative in week 3.
Last reviewed: November 2026. Example numbers, not a forecast of your business. Educational only, not financial or tax advice.
13-week cash flow forecast tool
This forecast answers which week a small shop would run short. It is for an owner who pays people, not for a hobby spreadsheet. Fill the inputs to build all 13 weeks, then type over any cell you already know. Hand edits stay put when you move the sliders. Nothing you type is saved or sent anywhere, and every number rides in the share link. The honest catch: customers pay late, so a green profit line can still be a red week.
What the numbers mean
- Lowest cash
- The smallest ending balance in the 13 weeks. On the example that is $3,300 in week 1.
- Week you run short
- The first week ending cash plus the unused credit line is still below zero. The example never runs short. A 20% sales drop runs short in week 11. A 4-week wait runs short in week 3.
- Grade
- D on the example: cash slips under the $5,000 minimum and you still pay yourself. F means the credit line does not cover the hole.
- Vs forecast
- Actual ending cash minus the forecast ending cash for that week. It stays blank until you type an actual.
How to use the 13-week cash flow forecast
- Start with the bank balance, not the profit and loss. Cash is what pays the bills.
- Enter open invoices and how long customers take to pay. Pull the A/R total from your invoicing app. If net 30 customers usually pay in 40 days, use 6 weeks.
- Set pay runs, monthly bills, loan payments, and the next tax payment. Those lumpy weeks are the ones that sink people.
- Type the known one-offs into the table. An annual insurance bill, a fat customer deposit, a new laptop. Hand edits turn yellow.
- Slide "what if sales change" to -20%. If a week goes red, deal with it while you still can.
- Redo it every Monday. Type last week's actual ending cash, or use Roll forward one week, then copy the link so this week's version is saved.
13-week cash flow example: profitable and still short
The default numbers are a small service business. It has $6,000 in the bank, wants to keep $5,000, bills $5,000 a week, and gets paid in about 2 weeks with $10,000 already owed. It runs payroll of $3,200 every other week, pays $2,500 of rent and fixed bills and a $900 loan each month, spends 20% of sales on supplies, owes a $4,500 estimated tax payment in week 9, and pays the owner $1,000 a week.
| Week | Cash in | Cash out | Net | Ending cash |
|---|---|---|---|---|
| Week 1 | $5,000 | $7,700 | -$2,700 | $3,300 |
| Week 2 | $5,000 | $2,000 | $3,000 | $6,300 |
| Week 3 | $5,000 | $6,100 | -$1,100 | $5,200 |
| Week 4 | $5,000 | $2,000 | $3,000 | $8,200 |
| Week 5 | $5,000 | $7,700 | -$2,700 | $5,500 |
| Week 6 | $5,000 | $2,000 | $3,000 | $8,500 |
| Week 7 | $5,000 | $6,100 | -$1,100 | $7,400 |
| Week 8 | $5,000 | $2,000 | $3,000 | $10,400 |
| Week 9 | $5,000 | $9,700 | -$4,700 | $5,700 |
| Week 10 | $5,000 | $4,500 | $500 | $6,200 |
| Week 11 | $5,000 | $5,200 | -$200 | $6,000 |
| Week 12 | $5,000 | $2,900 | $2,100 | $8,100 |
| Week 13 | $5,000 | $5,200 | -$200 | $7,900 |
Over 13 weeks it takes in $65,000 and pays out $63,100, so it's up $1,900. But week 1 stacks payroll, rent, supplies, and owner pay into a $7,700 week, and cash falls to $3,300. Week 9 is worse on paper: the $4,500 tax payment lands on a payday for a $9,700 week. It only survives because weeks 4 through 8 built a cushion.
Now stress it. Drop new sales 20% and cash goes negative in week 11. Leave sales alone but let customers take 4 weeks to pay instead of 2, and it goes negative in week 3 and stays there most of the quarter. Same business, same profit margin. Timing is the whole game.
What to do when a week goes red
Fix timing first, because it works this week. Cost cuts take a month or more to show up in cash.
- Collect faster. Ask for a deposit on new work, send invoices the day the job ends, and call anything over 30 days. Cutting the wait from 4 weeks to 2 is worth a full week of sales in the bank. The cash conversion cycle calculator puts a dollar figure on every day you shave off.
- Move a bill. Ask a vendor for net 30, or shift an annual software renewal to a strong week. Never skip payroll taxes.
- Flex owner pay. Pausing $1,000 a week for two weeks covers most short weeks in the example.
- Set up a credit line before you need it. Banks lend to businesses that don't look desperate. Enter the unused amount above to see if it covers the gap.
- Set aside tax money every week. 25% to 30% of profit into a separate account turns the quarterly payment into a non-event. The Profit First method is one way to do it.
What the cash safety grade means
The grade looks at your lowest balance in the 13 weeks, your minimum, and how many weeks of average bills the low point would cover.
| Grade | Rule |
|---|---|
| A Strong | Never below your minimum, and the low point covers 4+ weeks of bills. |
| B Solid | Never below your minimum, 2 to 4 weeks of cover at the low point. |
| C Thin | Never below your minimum, under 2 weeks of cover. |
| D Risky | Dips below your minimum, or goes negative but your credit line covers it. |
| F Risky | Runs out of cash, even after the credit line. |
An A does not mean the business is good. It means you will not miss a bill this quarter. Once you're consistently at B or better, the extra cash is what you can move into investments that pay you whether you work or not. See business cash flow for how to do that.
13-week cash flow forecast FAQ
What is a 13-week cash flow forecast?
A week-by-week plan of cash you expect to collect and pay over the next 13 weeks, which is one quarter. Each week starts with the cash you have, adds money in, subtracts money out, and carries the ending balance forward. The point is to spot the short week while you can still move a bill.
Why 13 weeks and not 12 months?
Thirteen weeks reaches a payroll, a quarterly tax payment, and a slow month, and it is close enough that the numbers are mostly real invoices. A 12-month forecast is better for planning growth. The 13-week view is better for not bouncing a payment.
How do I build a 13-week cash flow forecast?
Start with today's bank balance. Add the invoices you expect customers to pay each week and any other cash coming in. Subtract payroll on its pay dates, rent and fixed bills, vendor payments, loan payments, taxes, and what you pay yourself. Carry each week's ending cash forward. This page does that math, and you can type over any week in the table.
How much cash should a small business keep?
A common rule of thumb is one to three months of operating costs. At minimum, cover your biggest single week of bills, often a payroll week that lands on rent or a tax payment. In the example the biggest week is $9,700, and the owner picked a $5,000 minimum.
What do I do if my forecast shows a negative week?
Work the list in order: chase overdue invoices or ask for deposits, move a flexible bill to a stronger week, pause or trim owner pay for a week or two, then line up a credit line before you need it. Cutting expenses takes the longest to show up in cash, so start with timing.
Is profit the same as cash flow?
No. You can show a profit and still run out of cash, because customers pay late, taxes arrive in a lump, and payroll does not wait. The default example makes $1,900 over the quarter but drops to $3,300 in week 1. If customers take 4 weeks to pay instead of 2, the same business goes negative in week 3.
How do I import a CSV?
Download the blank template, fill week numbers and the cash columns in a spreadsheet, then choose the file on this page. The read stays in your browser. A file with a bad week, a missing header, or a cell that is not a number shows an error and leaves the grid as it was. Nothing is uploaded.
What does roll forward one week do?
It sets opening cash to last week's ending cash, or to the actual ending you typed for week 1. Payday, rent, loan, and tax weeks move with the model, and hand edits shift back one week. The button does nothing until you click it, so the example grade stays D and the example still does not run short.
What is actual versus forecast?
Type the real ending cash in the Actual column. Vs forecast is that number minus the forecast ending cash. A blank actual is ignored. The grade and the week you run short stay on the forecast, not on the actuals.
What is the minimum cash line?
The dashed line on the ending cash chart is the minimum cash you typed. The example is $5,000. The grade already uses that same floor. The line does not add a new assumption, and it has no share-link key of its own.
Educational only. Not financial, legal, or tax advice. A forecast is only as good as the numbers you put in, and real customers pay late. Illustration, not a promise the week will match the grid.