How can I forecast monthly cash flow for a service business with delayed payments?

[SavannahD]

I run a small digital marketing agency, and while we're profitable on paper, I constantly feel like I'm flying blind when it comes to our monthly cash position. My current cash flow forecasting is basically just guesswork based on when I think invoices will be paid, and it's led to a few stressful scrambles to cover payroll. For other small business owners, what tools or methods have you found most effective for creating a reliable forecast? How do you accurately predict your variable expenses and account for client payment delays, and what's a reasonable cash buffer to aim for in a service-based business with recurring but not always consistent revenue?

[AlexanderL]

You’re not alone—lots of small agencies run into this. The contrast between “on-paper” profitability and actual cash is real. My go-to setup is a rolling 13‑week cash flow forecast that updates every week. Build it in a spreadsheet (or your accounting tool if it has one) and separate inflows (invoices due, retainers, new deals) from outflows (payroll, taxes, vendors). The trick is to bake in your collection window based on your current DSO and to run several scenarios (best, expected, and a conservative case). For a buffer, aim for at least 1–2 months of operating expenses; if you’re payroll-heavy or see seasonal slumps, target 3–4 months. A line of credit or credit facility gives you a real safety net, and you can reduce risk by requiring deposits or milestones for larger projects to smooth cash.