What is a rolling 13 week forecast template and how do I build one for my business?

A rolling 13 week forecast template is a spreadsheet or software model that projects your cash inflows and outflows 13 weeks ahead, updated every week so the forecast window always moves forward with you. It is the single most widely used liquidity tool in commercial lending, turnaround management, and distressed business situations. Lenders, restructuring advisors from firms like CLA and KPMG, and bankruptcy courts treat the 13-week cash flow forecast as the standard instrument for judging whether a company can pay its bills. If you want the definitive version of this tool, here is exactly what it is, why 13 weeks, how to build one, and where spreadsheets fall short.

What a Rolling 13 Week Forecast Actually Is

Also worth reading: How Should a Small Business Forecast Cash Flow in 2026? · How Can an AI Cash Flow Coach Help SMBs Build a Better Weekly Cash Flow Template? · How Can SMBs Forecast AI Costs and Build a Realistic Savings Plan for 2026?

The rolling 13 week forecast is a week-by-week projection of cash on hand, beginning with your opening bank balance and adding expected receipts (customer collections, loan draws, tax refunds) and subtracting expected disbursements (payroll, rent, supplier payments, tax remittances, debt service). Each column represents one week, giving you 13 columns of projected ending cash. The word 'rolling' means the entire model shifts forward one week at a time: each Monday you drop the oldest week, add a new thirteenth week, and replace last week's projections with what actually happened.

The output that matters most is the weekly ending cash line. When ending cash dips below a minimum operating threshold, typically one to two weeks of payroll plus critical supplier obligations, you have identified a funding gap roughly a quarter in advance. That lead time is the entire point. A profit and loss statement tells you whether you were profitable last month; the 13 week forecast tells you whether you will miss payroll in November while it is still September, which is when you still have options.

The framework is also diagnostic. Because every line item is a discrete weekly assumption, variance between forecast and actual points to the specific driver: collections running eight days slower than assumed, a supplier shortening terms, or a seasonal inventory purchase landing at the wrong time. Treat it as a living operating document, not a finance department artifact.

Why Exactly 13 Weeks (and Not 12 or 26)

Thirteen weeks is one quarter expressed in the smallest practical planning unit. Weekly granularity matters because cash crises unfold on weekly cycles: payroll runs weekly or biweekly, supplier terms often sit at net 30, and tax deposits follow fixed calendars. Monthly forecasting averages away exactly the intra-month dips that put companies in trouble, a company can show positive average cash for October and still bounce a payroll check on the 14th.

The 13 week horizon balances precision against foresight. Forecast accuracy decays quickly with time: receipts and disbursements two weeks out might be predictable within 5 to 10 percent, while week 13 might carry 20 to 30 percent error. Beyond roughly one quarter, weekly-level forecasting becomes guesswork, so a 26-week weekly model buys little real information. Anything shorter than a quarter is too short to react to what you see, since many remedial actions, renegotiating terms, arranging a line increase, collecting a large receivable, take 6 to 10 weeks to execute.

The rolling element is what makes it powerful rather than static. A forecast built once in January and reviewed in April is stale by February. Rolling weekly keeps the near-term weeks highly accurate, because near-term assumptions keep getting corrected against actuals, and pushes out the horizon continuously. Turnaround professionals, including those following insolvency warning-sign guidance published by firms like Mayer Brown, use the rolling 13 week specifically because courts and creditors accept it as evidence of a company's liquidity trajectory and management's grip on the business.

How to Build One: Step by Step

Start with the skeleton. Columns: week beginning date (week 1 should start this week, not next Monday), receipts section, disbursements section, net cash flow, opening balance, ending balance, and a row for minimum cash covenant or comfort level. Rows under receipts: cash sales, collections on receivables (broken into current, 30-day, 60-day, 90-plus buckets), other income. Rows under disbursements: payroll and payroll taxes, rent, suppliers, insurance, debt principal and interest, capital expenditures, owner draws or dividends, taxes.

Now populate it with real data, and this is where most templates die. Opening balance comes from your actual bank balance, not your book balance, book cash includes uncleared checks and deposits in transit. Collections should be built from your actual aged receivables ledger: if you have $180,000 in receivables and historical collection behavior shows 40 percent collected within 30 days, 30 percent in 31 to 60, and 15 percent beyond 90, apply those percentages to the aging buckets rather than assuming invoices are paid on their due dates, because they generally are not. Payroll should reflect your actual pay calendar including the two extra-three-paycheck weeks that hit biweekly employers twice a year.

Build in mechanics before pretty formatting: a receipts subtotal, a disbursements subtotal, net flow = receipts minus disbursements, ending balance = opening plus net flow, and next week's opening = prior week's ending. Add a variance row that compares last week's projection to actual, this single row is what converts the template from a one-time exercise into a rolling discipline. Set conditional formatting so ending cash below your minimum threshold turns red. Expect the first build to take 4 to 8 hours; the weekly update after that should take 30 to 60 minutes once your collections assumptions are calibrated.

Spreadsheet Template vs Dedicated Software

The honest comparison is a manually maintained Excel or Google Sheets template against purpose-built cashflow tools, including AI-driven platforms like GlassJAR that automatically sync transactions and surface variances. Both can work; they fail in different ways.

Spreadsheets remain the right answer for many businesses under roughly $2 million revenue with simple collections, and they are what most lenders will ask you to email them anyway. The case for software strengthens sharply when your receivables exceed a few dozen open invoices, when multiple people need to touch the forecast, or when the weekly manual update keeps slipping, the most common reason rolling forecasts fail is not bad math but abandonment. Automated tools remove the friction that causes abandonment, and AI-driven categorization reduces the collection-assumption guesswork by learning your actual customer payment behavior. The trade-off is recurring cost and the need to verify that the tool's logic is visible rather than a black box.

Common Mistakes That Ruin a 13 Week Forecast

The first and most damaging mistake is forecasting collections as if invoices were paid on their due dates. Real-world SMB collection behavior routinely runs 10 to 20 days past terms; if your terms are net 30 and you assume payment in week 4, you are systematically overstating near-term cash by weeks of payroll. Build the forecast off aged balances and measured payment behavior, not invoice dates.

The second mistake is ignoring the roll-forward discipline. A forecast that is not updated against actuals within a few days of week end loses its calibration, and its accuracy decays visibly by week 6 or 7. Third: mixing accrual and cash logic, booking a sale as a receipt when it is invoiced rather than when cash lands is the classic accounting-trained error that makes the model useless for liquidity. Fourth: forgetting lumpy but predictable items, quarterly payroll tax filings, insurance premiums, estimated income tax payments due in January, April, June, and September, and annual debt principal payments. These are known dates with known amounts; missing them creates phantom crises and erodes trust in the tool.

Fifth: hiding problems with optimism. If week 9 shows negative $40,000 and you quietly move a supplier payment out two weeks to make it look survivable, you have destroyed the document's purpose. Lenders and boards read the raw model. Finally: excessive granularity. A 200-line template no one can maintain in an hour is worse than a 40-line template that gets updated every single week.

When You Need One and How Fast to Act

Build a rolling 13 week forecast if any of the following is true, and treat the trigger dates seriously. You are losing money on a monthly basis. Your receivables exceed 60 days sales outstanding. You have less than two months of fixed operating costs in cash. You have a credit line you depend on, or a covenant requiring minimum liquidity. You are growing faster than 25 percent annually, growth consumes cash through inventory and receivables even when profitable. Or a lender, investor, or board member has asked for one, which in turnaround contexts is often a formal requirement rather than a suggestion.

If a crisis is already visible, payroll risk within the next two months, act within days, not weeks. The model is fastest to build precisely when you most need it because your data is fresh in your mind, and the output immediately tells you the size and timing of the gap you must close. If you are healthy, start it anyway but at lower intensity: a 90-minute build and a monthly review cadence is defensible when cash is stable, upgrading to full weekly rolling when warning signs appear. The cost of building one, essentially an afternoon and a spreadsheet, is trivially small against the cost of discovering a funding gap two weeks before payroll instead of ten.

Caveats and Honest Limitations

A 13 week forecast is not a strategy, and it is worth being blunt about what it cannot do. It cannot fix a business that is structurally unprofitable; it only tells you the date the money runs out, which is why turnaround advisors pair it with profitability and working-capital actions. Its accuracy collapses at the far end of the horizon, so decisions affecting week 12 and 13 should be revisited weekly as those weeks come into sharper focus. It also depends entirely on input discipline: a forecast fed with sales that will not close and receivables that will not collect produces confident-looking nonsense, which is arguably more dangerous than no forecast at all.

It also carries reporting obligations. Once you circulate a rolling 13 week to a lender or board, stopping the updates or producing them irregularly signals loss of control, and creditors may read the gap between forecast and actual as a distress indicator in its own right. Treat the commitment as ongoing. Done properly, weekly, honest, and variance-checked, it is the highest return-per-hour financial discipline available to a small or mid-sized business, and pairing the spreadsheet discipline with automated data capture, as tools like GlassJAR do, simply lowers the cost of keeping it alive.