Latest / Cash Flow Conversations with Fexingo: Working Capital, Receivables, and Small Business Finance / How Rolling Cash Flow Forecasts Prevent Small Business Crises
Transcript
- Lucas: There's this moment every small business owner knows — you check your bank balance, and it's lower than you expected. Not because you lost money, but because a big customer payment that was supposed to arrive three weeks ago still hasn't shown up. And meanwhile, payroll is tomorrow. Luna: Right, it's not a profitability problem — it's a timing problem. You're profitable on paper, but broke in the bank. Lucas: Exactly. And that timing gap is what a rolling cash flow forecast is designed to catch. Not the once-a-year budget, but a living document that looks ahead every single week. I want to talk about why the rolling forecast is the single most underused tool in small business finance. Lucas: If these conversations have moved your work forward in some small way, the way we keep this show ad-free and focused on practical tools is through listener support. You can find us at buy me a coffee dot com slash fexingo. It makes a real difference, and it keeps us independent. Luna: Yeah, and we really appreciate it. It's what lets us dig into topics like this without any sponsor constraints. Lucas: So let's get into the mechanics. A rolling forecast isn't about predicting the future perfectly — it's about reducing the surprise. You're updating your cash inflows and outflows weekly for the next 13 weeks. That's the standard horizon. Luna: Why 13 weeks specifically? Why not 12 or 16? Lucas: Good question. 13 weeks is basically one quarter, but it's long enough to see seasonal patterns — like a retailer who has a big inventory buy three months before the holiday season. And it's short enough that your assumptions are still grounded. Anything beyond 13 weeks, and you're basically guessing. Luna: So you're not trying to forecast revenue for next year — you're just trying to make sure you survive the next three months. Lucas: Exactly. And the 'rolling' part means that every week, you drop the oldest week and add a new one. So you always have a 13-week forward view. It forces you to constantly update your assumptions based on what actually happened. Luna: Let's make this concrete. Can you walk us through a real example? Lucas: Sure. Let's say there's a boutique furniture manufacturer I'll call Maple & Oak. They make custom tables and chairs. They're profitable — gross margins around 45 percent. But they had a cash crunch last year that almost shut them down. Luna: What happened? Lucas: They landed a big contract with a hotel chain — $200,000 worth of furniture. Great news, right? But the hotel chain's payment terms were net 60 days. Maple & Oak had to buy lumber, pay their artisans, and cover rent for two months before seeing a dime from that contract. Luna: And they didn't see it coming. Lucas: They had a profit and loss statement that showed they were in the black. But they didn't have a cash flow forecast. So when the lumber supplier demanded payment in week 3, and payroll hit in week 4, their bank balance dropped to $4,000. They had to scramble for a short-term loan at a high rate. Luna: And a rolling forecast would have caught that? Lucas: Absolutely. If they had mapped out their expected inflows — that $200,000 coming in week 9 at the earliest — and their outflows — lumber in week 3, payroll in week 4, rent in week 1 — they would have seen the $4,000 low point coming from week one. They could have negotiated better terms with the lumber supplier, or arranged a line of credit in advance. Luna: So the forecast gives you time to act. Instead of reacting in a panic, you have weeks to find a solution. Lucas: That's the whole point. And the most important input for a good forecast is your receivables aging report. Because your biggest uncertainty is usually when customers will actually pay, not whether they'll pay. Luna: How do you use the aging report in the forecast? Lucas: You take each outstanding invoice and assign a probability of being paid in a given week based on how overdue it is. For example, invoices that are 0 to 30 days old might have a 90 percent chance of being paid in the next week. Invoices 31 to 60 days overdue might have a 60 percent chance. Over 90 days, maybe 30 percent. Luna: So you're not just assuming everyone pays on time. Lucas: Right. That's the mistake most owners make. They look at their sales and assume cash comes in when the invoice is due. But the real world is messier. A rolling forecast that incorporates your actual collection history is much more accurate. Luna: And what about the outflow side? What should you include? Lucas: Everything that could hit your bank account in the next 13 weeks. Rent, payroll, supplier payments, taxes, loan payments, even estimated credit card processing fees. The more granular, the better. And you should separate fixed obligations from variable ones. Luna: Okay, so let's say I'm a small business owner listening right now. How do I actually start building one of these? Lucas: You can start with a simple spreadsheet. Column A is the week ending date. Then you have rows for beginning cash balance, expected cash inflows, expected cash outflows, and ending cash balance. For inflows, list each customer you expect to pay and the amount. For outflows, list each expense. Luna: And update it every week? Lucas: Yes. Every Friday afternoon, compare your forecast to what actually happened. Did a customer pay earlier than expected? Did a supplier invoice come in higher? Adjust the next 13 weeks accordingly. That's the rolling part. Luna: It sounds simple, but I imagine most owners don't do it because it feels like a chore. Lucas: It's a discipline. But once you've done it for a few weeks, it becomes a habit. And the payoff is huge. You stop getting blindsided. You start making better decisions about when to invest in inventory or hire someone. Luna: I've heard some business owners say they use their budget as their forecast. Why is that insufficient? Lucas: A budget is a static plan for the year. You set it in January and maybe revisit it quarterly. But a cash flow forecast is a dynamic tool. It reflects what's actually happening. If you get a big order in March, your budget doesn't change — but your forecast should update immediately. Luna: So the budget tells you if you're on track to be profitable. The forecast tells you if you'll have enough cash to keep the lights on. Lucas: Exactly. And you can be profitable and still go out of business if you run out of cash. That's the paradox of growth. The more you sell, the more you have to spend upfront on inventory and labor, and the more you're waiting on customer payments. Luna: That's why venture-backed startups can burn through cash so fast — they're growing, but the cash outflow comes before the cash inflow. Lucas: Right. And for a small business without a venture cushion, a rolling forecast is your early warning system. Let me give you one more example. I talked to a landscaping company in Denver that started doing 13-week forecasts after a close call. Luna: What happened to them? Lucas: They had a great spring — lots of new contracts. But all those contracts required them to buy plants and materials upfront. Their forecast showed that in late June, they'd have only two weeks of cash left. That gave them time to arrange a line of credit with their bank, which they used for exactly three weeks before the customer payments started rolling in. Luna: So they used the forecast proactively instead of reactively. Lucas: Exactly. And the bank was impressed that they came in with a forecast. It made the loan approval easier. Banks love to see that you understand your cash flow. Luna: What's the biggest mistake people make when they first start forecasting? Lucas: Being too optimistic about payment timing. Most owners assume customers will pay on the due date. But the reality is that the average small business invoice is paid 10 to 15 days late. If you build that lag into your forecast, you'll be much more accurate. Luna: So base your timing on history, not hope. Lucas: Exactly. Look at your receivables aging over the past six months. Calculate the average number of days it actually takes to get paid. Use that number, not your stated terms. Luna: And what about the outflows? Any common mistakes there? Lucas: People forget quarterly tax payments. Or they forget that they have to pay sales tax a month after collecting it. Those are big surprises. Also, if you have a credit card, remember that you might not pay the balance until weeks after the statement closes. That timing matters. Luna: So the forecast should include every single cash movement, no matter how small. Lucas: Yes. Even small things like software subscriptions or insurance premiums. They add up and they have specific due dates. Missing one can trigger a late fee or a service interruption. Luna: How often should a business owner review the forecast? Lucas: At least once a week. Many successful owners do it every Monday morning for 15 minutes. They update the actuals from last week and look at the next four weeks closely. That's usually the critical window. Luna: And if they see a problem, what do they do? Lucas: They have options. They can delay a non-essential purchase. They can call a customer who's overdue and offer a small discount for immediate payment. They can ask their bank for a short-term line of credit. The key is they have time to choose the least painful option. Luna: So a rolling forecast doesn't just prevent crises — it actually gives you negotiating leverage. Lucas: Absolutely. When you know you'll be short in three weeks, you can call a supplier and say, 'Can we push this payment to week 5?' instead of calling on the due date and saying, 'Sorry, I can't pay.' The first conversation is a lot easier. Luna: I think the takeaway here is that this is a tool any business owner can use, regardless of size or industry. Lucas: It really is. You don't need fancy software. A spreadsheet, your bank statements, and your receivables aging report — that's all you need to start. And once you see the power of knowing your cash position 13 weeks out, you'll never go back. Luna: So for anyone listening who's been caught off guard by a cash crunch, this is the fix. Lucas: It is. And the best time to start is this weekend. Block out an hour, open a blank spreadsheet, and map out the next 13 weeks. Your future self will thank you.