What it is, and what it is not
A budget says what you plan to earn and spend this year. A P&L says what you earned and spent last month. Neither tells you whether the account will cover the July 24 payroll. That is the only job of the 13-week forecast, and it does it by ignoring most of what accounting cares about: no depreciation, no accruals, no interest in when a sale was earned, only in when the money lands.
Direct method cash forecasting is the practice of listing expected receipts and payments individually, by date, rather than starting from profit and adjusting it. Every 13-week forecast uses the direct method. The indirect method, which begins with net income and adds back non-cash items, is how the cash flow statement in QuickBooks is built, and it explains last quarter well enough while being no help with next Friday.
Abacum, which sells planning software, puts the share of companies using any rolling forecast at 19 to 25 percent and says 96 percent still plan in spreadsheets. The figure for owners with fewer than 50 staff is not published anywhere we can find. The templates that rank for the term have 40 rows and assume a finance team, and the one an owner needs has about twelve.
Building one in about an hour
Start with opening cash. Opening cash is the cleared balance in every business bank account this morning, added together, less checks written but not yet cleared. Use the bank, not the QuickBooks balance, unless the bookkeeper reconciled last week. If you have a line of credit, note the available amount on a separate line. It is not cash, and putting it on the same line is how owners talk themselves into a hire they cannot fund.
Then receipts, week by week. Your sales pipeline is a poor predictor of next month's collections; the accounts receivable aging report and the last six months of deposits are much better. Accounts receivable aging is a report that lists every unpaid invoice by how long it has been outstanding, in buckets of current, 1 to 30, 31 to 60, 61 to 90 and over 90 days. Apply the collection rate you actually see to each bucket. For most service businesses, current invoices mostly arrive within four weeks, 31-to-60 invoices at about half that rate, and anything over 90 days should be forecast at zero until it shows up. Add card and cash sales from the same weeks last year. The receipts line will be wrong, but wrong in known ways. We cover reading the aging report as next month's cash separately.
Payments are easier because you control most of them. Payroll goes in on its actual dates, gross plus employer taxes, with the three-run months marked. Rent, insurance, loan and lease payments go in on their due dates. Debt service is the total of principal and interest due on every loan in a period; it belongs in the forecast in full, even though only the interest ever reaches your P&L. Accounts payable comes from the AP aging, spread over the weeks you intend to pay it. Add sales tax remittances, estimated tax deposits, and your own draws. Owners forget draws more often than anything else.
The last line is closing cash: opening cash plus receipts minus payments, which becomes next week's opening cash. If any week's closing cash is below the next payroll, you have found the thing the forecast exists to find.
The version for an owner with several companies
Nearly every 13-week template assumes one company and one bank account. The owners who need the forecast most tend to have three of each. Build one column set per company, then a total. Cash in the property LLC is not cash in the operating company unless you move it, and moving it has tax and lender consequences, so keep them separate and add a line for the transfers you plan to make. If the holding company sweeps cash on the first of the month, put the sweep in both forecasts, out of one and into the other, on the same date. The consolidated total should not change when you do this. If it does, you have booked the transfer once.
Decide which company funds payroll. Shared staff paid from one entity and recharged to another show up as an outflow in one forecast and a receivable in the other, so forecast the settlement on the date it usually happens, not the date it should. The same goes for the management fee: if the operating company pays the holding company $8,500 on the 15th, that is a real movement in both forecasts and nets to zero in the total. Where a company has several bank accounts, use a line per account. The total matters for the business; the individual balances matter for the overdraft.
Reading it: the low week and the three levers
Once built, the forecast has one number that matters: the lowest closing cash in the thirteen weeks, and which week it falls in. Find the low week, then ask what causes it. Usually it is a collision: a three-payroll month, a quarterly tax deposit and an annual insurance premium landing within ten days of each other, on top of a slow collections month. None of those is a surprise on its own. Together they are why QuickBooks' Business Ownership in 2026 survey of 1,305 owners found that 39 percent had struggled to cover payroll or bills because of a single late customer payment, and why its 2025 late-payments research found 47 percent carrying invoices more than 30 days overdue.
The levers are the same three every time. Pull receipts forward: call the four largest current invoices before they are due, offer a small discount for payment this week, or bill the milestone you have already hit. Push payments back: ask the two largest vendors for fifteen days, move a draw, defer a purchase. Or bring in outside cash, which means drawing the line or arranging one before you need it. The forecast tells you which lever, how much, and by when, six weeks before the bank statement would.
What the forecast cannot do is predict a customer who stops paying, a job that overruns, or a tax bill your CPA has not mentioned. It lists what you know. Abacum's guidance is 85 to 90 percent accuracy on near-term receivables. In weeks nine to thirteen it is a sketch, and that is fine, because those weeks exist to give you time rather than precision.
A worked example: the deposit that was counted twice
On Monday, July 6, the owner of an HVAC contractor with 34 staff sits down to build his first forecast. Payroll runs every other Friday at $87,600, and the bookkeeper closes the books about three weeks after month end. Opening cash across both accounts is $212,300. He spreads the $486,000 on the AR aging over the coming weeks by bucket. Payments come from the AP aging, the payroll calendar, the loan schedule and a $31,000 estimated tax deposit due in week 6.
The first pass looks comfortable: the low week is week 8 at $127,500. Then he notices that the aging still shows a $148,000 progress invoice from May as open. The customer paid it on July 1. The money is in the bank, which is why it is in the opening cash, but the bookkeeper has not applied the payment, so it is also sitting in the aging as a receipt due in week 2. It has been counted twice.
| Week | Receipts | Payments | Closing cash, first pass | Closing cash, corrected |
|---|---|---|---|---|
| 1 | $41,200 | $50,300 | $203,200 | $203,200 |
| 2 | $215,800 | $109,700 | $309,300 | $161,300 |
| 3 | $58,400 | $55,450 | $312,250 | $164,250 |
| 4 | $49,900 | $119,600 | $242,550 | $94,550 |
| 5 | $72,300 | $53,900 | $260,950 | $112,950 |
| 6 | $44,100 | $143,400 | $161,650 | $13,650 |
| 7 | $63,700 | $43,550 | $181,800 | $33,800 |
| 8 | $55,200 | $109,500 | $127,500 | −$20,500 |
Remove the $148,000 and week 6 closes at $13,650 after the tax deposit, and week 8 goes to negative $20,500 on payroll day. The business is not in trouble; it has $63,700 due in week 7, $55,200 in week 8 and a line it has never drawn. But on the first pass the owner was about to approve a $42,000 truck for week 5. On the corrected pass he moves the truck to September, calls the two customers behind the week 7 receipts, and asks the bookkeeper to apply payments weekly rather than at close. That last request is the one that matters. A forecast built from a stale aging will make this mistake every quarter.
Keeping it alive
A 13-week forecast that is built once and admired is a spreadsheet. The tool is the rebuild. Every Monday, replace the opening cash with the real balance, drop the week that just happened, add a new week thirteen, and compare what you forecast for last week with what arrived. That difference is the most useful number you will see all week, because it tells you which assumption is wrong.
Common advice says to update monthly if weekly is too much. We would say the opposite: a monthly 13-week forecast is a nine-week forecast with a four-week blind spot at the front, which is where the payroll is. If weekly is not possible, fix what is making it impossible, which is nearly always payment application and bank feeds nobody reconciles.
Navigator Pro does the rebuild for you. It reads every QuickBooks Online file each morning, read-only, and redraws the 13-week plan per company and in total, so the low week and its cause are in the morning brief before you have opened a spreadsheet, and you can test a hire, a truck or a price change against it. The base Navigator plan shows cash and AR and AP aging but not the forecast; the tiers are on the pricing page.
Mistakes we see most
Forecasting from the sales pipeline instead of the aging, which is how a good sales month becomes a bad cash quarter. Leaving out owner draws because they are discretionary; they are, right up until the week you need them. Booking the line of credit as cash. Treating sales tax collected as revenue when it is money you hold for the state. And the one from the example: building from an aging nobody has applied payments to.
The margin for these errors is thin. A 2016 JPMorgan Chase Institute study of 597,000 small firms found the median business held 27 days of cash. At that level the low week is never far away. If the underlying question is why there is less cash than the P&L suggests, why net income and the bank balance disagree traces it, and how many days of cash you should hold turns the low week into a target.
Questions owners ask
How accurate should a 13-week cash flow forecast be?
Near-term weeks should be close. Abacum's guidance is 85 to 90 percent accuracy on receivables in the first few weeks, and payments should be closer than that because you control them. Weeks nine to thirteen will drift, which is expected. A receipts line that misses by the same margin three weeks running is telling you to change a collection assumption.
Can a 13-week forecast replace the annual budget?
No. The budget sets what you intend to spend and earn over a year and is compared to the P&L. The 13-week forecast answers whether the bank account covers the next quarter's payments, and is compared to the bank statement. Businesses with tight cash rely on the forecast far more, but the budget still sets the targets.
Should I use the direct or indirect method?
Direct. List each expected receipt and payment by week, starting from the bank balance. The indirect method starts from net income and adjusts for non-cash items, which is how the cash flow statement in QuickBooks is built and is useful for explaining last quarter. It cannot tell you which Friday is short, because it does not know about dates.
How often should I update it?
Weekly, on the same day. Replace opening cash with the actual bank balance, drop the past week, add a new week thirteen, and compare last week's forecast to what happened. A monthly update leaves a four-week blind spot at the front, which is exactly where payroll sits. If weekly feels impossible, the books are usually the problem.
What if I have several companies?
Build one forecast per company, each from its own bank accounts, and a total underneath. Put planned transfers between companies on both sides on the same date so the total does not change. Decide which entity funds payroll and forecast the recharge to the others on the date it usually settles. Cash in your property LLC is not available to the operating company until you move it.
Related
If the question behind the forecast is why there is less cash than the P&L suggests, start with why net income doesn't match your bank balance. How much cash reserve a business should hold turns the low week into a number of days to keep. If a lender is involved, debt service coverage ratio for business owners explains the ratio the bank runs on the same loan payments.
If you would rather have the forecast rebuilt every morning than every Monday, the trial connects to QuickBooks Online in about fifteen minutes and needs no card: navigatorhq.ai.
Published . Last updated . Reviewed by a CFO on the Navigator team.