Forecasting Cash Flow From Your Receivables
Module 4: Cash Flow & Working Capital, Chapter 3
The short answer
Cash flow forecasting from AR means projecting when open invoices will actually convert to cash, based on your own historical payment patterns by aging bucket, not just assuming every invoice pays exactly on its due date. A realistic forecast accounts for the fact that some percentage of every bucket always pays later than terms specify.
Why isn't the aging report itself already a forecast?
Because an aging report shows what's currently outstanding, a snapshot, not a prediction of when it converts to cash. Two businesses with an identical aging report can have very different actual collection timelines, depending on their own clients' real payment behavior. A forecast layers your own historical pattern on top of the snapshot.
How do you actually build one?
- Pull your current aging report, the same one covered in Module 1, broken into its standard buckets.
- Apply your own historical collection rate by bucket. If Current invoices historically collect at 95% within two weeks, and 31-60 day invoices historically collect at 60% within the following month, use those real rates, not an assumption that everything pays exactly on time.
- Project the resulting cash by week or month, rather than treating the whole AR balance as available on a single date.
| Bucket | Balance | Historical collection rate (30 days) | Forecasted cash |
|---|---|---|---|
| Current | $40,000 | 90% | $36,000 |
| 1-30 days | $15,000 | 70% | $10,500 |
| 31-60 days | $8,000 | 45% | $3,600 |
| 60+ days | $5,000 | 20% | $1,000 |
This gives a materially more realistic 30-day cash projection ($51,100) than simply assuming the full $68,000 balance converts to cash on schedule.
Where do the historical collection rates actually come from?
Your own payment history, reviewed over at least the last several months. This is one of the clearest reasons consistent aging report tracking, covered in Module 1, pays off beyond just monitoring: it's the raw data a real forecast depends on.
How often should this forecast be updated?
Weekly for active cash management, since both the aging report and the incoming payments change constantly. A forecast built once a quarter is already stale by the time most of it plays out.
Quick check
Three questions. No email required, this one's just for you.
1. Why isn't an aging report by itself already a cash flow forecast?
2. Where should the collection-rate assumptions in a cash flow forecast actually come from?
3. How often should a receivables-based cash flow forecast typically be updated for active cash management?
Frequently asked questions
What if I don't have enough payment history yet to calculate real collection rates?
Start with conservative, general assumptions (roughly matching the healthy-aging benchmarks from Module 1) and refine them with your own data as it accumulates over the first several months.
Does this forecast need to be complicated to be useful?
No, even a simple spreadsheet applying rough historical rates by bucket is far more useful than assuming the full AR balance converts to cash on schedule.
How does this connect to the rest of the module?
This forecast is the foundation for the 13-week cash flow forecast covered in this module's final chapter, which combines this receivables projection with the rest of the business's cash inflows and outflows.
Sources
- Standard AR forecasting methodology, aging-bucket collection rate approach
Prefer to have this run for you?
A Receivables Review shows exactly where your own AR process could improve.
Book a Receivables Review