The 13-Week Cash Flow Forecast: A Step-by-Step Template

1. What Is a 13-Week Cash Flow Forecast?

A 13-week cash flow forecast is a rolling, week-by-week projection of every dollar entering and leaving your bank accounts over the next quarter. It uses the direct method: actual receipts and disbursements, not accrual accounting. The output is a single number per week — your projected closing cash balance — and a clear picture of where that balance dips below your minimum threshold.

If your P&L tells you whether you're profitable, the 13-week forecast tells you whether you'll still be solvent on Friday.

2. Why 13 Weeks (and Not 4 or 26)?

Thirteen weeks is the universal short-term forecast horizon for three reasons:

1. It equals one fiscal quarter, aligning with board reporting, debt covenants, and tax payment cycles.
2. It's long enough to act. Spotting a cash gap in week 9 today gives you 60+ days to draw on a line of credit, accelerate collections, delay non-critical AP, or raise capital.
3. It's short enough to be accurate. Beyond 13 weeks, AR aging and AP commitments stop being reliable inputs and forecasts collapse into guesswork.

3. Direct vs Indirect Method (and Why You Want Direct)

There are two ways to forecast cash flow:

For a 13-week horizon, always use the direct method. You're not trying to reconcile to GAAP — you're trying to predict whether the bank balance clears payroll on the 30th.

4. The 13-Week Template Structure

Every solid 13-week template — whether in Excel, Google Sheets, or software — has the same row structure. Columns are weeks (W1 through W13); rows are line items grouped into four blocks:

The closing balance of week N becomes the opening balance of week N+1. That single roll-forward is the heart of the model.

5. Build It: 7 Steps

1. Set the opening cash balance. Pull every operating bank account as of Monday of week 1. Reconcile to the GL before starting — start dirty, stay dirty.
2. Forecast cash receipts by week. Use AR aging and historical DSO. Add new bookings only when probability-weighted from the CRM.
3. Forecast cash disbursements by week. Schedule AP, payroll, rent, debt service, taxes, and capex by their actual due dates — never by accrual.
4. Calculate weekly net cash flow. For each week: Receipts − Disbursements = Net Change.
5. Roll the closing balance forward. Add net cash flow to prior week's closing. Conditionally format any week below your minimum cash threshold.
6. Compare to last week's forecast. Run a variance report: actual vs forecast for week 1. Investigate any line item with >5% variance.
7. Roll forward and republish. Drop the completed week, add a new week 13, republish every Monday before noon.

6. Modeling Cash Receipts (Where Forecasts Live or Die)

Receipts are the hardest block to get right. Three rules:

6.1 Drive from AR aging, not from invoices

An invoice dated today doesn't pay today. Use historical DSO by customer (or customer tier) to schedule the cash week. Net-30 customers with 12-day average lateness pay in week 6, not week 4.

6.2 Probability-weight new bookings

Don't assume 100% of pipeline closes. Multiply forecasted deals by stage probability and apply DSO on top:

Forecasted cash week = Deal value × Close probability × (1 if expected close week + DSO falls in horizon)

6.3 Separate one-time and recurring

Tax refunds, asset sales, and financing draws should live on their own lines. Mixing them with operating receipts is the #1 way to deceive yourself about run-rate cash generation.

7. Modeling Disbursements (Easier — but Don't Get Lazy)

Disbursements are more predictable than receipts because most are contractually scheduled. Group them into fixed, variable, and one-time:

The single most missed disbursement: quarterly estimated taxes. Put them on the calendar permanently and tag the cells.

8. The Weekly Variance Review (The Habit That Makes It Work)

A 13-week forecast that isn't reviewed against actuals is decoration. Every Monday, run a 30-minute variance meeting that answers four questions:

1. Where did we beat or miss last week's forecast, by line item?
2. Why? Timing, amount, or missing item?
3. What does that change in weeks 2–13?
4. What action do we take this week (collections call, AP delay, draw on credit line)?

9. The 8 Most Expensive 13-Week Forecast Mistakes

1. Forecasting accrual revenue as cash. Booked ≠ collected.
2. Using one DSO for all customers. Enterprise pays in 60+, SMB pays in 15. Segment.
3. Ignoring intra-month timing. Payroll on the 15th and AR on the 30th creates a real, weekly cash gap.
4. Skipping the variance review. No review = no learning = no improvement.
5. Hiding tax payments. Quarterly estimated taxes blow up more SMBs than any other line item.
6. Not modeling the credit line. Show the draw and the repayment — both affect cash and covenants.
7. Forecasting in months, then dividing by 4. Cash doesn't move evenly; this hides the gaps you most need to see.
8. Single point estimates only. Run a base, downside, and upside scenario every week.

10. Scenario Planning: Base, Downside, Upside

A serious 13-week forecast carries three scenarios in parallel:

Define the trigger threshold in advance: "If projected closing cash in any week of weeks 5–13 falls below $X, we move to the downside playbook automatically." Pre-committing the decision prevents panic.

11. Spreadsheet vs Software: When to Switch

Spreadsheets are great until they aren't. Switch to dedicated cash flow software when any of these is true:

• You spend more than 2 hours a week rebuilding the forecast.
• You manage more than one entity or currency.
• You need to share with non-finance stakeholders (founders, investors, lenders).
• Your variance is consistently >10% in week 1 — that's a data integration problem, not a model problem.
• You want scenarios that update automatically when AR, AP, or pipeline changes.