Average collection days - customer

I want to determine and distinguish between the customers who pay on time and the customers who are consistently late in their payments.

Is there any way we can generate a report from Manager or download some tables from Manager and prepare the report in Excel to achieve the objective as stated above.

Timeliness of customers is not recorded in the database. Nor is age of invoices one they are paid. So I see no way to obtain what you desire without tedious examination of individual invoices. You may be better off keeping separate customer records.

1 Like