Returned Payment Automation Suite
Version v1.04 · technical reference. Back to the case study →
Overview
The Returned Payment Automation Suite is a UiPath bot that processes returned payment accounts by navigating an internal credit-servicing application, updating settings across multiple screens based on a comprehensive scenario matrix, writing calculated comments, and logging all changes for audit compliance.
The bot transforms a manual process that took 3-5 minutes per account into an automated 14-16 second operation with 100% accuracy and full audit trail.
Features
Core capabilities and processing features of the automation suite.
- 17 Scenario Configurations - Single codebase handles all business scenarios
- Dataiku Integration - Pulls daily account lists from Dataiku reports
- Application Navigation - Automates multi-screen workflow
- Calculated Comments - Generates standardized comments based on scenario
- Full Audit Logging - Every action recorded for compliance
- Multi-tab navigation within the application
- Batch processing capability (hundreds of accounts)
- Error handling with graceful recovery
System Requirements
Required software and environment specifications.
| Requirement | Specification |
|---|---|
| Platform | UiPath StudioX |
| Runtime | UiPath Robot (Attended) |
| Applications | Internal credit application, Excel |
| Data Source | Dataiku Reports |
| OS | Windows 10/11 |
Architecture
The system follows a three-layer architecture for processing returned payments.
- Input Layer: Dataiku-generated Excel report, scenario matrix lookup, configuration settings
- Processing Engine: UiPath StudioX workflows, VB.NET expressions, scenario routing logic
- Output Layer: Updated credit-application records, comprehensive audit log, processing summary
Scenario Matrix
The bot handles 17 distinct business scenarios, each with specific screen navigation paths, dropdown selections, field updates, and comment templates.
| Scenario Type | Action | Comment Format |
|---|---|---|
| Return - NSF | Update status, set flag | "NSF Return - [Date] - [Amount]" |
| Return - Closed | Update status, close account | "Account Closed - [Reason]" |
| Return - Stop Payment | Flag for review | "Stop Payment - Review Required" |
| ... | ... | (17 total scenarios) |
Usage
Daily operation workflow for processing returned payments.
- Download Report: Access Dataiku dashboard, export daily returned payments report, save to input folder
- Launch Bot: Open UiPath Assistant, select "Returned Payment Suite", click Run
- Monitor Progress: Bot displays current account, real-time count, automatic pause on exceptions
- Review Results: Check audit log for exceptions, verify statistics, archive completed report
Logging & Audit
Comprehensive audit trail for compliance requirements.
- Every field change captured with before/after values
- Timestamps for all actions
- User/bot identification
- Exception details with screenshots
Results
Performance metrics and business impact.
| Metric | Before | After | Improvement |
|---|---|---|---|
| Time per Account | 3-5 minutes | 14-16 seconds | ~92% reduction |
| Accuracy | Variable (human error) | 100% | Eliminated errors |
| Daily Capacity | Limited by fatigue | Hundreds | Unlimited scaling |
| Audit Trail | Partial/manual | Complete/automatic | Full compliance |
Technology Stack
Technologies used in the automation suite.
- UiPath StudioX - Automation platform
- Excel - Data input/output
- Dataiku - Report generation
- VB.NET - Custom expressions
- Internal credit application - Target system