Credit Controllers often have to report an overdue, promises and also a summary of payments by customer and for a period of time (today, this week, this month etc.). The Collected Summary report can be used for this purpose.
The report shows the following information for a Customer and the fields are calculated based on Customer Ledger Entries.
- Sales (LCY)
- Outstanding
- Overdue
- Promised
- Paid (LCY)
- Percentage Collected (Paid (LCY)/Sales (LCY))*100
On the reports Request Page, we can set Reporting Period and Customer filters.
The below shows an example of the detail that is generated:
At the bottom of the page there are 3 total values Fields for the selected period:
- Sales (LCY)
- Paid (LCY)
- Overall Percentage Collected