Loan Management systems Loan Management Systems LMS Loan

  • Slides: 71
Download presentation
Loan Management systems ® Loan Management Systems ® (LMS )

Loan Management systems ® Loan Management Systems ® (LMS )

Loan Management Systems ® Features Highlight l l l Loan creation Track Customer’s Loan

Loan Management Systems ® Features Highlight l l l Loan creation Track Customer’s Loan and other transactions. Track Salesman’s Collection l Monthly Collection report

Loan Management Systems ® Login to the application Running LMS ® application • Enter

Loan Management Systems ® Login to the application Running LMS ® application • Enter the Server Name eg( your computer namesqlexpress). 2. Enter ‘loans’ for Database. 3. Enter you user id to access the program. (eg. user 1) 4. Password for the user entered above. (eg. password) 5. Click ‘OK’ to continue. If all the above information are entered correctly user will be able to see the application main menu. 1 2 3 4 4

Loan Management Systems ® Main Menu

Loan Management Systems ® Main Menu

Loan Management Systems ® In the main menu you can see the following Sub

Loan Management Systems ® In the main menu you can see the following Sub menus l l Setup Loans Processing Reports Utilities

Loan Management Systems ® Setup Menu 1 Before creating New Loan Master you need

Loan Management Systems ® Setup Menu 1 Before creating New Loan Master you need to setup some ‘one-time’ master files. Eg are Customer Master, Salesman Master, Finance Code Master & Branch code Master. 1. Click this option for ‘Customer’ master.

Loan Management Systems ® Customer Master Setup 1 2 1. For New Customer enter

Loan Management Systems ® Customer Master Setup 1 2 1. For New Customer enter ICNo. Press <Enter> to accept, if existing record found the information of that customer will be displayed, otherwise continue enter the rest of the information. 2. Enter customer name in this field. 3. These Tabs are fields which you can enter more information for the customer 4. For Date field you can use this button ‘>’ to show a calendar and choose the date require. 5. Use ‘Combo’ button to choose from a lists. 6. Use this ‘Browse’ button to select Picture file from folder. 7. Currency Code, Use lookup button to select from currency master. 8. Enter the GL Control for this customer code. Use ‘Lookup’ to select from GL master. 3 4 7 6 5 8

Loan Management Systems ® Customer Master Setup 1 2 1. Other Address Tab 2.

Loan Management Systems ® Customer Master Setup 1 2 1. Other Address Tab 2. Enter other address information

Loan Management Systems ® Customer Master Setup Reference Details

Loan Management Systems ® Customer Master Setup Reference Details

Loan Management Systems ® Customer Master Setup Family Detail

Loan Management Systems ® Customer Master Setup Family Detail

Loan Management Systems ® Customer Master Setup Financial Details

Loan Management Systems ® Customer Master Setup Financial Details

Loan Management Systems ® Customer Master Setup Enter Remarks if there is any. •

Loan Management Systems ® Customer Master Setup Enter Remarks if there is any. • 1 Click ‘Save’ button to create this new customer or if existing/old record will update the changes.

Loan Management Systems ® 1 A dialog box will display upon successfully saving the

Loan Management Systems ® 1 A dialog box will display upon successfully saving the customer master. • Click ‘OK’ button to clear this dialog box

Loan Management Systems ® Last Document No. 1 1. Last Document No. setting option

Loan Management Systems ® Last Document No. 1 1. Last Document No. setting option is located here (Setup>Last Document No. )

Loan Management Systems ® Last Document No. 1 3 2 1. Systems will default

Loan Management Systems ® Last Document No. 1 3 2 1. Systems will default ‘LASTNO’ just press <Enter> to continue and accept this field. 2. Most of the last document no setting will be displayed. 3. Enter the Prefix and the last no. 4. Upon saving in Loan Master Creation screen, the generated loan no would be AGRM/000017

Loan Management Systems ® Loan Processing Menu l l l l l Loan Master

Loan Management Systems ® Loan Processing Menu l l l l l Loan Master Creation Loan Miscellaneous Debit Entry Legal Fees Debit Entry Discount or Other Credit Entry Loan Receipt Entry Loan Reverse Entry Black List Report Entry Cancel Black List Report Entry Other Utilities, Change Receipt No and Date

Loan Management Systems ® Loan Master Creation 1 1. Option found in Main Menu>Loans

Loan Management Systems ® Loan Master Creation 1 1. Option found in Main Menu>Loans Processing>Loan Master Creation

Loan Management Systems ® Loan Master Creation 1 2 3 1. Leave it blank

Loan Management Systems ® Loan Master Creation 1 2 3 1. Leave it blank if you want the Systems to auto generate the loan No. upon saving this records. Press <Enter> to continue and accept this blank field. 2. Click ‘Lookup’ button to retrieve from Customer Master file. 3. Installment Amount and Last Installment will be calculate upon entering ‘Finance Period’

Loan Management Systems ® Loan Master Creation 3 1 2 1. Installment Amount and

Loan Management Systems ® Loan Master Creation 3 1 2 1. Installment Amount and Last Installment will auto calculated based on the formula. 2. Enter Agreement Date and Commence Date. 3. Enter No of days overdue 4. Overdue charge in Amt or in percentage. 3

Loan Management Systems ® Loan Master Creation 1 1. On the ‘Customer Details’ tab,

Loan Management Systems ® Loan Master Creation 1 1. On the ‘Customer Details’ tab, the information are extracted from Customer Master.

Loan Management Systems ® Loan Master Creation 1 1. When everything are in order

Loan Management Systems ® Loan Master Creation 1 1. When everything are in order press ‘Save’ button to create Loan Master from the information entered.

Loan Management Systems ® Loan Master Creation

Loan Management Systems ® Loan Master Creation

Loan Management Systems ® Loan Receipt Entry 1. 1 Option found in Main Menu>Loans

Loan Management Systems ® Loan Receipt Entry 1. 1 Option found in Main Menu>Loans Processing>Loan Receipt Entry

Loan Management Systems ® Loan Receipt Entry 3 1 2 4 1. Leave it

Loan Management Systems ® Loan Receipt Entry 3 1 2 4 1. Leave it blank to let the systems auto generate a new Loan Receipt Trans. No. Just press <Enter> key 2. Use ‘Lookup’ button to select from Loan Master. 3. Lookup Records dialog displays. 4. Select Loan No. from the list double click record, or highlight using arrow keys, then press ‘OK’

Loan Management Systems ® Loan Receipt Entry 1 3 2 1. Most of the

Loan Management Systems ® Loan Receipt Entry 1 3 2 1. Most of the information from Loan Master will be extracted and display on this screen. 2. Schedule/Receipt info for this loan. 3. Misc/Debit/Credit Transactions for this loan.

Loan Management Systems ® Loan Receipt Entry 1 2 3 2 1. Select Payment

Loan Management Systems ® Loan Receipt Entry 1 2 3 2 1. Select Payment Type. 2. Choose GL Debit A/C. Use ‘Lookup’ button to choose from the lists. 3. Enter Installment Amount. 4. When everything is OK press ‘Save’ button to create new loan receipt transaction.

Loan Management Systems ® Loan Receipt Entry 1 1. A new loan receipt transaction

Loan Management Systems ® Loan Receipt Entry 1 1. A new loan receipt transaction will be created and saved to file. Click OK to accept and continue for new ‘Loan Receipt’.

Loan Management Systems ® Loan Miscellaneous Debit Entry 1 1. Option found in Main

Loan Management Systems ® Loan Miscellaneous Debit Entry 1 1. Option found in Main Menu>Loans Processing>Loan Miscellaneous Debit Entry

Loan Management Systems ® 3 Loan Miscellaneous Debit Entry 1 2 4 1. Leave

Loan Management Systems ® 3 Loan Miscellaneous Debit Entry 1 2 4 1. Leave it blank to have systems auto generate a new Loan Miscellaneous Debit No. Just press <Enter> key. 2. Use ‘Lookup’ button to select from Loan Master. 3. Lookup Records dialog displays. 4. Select Loan No. from the list, double click record to accept loan no. , or highlight using arrow keys, then press ‘OK’

Loan Management Systems ® Loan Miscellaneous Debit Entry 1 2 3 5 4 1.

Loan Management Systems ® Loan Miscellaneous Debit Entry 1 2 3 5 4 1. Most of the information from the selected Loan Master will be extracted and display to the rest of the fields on this screen. 2. Enter Particular/Description for this Miscellaneous Debit Entry. 3. Select Debit details from GL table. 4. Enter Miscellaneous Transaction Amount. 5. Click ‘Save’ to create new Misc. Debit Transaction.

Loan Management Systems ® Loan Miscellaneous Debit Entry 1 1. A new Miscellaneous Debit

Loan Management Systems ® Loan Miscellaneous Debit Entry 1 1. A new Miscellaneous Debit Transaction will be created and saved to file. Click OK to accept and continue for new ‘Loan Misc. Debit Notes’.

Loan Management Systems ® Loan Miscellaneous Debit Entry 1 1. Click ‘Yes’ button to

Loan Management Systems ® Loan Miscellaneous Debit Entry 1 1. Click ‘Yes’ button to print this Miscellaneous Debit Notes.

Loan Management Systems ® Loan Miscellaneous Debit Entry 2 3 1 4 1. These

Loan Management Systems ® Loan Miscellaneous Debit Entry 2 3 1 4 1. These button are to navigation report. 2. Click ‘Print’ button to send report to attached printer. 3. Click ‘PDF’ button to create report in PDF format. 4. Zoom in or zoom out this report. 5. Exit from this screen. 5

Loan Management Systems ® Legal Fees Debit Entry 1 1. Option found in Main

Loan Management Systems ® Legal Fees Debit Entry 1 1. Option found in Main Menu>Loans Processing>Legal Fees Debit Entry.

Loan Management Systems ® 3 Legal Fees Debit Entry 1 2 4 1. Leave

Loan Management Systems ® 3 Legal Fees Debit Entry 1 2 4 1. Leave it blank to have systems auto generate a new Loan Miscellaneous Debit No. Just press <Enter> key. 2. Use ‘Lookup’ button to select from Loan Master. 3. Lookup Records dialog displays. 4. Select Loan No. from the list, double click record to accept loan no. , or highlight using arrow keys, then press ‘OK’

Loan Management Systems ® Legal Fees Debit Entry 1 2 3 5 4 1.

Loan Management Systems ® Legal Fees Debit Entry 1 2 3 5 4 1. Most of the information from the selected Loan Master will be extracted and display to the rest of the fields on this screen. 2. Enter Particular/Description for this Legal Fees Debit Entry. 3. Select Lawyer code from GL Table. 4. Enter Legal Fees Debit Transaction Amount. 5. Click ‘Save’ to create new Legal Fees Debit Transaction.

Loan Management Systems ® Legal Fees Debit Entry 1 1. A new Legal Fees

Loan Management Systems ® Legal Fees Debit Entry 1 1. A new Legal Fees Debit Transaction will be created and saved to file. Click OK to accept and continue for new ‘Legal Fees Debit’.

Loan Management Systems ® Legal Fees Debit Entry

Loan Management Systems ® Legal Fees Debit Entry

Loan Management Systems ® Legal Fees Debit Entry

Loan Management Systems ® Legal Fees Debit Entry

Loan Management Systems ® Discount Or Others Credit Entry 1 1. Option found in

Loan Management Systems ® Discount Or Others Credit Entry 1 1. Option found in Main Menu>Loans Processing>Discount Or Others Credit Entry.

Loan Management Systems ® Discount Or Others Credit Entry 1 3 2 4 1.

Loan Management Systems ® Discount Or Others Credit Entry 1 3 2 4 1. Leave it blank to have systems auto generate a new Discount Or Others Credit No. Just press <Enter> key 2. Use ‘Lookup’ button to select from Loan Master. 3. Lookup Records dialog displays. 4. Select Loan No. from the list, double click record to accept loan no. , or highlight using arrow keys, then press ‘OK’

Loan Management Systems ® Discount Or Others Credit Entry 1 2 4 1. Most

Loan Management Systems ® Discount Or Others Credit Entry 1 2 4 1. Most of the information from the selected Loan Master will be extracted and display to the rest of the fields on this screen. 2. Enter Reference No. if any. 3. Enter Discount Or Others Credit Transaction Amount. 4. Click ‘Save’ to create new Legal Fees Debit Transaction. 3

Loan Management Systems ® Discount Or Others Credit Entry 1 1. A new ‘Discount

Loan Management Systems ® Discount Or Others Credit Entry 1 1. A new ‘Discount Or Others Credit Transaction’ will be created and saved to file. Click OK to accept and continue for new ‘Discount Or Others Credit’.

Loan Management Systems ® Discount Or Others Credit Entry

Loan Management Systems ® Discount Or Others Credit Entry

Loan Management Systems ® Discount Or Others Credit Entry

Loan Management Systems ® Discount Or Others Credit Entry

Loan Management Systems ® Reverse Loan Receipt Entry 1 1. Option found in Main

Loan Management Systems ® Reverse Loan Receipt Entry 1 1. Option found in Main Menu>Loans Processing>Reverse Loan Receipt Entry.

Loan Management Systems ® Reverse Loan Receipt Entry 3 1 2 4 1. Leave

Loan Management Systems ® Reverse Loan Receipt Entry 3 1 2 4 1. Leave it blank to have systems auto generate a new Reverse Loan Receipt No. Just press <Enter> key 2. Use ‘Lookup’ button to select from Loan Master. 3. Lookup Records dialog displays. 4. Select Loan No. from the list, double click record to accept loan no. , or highlight using arrow keys, then press ‘OK’

Loan Management Systems ® Reverse Loan Receipt Entry 1 3 2 4 5 1.

Loan Management Systems ® Reverse Loan Receipt Entry 1 3 2 4 5 1. Most of the information from the selected Loan Master will be extracted and display to the rest of the fields on this screen. 2. Enter Payment Type. 3. Enter GL Debit A/C or click Lookup button to select from the lists. 4. Enter Reverse Loan Transaction Amount. 5. Click ‘Save’ to create new Reverse Loan Receipt Transaction.

Loan Management Systems ® Reverse Loan Receipt Entry 1 1. A new ‘Reverse Loan

Loan Management Systems ® Reverse Loan Receipt Entry 1 1. A new ‘Reverse Loan Receipt Transaction’ will be created and saved to file. Click OK to accept and continue for new ‘Reverse Loan Receipt’.

Loan Management Systems ® Reverse Loan Receipt Entry

Loan Management Systems ® Reverse Loan Receipt Entry

Loan Management Systems ® Reverse Loan Receipt Entry

Loan Management Systems ® Reverse Loan Receipt Entry

Loan Management Systems ® Black List Report Entry 1 1. Option found in Main

Loan Management Systems ® Black List Report Entry 1 1. Option found in Main Menu>Loans Processing>Black List Report Entry.

Loan Management Systems ® Black List Report Entry 1 2 3 4 5 1.

Loan Management Systems ® Black List Report Entry 1 2 3 4 5 1. Leave it blank to have systems auto generate a new Black List Report No. Just press <Enter> key 2. Enter fields to filter before retrieve. 3. For some reason you want to cancel the retrieving you can press this ‘Cancel’ button. 4. Click ‘Retrieve’ button to extract Loan Master based on Filtering fields. 5. Choose YES or NO from option button 6. Press ‘Save’ button to create new ‘Black List Report’

Loan Management Systems ® Black List Report Entry 1 1. A new ‘Black List

Loan Management Systems ® Black List Report Entry 1 1. A new ‘Black List Report Transaction’ will be created and saved to file. Click OK to accept and continue.

Loan Management Systems ® Other Utilities Change Receipt No and Date 1 1. Option

Loan Management Systems ® Other Utilities Change Receipt No and Date 1 1. Option found in Main Menu>Loans Processing>Other Utilities Change Receipt No and Date.

Loan Management Systems ® Other Utilities Change Receipt No and Date 1 2 3

Loan Management Systems ® Other Utilities Change Receipt No and Date 1 2 3 1. Enter Receipt No. or click ‘Lookup’ button to retrieve from the lists. 2. Lookup Records dialog displays. 3. Select Receipt No. (Trans Id. ) from the list, double click record to accept the Receipt No. or highlight using arrow keys, then press ‘OK’

Loan Management Systems ® Other Utilities Change Receipt No and Date 1 2 1.

Loan Management Systems ® Other Utilities Change Receipt No and Date 1 2 1. Original Receipt No. displayed. 2. Original Receipt Date displayed.

Loan Management Systems ® Other Utilities Change Receipt No and Date You can change

Loan Management Systems ® Other Utilities Change Receipt No and Date You can change either one or both Receipt No. and Receipt Date. In this example both Receipt no. and Date changed. 1 2 • New Receipt No. HRA 000041 A • New Receipt Date 08 -Mar-2009 • Click ‘Save’ to commit the change

Loan Management Systems ® Other Utilities Change Receipt No and Date 1 2 For

Loan Management Systems ® Other Utilities Change Receipt No and Date 1 2 For confirmation the password is today month + day (eg. Today is 10 Mar 2009), so 10 + 3 (Mar) = 13 • Enter month + day. • Click ‘Ok’ to confirm

Loan Management Systems ® Other Utilities Change Receipt No and Date 1 1. Click

Loan Management Systems ® Other Utilities Change Receipt No and Date 1 1. Click ‘Yes’ to continue

Loan Management Systems ® Other Utilities Change Receipt No and Date 1 1. Click

Loan Management Systems ® Other Utilities Change Receipt No and Date 1 1. Click ‘OK’ to continue

Loan Management Systems ® Other Utilities Change Receipt No and Date 1 1. Click

Loan Management Systems ® Other Utilities Change Receipt No and Date 1 1. Click ‘OK’ to continue

Loan Management Systems ® Reports l Loan Reporting l Daily Printing l Miscellaneous Debit

Loan Management Systems ® Reports l Loan Reporting l Daily Printing l Miscellaneous Debit Transaction Report l Legal Fees Debit Transaction Report l Discount or Other Credit Transaction Report l Reverse Loan Receipt Transaction Report l Black List Transaction Report l Cancel Black List Transaction Report l Operation Report Printing l New Loan Listing l Loan Balance Listing l Fully Settled Loan Listing l Unsettled Expired Loan l Salesman Collection Report l Monthly Loan Collection Report l Customer Address Label Printing l Customer Statement Of Account l Management Report Printing l Loan Arrears Aging Report l Master Setup Reporting l Customer Master Listing l Salesman Master Listing l Financier Master Listing

Loan Management Systems ® Miscellaneous Debit Transaction Report 1 1. Misc. Debit Transaction Report

Loan Management Systems ® Miscellaneous Debit Transaction Report 1 1. Misc. Debit Transaction Report is located here.

Loan Management Systems ® Miscellaneous Debit Transaction Report 1 2 1. Filtering field. If

Loan Management Systems ® Miscellaneous Debit Transaction Report 1 2 1. Filtering field. If leave it blank, all Misc. Transaction with all loan will be selected. Click the ‘Lookup’ button to select from the Loan Master Lists. 2. Select records from the lists or use arrow key to move, double click record or click OK with the selected record highlighted.

Loan Management Systems ® Miscellaneous Debit Transaction Report 1 2 1. System will default

Loan Management Systems ® Miscellaneous Debit Transaction Report 1 2 1. System will default today date. Choose Transaction Date range (From Date: and To: ) Click the ‘Calendar’ button to select a day. 2. Choose output option. If you didn’t choose any system will default output to Screen. 3. Click ‘Print’ button to print the report. 3

Loan Management Systems ® Miscellaneous Debit Transaction Report

Loan Management Systems ® Miscellaneous Debit Transaction Report

Loan Management Systems ® Utilities l l Lock Table Maintenance. Change Loan No.

Loan Management Systems ® Utilities l l Lock Table Maintenance. Change Loan No.

Loan Management Systems ® Lock Table Maintenance Utilities This utilities is used to clear

Loan Management Systems ® Lock Table Maintenance Utilities This utilities is used to clear lock records that been locked by user during their file accessing. The lock have to be cleared if for some reason, while accessing a table the PC hangs or disconnected from the server. 1 2 3 4 5 • Check the record to be cleared or • Click ‘Select All’ or ‘Unselect All’ • Click ‘Delete’ button to delete the locks • Click ‘Refresh’ to retrieve any more locks in the systems.

Loan Management Systems ® Change Loan No. Utilities 1 2 3 4 5 1.

Loan Management Systems ® Change Loan No. Utilities 1 2 3 4 5 1. Enter Existing Loan No. or select from a lists by clicking the ‘Lookup’ button 2. Enter New code. 3. Click ‘Ok’ to continue 4. ‘Password’ dialog box display. Enter month + day for the password. 5. Click ‘Ok’ to accept

Loan Management Systems ® Utilities Change Loan No. 1 1. Click ‘Yes’ to accept

Loan Management Systems ® Utilities Change Loan No. 1 1. Click ‘Yes’ to accept