Merging Customers: Why and How

The topic of our Lunch and Learn session this week was Merging Customers.  Merging is the process of combining two customer records within the LMS software into a single record. There are several scenarios under which a merge should (or should NOT) be used:

  • If a single customer or entity exists on multiple portfolios within the core accounting system, then multiple records will be imported into the Suntell LMS database through the nightly download.  For example, customer John Smith might exist under Portfolio number 12345 and also under Portfolio number 67890.  That is exactly when the merge function should be used: to combine those duplicate customer records within the LMS.
  • The merge should NOT be used to combine related customers that may exist on the same portfolio.  For example, John Smith may exist on portfolio 12345 with Nameline 1 and Mary Smith may exist on the same portfolio with Nameline 2.  Those would import into Suntell as 12345.1 and 12345.2 respectively.  In this case, John Smith and Mary Smith are Related Interests, not duplicates of the same customer.  The merge should NOT be used in this case.
  • Sometimes duplicates may occur when a user accidentally adds a new record for a customer, for a new proposed loan, and an existing record already existed.  In this case, cleanup is the better way to handle the duplication, rather than the merge functionality.
For more information, please watch our most recent Lunch and Learn video.  Lunch and Learns are FREE training sessions held on the first and third Wednesday of each month at 12:00 Central Time.

Share this post


How does a loan origination system work?

An LOS is defined as a system that automates and manages the end-to-end steps in the loan process – from the application, through underwriting, approval, documentation, pricing, funding, and administration.

What is the difference between loan origination and underwriting?

A loan officer is someone who works for a bank or credit union or other financial institution and offers loans to borrowers, while an underwriter is someone who analyzes documents from potential borrowers to determine if they are eligible for a loan.

What are the benefits of loan origination software?

By now, lenders are well versed in the benefits of a digital loan origination system, such as: Providing borrowers with easy, streamlined, and digital applications. Providing bankers with automating spreading and financial analysis tools.