Collection forecast
A collection forecast is an estimate of how much of your outstanding receivables will be paid, and in which week or month, based on due dates and customer payment behaviour.
What it means
Its purpose is to plan cash: wages, rent, supplier payments and loan instalments all depend on money coming in. A good forecast does not assume every invoice is paid on its due date. It uses each customer's usual delay, any promises they have made and known disputes, then totals expected receipts by week.
Example
A bakery supplier has ₹6 lakh due next month. A big retailer with ₹3 lakh usually pays about 10 days late, so that amount is expected in the second week after due date. A small cafe's ₹40,000 is in dispute, so it is left out.
Records and checks
- Record: invoice, due date, expected receipt week, the basis for the guess and any promise from the customer.
- Verify: last month's forecast against actual receipts and note the difference.
- Checked by: the finance head updates it weekly and shares it with the owner before payment decisions.
Common mistakes
- Treating the due date as the receipt date for every customer.
- Never comparing the forecast to what actually came in, so the guesses never improve.
Did not find your answer?Message the lamp team on WhatsApp. Ask about setup, your records, or anything we have not covered here.Ask us on WhatsApp →