Profitable businesses run out of cash all the time. A big customer pays 30 days late, the annual insurance premium lands in the same week as payroll, a quarterly tax payment comes due, and suddenly the bank balance is lower than anyone expected. A 13-week cash flow forecast is the simplest tool for seeing those weeks coming while there’s still time to do something about them.

This free template gives you a week-by-week forecast for the next 13 weeks. It shows your opening and closing cash every week, flags any week that drops below your minimum cash buffer, and tracks how your actual results compare with the plan.
Free, no sign-up. Works in Excel, Google Sheets and LibreOffice.
Free online 13-week cash flow calculator
Want a quick answer before you open Excel? Enter your bank balance, your typical weekly receipts and your regular bills. The calculator builds a 13-week cash flow projection and shows the week your cash gets tightest. Tap Load example to see the worked example from further down this page.
What is a 13-week cash flow forecast?
It’s a rolling, week-by-week projection of the cash coming into and going out of your bank accounts over the next quarter. Unlike a profit and loss statement, it ignores when revenue is earned or expenses are incurred. It only cares about when money actually moves.
Why 13 weeks? It covers a full quarter, so it catches monthly bills, quarterly taxes and most seasonal swings. And it’s short enough that you can forecast each week with reasonable confidence. Weekly detail matters because cash problems rarely show up in monthly totals. A month can end with plenty of cash and still contain one week where you can’t make payroll.
Lenders, turnaround advisors and finance teams use 13-week forecasts whenever cash is tight. But it’s just as useful for a healthy small business that wants to know when it can afford to hire, buy equipment or take a draw.
What’s inside the template
- Start Here: four settings: business name, forecast start date, opening cash balance and your minimum cash buffer.
- Forecast: 13 weekly columns with 6 receipt lines and 13 payment lines you can rename. It calculates total receipts, total payments, net cash flow, closing cash and how far each week sits above or below your buffer. At the top you’ll see your lowest closing balance, which week it falls in, how many weeks are below the buffer and where you end up after week 13.
- Actual vs Forecast: one row per week where you record actual receipts and payments. It shows the variance against your forecast and your actual closing cash.
Closing cash turns light red when it falls below your buffer and bright red when it goes negative, so problem weeks are impossible to miss.
How to build your forecast, step by step
1. Start from the bank, not the books
Enter the actual cash balance in your business bank accounts on the first day of week 1. Your accounting software may show a different number if checks haven’t cleared or deposits are still pending; the bank balance is what you can actually spend.
2. Set a minimum cash buffer
Decide the lowest balance you’re comfortable holding, the cushion for surprises. Many owners use something like one payroll cycle plus rent. The template highlights every week below this level, which is often more useful than waiting for cash to hit zero.
3. Forecast receipts by when customers actually pay
This is where most forecasts go wrong. An invoice sent today with 30-day terms is not cash in week 1. Look at your open invoices and put each expected payment in the week you realistically expect it, based on how that customer has paid in the past. A customer who always pays ten days late should be forecast ten days late. For future sales you haven’t invoiced yet, use your recent weekly average and be conservative.
4. Forecast payments by their due dates
Work through your fixed commitments first: payroll on each payday, rent and loan payments on their due dates, and subscriptions on their billing dates. Then add variable costs like supplier bills based on their payment terms. Finally, hunt for the irregular items that cause most cash surprises: annual insurance premiums, quarterly estimated taxes, sales tax remittances, equipment purchases and owner draws.
If you run payroll every two weeks, enter it in alternating weeks, as in the example rows. Some months will have three paydays instead of two, and a weekly forecast shows that automatically.
5. Read the result
Here’s what a completed forecast looks like for a small service business that starts with $25,000 and wants to keep at least $10,000 on hand:
| Week | Starting | Opening cash | Receipts | Payments | Net flow | Closing cash |
|---|---|---|---|---|---|---|
| 1 | Oct 26 | $25,000 | $7,700 | $13,100 | ($5,400) | $19,600 |
| 2 | Nov 2 | $19,600 | $6,300 | $2,220 | $4,080 | $23,680 |
| 3 | Nov 9 | $23,680 | $8,600 | $12,380 | ($3,780) | $19,900 |
| 4 | Nov 16 | $19,900 | $6,800 | $3,050 | $3,750 | $23,650 |
| 5 | Nov 23 | $23,650 | $7,500 | $13,000 | ($5,500) | $18,150 |
| 6 | Nov 30 | $18,150 | $6,700 | $2,620 | $4,080 | $22,230 |
| 7 | Dec 7 | $22,230 | $8,900 | $16,580 | ($7,680) | $14,550 |
| 8 | Dec 14 | $14,550 | $6,400 | $10,150 | ($3,750) | $10,800 |
| 9 | Dec 21 | $10,800 | $7,800 | $13,100 | ($5,300) | $5,500 ⚠ |
| 10 | Dec 28 | $5,500 | $7,100 | $2,320 | $4,780 | $10,280 |
| 11 | Jan 4 | $10,280 | $8,500 | $12,280 | ($3,780) | $6,500 ⚠ |
| 12 | Jan 11 | $6,500 | $6,600 | $3,150 | $3,450 | $9,950 ⚠ |
| 13 | Jan 18 | $9,950 | $8,000 | $13,200 | ($5,200) | $4,750 ⚠ |
The business looks fine for two months. Then a $4,800 annual insurance payment in week 7 and a $6,500 tax payment in week 8 pull cash steadily down. By week 9 the balance is $5,500, half the buffer. That’s the kind of insight a 13-week forecast is for: with two months’ notice, the owner can push a customer to pay on time, delay an equipment purchase, skip a draw or arrange a line of credit before it’s urgent.
Keep it rolling every week
A 13-week forecast is only useful if it stays current. Once a week, ideally on the same day:
- On Actual vs Forecast, enter what actually came in and went out last week.
- Look at the variances. Were receipts late? Did a payment come in higher than planned? Adjust future weeks if the same thing is likely to happen again.
- Roll forward: save a copy, change the start date to the next week, move your numbers one column to the left and add a new week 13. Update the opening cash balance from your bank.
After a few weeks you’ll learn where your forecast tends to be too optimistic, and it will get noticeably more accurate.
Using the cash flow forecast template in Google Sheets
You don’t need Excel. The template works as a cash flow forecast in Google Sheets too, which is handy if you share the numbers with a partner or bookkeeper:
- Download the .xlsx file and upload it to Google Drive (New → File upload).
- Open it, then choose File → Save as Google Sheets. You now have a normal Google Sheet you can edit online.
- Enter your opening bank balance, minimum cash buffer and start date on the first sheet, then fill in expected receipts and payments week by week.
- Use Share to give your bookkeeper or business partner access, so everyone works from the same forecast instead of emailing copies.
- Each week, before you roll the forecast forward, make a copy (File → Make a copy) or name a version in the version history, so you can compare last week’s forecast with what really happened.
Prefer something even quicker? The online calculator above builds the same weekly cash flow forecast in your browser, with no file at all.
13-week cash flow forecast example
Here is a worked example for a small service business. It starts with $15,000 in the bank and collects about $7,800 a week from customers. It runs payroll of $8,500 every two weeks, pays $3,200 of rent and loan payments at the start of each month, and spends about $2,400 a week on suppliers, software and fuel. A $6,500 quarterly tax payment is due in week 8, and the owner expects a $5,000 overdue invoice to be paid in week 10. The minimum cash buffer is $8,000.
| Week | Opening cash | Cash in | Cash out | Closing cash |
|---|---|---|---|---|
| Week 1 | $15,000 | $7,800 | -$14,100 | $8,700 |
| Week 2 | $8,700 | $7,800 | -$2,400 | $14,100 |
| Week 3 | $14,100 | $7,800 | -$10,900 | $11,000 |
| Week 4 | $11,000 | $7,800 | -$2,400 | $16,400 |
| Week 5 | $16,400 | $7,800 | -$14,100 | $10,100 |
| Week 6 | $10,100 | $7,800 | -$2,400 | $15,500 |
| Week 7 | $15,500 | $7,800 | -$10,900 | $12,400 |
| Week 8 | $12,400 | $7,800 | -$8,900 | $11,300 |
| Week 9 | $11,300 | $7,800 | -$14,100 | $5,000 ⚠ |
| Week 10 | $5,000 | $12,800 | -$2,400 | $15,400 |
| Week 11 | $15,400 | $7,800 | -$10,900 | $12,300 |
| Week 12 | $12,300 | $7,800 | -$2,400 | $17,700 |
| Week 13 | $17,700 | $7,800 | -$14,100 | $11,400 |
What the example shows
The business brings in $106,400 over the quarter and pays out $110,000, so it is only slightly short. On a monthly profit and loss statement it would look fine. But in week 9, rent, payroll and the tax payment from the week before pile up, and cash drops to $5,000, which is $3,000 below the buffer. The overdue $5,000 invoice arrives one week too late.
If the owner gets that invoice paid by week 8 instead, week 9 closes at $10,000 and cash never drops below the buffer. That is the whole point of a 13-week forecast: you see week 9 coming in week 1, while there is still time to call the customer, move a supplier payment or line up credit.
You can change any number in the calculator above to test your own scenarios, then copy the plan into the Excel template to track actual results each week.
Forecast, projection or model: what is the difference?
You will see this called a 13-week cash flow forecast, a 13-week cash flow projection, a 13-week cash flow model, a 13-week cash flow budget or simply a “TWCF”. In practice they all mean the same thing: a week-by-week table of expected cash in, cash out and closing bank balance for the next quarter. Banks, lenders and turnaround advisers usually say “model” and expect to see actual results next to the forecast every week, which this template already includes.
Common cash flow forecasting mistakes
- Forecasting profit instead of cash. Revenue you’ve earned but not collected doesn’t pay bills. Neither does depreciation. Keep the forecast strictly about money in and out of the bank.
- Being optimistic about collections. Assume customers pay the way they actually pay, not the way your terms say they should.
- Forgetting irregular payments. Annual renewals, quarterly taxes and one-off purchases cause most surprises. Scan the last 12 months of bank statements for anything that doesn’t happen monthly.
- Ignoring owner draws and loan principal. They don’t show up as expenses on a profit and loss statement, but they leave the bank account all the same.
- Building it once and never updating it. A forecast that’s three weeks old is a guess. The weekly update takes 15 minutes once the structure is in place.
Frequently asked questions
How is this different from a profit and loss statement?
A profit and loss statement shows whether you made money over a period. A cash flow forecast shows whether you’ll have money in the bank on a given week. You can be profitable and still run short of cash, especially when customers pay slowly or large bills cluster together. If you track income and expenses in our small business bookkeeping spreadsheet, its monthly figures are a good starting point for your weekly averages.
How accurate does it need to be?
Accurate enough to spot trouble early. The nearest four weeks should be fairly precise because you know most of the bills and invoices. Weeks 9 to 13 will be rougher estimates. That’s normal, and they firm up as you roll forward.
I’m self-employed. Is this overkill?
Not if your income is uneven. Freelancers with lumpy client payments often get the most value from a weekly view, especially around estimated-tax due dates. Our self-employed income and expense tracker helps you work out how much to set aside for those payments, and you can then schedule them in this forecast.
Does it work in Google Sheets?
Yes. Upload the .xlsx file to Google Drive, open it with Google Sheets and choose File → Save as Google Sheets. The formulas and color warnings carry over. See the step-by-step Google Sheets setup above.
Can I use it as a simple weekly cash flow forecast?
Yes. Each of the 13 columns is one week, so it is a weekly cash flow forecast by design. If you only want to look a month ahead, fill in the first four or five weeks and leave the rest empty. Most small businesses find that 13 weeks (one quarter) is long enough to see payroll, rent, loan payments and quarterly taxes coming, and short enough to forecast with real numbers.
Should I include sales tax I’ve collected?
Yes. Sales tax you collect from customers is cash in the bank until you remit it. Include it in receipts, and put the remittance in the week it’s due so the forecast doesn’t make you think that money is yours to spend.
Is the template really free?
Yes. The Excel download and the online calculator are free, with no sign-up and no email required.
Can I give this forecast to my bank or lender?
Yes. Many lenders ask for a 13-week cash flow forecast when you apply for a line of credit or a loan, or when a business is going through a tough patch. Fill in the forecast, update the actual columns every week and send them the file. Keep your assumptions, like when big customers usually pay, in the notes so they can follow your numbers.
This template and guide are for general planning and educational purposes only and are not financial, tax or legal advice. See our disclaimer.
Bookkeeping Kit Pro 2026 links your P&L, invoices, bills, bank rec, mileage and quarterly tax in one Excel workbook (works in Google Sheets). The free templates on this site stay free.
Comments
9 responses to “Free 13-Week Cash Flow Forecast Template (Excel & Google Sheets) + Example”
[…] Free 13-Week Cash Flow Forecast Template […]
[…] Free 13-Week Cash Flow Forecast Template […]
[…] 13-Week Cash Flow Forecast Template […]
[…] 13-Week Cash Flow Forecast Template […]
[…] Free 13-Week Cash Flow Forecast Template […]
[…] Free 13-Week Cash Flow Forecast Template […]
[…] Free 13-Week Cash Flow Forecast Template […]
[…] Weekly Cash Flow Forecast Template (Google Sheets & Excel) […]
[…] Free 13-Week Cash Flow Forecast Template […]