7 Schedule Inquiry

This topic provides systematic instructions to inquiry of the loan repayment schedule.

Through this feature, the user is able to gain an understanding of the loan repayment life cycle. This page displays details of each instalment including the interest and principal amounts along with any charges if applicable, and the total instalment amount due on each specific date throughout the loan tenure.

The user is able to identify important information such as the frequency in which repayment instalments are made, the total number of instalments and the number of instalments paid and those that are pending. User can avail account related transactions on the kebab menu.

Using the Manage Columns feature, bank can configure and enable customizable UI display/download option for the end users. Using this feature, users can personalize the information to be displayed/downloaded from search grid displayed on the screen.

By clicking on Manage Columns option available on the screen, user can

  • Rearrange columns
  • Remove specific columns.

Note:

  • The downloaded report will have the same columns as displayed on the UI as per user preference as well as there will also be an option to modify the column selection while downloading.
  • The column preferences setup by the user will be saved for future reference, that means, in case the user revisits this screen, the preferred columns will only be displayed in the table.

To view loan schedule:

  1. Perform one of the following navigation to access the Corporate Loans Schedule Inquiry screen:
    • From the Dashboard, click Menu, and click Accounts, then click Corporate Loans. Under Corporate Loans, click Schedule Inquiry.
    • From the Dashboard, click on the Loan account number link of the Corporate Loan Summary widget. On the Corporate Loans Details screen, click kebab menu and select Schedule Inquiry.
    • From the Search bar, type Corporate Loans – Schedule Inquiry.
    • Access through the kebab menu of the transaction available in the Corporate Loans module.
    The Corporate Loans Schedule Inquiry screen displays.

    Figure 7-1 Schedule Inquiry


    Description of Figure 7-1 follows
    Description of "Figure 7-1 Schedule Inquiry"

    For more information on fields, refer to the field description table below:

    Table 7-1 Schedule Inquiry - Field Description

    Field Name Description
    Loan Account

    All the loan accounts are listed in a drop-down list with masked format along with nicknames, if defined.

    The user can select the loan account want to select and view schedule details. The account number will be masked as per account number masking configurations.

    If the user has accessed this page through the Overview widget, the account number selected will be pre-selected and the user can change selection as required.

    For more information on account nickname, refer to the Account Nickname chapter in this user guide.

    Due Date Displays the due date of the specific instalment.
    Principal Displays the principal amount that is due on the instalment date.
    Interest Displays the interest amount that is due on the instalment date.
    Instalment Displays the total instalment amount that is due on the instalment date.
    Charges Displays the charges that is unpaid due.
    Unpaid Instalment Displays the amount that remains to be paid, if at all, on the specific instalment date.
  2. Click filter criteria to search the loan repayment schedule based on filter criteria.
    The Filter screen displays.
    Specify the period for which instalment details in the repayment schedule are to be viewed.
    1. From the Loan Account Number list, select the loan account that you want to view loan schedule.
    2. From the From Date list, select the appropriate date.
    3. From the To Date list, select the appropriate date.
    4. Click Apply.

      Based on the specified period, the set of instalment in the loan repayment schedule are displayed.

  3. Click download to download the records in CSV and PDF format.
  4. Click manage columns to setup a column preference by rearranging or removing columns.
  5. Click kebab and select Instalment Summary, Rate Revision History, and Payment Overview to view transaction details on the Instalment Summary, Rate Revision History, and Payment Overview screens.

    Figure 7-2 Schedule Inquiry-Instalment Summery


    Description of Figure 7-2 follows
    Description of "Figure 7-2 Schedule Inquiry-Instalment Summery"

    For more information on fields, refer to the field description table below:

    Table 7-2 Installment summary - Field Description

    Field Name Description
    First Instalment Displays the date on which the first instalment payment is due on the loan.
    Last Instalment Displays the date on which the last instalment payment is due on the loan.
    Total Instalments Displays the total number of instalments of the loan.
    Instalments Paid Displays the number of instalments paid till date.
    Amount paid Till Date Displays the total amount paid in instalments till date.

    The Rate Revision History screen displays only if the user clicks on the Rate Revision History link in the Instalment Summary section. Each instance of interest rate revision is displayed against the corresponding date on this window.

    Figure 7-3 Schedule Inquiry-Rate Revision History


    Description of Figure 7-3 follows
    Description of "Figure 7-3 Schedule Inquiry-Rate Revision History"

    For more information on fields, refer to the field description table below:

    Table 7-3 Rate Revision History - Field Description

    Field Name Description
    Date Displays the date on which the interest rate has been revised.
    Rate Displays the revised interest rate.

    Figure 7-4 Schedule Inquiry- Payment Overview


    Description of Figure 7-4 follows
    Description of "Figure 7-4 Schedule Inquiry- Payment Overview"

    For more information on fields, refer to the field description table below:

    Table 7-4 Payment Overview - Field Description

    Field Name Description
    Paid Amount Details

    The following three fields and values will display the amounts that have been paid by the user towards the loan repayment.
    Paid Amount Displays the total loan amount that has been repaid till date.
    Paid Principal Displays the principal amount repaid till date.
    Paid Interest Displays the interest amount repaid till date.
    Unpaid Amount Details

    The following three fields and values will display the amounts that are yet to be paid by the user towards the loan.
    Unpaid Amount Displays the total loan amount pending for repayment.
    Unpaid Principal Displays the principal amount pending for repayment.
    Unpaid Interest Displays the interest amount pending for repayment.