M3 Financial Consulting
Menu

Guide · Cash

How to build a 13-week cash flow forecast

A 13-week cash flow forecast projects cash in and out of the business week by week for the next quarter. It starts from the actual bank balance, adds expected customer receipts, subtracts payroll, vendors, rent, debt service, taxes and capital spending, and ends each week with a closing balance measured against a minimum cash line. It is rolled forward and compared with actual results every week.

By Michael Alvarez III, Fractional CFOUpdated 8 min read

Key takeaways

  1. 01

    Start from reconciled cash. Opening cash is the actual bank balance, adjusted for outstanding checks and scheduled payments, not the book balance from the last close.

  2. 02

    Forecast receipts from payment behavior. Open receivables and expected billings by customer group, timed by how each group actually pays, not by the terms on the invoice.

  3. 03

    Place every payment in its week. Payroll on the day it leaves the account, vendors by payment run, and rent, debt service, taxes and capital spending in the weeks they clear.

  4. 04

    Hold a minimum cash line. Compare closing cash with the balance the business should not go below, so the cushion, and any week that breaks it, is visible weeks in advance.

  5. 05

    Roll it forward weekly. Record actuals, explain the variances, correct the assumptions behind them, drop the completed week and add a new week 13.

  6. 06

    Reconcile it to the budget and reports. Use the same assumptions as the 12-month forecast and the monthly package, so the plan, the reports and the bank balance agree.

Free templateDownload the 13-week cash flow templateExcel. Weekly receipts and disbursements, closing cash against a minimum balance, and a variance tab. Free, no email required..xlsx

A 13-week cash flow forecast answers a question the P&L cannot: whether the business will have enough cash in the bank each week for the next quarter, and if not, which week falls short. It is also among the first documents a lender requests when conditions tighten. This guide explains how to build one, keep it accurate and connect it to the budget and monthly reporting.

To start from a working file, download the 13-week cash flow forecast template (Excel). It is free, follows the structure below and includes a variance tab for the weekly review.

What is a 13-week cash flow forecast?

It is a week-by-week projection of cash receipts and disbursements for the next 13 weeks. Each week begins with opening cash, adds receipts, subtracts disbursements and ends with closing cash, which becomes the following week’s opening balance.

It uses the direct method. A direct method cash forecast lists actual cash movements by source: a customer group pays in week 4, payroll clears in weeks 2, 4 and 6, the equipment note is due in week 9. The indirect method, which starts from net income and adjusts for depreciation and working capital changes, suits a monthly or annual view but cannot show which week will be tight.

Why is a cash flow forecast 13 weeks?

Thirteen weeks is one quarter, a horizon that serves four purposes:

  • It captures non-weekly payments. Monthly rent and loan payments occur three times, a biweekly payroll six or seven times, and quarterly items such as estimated tax payments at least once.
  • It covers most collection cycles. An invoice issued today on 30- or 45-day terms usually lands inside the window, even if it is paid late.
  • It remains forecastable. The first four weeks or so rest mainly on known items: open invoices, approved bills, scheduled payroll. The middle weeks combine known items with expected billings, and the final weeks rely on run-rate assumptions. Beyond that horizon, weekly detail becomes speculative.
  • Lenders recognize the format. Banks review 13-week forecasts regularly, so a well-built one requires little explanation.

Because it rolls forward each week, the forecast always covers a full quarter ahead.

The structure of a 13-week cash flow template

A standard 13-week cash flow template, including the free one above, lists weeks 1 to 13 across the top, each labeled with its week-ending date, and these rows down the side:

  • Opening cash. The reconciled balance in the operating accounts at the start of the week.
  • Receipts. Customer groups A, B and C, other receipts (refunds, asset sales, owner contributions), and total receipts.
  • Disbursements. Payroll and benefits, vendors and materials, rent and occupancy, debt service, taxes, capital spending, other disbursements, and total disbursements.
  • Net cash flow. Total receipts less total disbursements.
  • Closing cash. Opening cash plus net cash flow.
  • Minimum cash balance. The floor the business should not go below, commonly enough to cover one payroll plus the bills due alongside it.
  • Cushion above minimum. Closing cash less the minimum. This is the line to monitor.

A separate variance tab compares forecast with actual, by line and by week.

How to build a 13-week cash flow forecast, step by step

  1. Fix the week-ending day. Choose one and use it consistently.
  2. Reconcile opening cash. Start from the bank balance and adjust for outstanding checks and scheduled payments. Exclude restricted cash and any account that cannot be drawn on freely.
  3. Group customers. Place the largest or slowest payers in their own group, regular customers on terms in a second, and small or card-paying customers in a third. Group by payment behavior, not only by size.
  4. Forecast receipts from open receivables and expected billings, timed by each group’s actual payment pattern (see the next section).
  5. Enter payroll and fixed costs. Pay dates, benefit premiums, rent and recurring contracts go in first because they are the most certain.
  6. Schedule vendor payments. Place each open payable and expected purchase in the week it will be paid, not only the week it is due.
  7. Add debt service, taxes and capital spending from the loan agreements, the tax calendar and the list of committed purchases.
  8. Set the minimum cash balance and calculate the cushion for every week.
  9. Review the forecast with operating staff. Sales knows which invoices are disputed; operations knows when materials will be ordered.

How to forecast receipts realistically

Receipts are the most common source of forecast error.

  • Use actual days to pay. Measure how long each customer group has taken to pay over recent months. If terms are 30 days and the group pays in 50, the forecast uses 50.
  • Start from the aging. Enter the largest open invoices individually, in the week they are expected. Spread smaller balances by group.
  • Lag new billings. Work billed in week 3 to a customer who pays in seven weeks arrives in week 10. New sales often change the 13-week position less than owners expect.
  • Account for payment runs. Many larger customers pay on a fixed day or twice a month. Place their receipts in those weeks rather than spreading them evenly.
  • Isolate problem invoices. Disputed, significantly overdue or partially paid items go in later, or not at all.
  • Include irregular items. Deposits, progress billings, retainage and card settlement lags all affect when cash arrives.

Payroll cycles, quarterly payments and other non-weekly items

Shortfalls usually come from the items that recur least often.

  • Payroll. A biweekly payroll has 26 pay dates a year, so two months each year have three. A semimonthly payroll falls on fixed dates regardless of weekday. Place payroll in the week the funds leave the account, often one or two days before payday, and include the payroll taxes withdrawn with it.
  • Quarterly and annual payments. Estimated tax payments as calculated by your CPA, sales tax remittances, property tax installments, insurance premiums, software renewals, bonuses and commissions.
  • Debt. Loan and equipment note payments on their due dates, interest on a line of credit, and any scheduled balloon payment.

The most reliable control is a calendar of every non-weekly payment for the year, checked each time the forecast rolls forward.

The weekly roll-forward and cash flow variance analysis

A rolling cash forecast is useful only if it is rolled forward consistently. Each week:

  1. Record actuals for the week just ended, reconciled to the bank.
  2. Compare forecast with actual on the variance tab, line by line.
  3. Classify each variance. A timing variance means the cash will still arrive or leave, in a different week, so move it. A permanent variance means the amount changed or will not occur, so correct the underlying assumption.
  4. Update the model. If a customer group is paying a week later than assumed, change the timing for the whole group, not a single invoice.
  5. Roll forward. Drop the completed week, set opening cash to the actual closing balance, and add a new week 13.
  6. Decide. Review the cushion and agree on action for any week that falls below the minimum: follow up on specific invoices, reschedule a payment, draw on the line of credit, or inform the bank in advance.

The following example illustrates the review:

Illustrative, in thousands Week 1 Week 2 Week 3 Week 4 Week 5
Opening cash 400 350 400 370 290
Total receipts 220 180 200 150 170
Payroll and benefits 140 0 140 0 140
Vendors and materials 90 100 90 110 90
Rent, debt service and taxes 40 30 0 120 40
Closing cash 350 400 370 290 190
Minimum cash balance 200 200 200 200 200
Cushion above minimum 150 200 170 90 (10)

Week 5 falls below the minimum because a quarterly tax payment in week 4 and a payroll in week 5 land close together. Identified five weeks in advance, the gap can be closed with targeted collections or a rescheduled vendor payment. Identified on the Monday of week 5, it is a shortfall.

Common 13-week cash flow forecast mistakes

  • Using invoice terms instead of payment behavior. The most common error, and it consistently overstates cash.
  • Mixing accrual figures into a cash forecast. Depreciation is not a payment, and booked revenue is not cash received. Loan principal does not appear on the P&L but does leave the bank.
  • Omitting non-weekly items. Quarterly taxes, annual premiums, the third payroll in a month.
  • Starting from an unreconciled balance. If week 1 opens on the wrong figure, every subsequent week is misstated by the same amount.
  • Adjusting the forecast to look acceptable. Pulling receipts earlier or pushing payments later to clear a tight week conceals the problem the forecast exists to reveal.

How lenders use a 13-week cash flow forecast

Banks request a 13-week forecast at a line of credit renewal, when a covenant is under pressure, or when a business is in a difficult period. They assess three things: whether the company can meet payroll and debt service through the quarter, whether the assumptions are documented and reasonable, and whether past forecasts matched results. A forecast supported by several weeks of explained variances carries more weight than one prepared immediately before the meeting.

M3 prepares lender-ready financial information: the forecast, the assumptions behind it, and its reconciliation to the receivables aging and the debt schedule. The owner leads the discussion with the lender. See loan and credit readiness.

How it connects to the budget and monthly reporting

The 13-week forecast is one of three views of the same business:

  • The annual budget sets the year’s targets, usually on an accrual basis.
  • The rolling 12-month forecast updates that plan monthly. A 12-month cash flow forecast works the same way by month, typically converting the budgeted P&L to cash.
  • The monthly reporting package records actual results and reconciles profit to cash.

All three should share assumptions. If the budget assumes customers pay in 40 days and the cash forecast uses 55, one of them is wrong. Budgeting, forecasting and FP&A and financial reporting describe how the three are built and kept consistent.

Getting started

To begin, download the 13-week cash flow forecast template (Excel), enter opening cash and the current week’s known items, and maintain it for a month. To have a former CFO build and run the forecast with your team each week, see M3’s cash flow management service, which begins with a free consultation.

Compare

13-week cash forecast vs annual budget vs monthly P&L

Three tools that answer different questions. Most companies need all three, built from the same numbers.

What differs13-week cash forecastAnnual budgetMonthly P&L
HorizonThe next 13 weeks, week by weekThe fiscal year, month by monthThe month just closed
Basis (cash vs accrual)Cash: money in and out of the bankUsually accrual, to match the P&LAccrual: revenue when earned, costs when incurred
UpdatedWeekly, rolled forwardOnce a year, sometimes re-forecastMonthly, after the close
Used forTiming payments, identifying tight weeks early, lender discussionsSetting targets and spending limits for the yearMeasuring profit and margin against the budget

Questions

13-week cash flow forecast: frequently asked questions

Why is a cash flow forecast 13 weeks?

Thirteen weeks is one quarter: long enough to capture every payroll cycle, three rounds of monthly rent and loan payments, and quarterly items such as estimated taxes. It is also short enough to forecast week by week from known invoices and bills. Because it rolls forward weekly, it always covers a full quarter ahead.

How do you do a 13-week cash flow forecast?

Start from reconciled opening cash. Forecast receipts by customer group from open receivables and expected billings, timed by how each group actually pays, then place payroll, vendors, rent, debt service, taxes and capital spending in the weeks they clear. Compare closing cash with a minimum balance, and roll the forecast forward every week.

How do you do a 12-month cash flow forecast?

A 12-month forecast works by month rather than by week. It usually starts from the budgeted P&L and converts it to cash using assumptions about collection timing, payment timing, debt service and capital spending. It suits planning the year, while the 13-week forecast suits managing the weeks immediately ahead.

What does a cash flow manager do?

A cash flow manager maintains a forward view of cash and acts on it: running the weekly forecast, following up on receivables, scheduling payables, monitoring the minimum cash line and flagging tight weeks early. In an owner-led company, this function often sits within the controller or fractional CFO role rather than a separate position.

What is a direct method cash forecast?

It forecasts actual cash receipts and disbursements by source: customer payments, payroll, vendor payments, rent, debt service and taxes. The indirect method starts from net income and adjusts for noncash items and working capital. The direct method is the standard for a 13-week forecast because it shows exactly which week cash becomes tight.

What is cash flow variance analysis?

It is the weekly comparison of forecast cash with actual cash, line by line. Each variance is classified as timing, where the cash moves to another week, or permanent, where the amount changed. Explaining variances is how the forecast becomes more accurate, and how a lender judges whether to rely on it.

What is a rolling cash forecast?

A rolling cash forecast always covers the same length of time ahead. Each week the completed week drops off, actuals replace estimates, and a new week is added at the end. A rolling 13-week forecast never runs out, unlike a fixed quarterly forecast that shortens as the quarter progresses.

Is there a free 13-week cash flow template?

Yes. M3 offers a free Excel template with weeks 1 to 13 across the top, receipts by customer group, disbursements by category, closing cash, a minimum cash line and a variance tab for forecast vs actual. The download link is on this page.

Do lenders ask for a 13-week cash flow forecast?

Often, particularly at a line of credit renewal, when a covenant is under pressure or when a business is in a difficult period. Lenders look for written assumptions and a record of forecasts that matched actual results. M3 prepares lender-ready financial information, and the owner leads the discussion with the lender.

How accurate should a 13-week cash flow forecast be?

The first few weeks should be close, because they rest on known invoices, bills and payroll dates. Later weeks depend on assumptions and will move. What matters is that every variance is explained and the assumptions improve, which typically takes one to two months of weekly reviews.

Keep reading

Related guides and services

Discuss your situation with Michael

A 30-minute conversation about your cash position, reporting, lending plans or costs. You leave with a clear view of what a fractional CFO would address first, whether or not you engage M3.

Book a free consultation

Free. 30 minutes. Google Meet.