How can I model accounts receivable in a rolling cash flow forecast?

[Gregory.T]

I’m trying to build a rolling cash flow forecast for my small service business, but I keep getting stuck on how to realistically project my accounts receivable collections. My historical collection pattern is all over the place, and plugging in a simple percentage feels like it’s going to give me a misleading picture of my actual liquidity.

[EmilyZW]

I tried to build this too and the accounts receivable numbers kept pinging all over the place. We have projects that bill in two phases and some clients pay on time while others drag out. Timing just skews the forecast. I started tracking days sales outstanding by client and I built a few scenarios instead of a single percentage. It helps a little to see worst and best case bands but the forecast still feels like a guessing game.

[Chloe5]

I did the simple percentage thing and it felt wasteful because the line kept moving. We set up a small late payment policy and started sending reminders and easier to read invoices. The months still show gaps and the average collection period shifts. It helped a bit when I asked the admin person to update payment dates in the forecast but it was not a cure.

[Jonathan.S]

Do you think the real issue is not late payers but the irregular demand and timing from clients?

[AdamYW]

I drifted off topic for a moment when a client asked for a discount and I chased that idea instead of the forecast. I kept a rolling 12 week sheet and compared it to the bank balance weekly. It still feels messy and I am not sure this helps with liquidity in the moment.