Executive Summary
The client is a healthcare-based organization responsible for managing and tracking patient insurance claims using Smartsheet and an external insurance portal. Prior to automation, claim identification, validation, and status updates were performed manually, resulting in processing delays and claim backlogs.
An RPA solution was implemented to automate claim filtering in Smartsheet, claim validation through the insurance portal, data extraction, and status updates. The bot now identifies eligible claims, extracts claim details, downloads Explanation of Benefits (EOB) documents, captures supporting screenshots, and updates all relevant information back into SmartSheet. This automation reduced processing time from 3 minutes per claim to less than 1 minute, eliminated claim backlogs, and significantly reduced manual effort.
Client Background
The client operates in the healthcare domain and handles a continuous flow of insurance claims submitted for patient treatments. SmartSheet is used as the primary tracking system for managing claim status and operational workflows.
The claims operations team is responsible for validating claim details, checking payment status from insurance portals, maintaining documentation such as EOBs, and ensuring SmartSheet is updated accurately for reporting and audit purposes.
Business Challenge
Before automation, the process involved:
- Manually logging into SmartSheet to review all patient insurance claims
- Filtering claims eligible for further processing
- Logging into insurance portal websites to search for claim details
- Extracting information such as claim number, paid amount, patient name, and payment recipient
- Downloading EOB documents and capturing screenshots as evidence
- Updating SmartSheet manually with the extracted details
Key challenges included
- High manual effort and repetitive tasks
- Processing time of approximately 3 minutes per claim
- Growing claim backlogs due to high claim volumes
- Risk of data entry errors and missing documentation
- Limited scalability without increasing headcount
To improve efficiency and eliminate backlogs, the client adopted RPA.
Objectives
The objectives of the automation initiative were:
Primary Goals
- Reduce manual effort in claim validation and updates
- Accelerate claim processing time
- Eliminate claim backlogs
- Improve data accuracy and consistency in SmartSheet
- Ensure complete documentation with EOB files and screenshots
- Enable scalable operations without additional resources
Success metrics included average processing time per claim, backlog reduction, and data accuracy.
Solution Approach
RPA Tool:
UiPath
Applications Involved
SmartSheet, Insurance Portal Websites
Key Automation Capabilities:
- Bot logs into SmartSheet and identifies claims eligible for processing
- Eligible claims are flagged and queued for further validation
- Bot logs into insurance portal websites and searches for claim details
- Extracts claim number, paid amount, patient name, and payment recipient
- Downloads the Explanation of Benefits (EOB) document
- Captures supporting screenshots for audit purposes
- Updates all extracted information back into SmartSheet automatically
Robust exception handling and logging were implemented to manage portal issues and incomplete claim data.
Implementation Journey
The automation was delivered in phases:
- Process discovery and SmartSheet workflow analysis
- Insurance portal interaction and data extraction design
- Bot development and testing
- Validation with claims operations team
- User acceptance testing
- Production rollout and post-deployment support
adoption.
Results / Outcomes
The automation significantly reduced operational effort and improved processing speed. The average processing time per claim was reduced from 3 minutes to less than 1 minute, enabling the team to clear pending claims efficiently.
By automating claim validation, documentation download, and SmartSheet updates, the solution eliminated claim backlogs and ensured timely updates with accurate data. The claims team was able to focus on exception handling rather than routine processing, resulting in improved productivity and operational stability.
Business Value Delivered