This automation solution transforms the complex daily VISA EP747 report processing across five African countries from an 8-hour manual task to a 3-minute automated process, representing a 99% reduction in processing time. The system effectively handles all settlement aspects while minimising risk and allowing staff to focus on value-added activities.

Multi-country VISA settlement automation slashes processing time by 99%

A specialised automation solution transforms the complex daily VISA EP747 report processing across five African countries from an 8-hour manual task to a 3-minute automated process. This multi-country implementation drastically improves operational efficiency while reducing risk and freeing staff for value-added activities.

‍

‍

Core Functionality

The system delivers end-to-end automation of VISA settlement processing:

1. Automated retrieval of VISA Edit Package (EP747) mainframe reports

2. Intelligent parsing of multiple report types (VSS-110, VSS-120, VSS-130, VSS-140)

3. Data normalisation and storage in SQL database

4. Accurate mapping and calculation of settlement values:  

1. Acquirer/Issuer Interchange (local and international)

2. Reimbursement fees

3. Fee/Charge collections

4. Net Settlement Amount

5. Automated reconciliation to ensure data accuracy

6. Journal creation for core banking integration

7. Web-based interface for oversight, exception handling, and approval workflows

‍

‍

Technical Information & Development

The solution implements several technical innovations:

• Secure integration with the VISA server for FTP file retrieval

• Direct connection to Oracle Flexcube for journal loading

• Low-code development approach for rapid implementation

• Configurable mapping engine for country-specific requirements

• Role-based security model for approval workflows

The initial implementation was completed in just one month, with subsequent country rollouts requiring only 2 hours of configuration plus 3 weeks for UAT and go-live.

‍

‍

Business Impact

The solution delivers transformative operational benefits across five African countries:

• Processing time reduced from 4-8 hours to 3 minutes (99% improvement)

• 24.5 hours saved per country per week

• Staff redeployed from manual data processing to exception handling

• Improved accuracy and elimination of manual calculation errors

• Reduced operational risk through automated reconciliation

• Simplified expansion to new countries

• The operations team freed from tedious tasks to focus on higher-value activities

‍

The Operations Manager noted: "This system has resulted in major operational efficiencies."

‍