A 13-week cash flow forecast is a plain spreadsheet that shows your projected bank balance week by week for the next quarter, and it tends to flag the tight week long before you’d feel it. You can build one in about an hour from your bank balance, your payables, and a list of who owes you money. Below: the layout, a filled-in example, and a 20-minute weekly routine that keeps it honest.
Key takeaways
- Thirteen weeks is far enough to see a squeeze and close enough to forecast honestly.
- Enter cash in the week it moves, not the week you invoice or get billed.
- The forgotten outflows are usually taxes, insurance, loan principal, and owner pay.
- Update actuals weekly and add one week to the end.
- A negative week is information, not failure, if you see it early.
Why 13 weeks
Thirteen weeks is a quarter, long enough to catch a payroll squeeze or a tax payment and short enough to forecast without fantasy. A monthly budget hides the timing problems that actually hurt: rent on the 1st, payroll on the 15th and 30th, a big customer who pays on the 22nd. A weekly grid shows all of it.
It also does what your financial statements can’t. The P&L, balance sheet, and cash flow statement (covered in our guide to reading your financial statements) look backward. The forecast looks forward. For the wider picture, start with the cash flow management guide, and the SBA’s overview of managing your business finances makes a good companion read.
The layout
Give the sheet one column per week and one row per kind of cash. If you start Monday, November 30, 2026, your 13 weeks run through the week of February 22, 2027.
| Row | What goes in it |
|---|---|
| Opening cash | Your actual bank balance in week 1; afterward, last week’s closing cash |
| Customer payments | Cash you expect to receive that week, timed by how each client really pays |
| Other inflows | Loan proceeds, refunds, owner deposits |
| Payroll and payroll taxes | Net pay on payday; tax deposits on their deposit dates |
| Rent, utilities, and insurance | On the due date |
| Vendors and supplies | Bills due that week, from your payables report |
| Taxes, debt, and owner pay | Estimated payments, loan payments, planned draws |
| Closing cash | Opening cash plus inflows minus outflows |
Two habits keep it honest. Include every account, not just the main checking account, and leave the formulas alone: closing cash is opening cash plus inflows minus outflows, and each week opens with the previous week’s close. Franchise owners can group rows to mirror the franchisor’s P&L, and our franchise chart of accounts template shows how to map them.
Filling in inflows realistically
Inflows are where most forecasts go wrong, because it’s tempting to enter cash on the date you hope it arrives. Pull your receivables aging report and place each open invoice in the week that customer actually pays, based on their history rather than the terms printed on the invoice. An invoice sent the week of December 7 to a client who typically pays in about 40 days belongs in the week of January 11, even if it says net 30.
For work you haven’t billed yet, be conservative. Count sales that are signed, scheduled, or reliably repeating, and leave new leads out until they’re real. If you sell through a card processor, use the actual lag between a sale and the deposit. When you can’t decide between two weeks, pick the later one.
Outflows: the ones people forget
Payroll and rent are impossible to forget. The payments below are the ones that crack a forecast:
- Payroll taxes and benefits. Deposits follow their own calendar (see the IRS employment tax due dates), and health premiums and retirement contributions leave on their own dates.
- Estimated taxes. The next owner installment is due Friday, January 15, 2027, according to the IRS page on estimated taxes. Confirm the date on IRS.gov.
- Insurance and annual renewals. Premiums, licenses, software plans, and domain names that come around once or twice a year.
- Debt payments. Loan principal never touches your P&L, but it leaves your account all the same.
- Owner pay. Draws and distributions are cash out even though they aren’t expenses, and how to pay yourself covers the options.
- Royalties and brand fund payments. Many franchise systems charge a royalty as a percentage of gross sales, plus a marketing or brand fund contribution. Check your franchise agreement for the timing.
Give each its own row, or fold them into one line. Either way, every one needs a date.
Updating weekly
The forecast earns its keep in the weekly update, which takes about 20 minutes:
- Replace last week’s estimates with the actual numbers from your bank.
- Write one line on the biggest miss and why. Patterns show up fast: one client always pays late, one vendor always bills early.
- Move slipped payments to the weeks they’ll probably land.
- Add a new week 13 at the end so you always see a full quarter ahead.
- Find the lowest closing balance and the week it happens.
Do it on the same day every week. If your records run a month behind, your forecast will too, so current bookkeeping is part of the deal.
Reading it: the week that goes negative
Here’s a hypothetical two-crew commercial cleaning company, five weeks into a forecast that started November 30. All figures are dollars.
| Line | Wk 5 (Dec 28) | Wk 6 (Jan 4) | Wk 7 (Jan 11) | Wk 8 (Jan 18) | Wk 9 (Jan 25) |
|---|---|---|---|---|---|
| Opening cash | 21,000 | 20,800 | 13,400 | 5,600 | -250 |
| Customer payments | 7,500 | 9,000 | 6,200 | 11,900 | 19,600 |
| Payroll (net pay) | 0 | 11,000 | 0 | 11,000 | 0 |
| Rent and utilities | 5,900 | 0 | 0 | 0 | 0 |
| Supplies, fuel, software | 1,800 | 2,400 | 1,900 | 2,600 | 1,700 |
| Owner draw | 0 | 3,000 | 0 | 3,000 | 0 |
| Payroll tax deposit | 0 | 0 | 5,600 | 0 | 0 |
| Q4 estimated tax | 0 | 0 | 6,500 | 0 | 0 |
| Equipment loan | 0 | 0 | 0 | 1,150 | 0 |
| Net change | -200 | -7,400 | -7,800 | -5,850 | 17,900 |
| Closing cash | 20,800 | 13,400 | 5,600 | -250 | 17,650 |
Read it from the bottom. Week 8 closes at negative $250. Set a minimum balance you’re comfortable with, say $10,000, and weeks 7 and 8 both fall below it. Three things pile up: the January 15 payments in week 7 (a $5,600 payroll tax deposit and a $6,500 Q4 estimate, $12,100 combined), a payroll in week 8, and December invoices that don’t pay until week 9. Nothing here is a disaster, and none of it shows on a P&L. It’s a timing problem you can see seven weeks ahead, which is the only kind you can fix cheaply.
From forecast to decisions
A forecast only matters if it changes what you do. Work through the options cheapest first.
Pull cash forward. Say $9,000 of week 9’s payments comes from one client. A friendly call in week 6 asking for payment by the 15th could move it into week 7, and week 8 goes from negative $250 to positive $8,750.
Slide payments back. Move the $3,000 owner draw from week 8 to week 9 and week 8 closes at $2,750. Push the $2,600 supplies order back a week too and it closes at $5,350. Neither costs anything but a little patience.
Borrow the gap. If that isn’t enough, a short draw on a line of credit (say $5,000 in week 7, repaid in week 9) covers the rest. Lenders are more comfortable when you can show current records and a forecast, and what lenders look for in your financial records explains how to get ready before you need the line.
If your business swings with the calendar, pair this forecast with the holiday cash flow plan.
Frequently asked questions
Why 13 weeks instead of 12 months?
Thirteen weeks is one quarter: long enough to see tax payments and slow seasons, short enough that your estimates stay believable. A 12-month budget is a different tool, good for setting goals. The forecast is for staying solvent while you chase them.
Do I need special software?
No. A spreadsheet works. If your ledger is in QuickBooks Online or Xero, the receivables and payables reports feed most of it. The weekly habit matters far more than the tool.
How accurate does it have to be?
Accurate enough to show the shape. The first four weeks should be close, and later weeks can be rougher. Each weekly update, and your one-line note on what you missed, makes the next forecast better.
Where to go from here
Start with this week’s bank balance and the next four Fridays, and fill in only what you know for certain. Add a week each time you update. If you’d rather have someone else keep the ledger current so the forecast starts from clean numbers, that’s what a BooXkeeping team is for. Our small business bookkeeping service is month-to-month, with a local Chief BooXkeeping Officer backed by a national team.
Reviewed for tax year 2026.
BooXkeeping is a bookkeeping company, not a CPA firm or a law firm. This article is general information for business owners, not tax, legal, or financial advice. Rules change and your situation is specific, so confirm anything here with your CPA or attorney before acting on it.
A 13-week cash flow forecast is a plain spreadsheet that shows your projected bank balance week by week for the next quarter, and it tends to flag the tight week long before you’d feel it. You can build one in about an hour from your bank balance, your payables, and a list of who owes you money. Below: the layout, a filled-in example, and a 20-minute weekly routine that keeps it honest.
Key takeaways
- Thirteen weeks is far enough to see a squeeze and close enough to forecast honestly.
- Enter cash in the week it moves, not the week you invoice or get billed.
- The forgotten outflows are usually taxes, insurance, loan principal, and owner pay.
- Update actuals weekly and add one week to the end.
- A negative week is information, not failure, if you see it early.
Why 13 weeks
Thirteen weeks is a quarter, long enough to catch a payroll squeeze or a tax payment and short enough to forecast without fantasy. A monthly budget hides the timing problems that actually hurt: rent on the 1st, payroll on the 15th and 30th, a big customer who pays on the 22nd. A weekly grid shows all of it.
It also does what your financial statements can’t. The P&L, balance sheet, and cash flow statement (covered in our guide to reading your financial statements) look backward. The forecast looks forward. For the wider picture, start with the cash flow management guide, and the SBA’s overview of managing your business finances makes a good companion read.
The layout
Give the sheet one column per week and one row per kind of cash. If you start Monday, November 30, 2026, your 13 weeks run through the week of February 22, 2027.
| Row | What goes in it |
|---|---|
| Opening cash | Your actual bank balance in week 1; afterward, last week’s closing cash |
| Customer payments | Cash you expect to receive that week, timed by how each client really pays |
| Other inflows | Loan proceeds, refunds, owner deposits |
| Payroll and payroll taxes | Net pay on payday; tax deposits on their deposit dates |
| Rent, utilities, and insurance | On the due date |
| Vendors and supplies | Bills due that week, from your payables report |
| Taxes, debt, and owner pay | Estimated payments, loan payments, planned draws |
| Closing cash | Opening cash plus inflows minus outflows |
Two habits keep it honest. Include every account, not just the main checking account, and leave the formulas alone: closing cash is opening cash plus inflows minus outflows, and each week opens with the previous week’s close. Franchise owners can group rows to mirror the franchisor’s P&L, and our franchise chart of accounts template shows how to map them.
Filling in inflows realistically
Inflows are where most forecasts go wrong, because it’s tempting to enter cash on the date you hope it arrives. Pull your receivables aging report and place each open invoice in the week that customer actually pays, based on their history rather than the terms printed on the invoice. An invoice sent the week of December 7 to a client who typically pays in about 40 days belongs in the week of January 11, even if it says net 30.
For work you haven’t billed yet, be conservative. Count sales that are signed, scheduled, or reliably repeating, and leave new leads out until they’re real. If you sell through a card processor, use the actual lag between a sale and the deposit. When you can’t decide between two weeks, pick the later one.
Outflows: the ones people forget
Payroll and rent are impossible to forget. The payments below are the ones that crack a forecast:
- Payroll taxes and benefits. Deposits follow their own calendar (see the IRS employment tax due dates), and health premiums and retirement contributions leave on their own dates.
- Estimated taxes. The next owner installment is due Friday, January 15, 2027, according to the IRS page on estimated taxes. Confirm the date on IRS.gov.
- Insurance and annual renewals. Premiums, licenses, software plans, and domain names that come around once or twice a year.
- Debt payments. Loan principal never touches your P&L, but it leaves your account all the same.
- Owner pay. Draws and distributions are cash out even though they aren’t expenses, and how to pay yourself covers the options.
- Royalties and brand fund payments. Many franchise systems charge a royalty as a percentage of gross sales, plus a marketing or brand fund contribution. Check your franchise agreement for the timing.
Give each its own row, or fold them into one line. Either way, every one needs a date.
Updating weekly
The forecast earns its keep in the weekly update, which takes about 20 minutes:
- Replace last week’s estimates with the actual numbers from your bank.
- Write one line on the biggest miss and why. Patterns show up fast: one client always pays late, one vendor always bills early.
- Move slipped payments to the weeks they’ll probably land.
- Add a new week 13 at the end so you always see a full quarter ahead.
- Find the lowest closing balance and the week it happens.
Do it on the same day every week. If your records run a month behind, your forecast will too, so current bookkeeping is part of the deal.
Reading it: the week that goes negative
Here’s a hypothetical two-crew commercial cleaning company, five weeks into a forecast that started November 30. All figures are dollars.
| Line | Wk 5 (Dec 28) | Wk 6 (Jan 4) | Wk 7 (Jan 11) | Wk 8 (Jan 18) | Wk 9 (Jan 25) |
|---|---|---|---|---|---|
| Opening cash | 21,000 | 20,800 | 13,400 | 5,600 | -250 |
| Customer payments | 7,500 | 9,000 | 6,200 | 11,900 | 19,600 |
| Payroll (net pay) | 0 | 11,000 | 0 | 11,000 | 0 |
| Rent and utilities | 5,900 | 0 | 0 | 0 | 0 |
| Supplies, fuel, software | 1,800 | 2,400 | 1,900 | 2,600 | 1,700 |
| Owner draw | 0 | 3,000 | 0 | 3,000 | 0 |
| Payroll tax deposit | 0 | 0 | 5,600 | 0 | 0 |
| Q4 estimated tax | 0 | 0 | 6,500 | 0 | 0 |
| Equipment loan | 0 | 0 | 0 | 1,150 | 0 |
| Net change | -200 | -7,400 | -7,800 | -5,850 | 17,900 |
| Closing cash | 20,800 | 13,400 | 5,600 | -250 | 17,650 |
Read it from the bottom. Week 8 closes at negative $250. Set a minimum balance you’re comfortable with, say $10,000, and weeks 7 and 8 both fall below it. Three things pile up: the January 15 payments in week 7 (a $5,600 payroll tax deposit and a $6,500 Q4 estimate, $12,100 combined), a payroll in week 8, and December invoices that don’t pay until week 9. Nothing here is a disaster, and none of it shows on a P&L. It’s a timing problem you can see seven weeks ahead, which is the only kind you can fix cheaply.
From forecast to decisions
A forecast only matters if it changes what you do. Work through the options cheapest first.
Pull cash forward. Say $9,000 of week 9’s payments comes from one client. A friendly call in week 6 asking for payment by the 15th could move it into week 7, and week 8 goes from negative $250 to positive $8,750.
Slide payments back. Move the $3,000 owner draw from week 8 to week 9 and week 8 closes at $2,750. Push the $2,600 supplies order back a week too and it closes at $5,350. Neither costs anything but a little patience.
Borrow the gap. If that isn’t enough, a short draw on a line of credit (say $5,000 in week 7, repaid in week 9) covers the rest. Lenders are more comfortable when you can show current records and a forecast, and what lenders look for in your financial records explains how to get ready before you need the line.
If your business swings with the calendar, pair this forecast with the holiday cash flow plan.
Frequently asked questions
Why 13 weeks instead of 12 months?
Thirteen weeks is one quarter: long enough to see tax payments and slow seasons, short enough that your estimates stay believable. A 12-month budget is a different tool, good for setting goals. The forecast is for staying solvent while you chase them.
Do I need special software?
No. A spreadsheet works. If your ledger is in QuickBooks Online or Xero, the receivables and payables reports feed most of it. The weekly habit matters far more than the tool.
How accurate does it have to be?
Accurate enough to show the shape. The first four weeks should be close, and later weeks can be rougher. Each weekly update, and your one-line note on what you missed, makes the next forecast better.
Where to go from here
Start with this week’s bank balance and the next four Fridays, and fill in only what you know for certain. Add a week each time you update. If you’d rather have someone else keep the ledger current so the forecast starts from clean numbers, that’s what a BooXkeeping team is for. Our small business bookkeeping service is month-to-month, with a local Chief BooXkeeping Officer backed by a national team.
Reviewed for tax year 2026.
BooXkeeping is a bookkeeping company, not a CPA firm or a law firm. This article is general information for business owners, not tax, legal, or financial advice. Rules change and your situation is specific, so confirm anything here with your CPA or attorney before acting on it.