Loan Management System is used to automate the back office activities of bank and finance company offers any type of loans. From an end-user perspective, the Loan Management System Project consists of two functional elements: Security Module, Customer and Loan transaction Module and a Query Module.
To day is the need of finance in every aspects of life. As we know these days’ different bank and finance company coming up with new finance product every month. In such competitive environment, so only selling the finance product is not the only target, but providing excellent service to the customer for long period is the next major task. Therefore, system has to come up that can handle back office activities, otherwise manage this activities of huge numbers of customer adapt and loan transaction might become cumbersome and headache is not taken seriously.
Therefore proposed “Loan Management System” has been designed to automate the back office activities of bank and finance company offers any type of loans. System can make the daily activities efficient and providing the fast response.
Security modules include security features like user management and application level password management..
- Maintain user master- Each user identified by the user name and user type. Only admin user can create, edit user information.
- Password must be 6 characters long.
- Password must be alpha numeric.
- While creating user system assign default password for the user, user must change default password for first time login.
- All login time stamp stored in the system for security audit.
- Access level and roles and privileges are set for different type of users.
Customer and Loan transaction module
Customer and loan transaction module includes Loan Type, Customer, Issuing Loan, EMI Calculation, Receive payments.
- The System Administrator can able to add, modify loan type like Home Loan, Personal Loan, can modify the interest rate..
- Maintain the customer database, customer database includes all the details like customer name, address, contact no, bank account no, pan no, email id, etc. Only Admin and Supervisor can delete customer record.
- One customer can have more than one loan, System generate unque loan no. system users can add, modify loan details like loan type, loan amount, tenure, mortgage details, guarantor details. User can view the monthly interest for loan.
- EMI Calculation- System have unique on screen monthly interest calculator, it provide details breakup of particular loans, System take input from user like Loan Amount, Interest Rate, Tenure, Issue Date and give details out put like monthly EMI, total interest, total cost.
- EMI calculation can be exported in Microsoft excel for future analysis..
- Receive payment – System can enter payment information for particular emi, it calculates late fine charges if it is receipt date is greater than the emi date.
- System has find customer facility, system user can find customer by their name, account no, pan no with using wild card character “%”.
A powerful query module give on screen information for particular customer, system user can view all information for particular customer in one screen by entering customer no.
Powerful search facility for finding customer id, if system user unable to remember customer id by typing customer name, account no, pan no. Find module support wild character search.
It display customer details like Customer Name, Account No..
Loan details like , loan no, loan amount, interest rate, type of loan, tenure, monthly emi, loan issue date.
Details break-up of emi and payment details in tabular form.
All data can be exported to Microsoft excel file for future references.