LMS Version 1

This system we use for helps automate every stage of the loan lifecycle, from application to closing.

Staff

0-How-to-Build-a-Loans-Management-System.jpg

The staff page in a loan management system is primarily used for creating new staff accounts within the system. This allows you to grant access to authorized personnel who will be involved in managing loans.

Here's a breakdown of its purpose:

Functionalities
Add Staff Page

There are few fields to create a staff/user.

  1. Staff No
  2. First Name
  3. Last Name
  4. First Name (Lao)
  5. Last Name (Lao)
  6. Nickname
  7. Date of Birth - date field
  8. Gender - dropdown
  9. Marital Status - dropdown
  10. Country
  11. Province
  12. City
  13. Village
  14. Contact Info
  15. Profile Image
  16. Payment Team
  17. Email
  18. Password
  19. Role
    • There are 3 roles, fields are change according to the role
      • Staff - Mentor, Manager, Department
      • Manager - Mentor, Department
      • Admin - Mentor
    • User Bank Details - Bank Account Number, Bank Account Name, Currency
    • User Status Details - User Status, Date

Staff List Page

Customer

1520055963747.jpeg

Creating new customers is a key function of the customer page in a loan management system (LMS). But it actually offers a wider range of benefits for both borrowers and lenders. the customer page allows you to easily create new customer profiles within the LMS. 

 The information in the customer page feeds into various other functionalities of the LMS.  For instance,  customer details are used during:

Functionalities
Add New Customer

image.png

  1. Agent of Customer Information
  2. Customer Relatives Information
  3. Vehicles Information
  4. Real Estate Information

image.png

List All Customer
  1. Customer Name
  2. ID Card/ Corporate No
  3. Phone No
  4. Customer ID

image.png

Merge Customer

Currency Rate

image.png

Currency Rate page

Functionalities

BCEL Currency Rate Page

NOTE: In our system, BCEL Rates are used for Journal entries.

Holidays

Functionalities
  1. User can see all the holidays on the Holiday List page.
  2. User can add/edit holiday details. 
    • Holiday Date
    • Event

 

Asset Valuation

Asset-Valuation.jpg

This asset valuation page is designed to estimate the value of assets associated with specific customers. To begin the valuation process, you'll need to select a customer from the customer list. In other words, customer selection is the starting point for all asset valuations. features available for searching for existing customers:

  1. Customer ID
  2. Family Book No
  3. Phone No
  4. Customer Name / Company Name

Additionally, the system allows users to create new customer profiles. This is helpful for onboarding new customers who haven't been previously registered in the system.

Collecting detailed information about the assets before proceeding. It highlights that two specific asset types are considered in this valuation process:

  1. vehicles
  2. land.

Vehicle: This refers to any motorized conveyance, such as a car, truck, motorcycle, that the borrower owns. The system likely requires details about the vehicle's make, model, year, condition, and any relevant features that might affect its value.

Land: This refers to a specific piece of real estate owned by the borrower. The system might require information about the property's location, size, type (residential, commercial, etc.), and any improvements or structures on the land that contribute to its value.

By collecting detailed information about these two asset types, the system can get a better understanding of the borrower's overall financial picture and their ability to repay the loan. The value of these assets can be used as collateral for the loan, meaning they could be used to recoup some of the loan amount if the borrower defaults.

Asset Valuation Process

Untitled Diagram.11-Page-24.drawio (2).png

Add Asset Valuation form

Screenshot 2024-07-24 095609.png

After fill the details, there are few steps to approve it.

Screenshot 2024-07-24 100635.png

Screenshot 2024-07-24 102216.png

Car Dealer Result Section

This section focuses on collecting data from various car dealers about a specific vehicle you're considering for valuation. It allows you to enter information from multiple car dealers for comparison.

The system automatically calculates the following fields once you've entered data for car dealers:

By having these minimum and maximum values automatically populated, you can easily see the range of buying and selling prices offered by different dealers. This helps you get a better sense of the overall market value of the vehicle.

Assessed Amount

Screenshot 2024-07-24 103025.png

Purchase Valuation Amount Calculation

Over-The-Counter Resale Price: This refers to the estimated resale price of the asset (likely the vehicle).

Loan To Value (LTV) [1]: This represents the ratio of the loan amount a borrower can qualify for compared to the appraised value of the asset. It's expressed as a percentage (e.g., 80% LTV).

The system uses the following formula to calculate the "Purchase Valuation Amount":

                            Purchase Valuation Amount = Over-The-Counter Resale Price * (Loan To Value (LTV)[1])

Maximum Loan Amount Calculation

Loan To Value (LTV) Ratio [1]: As mentioned previously, this represents the percentage of the asset's value that a lender is willing to finance through a loan.

Deduct Amount: This introduces a new variable that represents a specific amount to be subtracted from the initial loan amount calculation.

          Maximum Loan Amount = (Purchase Valuation Amount * (Loan To Value (LTV))%)[2] - Deduct Amount

Maximum Loan Amount as a Limit: The "Maximum Loan Amount" calculated by the system serves as a ceiling for the loan amount a borrower can be approved for. This ensures the loan stays within a reasonable range based on the asset's value and the lender's LTV policy.

Loan Approval Criteria: When considering a loan application, the system will verify that the borrower's requested loan amount is less than or equal to the calculated "Maximum Loan Amount." This helps ensure the loan stays within the limits established by the asset's value and the lender's risk tolerance.

Broker

Types-of-Insurance.jpg

In your loan management system, the broker acts as a bridge between borrowers and lenders. They don't directly issue loans themselves, but rather work to match borrowers with the most suitable loan options based on their financial profile and needs. Brokers typically have relationships with multiple lenders, allowing them to shop around for the best rates and terms on behalf of the borrower.

There are three key sections to streamline broker management and facilitate their involvement in the loan origination process:

Asset Transfer

coin-two-right-left-arrows-600nw-2294594153.webp

This module allows users to modify the details of assets in a contract after the contract has been created. This is likely targeted at situations where there might be errors or missing information in the initial contract.

The module seems to be divided into two main parts based on asset types:

  1. Vehicles Asset Transfer: This section likely handles changes to vehicle-related assets specified in the contract.

  2. Real Estate Asset Transfer: This section focuses on editing details pertaining to real estate assets mentioned in the contract.

The transfer process is completed in two steps:

  1. Pending.
  2. Submit.

Untitled Diagram.11-Page-23.drawio (1).png

Pending Page

To provide a list of assets eligible for transfer and allow users to initiate the transfer process for specific assets.

Screenshot 2024-07-25 135922.png

Submit Page

The Submit page is the second step in the asset transfer process. It presents a detailed view of the asset selected for transfer from the Pending page. Here, users can verify asset information before proceeding to the final step.

Screenshot 2024-07-25 140038.png

Complete Page

The Complete Page is the final step in the asset transfer process. It serves as the point where users input the necessary details to finalize the transfer.

Screenshot 2024-07-25 140123.png


Guarantor

What-is-a-guarantors-role-in-loan-f.webp

This feature implies that when a user is adding a new prospect to the system, the system should automatically attempt to create a guarantor profile based on the provided mobile number.

The user enters the guarantor's mobile number in the "Add Prospect" section. the system performs a real-time check for an existing guarantor record associated with the entered mobile number.

The system checks if the entered mobile number matches an existing guarantor record. 

Guarantor Information: The required information for new guarantor creation typically includes:

The Guarantor List page provides a comprehensive overview of all registered guarantors. The primary function of this page is to display essential information about each guarantor, allowing users to easily identify and access specific details when needed.

Sections:

Filtering:

Users can efficiently search and locate specific guarantors using the following filters:

Update Contact Number Process

Loan Prospect

loan_management_systems-1.jpg

A loan prospect is essentially a potential borrower who has been identified as a suitable candidate for a loan. The loan prospect process involves identifying, assessing, and nurturing these potential customers to convert them into actual borrowers.

Loan Process

Untitled Diagram.11-Page-22.drawio (2).png

1. Case Section

The Case Section appears to be a critical component of the "Add Prospect Form" where detailed information about the potential customer and their financial situation is collected. It also involves capturing information about the sales process and any guarantors involved.

1.1 Sales and Customer Information
1.2 Guarantor Information
1.3 Asset Valuation

2. Loan Details Section

The Loan Details section appears to be a crucial part of the prospect form, providing comprehensive information about the proposed loan. It includes details about the Loan Amount, fees, and other financial terms.

Loan Amount and Fees:

3. Document Section

The Document Section appears to be a critical part of the loan application process, where required documentation is listed and likely tracked for completion.

Mandatory Documents:

Optional Documents:

4. Collection Schedule Section

The Collection Schedule section appears to outline the calculation methodology for loan repayments, including principal, interest, and balance updates.

collection schedule.png

 5. CIB Section

The CIB (Credit Information Bureau) section is designed to capture and record a customer's credit history information. It appears to be a crucial component in assessing the creditworthiness of a loan applicant.

Note: Corporate & Investment Banking (CIB or BBVA CIB) includes the Group's wholesale businesses, i.e. investment banking, global markets, global loans and transactional services for international corporate customers and institutional investors across its global footprint.

6. History Section

The History section appears to tracking customer interactions, activities, and status changes over time. By capturing detailed information about each interaction, it provides valuable insights for decision-making and analysis.

7. Loan Form

The loan form is a digital document used within a customer department's customer unit. It appears to be a part of the loan approval process.

Basic Information:

Loan Details:

Form Actions:

8. Location Section

Location Section is aim to capture precise geographical information about the customer and guarantor. This section is designed to improve the accuracy of risk assessment, fraud prevention, and overall loan processing efficiency.

Components

9. Blacklist Section

The Blacklist Section is a crucial component of the loan form that acts as a real-time check for potential risks. This section is designed to identify if the applicant or guarantor has a history of defaulting on loans or exhibiting other credit-related issues.

10. Relationship History Section

The Relationship History Section provides a comprehensive overview of existing relationships between the loan applicant (customer or guarantor) and the lending institution.

11. Document List Section

The Document List section is a repository for essential documents related to the loan process. It contains a total of 19 different document types, each serving a specific purpose in the loan cycle.

Buttons

buttons.png

Navigation Buttons
Approval Process Buttons
Status Checking Button

prospect list.png

  1. Salesperson - This is drop down field
  2. Customer Name - This is text field
  3. Guarantor Name - This is text field
  4. Contract Type - There are five contract types.
  1. ID Card/Corporate No - This is text field
  2. Phone No - This is text field
  3. Customer ID - This is text field
  4. Prospect Initial Date range - Using this, can search date range
  5. Status - there are six(6) status
      1. Salespersons
      2. Contract No
      3. Customer Type
      4. Customer name/ Company Name
      5. Main Phone No
      6. Case No
      7. Contract Type
      8. Loan Amount
      9. Staff
      10. Status
      11. Action - This options will be change according to the status

Recordings

Day 1 Session: 10/06/2024

Modules

Link: https://us02web.zoom.us/rec/share/dmqPbo_9_muBpNdNjdcpW9mX7WyhN0ytPebylIMkKsw0OVElHhYqNqsxBRpbe1y6.ZnxO_9xKnm6LRfBs

Passcode: t1!G4cZw

Day 2 Session:  11/06/2024

Modules

Link:https://us02web.zoom.us/rec/share/1M9_-kbO4fSAJTiLN6VKlJ_VFN3ZZssKygLBcw3gmheRpno3YpkhCXui6gCV7S2I.fJnj3ogWpNJgUqn9

Passcode:Ww2^G&CP

Day 3 Session:  13/06/2024

Modules

Link: https://us02web.zoom.us/rec/share/XqO_nvT989HHPca_-67yzDAxSrVvSFq5NO8T4I6Jac1voB_7TG7BZd_3nE8dpyD2.SZbkLInFCt_f2kfl

Passcode:qb60E*!z

Day 4 Session:  14/06/2024

Modules

Link: https://us02web.zoom.us/rec/share/vr_9HlTYr8now3g7ZkzQZ7DBjhUTANIQ21zq1IipNmx3XB6SsuKNR3HbfX_B4CBn.T_wIzbTebPxewSfl

Passcode:TZZfR@w1

Day 5 Session:  18/06/2024

Modules

Linkhttps://us02web.zoom.us/rec/share/Ar12pyuDp9yPNR9qzkOYAI67DAxYLGKdBD6e7_bGZJPXeIXYUZ7px3r1kXEQEgoz.3NXEdU4r-BDqQzxI

Passcode: vt*G1=t6

Day 6 Session:  19/06/2024

Modules

Link: https://us02web.zoom.us/rec/share/Rfhx-n8382xTpA4GZcF1BGO7WNKGmEeqTVWiFbTnXDosWUWMmrZpdWcK7F3do6cI.deFlk-z_s7PKgedW

Passcode: 9e!?4g9^

Day 7 Session:  20/06/2024

Modules

Link: https://us02web.zoom.us/rec/share/lREebgY7AMGTuC-Gf_VfK4WzRqcVU5UKzN-tQBD64WYqoVYqyR4I_Te5guMPPApi.OJaLOXoL95brFNrQ

Passcode:J4*bNUuM

Day 8 Session:  24/06/2024

Modules

Link: https://us02web.zoom.us/rec/share/ldk874JoacnhL03V4qjOdt_wA00zmU50LBRtykOg-L4FIGGcmPJMPFOcd0vFNsEW.JiZCi_r1atA0OkT9

Passcode: Ndx5t=3G

Day 9 Session:  25/06/2024

Modules

Link: https://us02web.zoom.us/rec/share/LWZmWRyxSIenUIVB-vUKS7Tm6TOBs0mtcOlj9Jl4fpmB_8s1pZ_cHkDQoRVgL-Un.kjc0SmAGn3QExgNs

Passcode: B+.H4PS^

Day 10 Session:  10/07/2024

Modules

Link: https://us02web.zoom.us/rec/share/rSGpctdLnWUDCcJr416HuEh0nbInPwrqJxO5OinGFB6sMZgq65OGcAlACRSfXaj2.h6SOqKzWHu9LQY9g?startTime=1720607450000

Passcode:GHiU?5v.

Day 11 Session:  11/07/2024

Modules

Link: https://us02web.zoom.us/rec/share/ErJxD1KF2yEXMTLphlAnEFV2FavW5SObqH5-KZZ1l_Z6axbzjNupOWmtNeUdi_sd.OJm9bmypgUu_NXio?startTime=1720782008000

Passcode: p@7=UB9a

Day 12 Session:  12/07/2024

Modules

Link: https://us02web.zoom.us/rec/share/ErJxD1KF2yEXMTLphlAnEFV2FavW5SObqH5-KZZ1l_Z6axbzjNupOWmtNeUdi_sd.OJm9bmypgUu_NXio?startTime=1720782008000

Passcode:e9!qMkD+

Day 13 Session:  15/07/2024

Modules

Link: https://us02web.zoom.us/rec/share/ErJxD1KF2yEXMTLphlAnEFV2FavW5SObqH5-KZZ1l_Z6axbzjNupOWmtNeUdi_sd.OJm9bmypgUu_NXio?startTime=1720782008000

Passcode:$s%GwmS0

Day 14 Session:  16/07/2024

Modules

Link: https://us02web.zoom.us/rec/share/FhTjnQP6TMI-BVCQNtqKTkkwI2sy4lof0tAc0BpzDMJaJMP1K2WmRM5gkBsLhG19.xzdiTIBjwxIpjvA3?startTime=1721127811000

Passcode:d5F2^yCu

Day 15 Session:  17/07/2024

Modules

Link: https://us02web.zoom.us/rec/share/-qlMagXHb_ZBdG3OeNSL4TmnQ_8hf5fMWRDV--GhwBaq0E556yOeJTfOnJckczr2.e--TZ4FgvwPH0Y_5?startTime=1721214269000

Passcode:2*vXU^24

Day 16 Session:  18/07/2024

Modules

Link: https://us02web.zoom.us/rec/share/BDWbq_zT8MwIxhAf2vUDnT2vhA4N5JlcW7LkVKQ_S-MhwbiZDfDee4mM0T4R3bUN.dJxJyhOt97wupaHZ?startTime=1721300715000

Passcode:L?avEc3G

Loan Contract

contract.jpg

The document creation process begins with the approval of a loan prospect and culminates in the activation of the loan contract upon disbursement approval. This process involves multiple stages of review, approval, and verification.

Contract Approval Process

 

Untitled Diagram.11-Page-26.drawio.png

Loan Prospect Approval:

Contract Review and Approval:

Contract Approval:

Disburse Payment:

Approve Payment:

Loan Contract Page

Refinancing Process

Refinancing is a process where an existing loan is replaced with a new loan, often to secure better terms such as a lower interest rate, extended repayment period, or to consolidate debt. In the context of your system, this involves closing the current loan contract and creating a new one.

Collection

1 . Cash

The cash collection method is a fundamental process for recording payments made in physical currency. It involves the receipt of cash, generation of a receipt, and updating the corresponding loan contract.

Process

  1. Customer Payment: A customer presents a cash payment for their loan installment.
  2. Cash Verification: The cashier or collection agent verifies the amount tendered by the customer.
  3. Receipt Generation: The system generates a cash receipt detailing the following:
  1. Cash Handling: The collected cash is securely stored or deposited into the designated cash register or bank account.
  2. System Update: The system records the cash payment against the customer's loan contract, updating the balance accordingly.

2 . Bank Wire

The Bank Wire collection method is used to record payments made by customers through electronic bank transfers. This method typically offers two approaches for data input: linking existing bank statements or manually entering payment details.

Method 1: Linking Bank Statements

Method 2: Manual Entry

3. Collateral Disposal

The Collateral Disposal collection method involves processing the proceeds from the sale of seized collateral to offset the outstanding loan balance. The outcome of the process depends on the relationship between the sale amount and the outstanding balance.

Contract Status Update:

4. Litigation recovery 

The Recovery collection method is designed to account for lump sum payments made by customers to settle outstanding debts. These debts typically arise from missed or delayed payments on the original loan contract.

Contract Status Update:

5. Early/Late Closure

The Early/Late Closure collection method is used to finalize a loan contract before its scheduled term. This typically occurs when a borrower decides to pay off the entire loan balance in either ahead of schedule (early closure) or after the contract's end date (late closure).

Process

  1. Closure Request: The customer initiates a request to close the loan account.
  2. Balance Calculation: The system calculates the outstanding loan balance, including any accrued interest and penalties.
  3. Final Payment: The customer makes a final payment to cover the entire outstanding balance.
  4. Collection Entry: The system records the final payment under the "Early/Late Closure" collection method.
  5. Contract Closure: The loan contract is marked as "closed."
  6. Interest and Penalty Calculations:
    • Early Closure: Some loan contracts may include prepayment penalties. If applicable, the system calculates and deducts the penalty from the final payment.
    • Late Closure: Interest continues to accrue on the outstanding balance until the final payment is made. The system calculates and adds the accrued interest to the final payment.
  7. Account Closure: The loan contract is closed, and any remaining balance (surplus or deficit) is adjusted accordingly.

Loan Penalty

A loan penalty is a financial charge imposed on a customer for breaching the terms of a loan agreement. This typically occurs when a customer fails to adhere to the repayment schedule, such as missing a payment or making a late payment. Penalties can vary widely depending on the lender and the specific terms of the loan agreement.

Loan Accrual 

Loan accrual in this context refers to the calculation of interest that accumulates between the last scheduled payment date and the actual date of early loan closure. Since the borrower is paying off the loan ahead of schedule, they avoid paying interest for the remaining term of the loan. However, they are still liable for the interest accrued during the period between the last payment and the early closure date.

The accrual is added automatically when the contract is refinanced.

Example:

The lender calculates the interest for those five days and adds it to the final payment amount. This ensures that the lender receives interest for the actual usage of the funds.

Bank Statement

1. Introduction

This document outlines the process of uploading and processing bank statements within our system. The primary goal is to automate the linking of bank statements to existing collections and create new auto-collections as needed.

2. Adding Bank Statements

There are two methods to Add bank statements:

2.1 Manual Add

Bank statement.png

2.2 Upload Bank Statement

Bank statement 1.png

Once a bank statement is uploaded, the system automatically performs a series of checks to identify and link transactions to existing collection receipts. The following criteria are used to match transactions:

If a transaction meets all three criteria, it is successfully linked to the matching collection receipt.

3. Bank Statement Page(Credit/ Debit)

The Bank Statement page provides a comprehensive overview of all bank statements uploaded or manually entered into the system. It offers several search filters to help users locate specific statements efficiently:

Search Filters:

bank statement 2.png

Total Amounts

The page displays the total amount of all filtered statements in the following currencies:

statement 3.png

Bank Statement Table

The main table on the page lists all bank statements, providing detailed information about each transaction. Users can perform various actions on these statements:

statement 4.png

  1. Assign: Redirects to the Collection Receipt page to assign the statement to a specific collection receipt.
  2. Assign Collection: Opens a popup window to assign the statement to a bank collection.

statement 5.png

  1. Assign Account: Opens a popup window to assign the statement to a specific account.

statement 6.png

  1. Delete: Removes the statement from the database.

Exporting Bank Statements

The "Export" button allows users to export the filtered bank statement data into a downloadable format for further analysis or reporting.

By utilizing these features and filters, users can effectively manage and analyze bank statements, ensuring accurate financial records and efficient processing.