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
- Fix the week-ending day. Choose one and use it consistently.
- 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.
- 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.
- Forecast receipts from open receivables and expected billings, timed by each group’s actual payment pattern (see the next section).
- Enter payroll and fixed costs. Pay dates, benefit premiums, rent and recurring contracts go in first because they are the most certain.
- Schedule vendor payments. Place each open payable and expected purchase in the week it will be paid, not only the week it is due.
- Add debt service, taxes and capital spending from the loan agreements, the tax calendar and the list of committed purchases.
- Set the minimum cash balance and calculate the cushion for every week.
- 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:
- Record actuals for the week just ended, reconciled to the bank.
- Compare forecast with actual on the variance tab, line by line.
- 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.
- 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.
- Roll forward. Drop the completed week, set opening cash to the actual closing balance, and add a new week 13.
- 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.