Receivables management and collection
The Collection Placements solution was created to streamline the management and recovery of unpaid receivables linked to financing. Through a BI system based on a Data Warehouse, it enables:
- Continuous monitoring of outstanding debt positions
- Optimization of recovery timelines
- Compliance with industry regulations and company policy
Recovery process
- Flagging the customer as in default: after a financed sale, if the customer fails to pay they are added to the debtor database
- Debt monitoring: ageing, size and associated risk
- Assignment to an agency: after a set number of days of non-payment, the contract is assigned to a collection company
- Outcome: full or partial recovery, or irrecoverable
- Loss allowance analysis: expected losses and provisions in the accounts
Solution
ETL with SSIS and T-SQL, a Data Warehouse on SQL Server and Analysis Services for the Risk Management Division, and real-time Power BI dashboards on receivables, assignments and agency performance. The client moved from unstructured reporting, provided by suppliers, to a centralized view shared with the Risk Division.



