13-week cash flow forecast template

A 13-week cash flow forecast shows how much cash you'll have at the end of each week for the next quarter. This free template starts with this week's bank balance, adds expected receipts, takes off payroll, bills, loan payments, taxes and owner draws, and carries the ending cash forward, so you can see a tight week coming.

Updated November 2026

What does the template look like?

Type your numbers in the white cells. Totals and results add themselves in Excel. Here it is with sample figures, so you can see how it fills in.

Example figures
LineWk 1Wk 2Wk 3More
Starting cash
Opening cash$24,000.00$28,700.00$24,700.00...
Cash in
Customer payments$9,000.00$7,500.00$8,200.00...
Card deposits$3,200.00$3,000.00$3,400.00...
Loans or owner money in$0.00$0.00$0.00...
Total cash in$12,200.00$10,500.00$11,600.00...
Cash out
Payroll and payroll taxes$0.00$7,800.00$0.00...
Vendors and inventory$4,200.00$3,800.00$5,100.00...
Rent and utilities$2,900.00$0.00$0.00...
Loan payments$0.00$0.00$1,100.00...
Sales tax payments$0.00$0.00$2,600.00...
Estimated income tax$0.00$0.00$0.00...
Owner draws$0.00$2,500.00$0.00...
Other$400.00$400.00$400.00...
Total cash out$7,500.00$14,500.00$9,200.00...
Net cash flow$4,700.00-$4,000.00$2,400.00...
Closing cash$28,700.00$24,700.00$27,100.00...

Why 13 weeks?

It's one quarter, long enough to see payroll cycles, rent, loan payments, a sales tax return and a quarterly estimated tax payment, and short enough to be accurate. Weekly detail shows the tight weeks that a monthly view hides, like the week rent and payroll land together.

How do I use it?

Start with today's bank balance in week 1. Enter cash you expect to receive by the week you'll get it, based on your receivables aging. Enter every payment by the week it leaves. The closing cash line shows your cushion. If it drops near zero, you have weeks, not days, to move a payment, chase a customer or arrange a credit line.

Don't forget taxes

Sales tax you collected, payroll tax deposits and quarterly estimated taxes are some of the biggest cash payments a small business makes, and the easiest to forget. Put the due dates in from the tax deadline calendar.

General information, not tax advice for your situation.

Want a plan for this year?

We run your numbers and show you the options.

See our tax planning and CFO service
Questions

Still wondering?

Ask anything else on a free 30-minute call.

Book a call
How is a cash flow forecast different from a budget?

A budget plans profit. A forecast plans cash, including loan payments, owner draws, taxes and the timing of customer payments.

How often should I update it?

Every week. Replace last week's estimates with what actually happened and add a new week at the end.

What is a healthy cash cushion?

Many owners aim for at least one month of operating costs in the bank, and more for seasonal businesses.

Get started

Tell us what's messy. We'll tell you what it takes.

Tell us what you need and get a fixed price before any work starts. No pressure and no contract.

Get a free quote

Your name, plus an email or a phone number, whichever you prefer.

A sentence or two is plenty. Please don't include Social Security numbers, bank or card numbers, or tax documents here.

Thanks. This is a design preview, so nothing was sent.