Latest / Cash Flow Conversations with Fexingo: Working Capital, Receivables, and Small Business Finance / How a Bookkeeper Used Rolling Forecasts to Avoid Cash Crises
Transcript
- Lucas: You know the classic small business trap — you're profitable on paper, but you can't pay your bills because the cash hasn't landed yet. Luna: Oh, the 'profitable but broke' club. I've seen it more times than I'd like to admit. Lucas: Exactly. And most business owners try to solve it with either a budget or a prayer. But today's guest, a bookkeeper named Maria in Austin, used something a lot more surgical: a rolling 13-week cash flow forecast. Luna: Rolling forecast — that's where you update the forecast every week, right? So it always looks 13 weeks ahead. Lucas: Right. And Maria's case is interesting because she runs a solo bookkeeping practice, about $180,000 in annual revenue. Not a big operation. But she realised that her biggest client — a construction subcontractor — paid on a 45-day average cycle. That created a predictable cash gap every March when her quarterly taxes hit. Luna: So she knew the problem was coming. Did she have a budget? Lucas: She did. A traditional annual budget. But a budget is a static snapshot — it tells you 'you should have $10,000 left in March' based on assumptions you made six months ago. Her rolling forecast updated every Friday with actual receivables, actual payables, and a new 13-week outlook. And in January, that forecast showed her that her March cash balance would dip to negative $15,000. Luna: Ouch. But that's useful — she saw it coming two months early. Lucas: That's the whole point. She didn't panic. She went to her bank — a local credit union — and asked for a $75,000 line of credit. But here's the key: she didn't just show them her tax returns. She showed them the rolling forecast. The bank could see exactly when the cash would dip, when it would recover, and that the risk was temporary and seasonal. Luna: And they approved it? Lucas: Approved. $75,000 at prime plus two. The loan officer told Maria that most small business applications show up with a tax return and a vague 'I think I'll need money in spring.' She came in with a color-coded spreadsheet showing the exact week she'd draw, the exact amount, and the exact week she'd pay it back. Luna: That's a completely different conversation with a lender. You're not asking for a favor — you're showing them a plan. Lucas: Exactly. And that plan was built on three data points. First: accounts receivable aging. She knew her average client paid in 45 days, but she also knew which clients were trending toward 60 or 90. Second: payment terms on her own bills — her software subscriptions, her rent, her quarterly tax estimates. Third: seasonal patterns. Construction slows in February, so her client's payment would be late that month, pushing her cash crunch into March. Luna: So the forecast was basically a map of her actual cash cycle, not a wish. And she updated it every week. That's discipline. Lucas: It is. And she used a simple Google Sheets template — nothing fancy. The forecast had columns for each week: beginning cash, expected collections, expected payments, and ending cash. She'd adjust the actuals every Friday, then re-project the next 13 weeks. The whole thing took maybe 20 minutes a week. Luna: Twenty minutes. That's less than most people spend scrolling social media. And it saved her from a cash crisis. Lucas: And it did more than that. Once she had the line of credit, she didn't even need to use it right away. Just having it gave her peace of mind. But then in March, when her client payment was delayed by an extra week, she did draw $40,000 to cover payroll. She repaid it in full six weeks later when the client paid. Luna: So the line of credit cost her maybe a few hundred dollars in interest. Versus a late payroll penalty or a bounced check fee that could have been thousands. And a lot of stress. Lucas: Right. And she told me the forecast also changed how she talks to clients. She now sends a simple one-page cash flow summary to her two biggest clients every quarter, showing them how their payment timing affects her business. One of them actually adjusted their payment schedule from net 45 to net 30. Luna: That's a great ripple effect. The forecast became a communication tool, not just a planning tool. Lucas: Exactly. And I think that's the lesson a lot of small business owners miss. A rolling forecast isn't just for predicting — it's for negotiating. It gives you data to have a real conversation with lenders, with clients, with suppliers. Luna: I want to dig into the mechanics a bit. How detailed does the forecast need to be? Do you need to track every single transaction? Lucas: Maria's approach was to group transactions into categories. For collections, she listed each client separately if they represented more than 10% of revenue — that way she could see the impact of a late payment from a big client. For payments, she grouped by type: payroll, rent, software, taxes, and miscellaneous. That's about 10 to 15 line items per week. Luna: So manageable. And the 13-week window — why 13 weeks instead of 12 months? Lucas: Good question. A 13-week forecast is short enough to be accurate — you're not guessing about next November — but long enough to catch most cash cycles. For most small businesses, the cash conversion cycle is somewhere between 30 and 90 days. Thirteen weeks covers that plus a buffer. Plus, it aligns with a quarter, which makes it easy to compare to actuals. Luna: And it forces you to update it regularly. A 12-month budget you might look at once a quarter. A 13-week rolling forecast you touch every week. Lucas: Exactly. And that weekly touch is what makes it powerful. Because you're constantly comparing your forecast to reality. You see the variance immediately. If a client pays late, you adjust the next week's forecast and see the ripple effect. Luna: So it's a living document. And Maria's case shows it doesn't require a finance degree or expensive software. Lucas: Not at all. She used Google Sheets. There are templates online. Or you could use a simple Excel file. The tool isn't the point — the habit is. Luna: Speaking of habits, this show is ad-free and listener-supported. If these conversations help you think about cash flow differently, and you want to help us keep doing them, you can support us at buy me a coffee dot com slash fexingo. No pressure, but every bit helps. Lucas: Yeah, it's a small way to keep this resource available for everyone. And we really appreciate it. Luna: Okay, back to Maria. She's now been running the forecast for about eight months. Has it changed her business beyond the line of credit? Lucas: It has. She told me she's now planning to hire a part-time assistant this fall, because the forecast shows her cash flow will support it. Without the forecast, she probably would have waited another year, or just kept overworking herself. Luna: So the forecast gave her the confidence to grow. That's the flip side of cash flow management — it's not just about avoiding disaster, it's about seeing opportunity. Lucas: Exactly. And that's the big takeaway from Maria's story. A rolling 13-week forecast doesn't have to be perfect. It just has to be current. Start with a simple spreadsheet, update it every Friday, and within a month you'll start seeing patterns you never noticed before. Luna: And the next time you need a line of credit, you'll walk in with a map instead of a wish. Lucas: Maria's case is proof that it works. Next week, we'll look at how a small manufacturer used a similar forecast to negotiate better terms with suppliers.