{"id":5711,"date":"2021-07-14T12:28:02","date_gmt":"2021-07-14T12:28:02","guid":{"rendered":"https:\/\/wiki.habiletechnologies.com\/index.php\/docs\/cloudbankin-documentation\/loans\/reports-2\/"},"modified":"2022-09-22T09:55:52","modified_gmt":"2022-09-22T09:55:52","slug":"reports-2","status":"publish","type":"docs","link":"https:\/\/wiki.cloudbankin.com\/index.php\/docs\/cloudbankin-documentation\/loans\/reports-2\/","title":{"rendered":"Reports"},"content":{"rendered":"\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t

In this tab, you can see all the Reports related to <\/span>Loan Accounts, Saving Accounts, Clients, Accounting, Funds, etc.,<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t

\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"Reports\"\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t

The Standard Reports in CloudBankIN are classified into Five categories:<\/span><\/p>

  • \u00a0Clients<\/li>
  • \u00a0Loans<\/span><\/li>
  • \u00a0Savings<\/span><\/li>
  • \u00a0Funds<\/span><\/li>
  • \u00a0Accounting<\/span><\/li><\/ul>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t

    Field Name and Description \n<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t
    Standard Reports Field Descriptions<\/b><\/h6>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t
    Report Name<\/h6><\/td>
    Category<\/h6><\/td>
    Description<\/h6><\/td>
    Parameters to Search<\/h6><\/td><\/tr>
    Active Loans – Details<\/span><\/td>Loan<\/span><\/td>All active loans are listed, along with details such as principal, interest, and fees outstanding for each Loan.<\/span><\/td>Office, Loan Purpose, Fund, Currency, Office, Product, Loan Officer, Start Date, End Date<\/span><\/td><\/tr>
    Active Loans by Disbursal Period<\/span><\/td>Loan<\/span><\/td>Loan principal, interest rate, date disbursed, total loan amount, and total repaid are all listed by disbursal date.<\/span><\/td>Office, Currency, Fund, Loan Purpose, Loan Officer, Product, Start Date, End Date<\/span><\/td><\/tr>
    Active Loans in Last Installment<\/span><\/td>Loan<\/span><\/td>List of active loans on their last installment as of the day of the report is generated listing original loan details, expected maturity date as well as principal, penalties outstanding, interest, fees.<\/span><\/td>Office, Currency, Fund, Loan Purpose, Loan Officer, Product<\/span><\/td><\/tr>
    Active Loans in Last Installment (Summary)<\/span><\/td>Loan<\/span><\/td>List of active loans on their installment as of day of report, detailed by branch including no of clients, no of active loans and in arrears, total principal, interest, fees, penalties, and PAR calculation for loans on their last installment.<\/span><\/td>Office, Currency, Fund, Loan Purpose, PAR Calculation, Loan Officer, Product<\/span><\/td><\/tr>
    Active Loans Passed Final Maturity<\/span><\/td>Loan<\/span><\/td>It displays a list of clients with loan information such as Disbursed Date, Expected Maturity Date, as well as those who have already passed the maturity date.<\/span><\/td>Office, Currency, Fund, Loan Purpose, Loan Officer, Product<\/span><\/td><\/tr>
    Active Loans Passed Final Maturity Summary<\/span><\/td>Loan<\/span><\/td>It displays the number of loans with arrears (if any), as well as their details, that have passed their maturity date.<\/span><\/td>Office, Currency, Fund, Loan Purpose, PAR calculation, Loan Officer, Product\u00a0<\/span><\/td><\/tr>
    Active Loans Summary<\/span><\/td>Loan<\/span><\/td>A summary of total clients, active loans, arrears, PAR calculation, total disbursed, principal, interest, fees, and penalties for each branch is based on each branch.<\/span><\/td>Office, Currency, Fund, Loan Purpose, PAR Calculation, Loan Officer, Product<\/span><\/td><\/tr>
    Aging Detail<\/span><\/td>Loan<\/span><\/td>Aging Detail gives a list of clients with arrears in terms of the number of ‘Days,’ ‘Weeks,’ and ‘Days in Arrears Band’ under each office. It also shows the original principle, original interest, principal paid, interest paid, principal overdue, and interest overdue for the client.<\/span><\/td>Office<\/span><\/td><\/tr>
    Aging Summary (Arrears in Months)<\/span><\/td>Loan<\/span><\/td>Aging summary provides the number of loans in arrears in days (or on Schedule) with the currency type specified under a certain office.<\/span><\/td>Office, Currency<\/span><\/td><\/tr>
    Aging Summary (Arrears in Weeks)<\/span><\/td>Loan<\/span><\/td>Aging summary provides the number of loans in arrears in weeks (or on Schedule) with the specified currency type under a certain office.<\/span><\/td>Office, Currency<\/span><\/td><\/tr>
    Balance Sheet<\/span><\/td>Accounting<\/span><\/td>It displays a list of GL accounts (Assets, Liabilities, Equities, and so on) as well as the remaining amount in each account at a particular date for a given office.<\/span><\/td>Office, End Date, Output Type<\/span><\/td><\/tr>
    Branch Expected Cash Flow<\/span><\/td>Loan<\/span><\/td>This report offers ‘Expected Cash In’ (in terms of Principle, Interest, and Fees Penalty) and ‘Expected Cash Out’ (Loan Disbursals) and ‘Net Expected Cash Out’ at each date for the specified duration. (Expected Cash In ~ Expected Cash Out)<\/span><\/td>Office, Start Date, End Date, Output type<\/span><\/td><\/tr>
    Client Listing<\/span><\/td>Clients<\/span><\/td>It displays all clients for a specific branch, along with their Account Number, Client Status, Activation Date, and External Id.<\/span><\/td>Office<\/span><\/td><\/tr>
    Client Loans Listing<\/span><\/td>Clients<\/span><\/td>It displays a list of clients and their loan accounts, along with information such as Client Status, Loan Status (Approved, Disbursed, Closed, Rejected, Written-off), Amortization, Loan Frequency, etc.<\/span><\/td>Office, Currency, Loan Purpose, Fund, Loan Officer, Product, Start Date, End Date<\/span><\/td><\/tr>
    Expected Payments By Date – Basic<\/span><\/td>Loan<\/span><\/td>It shows Principal\/Interest\/Fees\/Penalties due and Total Due for all clients within a specific office for the given due date of the client.<\/span><\/td>Office, Loan Officer, Start Date, End Date<\/span><\/td><\/tr>
    Funds Disbursed Between Dates Summary<\/span><\/td>Funds<\/span><\/td>At a given duration, it lists all the funds which are disbursed with their currency type.<\/span><\/td>Currency, Fund, Start Date, End Date<\/span><\/td><\/tr>
    Funds Disbursed Between Dates Summary by Office<\/span><\/td>Funds<\/span><\/td>At a given duration and branch office name, it lists all the funds which are disbursed with their currency type.<\/span><\/td>Currency, Fund, Office, Start Date, End Date<\/span><\/td><\/tr>
    Income Statement<\/span><\/td>Accounting<\/span><\/td>This report displays the ‘Balance’ in each income account (ex: Fees Account, Charges Account) as well as the net balance for a specific office and time period.<\/span><\/td>Office, Start Date, End Date, Output type<\/span><\/td><\/tr>
    Loans Awaiting Disbursal<\/span><\/td>Loan<\/span><\/td>It displays a list of all the clients and a summary of their loans that are approved but not yet disbursed.<\/span><\/td>Office, Currency, Loan Purpose, Loan Officer, Fund, Product<\/span><\/td><\/tr>
    Loans Awaiting Disbursal Summary by Month<\/span><\/td>Loan<\/span><\/td>It displays a list of loan products that are due to be disbursed each month. It also displays the Principal Amount to be Disbursed.<\/span><\/td>Office, Loan Purpose, Fund, Currency, Loan Officer, Product<\/span><\/td><\/tr>
    Loans Pending Approval<\/span><\/td>Loan<\/span><\/td>It displays a\u00a0 list of clients and details of their loan accounts which are not yet approved.<\/span><\/td>Office, Currency, Loan Purpose,Loan Officer, Product\u00a0<\/span><\/td><\/tr>
    Obligation Met Loans Details<\/span><\/td>Loan<\/span><\/td>This report displays a list of loans with the details which are paid by the customers without any dues before the maturity date.<\/span><\/td>Obligation date type, Office, Currency, Fund, Loan Purpose, Loan Officer, Product, Start Date, End Date<\/span><\/td><\/tr>
    Obligation Met Loans Summary<\/span><\/td>Loan<\/span><\/td>This report displays a number of loans with their details (ex: total principal\/interest\/fees\/penalties repaid) which are paid by the customers without any dues before the maturity date.<\/span><\/td>Obligation date type, Office, Fund, Currency, Loan Purpose, Loan Officer, Product, Start Date, End Date<\/span><\/td><\/tr>
    Portfolio at Risk<\/span><\/td>Loan<\/span><\/td>

    This report shows portfolio at risk (in %) using the formula<\/span><\/p>

    Portfolio at Risk = Unpaid Principal balance of all loans with payment past due (by age,1,30, 60,90 days Etc) \/ Outstanding Portfolio.<\/span><\/p>

    It also shows Interest due, Fees due, Penalties, Fees Outstanding, etc.<\/span><\/p><\/td>

    		Office, Currency, Funds, Loan Purpose, PAR Calculation, Loan Officer, Product<\/span><\/td><\/tr>
    Portfolio at Risk by Branch<\/span><\/td>Loan<\/span><\/td>This is similar to the previous one but lists portfolios at risk by branch offices.<\/span><\/td>Office, Currency, Funds, Loan Purpose, PAR Calculation, Loan Officer, Product<\/span><\/td><\/tr>
    Rescheduled Loans<\/span><\/td>Loan<\/span><\/td>This report displays a list of all rescheduled loans, along with their details (such as the written-off date, the disbursed date, Rescheduled Principal\/Interest\/Fees, branch-by-branch).<\/span><\/td>Office, Currency, Product, Start Date, and End Date<\/span><\/td><\/tr>
    Trial Balance<\/span><\/td>Accounting<\/span><\/td>For a given office, and duration, this report displays a list of GL accounts with their debit and credit records.<\/span><\/td>Office, Start Date, End Date, Output type<\/span><\/td><\/tr>
    TxRunning Balances<\/span><\/td>Loan<\/span><\/td>This report displays a list of loan accounts and their transaction type(whether it’s in disbursement state or repayment state) Along with this, it shows Principal, Interest, Outstanding Principal, and Interest Income with specified currency and loan product.<\/span><\/td>\u00a0<\/span><\/td><\/tr>
    Written-Off Loans<\/span><\/td>Loan<\/span><\/td>It displays a list of all the loans which are written off at a given duration.<\/span><\/td>Office, Currency, Product, Start Date, End Date<\/span><\/td><\/tr>
    Credit Bureau Reports<\/span><\/td>Loan<\/span><\/td>This report will be useful to submit the data to all four credit bureaus in India.<\/span><\/td>\u00a0<\/td><\/tr><\/tbody><\/table><\/div>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
    \n\t\t\t\t\t\t
    \n\t\t\t\t\t
    \n\t\t\t
    \n\t\t\t\t\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\n\n\n