13-Week Cash Flow Forecast Template for Excel: Build It Week by Week

A 13-week cash flow forecast template is a weekly spreadsheet that starts with the cash you have today, adds the money you realistically expect to collect each week, subtracts every payment you know is coming, and shows your ending cash for each of the next 13 weeks. Thirteen weeks is one quarter: short enough to forecast with real invoices and bills, long enough to see a cash gap before it arrives. If one week’s ending cash falls below your safety buffer, you have time to act — chase an invoice, move a purchase, or arrange financing — instead of discovering the problem on payday.

This guide shows the exact layout to build in Excel or Google Sheets, the formulas behind each row, and a fully worked example for a small service business. It sits in our Small Business Finance hub next to the historical cash flow statement template, which looks backward; the 13-week forecast looks forward.

Why 13 weeks, and why weekly?

Monthly cash plans hide timing. Rent, payroll, loan payments and a large customer receipt can all fall in the same month and still leave you short for six days in the middle. A weekly view exposes those gaps. The 13-week horizon is a practical compromise used widely in treasury and turnaround work:

• Weeks 1–4 are built from hard data: open invoices, scheduled payroll, bills already received.
• Weeks 5–9 mix known commitments with estimates based on your recent collection pattern.
• Weeks 10–13 are mostly estimates, but they still catch quarterly items such as estimated taxes, insurance renewals or a balloon payment.

Because it is updated every week and always rolls forward, the forecast never runs out: when week 1 ends, you drop it, record what actually happened, and add a new week 13.

The template layout

Put the weeks across the columns (one column per week, with the week-ending date in the header) and the cash lines down the rows. Keep the structure simple enough that anyone on your team can update it in 20 minutes.

A second tab holds your inputs: open receivables with expected payment dates, recurring payments with their frequency, and the minimum cash buffer. A third tab stores the actual results of each closed week so you can measure how accurate the forecast was.

Step-by-step: building the forecast in Excel

1. Set up the week columns

Type the first week-ending date in C3 (for example a Friday). In D3 enter =C3+7 and copy it across to column O, which gives you 13 weeks. Format the row as dates so the headers read clearly.

2. Link opening cash

In C5 type today’s bank balance. In D5 enter =C30 (the previous week’s ending cash, assuming ending cash sits in row 30) and copy across. This chain is the backbone of the model: every week starts where the previous one finished.

3. Enter receipts

List each receipt line in rows 7–11 and total them in row 12 with =SUM(C7:C11). If you keep an invoice list with an “expected payment week” column, you can pull collections automatically with =SUMIFS(Invoices!$E:$E,Invoices!$G:$G,C$3), where column E holds the amount and column G the expected week-ending date.

4. Enter payments

List operating payments in rows 14–21 and non-operating payments in rows 23–26, then total all payments in row 27. Recurring items can be driven by a simple rule: for biweekly payroll starting in week 2, use =IF(MOD(COLUMN()-COLUMN($C$3)+1,2)=0,7800,0), or simply type the amounts into the right weeks if your schedule is irregular.

5. Calculate net flow and ending cash

• Net cash flow (row 29): =C12-C27
• Ending cash (row 30): =C5+C29
• Minimum buffer (row 31): an absolute reference to your input cell, e.g. =Inputs!$B$2
• Surplus or shortfall (row 32): =C30-C31

6. Flag the danger weeks

Select row 30 and add conditional formatting with the rule =C30<C31 filled in red. Add a summary cell that returns the lowest projected balance, =MIN(C30:O30), and the week it happens, =INDEX(C3:O3,MATCH(MIN(C30:O30),C30:O30,0)). Those two numbers are what the owner needs to see first.

Worked example: a 13-week forecast for a small service business

The business below starts with $18,000 in the bank and wants to keep at least $10,000 as a buffer. Assumptions: suppliers $3,900 every week, payroll $7,800 every second week (weeks 2, 4, 6…), rent $3,500 in weeks 1, 5, 9 and 13, a loan payment of $1,150 in weeks 4, 8 and 12, software $400 in weeks 3, 7 and 11, a one-time equipment payment of $8,000 in week 6 and a quarterly estimated tax payment of $6,500 in week 11. Collections come from the open invoice list and the recent payment pattern.

Over the quarter the business collects $123,500 and pays out $130,650, a net outflow of $7,150. It never runs out of cash, but it drops below the $10,000 buffer three times: week 6 ($9,150), week 11 ($7,800) and week 12 ($8,150). The lowest point is week 11, when the estimated tax payment lands in a payroll-free week with weak collections.

Testing a fix before you commit to it

The forecast lets you test options in minutes. Suppose the owner asks the equipment supplier to split the $8,000 into four monthly installments of $2,000, paid in weeks 6, 10, 14 and 18. Only $4,000 then falls inside this 13-week window. Re-running the model gives ending cash of $15,150 in week 6, $11,800 in week 11, $12,150 in week 12 and $14,850 in week 13. The lowest balance is now $11,800, so the buffer holds every week. Other levers to test the same way: collecting a large invoice one week earlier, moving a discretionary purchase, or reducing an owner draw.

How to forecast receipts realistically

Most forecasts fail on the receipts side, because invoice due dates are not payment dates. Three habits make collections more reliable:

1. Use your actual collection lag. If customers on 30-day terms usually pay on day 38, forecast day 38. Your sales tracker or invoice log already holds the dates you need to measure this.
2. Separate big customers. Give any customer worth more than about 10% of weekly receipts its own row, so a single late payment is visible.
3. Do not count new sales twice. Future sales enter the forecast only when they are expected to be collected, and only once — either as a known invoice or as an estimate, never both.

Card processors and marketplaces usually pay out on a schedule after fees and refunds. Forecast the net payout amount on the payout day, and record fees as part of that net figure rather than as a separate payment.

The weekly roll-forward routine

The forecast is only useful if it stays current. A simple weekly routine, done on the same day each week:

1. Copy the week that just ended into the Actuals tab, then replace the forecast figures with what really hit the bank.
2. Compare actual to forecast for that week. A variance column such as =Actual-Forecast on receipts and payments shows where your assumptions were off.
3. Delete the closed week from the forecast view and add a new week 13 at the end.
4. Update open invoices, new bills and any change in payroll or supplier terms.
5. Check the lowest balance and its week. If it is below the buffer, decide the action now and note it next to the week.

After four to six weeks of variance tracking you will see patterns — for example, collections consistently 10% below forecast — and you can adjust your estimates accordingly.

Common mistakes to avoid

• Mixing profit and cash. Depreciation, accruals and invoices not yet paid are not cash. Use the P&L template for profit and this forecast for cash.
• Forgetting irregular payments. Quarterly taxes, annual insurance, software renewals and loan balloon payments create most surprises. Keep a list of them on the Inputs tab.
• Booking payments on the invoice date. Record the date the money actually leaves the account.
• Hard-coding the opening balance every week. Only week 1 is typed; every later week must link to the previous week’s ending cash.
• No buffer. A forecast that only checks for a negative balance warns you too late. Set a minimum cash level that covers at least one payroll plus the largest weekly payment.

Which cash tool answers which question?

The tools work best together: the amortization schedule feeds the loan rows of the forecast, your business expense tracker shows which recurring costs to include, and an Excel dashboard can display the lowest projected balance at a glance.

FAQ

Is a 13-week cash flow forecast only for companies in trouble?

No. It became well known in restructuring work, but any business with uneven collections, payroll cycles or seasonal sales benefits from seeing cash week by week. It is especially useful when you are growing quickly, because growth often uses cash before it produces it.

Should I use the direct or indirect method?

For a 13-week forecast, use the direct method: list actual receipts and payments. The indirect method, which starts from net income and adjusts for non-cash items, is better suited to the historical cash flow statement.

How accurate does the forecast need to be?

Aim for the first four weeks to be close, because they are built on known invoices and bills. Later weeks will be less precise; what matters is that the forecast flags the weeks that need attention. Tracking variance every week is how accuracy improves.

Can I build it in Google Sheets instead of Excel?

Yes. Every formula in this guide — SUM, SUMIFS, MIN, INDEX/MATCH and conditional formatting — works the same way in Google Sheets, and sharing the file makes the weekly update easier for a small team.

What should the minimum cash buffer be?

There is no universal number. A practical starting point is enough cash to cover one full payroll plus your largest regular weekly payment; businesses with lumpy or seasonal revenue usually keep more. Review the buffer whenever payroll or fixed costs change.

Next step: set up the week columns and opening balance today, then enter only weeks 1–4 from your real invoices and bills. Once that works, extend to 13 weeks and start the weekly roll-forward. For more finance spreadsheets and guides, browse the Small Business Finance hub.