Latest / Cash Flow Conversations with Fexingo: Working Capital, Receivables, and Small Business Finance / How a Bookkeeper Used Cash Flow Forecasts to Land a Line of Credit
Transcript
- Lucas: So Luna, let me ask you something — if you run a bookkeeping firm, and you need a hundred and fifty thousand dollar line of credit to cover payroll during tax season, what do you take to the bank? Luna: I'd probably take my tax returns, profit and loss statements, maybe a list of clients under contract. Lucas: Right, and that's what most business owners bring. But the bank loan officer I talked to said those documents alone often aren't enough for a service business with few hard assets. The real game-changer? A cash flow forecast — projected month by month for the next six months. Luna: A forecast, not just historicals. That makes sense — the bank wants to know you'll have the cash to repay, not just that you had it last year. Lucas: Exactly. And we've got a specific case that shows exactly how this worked. A bookkeeping firm — let's call her Sarah — runs a practice in the Chicago suburbs. She had about forty small-business clients, monthly retainers plus some project work. Her problem: tax season from February through April meant she had to pay two extra part-time bookkeepers, and that created a cash crunch every year. Luna: So she needed a line of credit to bridge the gap. But she didn't own a building, didn't have equipment to pledge — just her receivables and her reputation. Lucas: Right. She approached a local community bank that knew her business account history. They asked for her financial statements, but also — and this is the key — they asked for a twelve-month cash flow projection. Not just a budget, but a proper forecast showing expected cash inflows by month, outflows by category, and the resulting cash balance. Luna: Did she have one ready? Lucas: She did not. She had QuickBooks with historical data, but no forward-looking model. So she built one. And the process of building it is what I think our listeners can really learn from. Luna: Walk me through it. What went into that forecast? Lucas: Start with the inflows. She listed every client, their monthly retainer, and the expected month of payment. Then she added project-based revenue — things like year-end tax prep for business clients, which tends to hit in March and April. For new clients, she estimated based on her pipeline of leads. She built a simple spreadsheet: one row per client, columns for each month. Luna: That's the revenue side. But cash flow forecasting also has to account for timing. If a client pays net 30, the invoice date isn't the cash date. Lucas: Exactly. She used her actual receivables aging to model a delay. For retainers, she assumed payment within 15 days — most of her clients paid by credit card. For project work, she assumed net 30. So the forecast showed cash inflows about two weeks to a month after the invoice date. That's a critical detail banks look for. Luna: And the outflows? Payroll is the big one for a service firm. Lucas: Payroll, rent, software subscriptions, insurance, and her own draw. For the extra seasonal staff, she added those payroll costs in February, March, and April. She also included an estimated tax payment in April. The result: a month-by-month cash balance projection. And what it showed was that her cash balance would drop to about eight thousand dollars in March — dangerously low for a business with forty thousand in monthly expenses. Luna: So the forecast actually identified the exact size and timing of the gap. That's powerful for a loan officer. Lucas: Powerful, and exactly what the bank wanted to see. The loan officer told me — and this surprised me — that most applicants just give them tax returns and say 'trust me.' But a cash flow forecast shows you've thought through the cycle. It shows the bank that you understand your business's liquidity pattern. Luna: What else did the bank look at in her forecast? Lucas: Two specific metrics. First, the minimum operating cash balance. Banks want to know you'll maintain a buffer above zero. Sarah's forecast showed she'd hit eight thousand, but with the line of credit, she'd never go below twenty thousand. Second, the debt service coverage ratio — projected net operating income divided by the proposed loan payment. The bank wanted to see at least 1.25 times coverage. Sarah's forecast showed 1.4. Luna: So she wasn't just asking for money — she was demonstrating her ability to repay. That's the difference between a borrower and a supplicant. Lucas: Exactly. And the bank approved her for a hundred and fifty thousand dollar line of credit at prime plus one point five, secured by a blanket lien on business assets, but no personal guarantee. That's rare for a service business with less than five years of history. Luna: No personal guarantee? That's a huge win. How did the forecast help her avoid that? Lucas: The loan officer said the forecast gave them confidence that the business itself could service the debt. When a borrower comes in with a detailed projection and can explain the assumptions — like why client payments lag by 15 days, or why payroll spikes in March — it signals operational maturity. The bank felt the risk was manageable without requiring her personal assets. Luna: I'm struck by how accessible this is. Any business owner with a spreadsheet and a half-day could build a forecast like that. Lucas: Absolutely. And the tools are easier than ever. Sarah used a template she found online from SCORE — the small business mentoring organization — and customized it. The key is to be honest about your assumptions. Don't inflate revenue projections. Banks will compare your forecast to your historical numbers, and if they don't match, they'll know. Luna: So what's the takeaway for a listener who's thinking, 'I need a line of credit but I've been putting it off'? Lucas: Start building the forecast today. Even if you're six months away from applying, start tracking your actual cash flow against a projection. That practice alone will make you a better business operator. And when you do go to the bank, bring that forecast — not just tax returns. Show them you see around corners. Luna: That's really useful. And if today's conversation helped you see a new path forward, that's exactly why we do this show ad-free — listener support keeps it that way. If you'd like to chip in, you can find us at buy me a coffee dot com slash fexingo. Lucas: Yeah, it's a small gesture that goes a long way toward keeping these conversations accessible to everyone who needs them. Now, speaking of seeing around corners — let's talk about one more thing Sarah did that I think is worth mentioning. After she got the line of credit, she didn't just use it for payroll. She also used it to offer early payment discounts to her biggest client, which actually improved her cash conversion cycle. Luna: That's clever — using the line strategically instead of just as a safety net. How did that work? Lucas: Her largest client was a medical practice that paid net 60. She offered them a 2 percent discount if they paid within 10 days. The cost of the discount was about eight hundred dollars a year, but it brought in sixty thousand dollars in cash about 50 days earlier. That cash then reduced her reliance on the line of credit, saving her about twelve hundred dollars in interest annually. Net positive. Luna: So the line of credit gave her the confidence to offer a discount she otherwise couldn't afford to wait for. It became a tool for growth, not just survival. Lucas: Exactly. And that's the mindset shift I'd love for every small business owner to have. A line of credit isn't an emergency fund you hide in the closet. It's a working capital tool that lets you optimize your cash flow. But you can't use it well unless you have a forecast telling you when you'll need it and when you can pay it back. Luna: So the forecast is the foundation. Without it, you're flying blind. With it, you have a map. Lucas: A map with a pretty clear route. If you're listening and you've been thinking about applying for a line of credit, I'd say spend this weekend building that six-month forecast. There are templates on the SBA website, on SCORE, even on YouTube. Then take it to a community bank or a credit union — they're often more willing to work with small businesses than the big national banks. Luna: And don't be afraid to ask the loan officer what they'd like to see. Sarah said she called ahead and asked, 'What would make my application stronger?' That's how she learned about the forecast in the first place. Lucas: Great point. Banks are in the business of saying yes — they need to lend money to make money. Help them say yes by giving them the data they need. A cash flow forecast does that better than almost anything else. Luna: Alright, next week we're going to look at a different angle — how a small manufacturer used a similar forecast to negotiate better terms with a key supplier. That one involves a surprising conversation about payment timing. Lucas: Looking forward to it. Until then, keep an eye on your cash, and build that forecast.