Collections Forecast Checklist
A collections forecast turns your aged receivables into a dated view of the cash you expect to bring in. This checklist helps you build a forecast that is realistic enough to plan around.
What this checklist covers
- Build a dated forecast of expected receipts from AR
- Weight expected cash by account behaviour and risk
- Incorporate promises to pay and known disputes
- Compare the forecast to actuals to improve accuracy
- Feed the forecast into cash-flow planning
7 min
Before you start
A forecast is only as good as the receivables data and the assumptions behind it. Reconcile the ledger and gather your behavioural context first.
- Confirm the aged trial balance is reconciled and cash applied.
- Pull each customer's terms and recent payment behaviour.
- Gather promises to pay, payment plans and known disputes.
- Decide the forecast horizon and the time buckets — weekly is common for cash planning.
Step 1 — Date the expected receipts
- For each open invoice, set an expected payment date from its due date and that customer's habits.
- Use a customer's actual pay-pattern, not just terms — a habitual late payer should not be forecast on time.
- Slot each expected receipt into the right week of the horizon.
- Layer in dated promises to pay and agreed payment-plan instalments.
Step 2 — Weight for risk
- Reliable payers: forecast close to full value on the expected date.
- Slow or erratic payers: push the date out and apply a haircut.
- Disputed amounts: exclude or heavily discount until resolved.
- At-risk accounts: forecast conservatively or not at all, mirroring your provisioning view.
Step 3 — Compare and refine
- Each period, compare forecast cash-in to what actually arrived.
- Investigate big misses — over-optimistic dates, a dispute, a forgotten payer.
- Adjust your assumptions so next forecast is sharper.
- Feed the forecast into the wider cash-flow plan and flag any shortfall early.
If reliable-looking accounts keep slipping, the issue is collection, not forecasting. The getting-paid-faster guide helps tighten it, and a free debt appraisal tells you which slow accounts to escalate.
Common mistakes
- Forecasting on terms alone. A 30-day customer who always pays at 50 days will wreck a terms-based forecast.
- Counting disputed cash. Including amounts in dispute inflates the forecast and disappoints planning.
- No actuals comparison. A forecast you never check against reality never improves.
- Over-optimism. Hope is not a forecasting method — weight for real behaviour.
Key takeaways
- Forecast on each customer's actual pay-pattern, not just their terms
- Weight expected cash for risk, and exclude or discount disputes
- Layer in dated promises to pay and payment-plan instalments
- Compare forecast to actuals each period and refine the assumptions
Frequently asked questions
Should I forecast collections on terms or on actual behaviour?
On actual behaviour. Terms tell you when an invoice is due, but a customer who consistently pays well past terms should be forecast on that real pattern. A terms-based forecast routinely overstates near-term cash and undermines planning.
How do I treat disputed invoices in a collections forecast?
Exclude them or apply a heavy discount until the dispute is resolved, because the timing and even the amount are uncertain. Forecasting disputed cash at full value is one of the fastest ways to make a forecast unreliable.
How far ahead should a collections forecast run?
Far enough to support your cash-flow decisions — often four to thirteen weeks in weekly buckets for short-term planning. Beyond that, accuracy falls off quickly because behaviour and new billing dominate, so keep the long view directional.
Work the checklist, then get paid
Use the free Invoice Generator, then let Merion recover anything that goes unpaid — commission-only.