Blog / Cash flow
Cash flow
The 13-week cash flow forecast: how to build one from your books
Profit and cash are not the same thing, and the gap between them is where most small businesses get squeezed. You can have a profitable quarter and still come up short on a Friday payroll, because the customer who owes you is paying in 45 days and the payroll tax deposit is due next Wednesday.
The 13-week cash flow forecast is the tool built for exactly that gap. It's used by lenders, turnaround advisors and finance teams, and it works just as well for a ten-person company. It is simple in concept. It takes discipline to keep accurate.
What it is, and why 13 weeks
Thirteen weeks is one quarter. That's long enough to see a problem coming, and short enough that you can forecast each week from real information: invoices you've already sent, bills already on file, paydays already set.
It tracks cash, not profit. A sale counts in the week the money lands in your account, not the week you invoiced. A bill counts in the week you pay it. Depreciation and other non-cash entries don't appear at all, while loan principal, owner draws and sales tax payments do, even though none of them is an expense on your profit and loss statement.
And it's weekly because cash moves weekly. A monthly forecast can show a comfortable month-end balance while hiding a week in the middle when payroll, rent and a tax deposit all go out before the big customer pays.
How to build one, step by step
- Start from reconciled opening cash. Use the balance from your books after the bank accounts are reconciled, not the number in your banking app. The app shows checks and payments that haven't cleared yet as money you still have. If your last reconciliation was months ago, that comes first. A forecast built on a wrong opening balance is wrong in every week after it.
- Lay out receipts by week. Start with your accounts receivable aging: every open invoice, who owes it, and when it's realistically going to be paid. Use each customer's actual payment habits, not your invoice terms. If a customer on 30-day terms reliably pays in 50, forecast 50. Then add expected new sales that will be collected inside the 13 weeks, kept conservative and kept on separate lines so you can see what's booked and what's hoped for.
- Put payroll on its real dates. Net pay goes out on paydays. Add your benefit and retirement contributions on the dates they're actually drafted.
- Add payroll tax deposits on their own schedule. The withheld and employer taxes leave on a different day from the paycheck. Federal deposits follow either a monthly or a semiweekly schedule, set before each year from a lookback period (see below). State withholding and unemployment have their own schedules.
- List payables and recurring bills. Work from your accounts payable aging and add everything that recurs: rent, insurance, software, utilities, vendors on terms. Include sales tax you've collected. It's in your account, but it isn't yours, and it goes out on your filing schedule. Include quarterly estimated taxes if you pay them. Our quarterly estimated taxes guide has the federal dates.
- Add debt and owner items. Loan and equipment payments (principal and interest), credit card payoffs, line-of-credit draws and repayments, and owner draws or distributions.
- Calculate ending cash each week. Opening cash, plus receipts, less disbursements, equals ending cash, which becomes next week's opening cash. Then draw a line at the minimum balance you're comfortable holding, and mark every week that falls below it.
What a few weeks look like
Made-up numbers, to show the shape:
| Week 1 | Week 2 | Week 3 | Week 4 | |
|---|---|---|---|---|
| Opening cash | 42,000 | 51,500 | 23,000 | 31,500 |
| Customer receipts | 18,000 | 6,000 | 21,000 | 9,000 |
| Payroll (net pay) | 0 | (22,000) | 0 | (22,000) |
| Payroll tax deposit | 0 | 0 | (8,500) | 0 |
| Rent, vendors, bills | (6,500) | (9,000) | (4,000) | (11,000) |
| Loan payment | (2,000) | 0 | 0 | 0 |
| Sales tax payment | 0 | (3,500) | 0 | 0 |
| Ending cash | 51,500 | 23,000 | 31,500 | 7,500 |
The profit and loss wouldn't show any of this. Week 4 is the week that matters, and you can see it a month ahead. That's time to chase the slow invoice, move a vendor payment or line up a draw on the credit line.
The tax deposit dates that catch people
Payroll tax deposits are the line owners most often get wrong in a forecast, because the timing has rules of its own. Federally, under IRS Publication 15 for 2026:
- Which schedule you're on is decided before the year starts, from the taxes you reported in a lookback period that, for Form 941 filers, runs July 1 through June 30. If you reported $50,000 or less, you're a monthly depositor; more than that, semiweekly.
- Monthly depositors deposit the taxes on a month's payroll by the 15th of the following month.
- Semiweekly depositors deposit taxes for Wednesday, Thursday or Friday paydays by the following Wednesday, and for Saturday through Tuesday paydays by the following Friday.
- The $100,000 rule: if you accumulate $100,000 or more in taxes on any day during a deposit period, the deposit is due the next business day, whichever schedule you're on.
Separately, Form 941 is filed quarterly, by the last day of the month after each quarter ends. The filing date is not when the cash moves. The deposits are.
Keeping it rolling
A forecast built once and never touched again goes stale within a few weeks. The value is in the weekly routine:
- Close out last week. Replace last week's forecast with what actually happened, from the reconciled bank activity.
- Look at the misses. Which receipts came in late? Which bills were bigger than planned? A miss that repeats is telling you something about a customer or a cost.
- Update the open weeks. New invoices, new bills, a changed payroll, a new loan.
- Add week 14, so you always see a full quarter ahead.
- Check the minimum-cash line and decide now what you'll do about any week below it.
That routine depends on books that are current. If transactions are categorized a month late, the forecast is always comparing itself with stale actuals. That's one reason it pairs naturally with a monthly close.
The warning signs it catches
- Customers paying later. The gap between forecast and actual receipts widens week after week, usually before anyone notices it in the profit and loss.
- Growth eating cash. More sales mean more receivables and often more inventory and payroll up front. A growing business can be short of cash precisely because it's growing.
- One customer carrying the weeks. If a single late payment drops a week below your minimum, you've found a concentration risk.
- The credit line creeping up. Draws that never come back down suggest the business is funding operations with debt.
- Tax payments being pushed. When cash is tight, it's tempting to delay a deposit or a sales tax payment. The forecast shows that pressure before it becomes a penalty notice.
What commonly goes wrong
- Building it from the profit and loss. Revenue isn't receipts, and expenses aren't payments. Start from receivables, payables and the bank.
- Forgetting the lumpy items. Annual insurance, property tax, year-end payroll filings, equipment you're planning to buy. Put them in the week they hit.
- Treating collected sales tax as yours. It belongs to the state until you remit it.
- Optimistic receipts. Forecasting by invoice terms instead of payment history is the most common reason a forecast looks fine and the bank account doesn't.
This is general information, not tax or financial advice for your situation. Deposit rules here are the federal rules for 2026; check anything time-sensitive against the IRS pages linked below before you act on it.
Where these rules come from
- The lookback period, the $50,000 monthly/semiweekly threshold, the monthly and semiweekly deposit days and the $100,000 next-day rule: Publication 15 (2026), Employer's Tax Guide, irs.gov
- The two deposit schedules and deposits by electronic funds transfer: Depositing and reporting employment taxes, irs.gov
- Form 941's quarterly due dates: Employment tax due dates, irs.gov
- Tracking money in and money out, and keeping watch over cash, receivables, payables and bank reconciliation: Manage your finances, sba.gov