A 13-week cash flow forecast shows how much cash you’ll have at the end of every week for the next quarter. It’s the simplest tool I know for spotting a tight stretch while there’s still time to do something about it, and this time of year it really earns its keep.
Something I learned at Kan Jam: the cash for a big selling season goes out long before it comes back. Inventory, freight, packaging and marketing all get paid up front, and then you wait weeks or months for retailers and customers to pay you. A business can be profitable on paper the whole time and still feel tight in the bank.
The same thing happens to a lot of businesses every winter. January is when a lot of bills come due and a lot of customers pay slow. Costs are still moving too. In the Federal Reserve’s 2026 Report on Employer Firms, 77% of businesses said rising costs, tariff costs or both were a challenge, so last year’s pattern isn’t a safe guide on its own.
Here’s how to build a 13-week cash flow forecast, how to use it every week, and a free template to get you started.
Thirteen weeks is one quarter. That’s short enough to forecast real payments on real dates, like payroll on the 15th and rent on the 1st, and long enough to see a problem two or three months before it shows up.
It also catches what a monthly P&L can hide. A month can look fine on paper and still have one week where payroll, a big vendor bill and a loan payment all land together. A weekly view shows you that week in advance.
And it keeps the focus on cash, not profit. Loan principal, owner distributions and inventory purchases don’t show up on your P&L the way they hit your bank account. A 13-week cash flow forecast puts them right where they belong. That’s also why bankers like seeing one, and it pairs well with what we covered in what banks want to see in your financials.
You don’t need special software. A spreadsheet works great, and the free template below is already set up for you. Here’s the process.
Use your actual bank balance, not the cash balance on your books. If you have more than one account, add them up. This is your starting line.
Pull your accounts receivable aging and place each invoice in the week you expect the money to land. Use how each customer actually pays, not your payment terms. If a big customer usually runs 20 days late, plan on 20 days late. Then add expected sales you haven’t invoiced yet, plus anything else coming in, like a loan draw.
Put payroll and payroll taxes on your real pay dates. Add rent, loan payments (principal and interest), vendor and inventory payments, credit cards, software and owner distributions. Then look ahead for the lumpy stuff that’s easy to forget, like annual insurance renewals, year-end bonuses and big equipment purchases.
Each week, ending cash equals beginning cash plus cash in minus cash out. That ending number becomes next week’s beginning cash. Do that for all 13 weeks and you can see your cash line for the whole quarter.
Decide the lowest balance you’re comfortable holding. A lot of founders use two payrolls as a starting point. Then flag any week that drops below it. That’s your low point, and now you know about it with weeks to spare.
Here’s what the first four weeks might look like for a company starting with $250,000 in the bank.
| Week 1 | Week 2 | Week 3 | Week 4 | |
|---|---|---|---|---|
| Beginning cash | $250,000 | $230,000 | $245,000 | $160,000 |
| Cash in | $110,000 | $135,000 | $95,000 | $140,000 |
| Cash out | $130,000 | $120,000 | $180,000 | $115,000 |
| Ending cash | $230,000 | $245,000 | $160,000 | $185,000 |
Week 3 is the one to watch. Payroll and a quarterly loan payment land together while a big customer payment slips into week 4. If this company’s minimum cash line is $175,000, it now has two weeks to move a vendor payment, speed up a collection or line up a short draw on its credit line.
A forecast is most useful when it stays current. Block 15 minutes at the same time every week. Enter what actually happened, compare it to what you expected, and roll a new week onto the end so you’re always looking 13 weeks out.
Pay the most attention to the biggest misses. If collections keep coming in late, that’s a pattern worth fixing. If a cost keeps surprising you, it belongs in the forecast going forward.
When a low point shows up, you have options. You can invoice faster and follow up on overdue accounts, talk to key vendors about timing before a bill is due, hold off on an inventory order, or call your banker about your line of credit before you need it. Most of these levers live in your working capital, which we walked through in Net Working Capital: The Cash Flow Lever.
The best forecasts use real payment behavior instead of payment terms. They include the cash items that never hit the P&L, like loan principal and owner distributions. They plan for the lumpy, once-a-year payments. And they get updated every week, because a forecast built once in November is a guess by January.
It also helps to start from books you trust. If your close runs late or your accounts aren’t reconciled, the forecast inherits those gaps. Clean, current books make every week of the forecast more accurate.
We built a simple Google Sheets template that does the math for you. Enter your starting cash, your cash cushion and your weekly cash in and out. It calculates ending cash for all 13 weeks, flags any week below your cushion and gives you a row to track actual results.
Get your free copy of the 13-week cash flow template
Building the forecast is a great first step. Keeping it accurate every week is where most founders run out of time, especially in a busy season.
That’s a big part of what our fractional CFO services cover: building and updating a rolling 13-week cash flow forecast, running scenarios before big decisions like a new hire or a loan, and keeping the monthly close on time so the numbers underneath are solid. For Charlotte founders heading into a new year, it’s one of the most useful tools we can put in place.
A budget sets your plan for the year, usually by month, and focuses on revenue, expenses and profit. A 13-week cash flow forecast looks at the next quarter week by week and focuses on actual cash moving in and out of the bank. Most growing businesses benefit from both.
The direct method. You forecast actual receipts and payments by week, which is what makes it useful for spotting a tight week. The indirect method, which starts from net income, works better for longer-range planning.
Every week. Enter actual results, adjust the weeks ahead and add a new week at the end so you always have 13 weeks in view.
Yes. A spreadsheet works fine. Your accounting system just makes it faster, because your receivables and payables reports give you most of the inputs. If you’re weighing whether to bring in outside help, our fractional CFO cost guide covers typical ranges.
A 13-week cash flow forecast turns January from a surprise into a plan. If you’d like a second set of eyes on yours, or help building one, let’s grab coffee.
Gregg Turkovich is the Managing Partner of Fuse CFO & Accounting, a Charlotte-based firm providing fractional CFO support and operational accounting to growth-stage founders. He helped grow Kan Jam and took it through two sales.
Gregg Turkovich, Fuse
What's on your plate right now?
Free 30-minute call, no pitch. Something else?