Skip to content

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.

In short: a 13-week forecast lists, week by week, the cash you expect to come in and go out over the next quarter, starting from your reconciled bank balance. You build it from your receivables, your payroll calendar, your tax deposit schedule, your bills and your loan payments. Each week you replace the oldest week with actual results and add a new week at the end. Its job is to show you a tight week while there's still time to do something about it.

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

  1. 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.
  2. 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.
  3. 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.
  4. 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.
  5. 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.
  6. 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.
  7. 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 1Week 2Week 3Week 4
Opening cash42,00051,50023,00031,500
Customer receipts18,0006,00021,0009,000
Payroll (net pay)0(22,000)0(22,000)
Payroll tax deposit00(8,500)0
Rent, vendors, bills(6,500)(9,000)(4,000)(11,000)
Loan payment(2,000)000
Sales tax payment0(3,500)00
Ending cash51,50023,00031,5007,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:

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:

  1. Close out last week. Replace last week's forecast with what actually happened, from the reconciled bank activity.
  2. 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.
  3. Update the open weeks. New invoices, new bills, a changed payroll, a new loan.
  4. Add week 14, so you always see a full quarter ahead.
  5. 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

What commonly goes wrong

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

Want a forecast someone keeps current? Cash flow forecasts are work we do every month, built from books we close and reconcile, so the numbers in week one are real. We'll show you the tight weeks early and what your options are. See our services or book a free 15-minute call →

Let's close your books

Book a free 15-minute call.

Tell us what you run and how far behind the books are. You'll usually leave with a price and a plan, or get the price by email within a day.

Book a free 15-minute call
Book a free 15-minute call