Break free from spreadsheets in 6 weeks
75% productivity boost. 10x faster Rate Sheets creation since live.
50% less work for data entries, calculations, and data analysis
Key Takeaways
Instant access to exec dashboards; View, approve, download Rate Sheets on-the-fly
100% transparency. Secured with version controls, role-based access and audit trails
Challenge
Allied Benefit Systems, one of the US largest healthcare third-party administrator, relied heavily on Microsoft Excel for managing 'Rate Sheets'—detailed financial documents outlining fund distributions to healthcare sub-entities like premiums and broker commissions. They were challenged by:
Inefficient data management and cumbersome administrative tasks.
High susceptibility to errors due to manual data entry and complex calculations.
Lack of version control and proper change management, causing process breakdowns.
Inadequate tracking of Service Level Agreements (SLAs) and deadlines.
Limited data analytics capabilities, slowing down decision-making.
Solution
Mokxa partnered with Allied Benefit Systems to develop a modernized 'Rate Sheets Management Solution' using Joget. The solution was delivered in just six weeks and featured:
Automation of complex financial formulas and policies for compliance and data integrity.
User-friendly dashboards providing executives with instant access to actionable data for effective analysis and decision-making.
Templatized forms and customizable reports to streamline data entry and calculations.
Robust version control, role-based access, and audit trails to enhance transparency and security.
Outcome
The implementation of the automated solution led to significant improvements:
10x increase in the speed of Rate Sheets creation.
75% boost in productivity across related workflows.
Reduced time spent on data entries, calculations, and analysis by 50%.
Enabled instant access to pending action items, allowing stakeholders to view, approve, and download Rate Sheets on-the-fly.
Enhanced cross-department collaboration through secure, transparent processes.
Full Story
Context
'Rate Sheets' management is a workflow to generate detailed financial sheets for funds distributions to healthcare sub-entities (like premiums, broker commissions, etc)
This requires the extensive use of spreadsheets (MS Excel) for various administrative & analytical tasks, such as data entry, performing calculation with formulas, data analytics, and more.
Despite maximizing the capabilities of spreadsheets, Allied Benefit Systems still faced significant limitations inherent to manual processes.
This led to problems like inaccurate data, slow and error-filled tasks, poor tracking of deadlines, breakdowns due to poor version control, and ineffective decision-making.
Solution
Mokxa collaborated with citizen developers from Allied Benefit Systems to build a modernized 'Rate Sheets Management Solution', demonstrating optimal resource utilization for an innovative, cost effective business solution delivery in just six weeks.
Built on Joget, the solution simplifies business processes that are pertaining to the financial & analytical aspects of premiums distributions and management.
Complex financial formulas and policies are baked into the design, automating financial compliance, ensuring data integrity.
User friendly dashboards helped executives at Allied Benefit Systems to easily access meaningful data for effective analysis and decision-making.
Outcome
Breaking free from spreadsheets, business users were able to instantly adopt the business solution to manage financial sheets, achieving a record-breaking 10x faster Rate Sheets creation.
50% time savings for data entries through automated processes, templatized forms and customizable reports - freeing up the team to focus on creative tasks.
Instant access to pending action items enabling key stakeholders to view, approve, and download Rate Sheets on-the-fly.
Reduced human errors through validation-checks that were in place, allowing Allied Benefit Systems to scale with lesser risks and fewer variables.
Enabled effective, secured cross department collaboration via version controls, role-based access, and change management with audit trails