Login

I’m trying to build a rolling 12-month cash flow forecast for my small service business, but I keep getting stuck on how to realistically project my quarterly tax payments. My revenue is irregular, so just using last year’s numbers feels off, but I’m not sure what a better method would be.

I built a rolling 12 cash flow by carving out a little quarterly outflow for obligations I know I’ll owe, then feeding it with what I actually collect. I used a simple reserve rate—a rough percentage of the quarter’s expected receipts—and adjusted it after every quarter when I saw the real numbers. It kept me from scrambling when a big invoice came late.

I tried using last year’s quarterly patterns as a baseline, but the irregular revenue really threw it off. So I switched to a current-year approach: for each rolling 3 months I take the year-to-date cash inflows and income portion, annualize it, and use that as the forecast for the next quarter. I adjust with updates as client work comes in or if a big expense lands. It’s imperfect, but it’s less shocking than the 12-month mirror of last year.

On the tax side, dividing last year’s total into four felt like a blunt instrument. In busy quarters I’d gross up and overpay, in quiet quarters I’d underpay. I now keep a separate tax reserve—a fixed portion of the forecasted profit—and tweak it after each Q to stay in the ballpark. It’s not perfect, but it reduces the panic when payments are due.

Sometimes I drifted off topic and started worrying about the timing of receivables and payables—like whether a vendor invoice lands before you’ve gotten paid by a client. I did a quick test comparing forecast vs actual receipts and realized most of the variance came from late client payments, not the forecast math. I added a 6-week cushion for that and then kept the rest as I go. Do you think the real problem is the forecast, or is it the money actually showing up from clients?

Login
Username:
Password:	Lost Password?
	Remember me