How to Build a Simple Rolling Forecast for the Next 13 Weeks

A 13-week rolling forecast is a weekly cash-flow model that shows expected cash in, cash out, and ending cash balance for the next quarter. It is most useful when a business needs a practical view of liquidity, not a long-range profit projection.

TL;DR: Build the forecast from bank cash, receivables, payables, payroll, debt payments, tax dates, and expected sales receipts. Update it every week, roll the window forward, compare forecast to actuals, and use the variance to improve the next version.

Why Thirteen Weeks Is a Useful Window

Thirteen weeks is long enough to reveal payroll cycles, vendor obligations, tax dates, debt payments, and receivable timing. It is short enough that the owner or finance team can still make informed calls before the numbers become guesswork. The Federal Reserve’s small business research resources emphasize the importance of practical financial information for small firms, and a rolling forecast turns that information into a weekly routine.

Unlike a budget, the rolling forecast does not try to describe the entire year. Unlike an income statement, it does not focus on accounting profit. It answers a narrower question: how much cash is likely to be available each week if expected collections and payments happen as planned?

This distinction matters because profitable businesses can still run short of cash. Slow-paying customers, inventory purchases, delayed financing, seasonal payroll, or tax deposits can pressure liquidity even when sales look healthy. A 13-week forecast gives management a place to see those timing gaps early.

Documents and Numbers to Have Ready

• Before building the model, gather current bank balances, open invoices, customer payment expectations, accounts payable, payroll schedules, loan payment dates, rent, insurance, tax deposits, subscriptions, inventory purchases, owner draws, planned capital spending, and available credit lines. If the business accepts card and bank payments, compare settlement timing with actual deposits. The discussion of account-to-account payments vs card payments can help clarify why payment rails affect cash timing.
• Use actual bank cash as the starting point. Do not start with book cash unless it has been reconciled. Add separate lines for restricted cash, credit-card reserves, merchant holds, or escrowed funds when those amounts cannot be freely used for operations.
• Keep the first version simple. A forecast that is updated weekly is more useful than a complex model nobody trusts. The usual columns are Week 1 through Week 13. The usual rows are beginning cash, cash receipts, cash disbursements, net cash flow, ending cash, and notes.

Build the Model Step by Step

Step 1: Enter the beginning cash balance from reconciled bank accounts. Step 2: Add expected customer receipts by week, using invoice due dates adjusted for actual customer behavior. Step 3: Add recurring revenue, deposits, retainers, or subscription receipts where applicable.

Step 4: Add cash outflows by category. Payroll, payroll taxes, rent, debt service, vendor payments, insurance, utilities, software, inventory, contractor payments, and owner distributions should not be buried in one line. Step 5: Calculate ending cash as beginning cash plus receipts minus disbursements. Step 6: roll the ending balance into the next week’s beginning balance.

Step 7: Add a minimum cash target. This is not a universal number; it depends on payroll size, operating risk, seasonality, and access to credit. The target gives the business a warning line. When projected ending cash drops below the target, management can evaluate collection calls, expense timing, credit options, or inventory decisions.

A Simple Forecast Layout

How to Review It Every Week

Set a fixed review day. Enter actual receipts and payments for the week just completed, compare them with forecasted amounts, and explain major variances. Then roll the forecast forward by adding a new week at the end. The model should always show the next 13 weeks, not simply count down to zero.

Use variance notes to improve assumptions. If a customer always pays ten days late, adjust the collection week. If payroll taxes are routinely missed in the first draft, add a separate line. If vendor payments are negotiated, update dates immediately rather than leaving old assumptions in place.

A rolling forecast is also useful when preparing for financing. Lenders may ask how a business manages liquidity, and a consistent forecast can support the conversation. It does not guarantee approval, but it can show that management understands cash timing. For broader household-style planning ideas, a one-page personal financial dashboard uses a similar discipline at the personal level.

Mistakes That Make the Forecast Unreliable

The biggest mistake is confusing revenue with receipts. A sale only helps cash when money is collected. The second mistake is entering optimistic collection dates without checking customer behavior. The third is forgetting large but irregular payments such as insurance renewals, estimated taxes, equipment deposits, or annual software contracts.

Another warning sign is a forecast that never changes. A rolling forecast should respond to actual information. If every weekly update simply copies the old plan, the model is not being used as a management tool.

Be careful with financing assumptions. Do not show a new loan, investor payment, or credit-line draw as available cash until the terms are documented and access is realistic. Contingent funding can be shown in a separate scenario, but it should not hide an operating shortfall.

Scenario Planning for Cash Pressure

After the base forecast is complete, add two simple scenarios. The first should show delayed collections, such as top customers paying one or two weeks later than expected. The second should show a planned cost increase, such as inventory, hiring, insurance renewal, or equipment repair. These scenarios help the owner see which weeks are most sensitive to timing changes.

Do not overbuild scenarios. A useful version changes a few assumptions and shows the effect on ending cash. If a delayed receivable creates a payroll problem in Week 7, management can begin collection calls, negotiate vendor timing, or speak with a lender in Week 2. That is the practical value of the model.

The forecast should also show which actions are inside management control. Calling customers, invoicing earlier, pausing discretionary spending, or staging purchases may be realistic. Hoping for a new loan by Friday may not be. Separating controllable actions from uncertain events keeps the forecast honest.

Governance for a Small Team

Assign one owner for the model and one reviewer. The owner updates actuals and assumptions. The reviewer challenges timing, missing payments, and optimistic collection dates. Even in a small business, this second set of eyes can catch errors before the forecast is used for payroll, inventory, or financing decisions.

Save each weekly version rather than overwriting history. The archive helps the business learn whether it consistently overestimates receipts, underestimates vendor payments, or misses tax dates. Over time, those lessons make the model more reliable and reduce surprise cash gaps.

Turning the Forecast Into Decisions

Once the forecast is working, use it to rank actions by urgency. Weeks with projected cash gaps may call for earlier invoicing, tighter collections, staged vendor payments, spending pauses, or financing conversations. Weeks with excess cash can support inventory purchases, debt reduction, reserves, or planned growth spending.

The forecast should remain educational and operational, not a substitute for professional advice. Businesses facing distress, covenant concerns, tax debt, or payroll risk should speak with a CPA, attorney, turnaround advisor, or lender before making commitments. The best 13-week forecast does not predict the future perfectly. It makes cash decisions visible early enough to act.

Visual Direction: How to Build a Simple Rolling Forecast for the