Latest / Cash Flow Conversations with Fexingo: Working Capital, Receivables, and Small Business Finance / How a Red-Yellow-Green Receivables Dashboard Works
Transcript
- Lucas: Let me start with a number: a landscaping firm I spoke with recently had $47,000 sitting in invoices that were between 60 and 90 days past due. They didn't have a system to see it until their bookkeeper flagged it at month-end. By then, three customers had already gone quiet. Luna: Right, because by the time you notice, the money is already trapped. So how do you catch it earlier? Lucas: You build a receivables dashboard — and the simplest effective version is a red yellow green system based on days past due. Let me walk through how it works and why it's surprisingly powerful. Luna: Before you go deep — and I know you're about to — I just want to say something. If these conversations have moved your work forward in some small way, listener support is what keeps this show ad-free. It's at buy me a coffee dot com slash fexingo. Not a big ask, just if it's useful. Okay, back to the dashboard. Lucas: Thanks, Luna. So the basic idea is simple: every invoice gets a color. Green means 0 to 30 days — normal, no urgency. Yellow means 31 to 60 days — watch it, maybe send a reminder. Red means over 60 days — escalate, call, stop work if needed. Luna: That sounds like a fancy version of an aging report. What makes it different? Lucas: An aging report is static — it's a snapshot at month-end. A dashboard, if you update it weekly or even daily, becomes a living tool. The landscaping firm I mentioned started doing that. They put a simple spreadsheet on a shared drive with three columns: client name, invoice amount, and a color cell they changed manually. Luna: Just color-coded cells in a spreadsheet? Lucas: Exactly. No special software. They had about 50 active invoices at any time. Every Monday morning, the office manager spent 15 minutes updating the colors based on how many days since the invoice date. The owner would glance at it for 30 seconds and know exactly which accounts needed attention. Luna: And that changed behavior? Lucas: Dramatically. Within three months, their over-60-day receivables dropped by about 30 percent. Why? Because red invoices got a phone call the same week they turned red, not at month-end. And customers learned that this company pays attention, so they paid faster. Luna: So it's partly a psychological effect on the customer too. Lucas: Yes, but also on the business owner. When you see a sea of green, you feel good. When you see too much red, you know you have a problem. It creates an emotional signal that drives action in a way that a table of numbers doesn't. Luna: Are there any pitfalls? I can imagine someone setting it up and then ignoring it after two weeks. Lucas: That's the biggest risk. The dashboard is only as good as the discipline to update it. The landscaping firm made it part of a Monday morning routine — same time, same person. They also added a simple rule: no new work for any client with a red invoice unless the owner approved it. Luna: That's a powerful lever. If you stop providing service, suddenly payment becomes urgent. Lucas: Right. But you have to be consistent. If you make exceptions, the system breaks. The owner told me the hardest part was telling a long-time client, 'I can't send my crew until you clear that invoice.' But he said after two times, that client never went red again. Luna: So it's a combination of visibility and a hard rule. What about scaling? Does this work for a business with hundreds of invoices? Lucas: At a certain point, manual color coding becomes tedious. But you can automate it. Most accounting software — QuickBooks, Xero, FreshBooks — can generate aging reports that you can export and then conditionally format in Excel. Or you can use a tool like Airtable that updates colors automatically based on date fields. Luna: So the barrier to entry is really low. A spreadsheet and a weekly routine. Lucas: Yeah. And I'd say the routine is actually more important than the tool. The landscaping firm's owner said the biggest insight wasn't the dashboard itself — it was realizing that he had been ignoring the problem because he didn't have a clear picture. Once he saw the red, he couldn't unsee it. Luna: That reminds me of something I read about visual management in manufacturing. It's the same principle — making problems visible so they get solved. Lucas: Exactly. It's borrowed from lean operations. And it applies perfectly to cash flow. One more detail: they also added a fourth color — gray — for invoices that were in dispute. So red meant 'needs action,' gray meant 'needs resolution but not necessarily payment today.' That prevented confusion between a slow payer and a disputed charge. Luna: That's smart. Because a dispute requires a different process than a dunning call. Lucas: Right. And if you lump them together, you might pressure a good customer over a misunderstanding. So the system needs nuance. Luna: Let me ask about the thresholds. You said 0-30 green, 31-60 yellow, over 60 red. Is that standard? Could a business use different buckets? Lucas: Absolutely. It depends on your industry and payment terms. If you offer net-30 terms, 30 days is still green. But if you're in construction with net-60, you might shift the yellow to 61-90 and red to over 90. The key is to align the colors with what's normal for you and what's alarming. Luna: And you'd set the thresholds based on your historical data? Lucas: Yes. Look at when your typical customer pays. If most pay within 45 days, then yellow could start at 46. But I'd recommend making red anything beyond your comfort zone — for many small businesses, that's 60 days, because after 60 days the probability of non-payment spikes. Luna: So it's a simple system, but it forces you to know your numbers. Lucas: Exactly. And that's really the point. A lot of small business owners avoid looking at receivables because it's stressful. But a color-coded dashboard turns it into a quick scan. You see the red, you act, and you move on. It reduces the cognitive load. Luna: I want to try this myself. I have a few freelance clients. I'm going to set up a spreadsheet tonight. Lucas: Do it. And if you do, let me know how it goes. I think you'll be surprised at how much clarity it brings. Luna: Will do. So to recap: simple color code, weekly update, hard rule on new work for red accounts, and adjust thresholds to your industry. That's a receivables dashboard in a nutshell. Lucas: That's it. And if you're listening and you haven't looked at your aging report this month, maybe today's the day. It could save you from that $47,000 surprise.