How to Build a 13-Week Cash Flow Forecast (Free Template)

A 13-week cash flow forecast is the most useful single spreadsheet a small finance team can own. It is not a budget and it is not a P&L projection. It answers one question: how much cash will be in the bank at the end of each week for the next quarter, and which week is the tightest. This guide walks through the layout, the build, a worked example, and the weekly routine that keeps it honest. If you would rather fill in a ready-made version, the free 13-week cash flow forecast template runs in your browser and shows the low point automatically.

Why use a 13-week cash flow forecast?

Thirteen weeks is one quarter. It is long enough to see the next payroll crunch, the quarterly tax payment and the slow-paying customer, and short enough that you can forecast each item from facts you already know: invoices you have issued, bills you have received, and dates you have committed to.

Weekly matters more than the horizon. A monthly forecast hides the inside of the month, and the inside of the month is where cash runs short. Payroll, rent and loan payments land on specific days. Customer receipts arrive unevenly. A month can begin and end with a healthy balance and still dip below zero in week two.

It is also a direct forecast. The statement of cash flows in your annual accounts is usually prepared using the indirect method, starting from net income and adjusting for non-cash items, which accounting standards (FASB ASC 230 in the US, IAS 7 internationally) allow alongside the direct method. A 13-week forecast uses the direct approach: actual receipts and actual payments, by week. That is why it starts from the bank balance, not from profit. Profit and cash can diverge sharply: receivables, inventory, loan principal and owner draws all move cash without moving profit in the same way.

What goes into a 13-week cash flow forecast template?

Thirteen columns, one per week, plus a total. The rows follow the order cash actually moves:

Section	Rows	Where the numbers come from
Opening cash	Bank balance at the start of the week	Week 1: today's balance across all operating accounts. After that: last week's closing balance.
Receipts	Collections from existing receivables; collections from new sales; other receipts (grants, deposits, interest, asset sales)	Receivables aging, customer payment history, signed contracts
Operating payments	Payroll and payroll taxes; rent; vendors and suppliers; software and subscriptions; insurance; other	Payroll calendar, accounts payable aging, contracts, recurring bills
Non-operating payments	Loan principal and interest; estimated tax payments; equipment purchases; owner draws or distributions	Loan schedules, tax calendar, approved capital spend
Net cash flow	Total receipts minus total payments	Calculated
Closing cash	Opening cash plus net cash flow	Calculated
Minimum balance and headroom	Your buffer, and closing cash minus the buffer	A policy you set, such as one payroll plus one month of fixed costs

Keep one row per material item rather than one row per vendor. Twelve to twenty rows is plenty for most small businesses. More detail makes the forecast slower to update, and a forecast that is slow to update stops being updated.

How do you build it, step by step?

1. Set the start date and the weeks. Pick the day your week starts and label each column with the week-ending date. Use the same convention every time.
2. Enter opening cash. Today's balance in every operating account, net of any payments you have already released that have not cleared. Do not include money you cannot spend, such as a restricted grant held in the operating account or a deposit held for a customer.
3. Schedule the fixed payments. Payroll on its actual pay dates, with payroll taxes on the deposit schedule the IRS has assigned you (Publication 15 explains monthly and semiweekly depositors). Then rent, loan payments, insurance and subscriptions on their due dates.
4. Add the tax calendar. Quarterly estimated tax payments, sales tax remittances and any annual filings with a payment attached. These are large, predictable and easy to forget.
5. Forecast vendor payments from payables. Take the payables aging and place each significant bill in the week you will actually pay it, not the week it is due, if those differ.
6. Forecast collections from receivables. Place each open invoice in the week you expect the cash, based on how that customer actually pays. This is the step that decides whether the forecast is useful; it gets its own section below.
7. Add new sales and one-offs. Only revenue you are confident about: signed contracts, recurring customers, deposits due. Keep pipeline you hope to close in a separate scenario, not in the base case.
8. Calculate and find the low point. Closing cash for each week, the lowest closing balance in the 13 weeks, and the week it occurs.

Worked example (hypothetical numbers)

A business with $120,000 in the bank, biweekly payroll of $48,000, and one large customer due to pay $70,000 at the end of the month. The first four weeks look like this:

	Week 1	Week 2	Week 3	Week 4
Opening cash	$120,000	$126,000	$71,000	$73,500
Collections	$30,000	$25,000	$28,000	$95,000
Payroll	$0	($48,000)	$0	($48,000)
Rent	($9,000)	$0	$0	$0
Vendors	($15,000)	($12,000)	($18,000)	($14,000)
Estimated tax	$0	($20,000)	$0	$0
Annual software renewal	$0	$0	($7,500)	$0
Loan payment	$0	$0	$0	($6,000)
Closing cash	$126,000	$71,000	$73,500	$100,500

A monthly forecast would show $120,000 at the start, $178,000 in, $197,500 out, and $100,500 at the end. That looks comfortable against an $80,000 minimum balance. The weekly view shows the business sitting $9,000 below its buffer in week 2 and still below it in week 3.

Now test the obvious risk. If the $70,000 customer payment slips one week, week 4 collections fall to $25,000 and the closing balance drops to $30,500. That is the number worth knowing in week 1, while there is still time to move the software renewal, ask the customer for a firm date, or draw on a credit line.

How do you forecast collections accurately?

Collections are where most cash forecasts go wrong, because the easy assumption, that customers pay on their terms, is usually false. Forecast from behavior, not from terms.

• Start from the receivables aging. List every open invoice with its customer, amount and due date. The free invoice aging calculator buckets them and flags the balances most at risk.
• Use each customer's actual payment pattern. If a customer on 30-day terms has paid an average of 12 days late over the last six months, forecast their invoices at 42 days. Hypothetical example: a $20,000 invoice issued on 1 October on net 30 is due on 31 October; for that customer, forecast it in the week of 12 November.
• Treat the largest customers individually. The five biggest balances deserve a line each. Everything else can be grouped.
• Discount what is overdue. Invoices more than 90 days past due should not sit in the base forecast at full value. Put them in at a reduced amount, or in a separate row you can switch off.
• Separate new sales from existing receivables. Cash from invoices you have issued is far more certain than cash from sales you expect to make. Keep them on different rows so you can see how much of the forecast depends on each.

How do you keep a 13-week forecast accurate?

A 13-week forecast is rolling. Every week, the week that just ended drops off the front and a new week 13 is added at the back. The weekly routine takes far less time than the first build:

1. Record the actuals. Replace last week's forecast with what actually came in and went out, and reconcile the closing balance to the bank.
2. Compare forecast to actual. For each row, note the difference and the reason. Keep the history.
3. Update the next 12 weeks. New invoices issued, new bills received, payment dates that moved.
4. Add week 13. Mostly recurring items at first; detail fills in as it gets closer.
5. Read the low point. If the lowest week is below your minimum balance, decide what you will do about it now, not when you get there.

The comparison in step 2 is the step most teams skip and the one that improves the forecast fastest. After a couple of months it shows your own bias: most businesses find they are consistently optimistic about collections. Once you know the size of that bias you can correct for it. The guide on cash flow forecasting without a data team covers the four places a forecast usually drifts and how to fix each.

A forecast is also only useful if someone reads it. A good question for an owner or board to ask is the one Dr. Michelle Gordon puts to leaders about their actual cash position: what does the forecast say about our ability to meet our commitments over the next 13 weeks?

Common mistakes

• Building it from the P&L. Revenue is not receipts and expenses are not payments. Depreciation is in the P&L and not in cash; loan principal is in cash and not in the P&L.
• Forgetting the irregular items. Annual insurance, quarterly taxes, a third payroll in some months, bonuses. Keep a named list and review it each quarter.
• Putting pipeline in the base case. Hoped-for sales belong in an upside scenario.
• Never checking it against the bank. If the forecast's opening balance does not match the bank each week, every number after it is off.

How DataWyse helps

The build is a one-off. The weekly update is what consumes the time: pulling the receivables and payables agings, checking what cleared, and working out each customer's real payment pattern. DataWyse connects read-only to the accounting system and bank data, re-forecasts cash from your actual receivables, payables and customer payment history, and flags the week the balance is projected to fall below your minimum. Every number in the forecast shows the formula and the records it came from, so you can check why a week moved before you act on it.

If your forecast is small and stable, the free template and a weekly half-hour routine are enough. Automation earns its keep when the number of customers, entities or bank accounts makes the weekly update a day's work.