Latest / Cash Flow Conversations with Fexingo: Working Capital, Receivables, and Small Business Finance / How a Plumber's Cash Flow Forecast Saved His Business
Transcript
- Lucas: So there's this plumbing company in Ohio, three vans, eight employees, and the owner's name is Marcus. Revenue was fine, around two point four million a year, but he kept having these moments where he'd look at the bank balance and just panic. Luna: I feel like that's the story of every small business owner I've ever met. Revenue is fine, but the cash isn't there when you need it. Lucas: Exactly. And Marcus's problem wasn't profitability. It was timing. His biggest clients paid on net 45, but payroll hit every two weeks. So there were these recurring gaps where he'd have to draw on a line of credit just to make payroll, then pay it back when the checks came in. It worked, but it cost him in interest and stress. Luna: So what changed? Did he just get lucky with a big job? Lucas: No, he got disciplined. He started a rolling 13-week cash flow forecast. Every Friday, he'd sit down for twenty minutes and map out every invoice he expected to come in and every bill he had to pay, week by week, for the next thirteen weeks. No accounting software magic, just a spreadsheet he maintained himself. Luna: Thirteen weeks seems oddly specific. Why not a quarter, or six months? Lucas: Good question. Thirteen weeks is long enough to see real patterns, especially around seasonal work, but short enough that the numbers are still somewhat predictable. Anything beyond that, and you're just guessing. And the rolling part is key—every week you drop the oldest week and add a new one, so you're always looking at the same forward window. Luna: So what did he see when he first laid it out? Lucas: He saw a shortfall coming in about nine weeks. There was a big payroll week, followed by a slow receivables week because a couple of his big clients had pushed their payment dates. It wasn't a surprise in the sense that he knew those invoices were outstanding, but seeing it all on one timeline made it real. He knew he had to act. Luna: And what did he do? Call the bank for a bigger line? Lucas: That was his first instinct, but instead he called his main supplier. The plumbing supply house where he bought most of his fixtures and materials. He asked if they could switch his terms from net 30 to net 60 on just the next three orders. He told them exactly why—he had a cash flow gap in nine weeks, and if they could give him that flexibility, he'd consolidate all his purchasing with them moving forward. Luna: And they just said yes? Suppliers are usually pretty rigid about that stuff. Lucas: They said yes, but only because Marcus had a track record. He'd been paying on time for three years, and he was a reliable chunk of their revenue. The supplier knew that if they helped him out now, they'd keep that business long term. It was a relationship built on consistent behavior, and this was the payoff. Luna: So he moved three orders to net 60. How much cash did that free up? Lucas: About sixty-eight thousand dollars. That covered the entire payroll gap and then some. He didn't touch his line of credit that quarter, which saved him around eleven hundred dollars in interest. But the bigger win was the habit. He kept the forecast going, and now he catches these gaps months before they happen. Luna: That's the kind of story that makes you want to go build a spreadsheet immediately. But I'm guessing the hard part isn't the spreadsheet, it's the discipline. Lucas: That's exactly right. The forecast is just a tool. The discipline is sitting down every Friday and updating it, even when things are going well. Marcus told me the first few weeks were easy because he was motivated. But after a month, it felt like a chore. He almost skipped it one week, and that would've been the week he missed a small supplier invoice that would've thrown off his whole picture. Luna: It's like flossing. The benefits are invisible until you stop doing it and something rots. Lucas: Ha, exactly. And that's actually a good analogy for why this matters. You don't do a cash flow forecast to know what happened last month. You do it to see what's coming. And if you spot a problem early, you have options. Once you're in the middle of the crisis, your options are a lot more expensive—payroll advances, emergency lines, factoring that eats your margin. Luna: We've talked about factoring on the show before, and it can be a lifeline, but it's not cheap. So the forecast is basically a way to avoid needing the expensive lifeline. Lucas: Right. And not just factoring. It helps you negotiate better with everyone. When you know your cash position thirteen weeks out, you can ask for terms with confidence. You can also delay a purchase you don't really need, or push a client to pay a little faster—though that's a conversation we've covered in other episodes. Luna: Before we go deeper into the mechanics, I have to say—these conversations are exactly the kind of thing that makes the show worth supporting. We keep it ad-free, and that's only possible because a few listeners chip in a couple of dollars a month. If you've gotten something out of Cash Flow Conversations, consider buying us a coffee at buy me a coffee dot com slash fexingo. It genuinely makes a difference. Lucas: Yeah, we're not talking big money here. Every little bit helps us keep doing this. And we do appreciate it. Okay, back to the spreadsheet. Luna: So what does a good 13-week forecast actually look like? Is it just a list of dates and amounts? Lucas: It's more than that. The key is to separate your cash inflows and outflows into categories. For Marcus, inflows were customer payments, and he listed them by client, so he could see which ones were reliable and which ones always paid late. Outflows were things like payroll, rent, materials, and loan payments. He also had a line for unexpected expenses—just a buffer, maybe five percent of your average weekly outflow. Luna: And how did he handle the fact that some clients pay late? Did he just assume they'd pay on time and hope for the best? Lucas: No, that's the other thing he learned. He started using historical data to estimate when he'd actually receive payment, not when the invoice said it was due. For a client who consistently paid ten days late, he'd schedule the cash flow in week ten, not week seven. That made the forecast a lot more accurate. Luna: That's so simple but probably transformative. Most people probably just put the due date and then wonder why their forecast is wrong. Lucas: Exactly. And once Marcus had that accurate picture, he also started using the forecast to make better purchasing decisions. He'd see a slow week coming up and decide to push a big equipment purchase to the following week when he knew a big payment was landing. It's like moving furniture in a room—you just shift things around so everything fits. Luna: Did he ever consider just asking his clients for better payment terms instead of relying on the forecast? Lucas: He did, but he knew that was a tougher conversation. His big clients were bigger than him, so they had the leverage. He could ask for shorter terms, but they'd probably say no, or worse, they might slow down their payments. The supplier negotiation was easier because he had a relationship and a credible commitment. Luna: So the forecast gave him the clarity to know which negotiation was worth having. Lucas: Exactly. And that's the real value. It's not just about avoiding a cash crunch. It's about making better decisions across the board. When you know your cash position, you can say yes to a new project because you know you can fund the upfront costs. You can invest in a new van without sweating the down payment. You can even take a slightly bigger risk because you've got a buffer. Luna: And what about the flip side? Did the forecast ever make him feel too confident and take on something he shouldn't have? Lucas: That's a fair caution. Marcus said the forecast actually made him more cautious in some ways. He started seeing the full cost of every decision, including the opportunity cost. He turned down one job that would've required him to buy a bunch of specialized equipment because the forecast showed it would tie up too much cash for too long. Luna: That's a lesson a lot of business owners could use. It's not just about making money—it's about whether you can afford to wait for the money. Lucas: Right. And that's the difference between a profitable business and a sustainable one. Marcus's business was always profitable on paper, but now it's profitable and sustainable. He's got a three-month cushion of visibility, and that's completely changed how he runs the company. Luna: So if someone listening right now wants to start doing this for their own business, what's the first step? Do they need to buy fancy software? Lucas: No, Marcus used a spreadsheet. I'd say start with a simple template—columns for weeks, rows for categories. List your expected inflows and outflows based on historical data, not due dates. Then update it every week without fail. If you miss a week, you're flying blind. The whole point is to build the habit. Luna: And how long until it starts paying off? A month? Two? Lucas: Honestly, it pays off in the first week because you immediately see where you're guessing. But the real payoff comes after a few months when you have enough history to make the forecast reliable. Marcus says the first time he saw a full quarter without touching his line of credit, he felt like he'd won the lottery. But it was just a spreadsheet. Luna: That's a great image to end on. A spreadsheet as a lottery ticket. Thanks, Lucas. Lucas: Thanks, Luna. And to our listeners—if you've got a business, even a small one, give this a try. It's twenty minutes a week that could save you a sleepless night.