{"id":2481,"date":"2022-12-13T11:26:24","date_gmt":"2022-12-13T11:26:24","guid":{"rendered":"http:\/\/beta.foundingminds.com\/?page_id=2481"},"modified":"2023-01-06T06:21:16","modified_gmt":"2023-01-06T06:21:16","slug":"case-study-billing-invoicing","status":"publish","type":"page","link":"http:\/\/localhost\/verticals\/financial-services\/case-study-billing-invoicing\/","title":{"rendered":"Case Study : A Tailored, Multi-Tenant Solution for Recordkeeping, Billing, and Invoicing"},"content":{"rendered":"
FOUNDING MINDS<\/span><\/div>

A Tailored, Multi-Tenant Solution for <\/u>
\r\nRecordkeeping, Billing, and Invoicing<\/b><\/span><\/span><\/h2>
Record-keeping companies provide an essential service to organizations of all sizes. By signing contractual agreements with these companies, organizations like retirement solutions providers can outsource the management and execution of record-keeping operations to a professional team. As part of the handled operations, this team can calculate a service fee following specific criteria such as employee count, market value, and fee tiers.
\r\n
\r\nSuch was the case with Founding Minds\u2019 client, a record-keeping company using a legacy system for core financial operations. The legacy system used SQL to query relevant data and MS Excel to process calculations and generate templatized invoices. As a result, the company realized this extensive manual process could be replaced by a modern system, resulting in efficient deployment and several man-hours saved. There was an emerging need for an automated system that could handle calculating and sending invoices, which would free up even more time and resources for the organization and reduce the likelihood of errors. Such a system would be of great benefit to the record-keeping company and its clients alike.<\/div><\/header><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/section>
<\/div><\/div>

Situation Overview<\/span><\/h4>\n

The record-keeping company employs a distribution channel for dividing payments from plan sponsors among advisors, third-party administrators (TPAs), and various vendors. There was a constant need to calculate potential discounts, decide the plan minimums and maximums, exclude certain securities from the fee calculation, etc. For a more integrated and streamlined process, the team required a robust automated system in place, with cutting-edge technology incorporated to make the process smoother for the stakeholders involved. The key features of such a system included the following:<\/span><\/p>\n

    \n
  • Ability to handle large volumes of data with speed and accuracy. <\/span><\/li>\n
  • Advanced visibility features to ensure effortless accounting and record-keeping.<\/span><\/li>\n
  • Flexibility to integrate with different types of software systems.<\/span><\/li>\n
  • Scalability to accommodate future growth.<\/span><\/li>\n<\/ul>\n

    Such a system could play a vital role in ensuring the record-keeping company\u2019s smooth operation and maximizing its clients\u2019 satisfaction levels.<\/span><\/p>\n

    Client Needs Analysis<\/span><\/h4>\n

    The development of an efficient automated solution required highlighting the key pain points that needed to be addressed by the proposed automated system. The following were the client\u2019s primary needs:<\/span><\/p>\n

      \n
    • Calculate up-to-date discounts, set plan minimums and maximums, and exclude certain securities from the fee calculator using rules.<\/span><\/li>\n
    • Automatically adjust the invoice amount by offsetting plan funds, collecting from revenue generated, or selling off-plan assets in the market.<\/span><\/li>\n
    • Switch from legacy SQL, MS Excel-based billing system to a state-of-the-art automated system to reduce manpower and labor costs.<\/span><\/li>\n
    • Ensure due diligence and fiduciary responsibility.<\/span><\/li>\n
    • Building transparency in the long-term for key areas like client fee payment, service value costs, and details of products invested in individual retirement portfolios.<\/span><\/li>\n<\/ul>\n

      Challenges to Overcome<\/span><\/h4>\n

      Developing a future-proof automated solution to cater to such specific clients\u2019 needs was an uphill battle. There were some key issues facing Founding Minds\u2019 team members throughout the development process. Firstly, reducing the time spent calculating fees and creating invoices from a few weeks to days was a meticulous undertaking. The team further had to ensure that the new system worked with the minimal human interaction possible to maximize the cost-efficiency.\u00a0 All the while, the team met the challenging task of selecting the right technologies to support a financial system that would be relevant for decades to come.<\/span><\/p>\n

      The Resulting Automated and Scalable Solution\u00a0<\/span><\/h3>\n

      The diligent analysis and creative efforts of Founding Minds\u2019 industry-best development team paved the way for the creation of a groundbreaking automated solution. The solution includes the following prominent features:<\/span><\/p>\n

        \n
      • Horizontal Scalability \u2013 the solution is horizontally scalable to meet the client\u2019s infrastructure specifications.<\/span><\/li>\n
      • Well-Integrated Billing Process \u2013 a configured billing rule engine is included that connects with various sub-systems to retrieve data and create real-time security market value, and calculate fees on the spot.\u00a0<\/span><\/li>\n
      • Fee Hierarchy Enabled \u2013 the solution can be customized for any complex fee hierarchy.<\/span><\/li>\n
      • Automated Scheduling \u2013 a customizable scheduling system is included for the automation of invoices and statements generation.<\/span><\/li>\n
      • Flexibility of Use \u2013 the solution is fully customizable to match any rules the client may require and supports re-calculations, re-runs, and adjustments.<\/span><\/li>\n
      • Accounting Visibility \u2013 ledger entries and reports can be created and integrated with the client\u2019s legacy accounting systems.<\/span><\/li>\n
      • Intuitive UI\/UX \u2013 friendly and easy to use for support staff and back office personnel.<\/span><\/li>\n
      • Audit Logs \u2013 for visibility and transparency.<\/span><\/li>\n<\/ul>\n

        The automated solution offered by Founding Minds resulted from the implementation of many modern, leading-edge tools and technologies.\u00a0<\/span><\/p>\n

        Tools utilized<\/span><\/h4>\n
          \n
        • Agile Methodology for Project Management<\/span><\/li>\n
        • .NET Core Framework for Backend Development<\/span><\/li>\n
        • Angular for Frontend Development<\/span><\/li>\n
        • MS SQL Server as Database<\/span><\/li>\n
        • Rabbit MQ Queue for Queue Management<\/span><\/li>\n
        • App Insights and Log4net for Logging<\/span><\/li>\n<\/ul>\n

          Technologies Implemented<\/span><\/h4>\n
            \n
          • Multi-Tenant Cloud Architecture<\/span><\/li>\n
          • Rule-Engine for Billing Calculation<\/span><\/li>\n
          • Invoice Generation<\/span><\/li>\n
          • ACH (Automated Clearing House) for Payments<\/span><\/li>\n<\/ul>\n

            Outcome and Impact<\/span><\/h3>\n

            Through the implementation of the proposed automated solution, the record-keeping company saw success as it gained a competitive edge by improving its workflow efficiency and productivity. With minimal human intervention, the intelligent solution added significant value to the company by:<\/span><\/p>\n

              \n
            • Helping calculate complex fee configurations and generating 100s of invoices per minute.<\/span><\/li>\n
            • Aiding in reducing the painstaking task of calculating fees and creating invoices from weeks to a couple of days.<\/span><\/li>\n
            • Assisting plan sponsors in paying invoices by forfeiture, deducting from revenue generated by the plan, or selling plan assets.<\/span><\/li>\n
            • Enabling them to settle payments for\u00a0<\/span><\/li>\n<\/ul>\n

              Our Team<\/span><\/h4>\n

              At Founding Minds, our team takes pride in being a reliable partner throughout the technological journey of our customers. We take time to understand customer requirements and combine our business and technical expertise to craft effective solutions. We take a holistic approach to innovate and do so with an understanding of the customer, their business, and trends in the industry.<\/span><\/p>\n

              Summary and Key Takeaways<\/span><\/h3>\n

              When a customer approached Founding Minds with a problem, the team took the time to understand the business need, researched the market and came up with a technical solution that satisfied all the customer requirements. The resulting record-keeping, billing, and invoicing solution have been used for several years, generating significant savings for the customer and their end clients.\u00a0<\/span><\/p>\n

              Founding Minds brought in a blended team of business analysts, technical architects, developers and managers who delivered the product using best-of-breed technologies in an Agile development process for nimbleness and transparency.<\/span><\/p>\n

              When looking for a software development vendor, it\u2019s important to choose a partner that understands your business and can adapt as the circumstances change. To build an effective long-term solution, this partner needs to be technically competent and flexible.<\/span><\/p>\n

              Founding Minds has a long track record of bringing solutions to market in the financial services domain. We are committed to being a loyal technology partner for your organization.<\/span><\/p>\n<\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/section>

              Situation<\/u> Overview<\/b><\/span><\/span><\/h2><\/header>
              <\/div><\/div><\/div><\/div><\/div>
              \"http:\/\/localhost\/wp-content\/uploads\/2022\/12\/drl.png\"<\/span><\/div>
              <\/div><\/div><\/div>

              The record-keeping company employs a distribution channel for dividing payments from plan sponsors among advisors, third-party administrators (TPAs), and various vendors. There was a constant need to calculate potential discounts, decide the plan minimums and maximums, exclude certain securities from the fee calculation, etc. For a more integrated and streamlined process, the team required a robust automated system in place, with cutting-edge technology incorporated to make the process smoother for the stakeholders involved. The key features of such a system included the following:<\/p>\n

                \n
              • Ability to handle large volumes of data with speed and accuracy.<\/li>\n
              • Advanced visibility features to ensure effortless accounting and record-keeping.<\/li>\n
              • Flexibility to integrate with different types of software systems.<\/li>\n
              • Scalability to accommodate future growth.<\/li>\n<\/ul>\n

                Such a system could play a vital role in ensuring the record-keeping company\u2019s smooth operation and maximizing its clients\u2019 satisfaction levels.<\/p>\n<\/div>

                <\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/section>
                <\/div>

                Client Needs<\/u> Analysis<\/b><\/span><\/span><\/h2><\/header>
                <\/div>

                The development of an efficient automated solution required highlighting the key pain points that needed to be addressed by the proposed automated system. The following were the client\u2019s primary needs:<\/p>\n

                  \n
                • Calculate up-to-date discounts, set plan minimums and maximums, and exclude certain securities from the fee calculator using rules.<\/li>\n
                • Automatically adjust the invoice amount by offsetting plan funds, collecting from revenue generated, or selling off-plan assets in the market.<\/li>\n
                • Switch from legacy SQL, MS Excel-based billing system to a state-of-the-art automated system to reduce manpower and labor costs.<\/li>\n
                • Ensure due diligence and fiduciary responsibility.<\/li>\n
                • Building transparency in the long-term for key areas like client fee payment, service value costs, and details of products invested in individual retirement portfolios.<\/li>\n<\/ul>\n<\/div>
                  <\/div><\/div><\/div>
                  <\/div>
                  \"http:\/\/localhost\/wp-content\/uploads\/2022\/12\/slider_02.png\"<\/span><\/div>
                  <\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/section>
                  <\/div>

                  Challenges to Overcome<\/b><\/span><\/span><\/h2><\/header>
                  <\/div>

                  Developing a future-proof automated solution to cater to such specific clients\u2019 needs was an uphill battle. There were some key issues facing Founding Minds\u2019 team members throughout the development process. Firstly, reducing the time spent calculating fees and creating invoices from a few weeks to days was a meticulous undertaking. The team further had to ensure that the new system worked with the minimal human interaction possible to maximize the cost-efficiency.\u00a0 All the while, the team met the challenging task of selecting the right technologies to support a financial system that would be relevant for decades to come.<\/p>\n<\/div>

                  <\/div>

                  The Resulting Automated and Scalable Solution<\/b>
                  \r\n<\/span><\/span><\/h2><\/header>
                  <\/div>

                  The diligent analysis and creative efforts of Founding Minds\u2019 industry-best development team paved the way for the creation of a groundbreaking automated solution. The solution includes the following prominent features:<\/p>\n

                    \n
                  • Horizontal Scalability \u2013 the solution is horizontally scalable to meet the client\u2019s infrastructure specifications.<\/li>\n
                  • Well-Integrated Billing Process \u2013 a configured billing rule engine is included that connects with various sub-systems to retrieve data and create real-time security market value, and calculate fees on the spot.<\/li>\n
                  • Fee Hierarchy Enabled \u2013 the solution can be customized for any complex fee hierarchy.<\/li>\n
                  • Automated Scheduling \u2013 a customizable scheduling system is included for the automation of invoices and statements generation.<\/li>\n
                  • Flexibility of Use \u2013 the solution is fully customizable to match any rules the client may require and supports re-calculations, re-runs, and adjustments.<\/li>\n
                  • Accounting Visibility \u2013 ledger entries and reports can be created and integrated with the client\u2019s legacy accounting systems.<\/li>\n
                  • Intuitive UI\/UX \u2013 friendly and easy to use for support staff and back office personnel.<\/li>\n
                  • Audit Logs \u2013 for visibility and transparency.<\/li>\n<\/ul>\n

                    The automated solution offered by Founding Minds resulted from the implementation of many modern, leading-edge tools and technologies.<\/p>\n<\/div>

                    <\/div><\/div><\/div><\/div><\/div>
                    <\/div>

                    Tools utilized<\/b>
                    \r\n<\/span><\/span><\/h2><\/header>
                    <\/div>
                      \n
                    • Agile Methodology for Project Management<\/li>\n
                    • .NET Core Framework for Backend Development<\/li>\n
                    • Angular for Frontend Development<\/li>\n
                    • MS SQL Server as Database<\/li>\n
                    • Rabbit MQ Queue for Queue Management<\/li>\n
                    • App Insights and Log4net for Logging<\/li>\n<\/ul>\n<\/div>
                      <\/div><\/div><\/div>
                      <\/div>

                      Technologies Implemented<\/b>
                      \r\n<\/span><\/span><\/h2><\/header>
                      <\/div>
                        \n
                      • Multi-Tenant Cloud Architecture<\/li>\n
                      • Rule-Engine for Billing Calculation<\/li>\n
                      • Invoice Generation<\/li>\n
                      • ACH (Automated Clearing House) for Payments<\/li>\n<\/ul>\n<\/div>
                        <\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/section>
                        <\/div>

                        Outcome<\/u> and Impact<\/b><\/span><\/span><\/h2><\/header>
                        <\/div>

                        Through the implementation of the proposed automated solution, the record-keeping company saw success as it gained a competitive edge by improving its workflow efficiency and productivity. With minimal human intervention, the intelligent solution added significant value to the company by:<\/p>\n

                          \n
                        • Helping calculate complex fee configurations and generating 100s of invoices per minute.<\/li>\n
                        • Aiding in reducing the painstaking task of calculating fees and creating invoices from weeks to a couple of days.<\/li>\n
                        • Assisting plan sponsors in paying invoices by forfeiture, deducting from revenue generated by the plan, or selling plan assets.<\/li>\n
                        • Enabling them to settle payments for<\/li>\n<\/ul>\n<\/div>
                          <\/div>

                          Our <\/u> Team<\/b><\/span><\/span><\/h2><\/header>
                          <\/div>

                          At Founding Minds, our team takes pride in being a reliable partner throughout the technological journey of our customers. We take time to understand customer requirements and combine our business and technical expertise to craft effective solutions. We take a holistic approach to innovate and do so with an understanding of the customer, their business, and trends in the industry.<\/p>\n<\/div>

                          <\/div>

                          Summary and <\/u> Key Takeaways<\/b><\/span><\/span><\/h2><\/header>
                          <\/div>

                          When a customer approached Founding Minds with a problem, the team took the time to understand the business need, researched the market and came up with a technical solution that satisfied all the customer requirements. The resulting record-keeping, billing, and invoicing solution have been used for several years, generating significant savings for the customer and their end clients.<\/p>\n

                          Founding Minds brought in a blended team of business analysts, technical architects, developers and managers who delivered the product using best-of-breed technologies in an Agile development process for nimbleness and transparency.<\/p>\n

                          When looking for a software development vendor, it\u2019s important to choose a partner that understands your business and can adapt as the circumstances change. To build an effective long-term solution, this partner needs to be technically competent and flexible.<\/p>\n

                          Founding Minds has a long track record of bringing solutions to market in the financial services domain. We are committed to being a loyal technology partner for your organization.<\/p>\n<\/div>

                          <\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/div><\/section>","protected":false},"excerpt":{"rendered":"","protected":false},"author":5,"featured_media":0,"parent":2479,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":[],"_links":{"self":[{"href":"http:\/\/localhost\/wp-json\/wp\/v2\/pages\/2481"}],"collection":[{"href":"http:\/\/localhost\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"http:\/\/localhost\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"http:\/\/localhost\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"http:\/\/localhost\/wp-json\/wp\/v2\/comments?post=2481"}],"version-history":[{"count":13,"href":"http:\/\/localhost\/wp-json\/wp\/v2\/pages\/2481\/revisions"}],"predecessor-version":[{"id":3687,"href":"http:\/\/localhost\/wp-json\/wp\/v2\/pages\/2481\/revisions\/3687"}],"up":[{"embeddable":true,"href":"http:\/\/localhost\/wp-json\/wp\/v2\/pages\/2479"}],"wp:attachment":[{"href":"http:\/\/localhost\/wp-json\/wp\/v2\/media?parent=2481"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}