Using average daily collections to explain a cash miss
Check workday count before blaming slower customer payments. Then test whether the remaining gap reflects timing or credit deterioration.
Wall Street Playbook ·
Calculate a day-adjusted baseline
The cash forecast assumed 22 collection days at $100,000 per day. The month had 20 effective collection days and actual receipts of $1.9m. At the plan pace, 20 days would produce $2.0m. Day count explains $200,000 of the $300,000 miss. The remaining $100,000 requires investigation.
Examine the residual
Use customer-level receipts and overdue balances to test whether a small number of payers dominate the difference. Document when delayed cash is expected. Do not simply move the entire gap into next month if collections history or disputes suggest a permanent loss.
FP&A Interview & Case Workbook
Get the complete guide when you’re ready for more practice.
Sale price $50.15 Original price $59