Online help

Cash forecast report » What is the cash forecast report?

This report provides a forecast of cash receipts coming from your customers.

It is based both on the work of the collector (qualification of items with appropriate status), the performance of your business in disputes resolution and customer payment behavior recorded by My DSO Manager.

It is possible to have an overall view taking into account all of these criteria, or focus only on the promises of payment with dedicated check boxes.

The report can be filtered by customer group, collector, internal actor (commercial ...) associated with customers and analytical field (if set).

Cash forecast report

Calculation criteria :

  • Promises to pay. The report takes into account items qualified with a status « Promise to pay » for which a payment date was entered.
    Zoom1

  • Items qualified with a status type « dispute ». In this case, the collection forecast follows this rule: item due date + average resolution time for of this dispute type + average payment delay of the customer.
    Zoom2

  • Non qualified items or with another type of status (on going...). In this case, the collection forecast follows this rule: item due date + average payment delay of the customer.
    Zoom2

Items qualified with a status « Litigation » are not taken into account in the forecast report.
Items that do not have « respected » the forecast are also excluded. For example, An old promise to pay that has not been respected by the customer (invoice still not paid) will appear in the « overdue off forecast » category.

← Back : Online help » Various questions