This report is used to display a breakdown of your receivable including items in transit in different tranches according to their due date.
Unlike ageing balance which details the overdue
receivables, this report details the not yet due items. When these bills will be due?
The report is splitted into:
- overdue: corresponds to the sum of all items late in payment
- current month: sum of receivable which become due this month
- month M+1 : sum of invoices which will be due next month
This report has two main interests:
- it provides a dynamic view of the outstanding and helps to refine credit risk management and credit available versus the credit limit. Indeed, it's not the same if the bulk of receivables become due in the current month (therefore should be paid in that month) or if it will be only in 3 months.
- it provides visibility on the amounts to be paid by customers per month. For example in the example above, it appears that the recovery target for the current month is 124 K $ (98 K$ late + 26 K$ that are due this month). The sum to be recovered for the following month will be 134 K$.
You want to have a vision that takes into account the items qualification, the customer payment behavior, the performance on the resolution duration of the disputes
... go on the report cash forecast