Credit Control Reporting Project
The Challenge:
This credit control department had little or no visibility of the age of debts owed by clients and the outstanding balances or credits made to clients. A debtor report for executive management takes up to two weeks to compile from various data sources and formats and all credit transact ions have to be recorded and summarized manually.
When we engaged with the client, much of the credit control manager’s time was dedicated to manually collating data from various sources. Up to 2 days a week could be spent on this task.
The client needed a way to provide key internal management direct visibility into debtor and credit note information for all clients across up to 50 branches for any user defined period. Debts were to be viewed on a 30, 60, 90 day breakdown basis.
Official Intelligence was selected to design and develop Crystal Reports that would allow the creation of easy-to-use, understandable reports that would integrate data from several cross-platform databases and could be exported to a format suitable for manipulation while allowing all key staff to instantly access the credit control in the format they needed.
The Solution:
Three reports – a debtor day summary, an unallocated cash report and a credit note summary were to be created for each of 8 key credit control ledgers. Starting with an initial set of prototypes to be tested by key personnel, Official Intelligence was able to design and deploy the reports in 2 weeks.
The Results:
Immediately information for which there was no visibility was accessible at executive management level. Many of the staff tasks in the credit control department could be re-evaluated.