Automated SLA Payout Monitoring Dashboard with Bank Reconciliation and Proactive Merchant Communication

Challenge

Manual tracking of daily merchant payouts was error-prone, leading to missed payments and late discovery of discrepancies with bank statements. That meant merchant dissatisfaction, compliance issues and reactive problem-solving.

Approach

• Built an SLA monitoring dashboard tracking daily payout schedules, amounts and processing status across merchant accounts.
• Automated bank statement reconciliation, matching internal payout records to actual bank transfers with fuzzy matching.
• Added exception handling that classifies discrepancies, missed payments and processing delays by severity.
• Built templated merchant notifications for payment delays or issues.
• Added audit trails and compliance reporting for regulatory requirements and internal controls.

Results

• Payout discrepancies identified as they happen rather than days later.
• Manual reconciliation effort replaced by automated matching, with merchants told about issues proactively.

Technologies

Python, SQL, Tableau.

Impact

Payout operations became proactive, with automated reconciliation and transparent communication about payment issues.