Insurance companies struggle with regards to managing data entry due to their over-reliance on the manual handling of such activities by their internal staff. This has become even more pronounced as these companies are implementing digital transformation initiatives. This paper describes several practical methods for automating the many business processes of insurance companies using Visual Basic for Applications (VBA) tools that have been developed in Excel. Waterfall methodology, which is a linear process to define the requirements pre-system development, was followed by the Development and Testing phases, leading to Deployment. The implementation of five VBA tools assisted in the generation of Medical Benefit Reports (MBR) and daily claims reports for both individual and group claims, as well as the automation of documentation for Payments and First Payment Proposals (FPPs). The functional and usability testing and performance evaluation phases of the system demonstrated that the processing time was reduced between 70.00% and 91.67% with the benefits of increased consistency and improved user experience. The research findings show that VBA-based automation serves as an affordable solution that enables insurance companies to improve their operational processes through automation in environments where system integration options remain restricted.

Keywords

Insurance operations; Process automation; Visual Basic for Applications (VBA); Claims management; Operational efficiency