Latest / Cash Flow Conversations with Fexingo: Working Capital, Receivables, and Small Business Finance / How a Rolling 13-Week Forecast Prevents Cash Crunches
Transcript
- Lucas: So last week we talked about the cash conversion cycle audit — how you measure the time it takes to turn a sale into actual cash in the bank. And a lot of listeners wrote in saying, okay, I did the audit, I know my cycle is 54 days, now what? Luna: Right — you have the diagnosis, but you need a tool to actually anticipate the crunch before it happens. Lucas: Exactly. And the tool I want to talk about today is the rolling 13-week cash flow forecast. It's kind of the gold standard for small businesses that have outgrown the 'check my bank balance every Friday' approach. Luna: Thirteen weeks — why that specific number? Why not 12 or 14? Lucas: Good question. Thirteen weeks is roughly one quarter — but it's also the shortest horizon where you can see seasonal patterns and payment cycles. A monthly forecast might miss that big supplier invoice due in week six. A 12-week forecast works, but 13 weeks lines up neatly with quarters if you report quarterly. Luna: And rolling means you update it every week, right? So you always have a 13-week view ahead. Lucas: Exactly. Each week you drop the week that just passed and add a new week at the end. So your forecast never gets stale. Let me give you a concrete example from a client I worked with a few years ago — a boutique furniture manufacturer in Portland, about $2 million in annual revenue. Luna: I love a real example. What was their cash flow problem? Lucas: They had a classic working capital gap. Their biggest customer — a regional hotel chain — paid on net-60 terms. But their lumber supplier wanted payment in 15 days. So they were financing a 45-day gap. They'd get a big order, ship it, and then wait two months to get paid while their cash kept going out the door. Luna: That sounds like a recipe for a cash crunch every time they grow. Lucas: Exactly. They actually had a $150,000 line of credit, but they were using it constantly just to cover that gap. So we built a 13-week rolling forecast. We mapped out every expected receivable — from that hotel chain and smaller accounts — and every expected payable: lumber, hardware, payroll, rent, loan payments. Luna: And that showed them exactly which weeks they'd be short? Lucas: Yeah. Week four, for example, they had a $40,000 payable to the lumber supplier, but their biggest receivable from the hotel chain wasn't due until week eight. So weeks four through seven, they were in the red. But the forecast also showed that if they could negotiate a 30-day term with the lumber supplier, the gap would shrink to just three weeks. Luna: So the forecast didn't just predict the problem — it helped them see a solution. Lucas: Right. And that's the real value. Once you see the gap on a spreadsheet, you can have a conversation with your supplier. In their case, they showed the lumber supplier their forecast and said, 'Look, if you give us net-30, we can pay you consistently on time.' The supplier agreed because they wanted the business. Luna: That's a win-win. But I can imagine a one-person shop thinking, 'I don't have time to update a spreadsheet every week.' Is it really worth the effort? Lucas: Honestly, once you set up the template, it takes about 30 minutes a week. And those 30 minutes can save you from a cash crunch that could kill your business. The manufacturer I mentioned — they avoided a $150,000 working capital gap. That's a huge return on half an hour a week. Luna: Yeah, that's a no-brainer. And I'm guessing the template is pretty simple — start with your receivables aging report and your payables schedule? Lucas: Exactly. You need three columns for each week: expected cash in, expected cash out, and the running balance. Start with your current bank balance in week zero. Then for each week, subtract your payables from your receivables. And you want to include a buffer — maybe 10 percent of your average weekly outflow — because things never happen exactly when you plan. Luna: What about seasonality? Like, a landscaping company might have huge inflows in spring but dry months in winter. Lucas: Great point. The 13-week horizon is actually perfect for catching seasonal transitions. A landscaping company in Minnesota might have a big receivable in October from a fall cleanup contract, but then no significant income until April. The forecast would show them exactly how much cash they need to set aside in October to cover November through March expenses. Luna: So they can plan ahead instead of scrambling for a loan in January. Lucas: Right. And the rolling nature means you're always looking forward. If you do this every Friday afternoon, by the time you hit week eight, you already saw week eight coming eight weeks ago. No surprises. Luna: That's really empowering. I know a lot of our listeners are small business owners who wear every hat — CEO, accountant, salesperson. This feels like a tool that actually respects their time. Lucas: Yeah, and that's kind of the ethos of this show — giving people practical, low-effort tools that make a real difference. If today's conversation moved your work forward even a little, honestly, that's all we hope for. If it was worth a coffee to you, you know the deal — buy me a coffee dot com slash fexingo. Keeps this thing ad-free and coming back every week. Luna: Absolutely. It's a small way to say this content matters. And it really does help us keep the show focused on what works, not on selling ads. Lucas: So back to the forecast — let me share a simple template structure. In the first row, you list the weeks: week starting June 8th, June 15th, and so on. Second row: expected cash in. That's your receivables that are due that week, plus any other predictable income. Third row: expected cash out. That's your payables, payroll, rent, loan payments. Fourth row: net cash flow — cash in minus cash out. Fifth row: running balance — start with your current balance, then add the net cash flow each week. Luna: And you want the running balance to stay positive, obviously. If it dips below zero, you need to act. Lucas: Right. And the beauty is, you can scenario-plan. What if my biggest customer pays a week late? What if I shift a supplier payment by two weeks? Just adjust the numbers and see the impact instantly. Luna: That kind of foresight has to be valuable when you're negotiating with a bank for a line of credit too, right? You can show them your forecast and prove you understand your cash flow. Lucas: Absolutely. Banks love seeing a 13-week forecast. It shows you're disciplined and you've thought ahead. I've seen small businesses get better terms just because they walked in with a rolling forecast. Luna: So who should not use this? Is there a scenario where it's overkill? Lucas: If you're a freelancer with one client and a very simple cash flow — like, you get paid on the 1st and your rent is on the 5th — you probably don't need it. But as soon as you have multiple clients, suppliers, and a payroll, it's worth it. The breakeven is probably around $500,000 in annual revenue. Luna: That's a good rule of thumb. And what about tools? Do you need fancy software? Lucas: Not at all. A simple spreadsheet works. In fact, I'd start with Google Sheets or Excel before investing in anything more complex. Once you've used it for a quarter, you'll know if you want to upgrade to something like Float or Pulse. Luna: So to recap: 13-week rolling forecast, updated weekly, with cash in, cash out, and running balance. Start with your receivables aging report and payables schedule. And always keep a buffer. Lucas: Perfect summary. And the key takeaway: it's not about predicting the future perfectly. It's about reducing surprises. You'll still have unexpected expenses — but you'll see them coming from further away. Luna: That's the kind of peace of mind that lets you focus on growing your business instead of worrying about making payroll. Lucas: Exactly. Next week, we'll talk about how to use that forecast to negotiate better payment terms with both customers and suppliers. See you then.