13-week forecasting
Late Invoices Are Up. Here's a Simple 13-Week Cash Forecast to Survive Them
Late invoices got worse in 2026, and a monthly P&L will not tell you which payroll week is at risk. This post uses Intuit's late-payment data and walks an owner through a simple 13-week cash forecast they can build in a spreadsheet.
Your customer saying "it's in the mail" is not a cash plan.
Intuit's 2026 Late Payments Report found that 59% of small businesses have invoices overdue 30 or more days, up from 47% the year before. The average amount sitting out there was $17,700. And 39% of owners said a single late payment made it hard to cover payroll or bills.
It does not take a huge invoice to cause that kind of week. In the same report, a late payment under $1,000 was enough to strain 12% of owners, and 27% cited a missed payment under $5,000. Forty-nine percent said standard payment-processing times create cash-flow gaps even after the customer has already paid. The money can be "approved" and still not be in your account when rent is due.
Late invoices are not a new invention. What changed is the frequency, and what has not changed is how most owners watch for them: a monthly P&L, a bank-app glance, and a tight feeling the week before payroll. That is too late.
A 13-week cash forecast is the simplest way I know to see a late invoice before it hits a payroll Friday. You can build one this week in a spreadsheet. If you later want the same view connected to QuickBooks and your banks automatically, that is what Everage is for. Either way, the logic belongs to you.
Why a monthly P&L will not save you
A P&L tells you whether the month was profitable. It does not tell you whether week six is short.
Profit can look fine while a large invoice ages past 30 days, a tax payment lands on a Tuesday, and payroll hits on a Friday. The Federal Reserve's 2026 Report on Employer Firms found that 50% of employer firms reported uneven cash flow, including trouble collecting on receivables, and 54% had trouble paying operating expenses such as payroll, rent, or inventory. Intuit's July 2026 Insights survey, which covers the U.S., Canada, the UK, and Australia, found that 44% of small businesses reported cash-flow problems, and 53% still use spreadsheets for financial management. Spreadsheets are fine. A stale spreadsheet is not.
If you want the deeper weekly operating rhythm for a team, we already published a QuickBooks cash-flow forecasting playbook. This post is the owner version: a survival forecast you can stand up in an afternoon, built around the fact that invoices are arriving later.
Build a 13-week cash forecast in seven steps
Open a new Google Sheet or Excel file. Put "Starting cash" in the first column, then 13 week-ending dates across the top, starting with this week. That is the whole skeleton.
-
Enter today's real cash, not last month's books. Use the balances in the bank accounts you actually pay bills from. If QuickBooks and the bank disagree, trust the bank for this exercise and fix the books later. If you have tax money set aside in the same account, do not treat it as spendable starting cash.
-
List inflows by the week you will actually collect them. This is the step most forecasts get wrong. Do not drop an invoice into the week you sent it, or even the week it is "due," unless that customer really pays on time. Look at how each customer has been paying. Put expected collections, Stripe or Square payouts, Shopify deposits, and any other cash you have a reason to expect, in the week they are likely to land. If 59% of businesses are waiting more than 30 days, assume your slow payers will not suddenly become fast this quarter.
-
Be conservative with the maybes. If a collection is a maybe, put it in a later week or leave it out of the base case. You can add a second row for "upside if they pay on time." Do not build payroll around upside.
-
List outflows on the dates they leave the account. Payroll, rent, insurance, loan payments, sales tax, vendor bills, inventory purchases, subscriptions, and owner draws. Use the dates you actually pay, which may be earlier than the due date if you pay on a schedule, or later if you have been stretching vendors. Do not forget the payments that never show up as a QuickBooks bill, like a quarterly estimated tax.
-
Calculate a running balance, week by week. Starting cash plus that week's inflows minus that week's outflows equals the ending cash for the week. That ending number becomes the starting cash for the next week. The math is not fancy. The honesty is the work.
-
Mark the danger weeks. Highlight any week where the ending balance goes negative, or where it falls below the cash cushion you are not willing to breach. If you have not calculated that cushion yet, start with how to measure your cash-buffer days. The typical small business in a JPMorgan Chase Institute sample held only 17.6 days of cash. You want to see a week that would take you under your floor while you still have time to move.
-
Attach an action to every ugly week. A red cell with no owner is just a bad feeling. For each short week, write one specific move: call this invoice, wait to place that purchase, move this vendor payment by one week, or hold a draw. If the leak is collections, use the AR/AP automation playbook to set a simple follow-up rhythm. If the cash is sitting in inventory, read the ecommerce inventory and cash runway guide.
What the forecast should change this week
The point of 13 weeks is not to predict the future. It is to stop being surprised by a calendar you already have.
If week four looks tight because a large invoice is likely to slip, the move is this week, not in week four. Send the reminder. Time a purchase to land after a deposit you trust. Intuit also found that 74% of small businesses are not fully automated on bill pay. That cuts both ways. You may be paying faster than you are getting paid. The forecast is where you see that mismatch in a real week.
One rule that keeps this from turning into fiction: never let an overdue invoice sit in the forecast as if it will still arrive "on terms." Once it is late, move it out until you have a reason to believe otherwise.
Keep it alive, or it will rot
Update the sheet every week, on the same day, before you approve spending. Compare what you thought would happen last week with what actually happened. If the same customer slips every time, stop forecasting them as on-time. Thirteen weeks is long enough to see a quarter of payrolls, rent, and tax dates, and short enough that you will actually maintain it.
If building this by hand every Monday is exactly the chore you are trying to escape, a live cash-flow workspace can pull the same pieces from the tools you already use. Everage includes a rolling 13-week cash-flow forecast and a unified view of receivables, payables, and bank activity, with connections to QuickBooks, Plaid, Stripe, Square, Shopify, and CSV. It sits on top of QuickBooks. It does not replace it.
See the late invoice before it sees payroll
Late invoices are more common than they were last year. That does not have to be the week you find out.
Build the 13-week forecast. Mark the first ugly week. Take one action today that makes that week less ugly. When you want that forecast to update from your actual books and bank activity, start free at Everage or book a 30-minute demo. Bring the overdue invoice that is making you nervous.
Sources & further reading
From insight to action
Your cash story. All in one place.
Connect your books, banks, and payment tools. See what’s coming while there’s still time to act.