Financial Advisory Firm Implement Microsoft Dynamics GP

The Client

The client is a comprehensive, full service, multifaceted insurance and financial advisory firm and authorized exclusive agent. Integrity offers customers flexibility, with a variety of healthcare products and plans to choose from such as, life insurance, health insurance and Medicare supplements.

The Opportunity

For years, this client was tied down by a CRM legacy system that could not keep up with their business growth. Integrity was attempting to manage all aspects of their reconciliation processes through one, outdated, desktop CRM system. Each month, they would receive a commission statement regarding policies sold, active customers, customers dropping policies and commissions earned. This report typically created around 600-700 pages of information per month which 2-3 team members would comb through page by page. This process was taking anywhere from 40-80 man-hours per month, tying up precious resources and causing major frustrations throughout the team. Even within this period, only basic processes could be done. Integrity rarely had time to investigate errors or discover why certain clients dropped off and stopped using their services. Integrity was looking for an integrated solution that would automate processes, which would significantly reduce time and energy spent on the monthly reconciliation process.

The Solution

Initially, the first step of the solution process involved removing their outdated CRM system and making the conversion to Microsoft Dynamics CRM. Logan Consulting then had to analyze workflow and processes in order to develop a plan for how to simplify and automate monthly reconciliation. It was decided that a third party tool, Scribe, would be used which would directly implement reconciliation files into CRM, monthly. With this integration, Scribe would pull reconciliation data into a custom entity called policy updates. Once updates had been created, employees could easily use advanced finds, queries and data filters to organize their information, which made this painstakingly long process, quick and easy. This vast reduction in time then gave Integrity time to check for errors and dig deeper into studying which policies had been added, retained and terminated.

The Results

  • CRM users went from 12 to over 40
  • Processing time reduced from 40-80 hours a month to 8 hours a month
  • Allowed for deeper customer analyzation and insight
  • Discovered and corrected over $30,000 in errors within the first year
  • Reduced stress for all employees involved in the reconciliation process