Where can I view loan reports?

Loan Management Program Lesson 6: Reporting and Monitoring Where can I view loan reports?

Get full control of your loan portfolio.

1. Log in to the Wakandi Admin Panel.

Tanzania ADMIN LOGin
Uganda ADMIN LOGin
KEnya ADMIN LOGin

2. Go to the Reports menu and choose Loan.
3.  And choose the report you want. The following reports are available:

Active Loan Report

This report helps manage and track each loan’s performance, ensure timely repayments, and maintain the overall financial health of the lending portfolio.

The Active Loan Report is a detailed financial report that provides comprehensive information about all active organisational loans. It includes data on loan accounts, client details, loan specifics, and each loan’s current status. This report is crucial for monitoring the status of ongoing loans, managing repayments, and identifying overdue accounts.

Contents
  1. Account Number: Unique identifier for each loan account.
  2. Client Name: Name of the borrower.
  3. Reference ID: Internal reference number for tracking purposes.
  4. Loan Product: Type or name of the loan product.
  5. Member Type: Category of the borrower (e.g., individual or business).
  6. Gender: Gender of the borrower.
  7. Age: Age of the borrower.
  8. Branch: The branch where the loan was issued.
  9. Loan Officer: Name of the officer responsible for the loan.
  10. Tenure Type: Type of loan tenure (e.g., months, days).
  11. Tenure: Duration of the loan.
  12. Creation Date: The date when the loan was created.
  13. Disbursement Date: Date when the loan amount was disbursed to the borrower.
  14. Expiry Date: The date when the loan term ends.
  15. Total Principal: Total principal amount of the loan.
  16. Total Interest: Total interest amount to be paid over the loan term.
  17. Due Date: The date when the next payment is due.
  18. Outstanding Charges: Any additional outstanding charges.
  19. Outstanding Principal: The remaining principal amount has yet to be repaid.
  20. Outstanding Interest: The remaining interest amount has yet to be repaid.
  21. Original Disbursed Amount: The original amount disbursed at the start of the loan.
  22. Overdue Days: Number of days the payment is overdue.

Loan Aging Report

This report helps monitor the ageing of loan receivables, allowing financial managers to take appropriate actions to mitigate risks associated with overdue payments.

The Loan Aging Report is a financial report that categorizes and tracks the status of outstanding loans based on their age and payment status. It provides detailed information on each loan, including borrower details, loan terms, disbursement and expiry dates, and amounts due. This report is crucial for identifying overdue loans, assessing the risk of default, and managing the overall health of the loan portfolio by highlighting how long payments have been outstanding.

Contents
  1. Member Name: Name of the borrower.
  2. Account Number: Unique identifier for each loan account.
  3. Member Type: Category of the borrower (e.g., individual or business).
  4. Creation Date: The date when the loan was created.
  5. Disbursement Date: Date when the loan amount was disbursed to the borrower.
  6. Expiry Date: The date when the loan term ends.
  7. Gender: Gender of the borrower.
  8. Age: Age of the borrower.
  9. Branch: The branch where the loan was issued.
  10. Loan Officer: Name of the officer responsible for the loan.
  11. Tenure Type (e.g., months, days).
  12. Tenure: Duration of the loan.
  13. Overdue Days: Number of days the payment is overdue.
  14. Total Loan Disbursed Principal Amount: The original principal amount disbursed at the start of the loan.
  15. Total Outstanding Amount: Total remaining amount that has yet to be repaid.
  16. Total Installment Amount Due: The amount due for the current instalment period.
  17. Repayment Installment Paid: The amount that has been paid for the instalment.
  18. 0-30: Amount overdue for 0 to 30 days.
  19. 31.90: Amount overdue for 31 to 90 days.
  20. 91-180: Amount overdue for 91 to 180 days.
  21. 181-365: Amount overdue for 181 to 365 days.
  22. More than 365: Amount overdue for more than 365 days.
  23. Total: Total amount overdue across all periods.

Loan Repayment Report

The Loan Repayment Report is essential for maintaining the integrity of the loan management process, ensuring accurate accounting, and supporting strategic decision-making related to lending operations.

The Loan Repayment Report is a financial report that details all repayments made towards loans within a specific period. It includes the repayment date, transaction details, borrower information, loan specifics, and amounts repaid. This report is essential for tracking loan repayments, managing collections, and accurately accounting loan-related transactions.

Contents
  1. Repayment Date: Date when the repayment was made.
  2. Transaction Number: Unique identifier for the repayment transaction.
  3. Account Number: Unique identifier for the loan account.
  4. Client Name: Name of the borrower.
  5. Branch: The branch where the loan was issued.
  6. Loan Product: Type or name of the loan product.
  7. Loan Officer: Name of the officer responsible for the loan.
  8. Payment Method: Method used for repayment (e.g., cash, bank transfer).
  9. Member Type: Category of the borrower (e.g., individual or business).
  10. Tenure Type: Type of loan tenure (e.g., weeks, months).
  11. Tenure: Duration of the loan.
  12. Principle: Amount of principal repaid.
  13. Interest: Amount of interest repaid.
  14. Charges: Any additional charges repaid.
  15. Total Amount Repaid: Total repaid, including principal, interest, and charges.

Loan Disbursement Report

The Loan Disbursement Report is essential for ensuring the accuracy and integrity of the loan disbursement process, supporting financial management, and aiding in compliance and strategic planning.

The Loan Disbursement Report is a financial report that provides details about the disbursement of loans to borrowers within a specific period. It includes the disbursement date, transaction details, borrower information, loan specifics, and amounts disbursed. This report is crucial for tracking loan issuance, ensuring proper fund allocation, and managing the disbursement process efficiently.

Contents
  1. Disbursement Date: Date when the loan amount was disbursed.
  2. Transaction Number: Unique identifier for the disbursement transaction.
  3. Account Number: Unique identifier for the loan account.
  4. Client Name: Name of the borrower.
  5. Branch: The branch where the loan was issued.
  6. Loan Product: Type or name of the loan product.
  7. Loan Officer: Name of the officer responsible for the loan.
  8. Member Type: Category of the borrower (e.g., individual or business).
  9. Tenure Type: Type of loan tenure (e.g., days, months).
  10. Tenure: Duration of the loan.
  11. Loan Amount: Total principal amount of the loan.
  12. Charge: Any additional charges associated with the loan disbursement.
  13. Disbursement Amount: The amount is disbursed to the borrower after deducting any charges.

Loan Outstanding Report

This report helps track each loan’s repayment status, identify overdue payments, and manage the overall loan portfolio effectively.

The Loan Outstanding Report is a financial report that provides detailed information about the current status of all loans that have been disbursed but not yet fully repaid. It includes data on the original loan amount, repayments made, and the outstanding balances. This report is essential for monitoring the remaining obligations of borrowers, managing loan portfolios, and assessing the financial health of the lending institution.

Contents
  1. Loan Number: Unique identifier for each loan.
  2. Account Number: Unique identifier for the loan account.
  3. Client Name: Name of the borrower.
  4. Branch: The branch where the loan was issued.
  5. Tenure Type: Type of loan tenure (e.g., days, months).
  6. Tenure: Duration of the loan.
  7. Loan Officer: Name of the officer responsible for the loan.
  8. Loan Product: Type or name of the loan product.
  9. Member Type: Category of the borrower (e.g., individual or business).
  10. Principal Amount: Original principal amount of the loan.
  11. Interest Amount: Total interest amount to be paid over the loan term.
  12. Charges: Any additional charges associated with the loan.
  13. Repaid Principal: Amount of principal that has been repaid.
  14. Repaid Interest: Amount of interest that has been repaid.
  15. Repaid Charges: Amount of additional charges that have been refunded.
  16. Outstanding Principal: The remaining principal amount has yet to be repaid.
  17. Outstanding Interest: The remaining interest amount has yet to be repaid.
  18. Total Outstanding: Total remaining amount that has yet to be repaid, including principal, interest, and charges.
  19. Outstanding Charges: Additional charges remain that have yet to be repaid.

All Loan Report

This report helps maintain a complete and up-to-date record of all loans, ensures accurate tracking and management of the lending portfolio, and provides essential financial analysis and reporting data.

The All Loan Report is a comprehensive financial report that provides detailed information on all loans within the lending portfolio, regardless of their status. It includes data on borrower details, loan specifics, and key dates. This report is essential for a complete overview of all loans, facilitating the management, analysis, and tracking of the loan portfolio.

Contents
  1. Account Number: Unique identifier for each loan account.
  2. Client Name: Name of the borrower.
  3. Loan Product: Type or name of the loan product.
  4. Member Type: Category of the borrower (e.g., individual or business).
  5. Gender: Gender of the borrower.
  6. Age: Age of the borrower.
  7. Branch: The branch where the loan was issued.
  8. Loan Officer: Name of the officer responsible for the loan.
  9. Tenure Type: Type of loan tenure (e.g., days, months).
  10. Tenure: Duration of the loan.
  11. Loan Status: Current loan status (e.g., disbursed, new).
  12. Creation Date: The date when the loan was created.
  13. Disbursement Date: Date when the loan amount was disbursed to the borrower.
  14. Expiry Date: The date when the loan term ends.
  15. Total Principal: Total principal amount of the loan.
  16. Total Interest: Total interest amount to be paid over the loan term.

Expected Repayment Report

This report helps track upcoming repayments, manage borrower accounts, ensure accurate and timely collections, and support financial planning and forecasting.

The Expected Repayment Report is a financial report that provides details on the expected repayments for outstanding loans. It includes the borrower’s details, loan specifics, due dates, and the amounts owing for principal, interest, and penalties. This report is crucial for managing and forecasting cash flow, ensuring timely collections, and identifying potential loan repayment issues.

Contents
  1. Account Number: Unique identifier for each loan account.
  2. Client Name: Name of the borrower.
  3. Phone Number: Contact number of the borrower.
  4. Branch: The branch where the loan was issued.
  5. Due Date: The date when the following repayment is due.
  6. Principal Balance: The remaining principal amount of the loan.
  7. Principal Due: The principal amount that is due for the next repayment.
  8. Interest Due: The interest amount that is due for the next repayment.
  9. Penalty Due: Any penalty amount that is due.
  10. Total Due: Total amount due, including principal, interest, and penalties.

Loan Arrears Report

This report helps identify overdue loans, monitor the ageing of arrears, and take appropriate actions to mitigate the risks associated with loan defaults.’

The Loan Arrears Report is a financial report detailing all overdue loans that are not fully paid as per the agreed terms. It includes information such as the borrower’s details, loan specifics, amounts overdue, and the duration of the overdue period. This report is crucial for managing overdue loans, assessing the risk of default, and taking necessary actions to recover overdue amounts.

Contents
  1. Account Number: Unique identifier for each loan account.
  2. Client Name: Name of the borrower.
  3. Phone Number: Contact number of the borrower.
  4. Branch: The branch where the loan was issued.
  5. Loan Disbursement Date: Date when the loan amount was disbursed to the borrower.
  6. Loan Expire Date: Date when the loan term ends.
  7. Loan Amount: Total principal amount of the loan.
  8. Outstanding Principal: The remaining principal amount has yet to be repaid.
  9. Principal In Arrears: Amount of principal that is overdue.
  10. Interest In Arrears: Amount of interest that is overdue.
  11. Penalty In Arrears: Amount of overdue fines.
  12. Total In Arrears: Total amount overdue, including principal, interest, and penalties.
  13. Principal In Arrears Percentage: Percentage of the principal that is in arrears.
  14. Overdue Days: Number of days the payment is overdue.

Portfolio At Risk (PAR) Report

This report helps identify and manage loans at risk of default, enabling financial institutions to take timely actions to recover overdue amounts and reduce credit risk.

The Portfolio At Risk (PAR) Report is a financial report that provides detailed information on loans that are at risk of default. It includes data on borrower details, loan specifics, outstanding amounts, and arrears. This report is essential for assessing the credit risk of the loan portfolio, monitoring the health of outstanding loans, and taking proactive measures to mitigate potential losses.

Contents
  1. Account Number: Unique identifier for each loan account.
  2. Client Name: Name of the borrower.
  3. Branch: The branch where the loan was issued.
  4. Repayment Date: Date of the last repayment made.
  5. Loan Officer: Name of the officer responsible for the loan.
  6. Loan Amount: Total principal amount of the loan.
  7. Outstanding Principal: The remaining principal amount has yet to be repaid.
  8. Portfolio At Risk: Amount of the loan at risk of default.
  9. Principal In Arrears: Amount of principal that is overdue.
  10. Interest In Arrears: Amount of interest that is overdue.
  11. Total Arrears: Total amount overdue, including principal, interest, and penalties.
  12. Arrears Rate: The rate at which the loan is in arrears.
  13. Risk Percentage: The percentage of the loan portfolio that is at risk.
  14. Last Repayment Amount: The amount of the previous repayment made by the borrower.

Accrued Interest Report

This report helps track accrued interest on loans, manage interest income, and accurately record and report all interest liabilities.

The Accrued Interest Report is a financial report that provides detailed information about the interest accumulated but not yet paid on outstanding loans. It includes data on borrower details, loan specifics, interest amounts, and repayment information. This report is essential for understanding the interest liability of borrowers, managing interest income, and ensuring accurate financial reporting.

Contents
  1. Loan Number: Unique identifier for each loan.
  2. Account Number: Unique identifier for the loan account.
  3. Client Name: Name of the borrower.
  4. Branch: The branch where the loan was issued.
  5. Tenure Type: Type of loan tenure (e.g., days, months).
  6. Tenure: Duration of the loan.
  7. Loan Officer: Name of the officer responsible for the loan.
  8. Loan Product: Type or name of the loan product.
  9. Member Type: Category of the borrower (e.g., individual or business).
  10. Principal Amount: Original principal amount of the loan.
  11. Interest Amount: Total interest amount to be paid over the loan term.
  12. Charges: Any additional charges associated with the loan.
  13. Total Repaid Principal: Amount of principal that has been repaid.
  14. Total Repaid Interest: Amount of interest that has been repaid.
  15. Accrued Interest: Interest that has been accumulated but not yet paid.
  16. Outstanding Accrued Interest: Accrued interest that is still outstanding.
  17. Total Outstanding Principal: The remaining principal amount has yet to be repaid.
  18. Total Outstanding Interest Amount: The remaining interest amount has yet to be repaid.
  19. Total Outstanding Charges: Additional charges remain that have yet to be repaid.

Deferred Interest Report

This report helps track deferred interest on loans, manage deferred interest income, and ensure that all deferred interest liabilities are accurately recorded and reported.

The Deferred Interest Report is a financial report that provides detailed information about the interest deferred on outstanding loans. It includes data on borrower details, loan specifics, interest amounts, and repayment information. This report is essential for understanding borrowers’ deferred interest liability, managing deferred interest income, and ensuring accurate financial reporting.

Contents
  1. Loan Number: Unique identifier for each loan.
  2. Account Number: Unique identifier for the loan account.
  3. Client Name: Name of the borrower.
  4. Branch: The branch where the loan was issued.
  5. Tenure Type: Type of loan tenure (e.g., days, months).
  6. Tenure: Duration of the loan.
  7. Loan Officer: Name of the officer responsible for the loan.
  8. Loan Product: Type or name of the loan product.
  9. Member Type: Category of the borrower (e.g., individual or business).
  10. Principal Amount: Original principal amount of the loan.
  11. Interest Amount: Total interest amount to be paid over the loan term.
  12. Charges: Any additional charges associated with the loan.
  13. Total Repaid Principal: Amount of principal that has been repaid.
  14. Total Repaid Interest: Amount of interest that has been repaid.
  15. Accrued Interest: Interest that has been accumulated but not yet paid.
  16. Outstanding Accrued Interest: Accrued interest that is still outstanding.
  17. Deferred Interest: Interest that has been deferred and is not yet due.
  18. Total Outstanding Principal: The remaining principal amount has yet to be repaid.
  19. Total Outstanding Interest Amount: The remaining interest amount has yet to be repaid.
  20. Total Outstanding Charges: The remaining additional charges have yet to be repaid.

Expected Loan Repayments Report

This report helps track the expected repayments for each loan, ensure accurate and timely collections, manage borrower accounts, and support financial planning and forecasting.

The Expected Loan Repayments Report is a financial report that provides detailed information about the expected repayments for outstanding loans. It includes data on borrower details, loan specifics, expected repayment amounts, and due dates. This report is essential for managing and forecasting cash flow, ensuring timely collections, and identifying potential loan repayment issues.

Contents
  1. Loan Number: Unique identifier for each loan.
  2. Account Number: Unique identifier for the loan account.
  3. Client Name: Name of the borrower.
  4. Tenure Type: Type of loan tenure (e.g., days, months).
  5. Tenure: Duration of the loan.
  6. Branch: The branch where the loan was issued.
  7. Loan Officer: Name of the officer responsible for the loan.
  8. Loan Product: Type or name of the loan product.
  9. Member Type: Category of the borrower (e.g., individual or business).
  10. Principal Amount: Original principal amount of the loan.
  11. Interest Amount: Total interest amount to be paid over the loan term.
  12. Charges: Any additional charges associated with the loan.
  13. Total Expected Principal: Total principal amount expected to be repaid.
  14. Total Expected Accrued Interest: Total interest amount expected to be repaid.
  15. Total Repayment Amount: Total amount expected to be repaid, including principal, interest, and charges.

Fee Status Report

This report helps track the status of fee payments, manage outstanding fees, ensure timely collections, and provide insights into borrowers’ payment behaviour.

The Fee Status Report is a financial report that provides detailed information about the fees charged to borrowers, their payment status, and any outstanding amounts. It includes data on borrower details, fee specifics, due dates, payment status, and overdue days. This report is essential for tracking the collection of fees, managing outstanding fee balances, and ensuring timely payments.

Contents
  1. Member Name: Name of the borrower.
  2. Branch: Branch where the fee was charged.
  3. Charge Type: Type of fee charged.
  4. Amount: Total amount of the fee charged.
  5. Outstanding Fee: Amount of the fee that is still outstanding.
  6. Status: Current payment status of the fee (e.g., Paid, Due).
  7. Due Date: The date when the fee payment is due.
  8. Payment Date: The date when the fee was paid.
  9. Overdue Days: Number of days the fee payment is overdue.

Paid Off Loans Report

This report helps track fully repaid loans, ensure accurate financial records, and provide insights into borrowers’ repayment histories.

The Paid Off Loans Report is a financial report that provides detailed information about fully repaid loans. It includes data on borrower details, loan specifics, repayment amounts, and the dates on which the loans were paid off. This report is essential for maintaining accurate records of fully repaid loans, managing the loan portfolio, and ensuring that borrowers have met all financial obligations.

Contents
  1. Account Number: Unique identifier for each loan account.
  2. Name: Name of the borrower.
  3. Refno: Reference number for the loan.
  4. Branch: The branch where the loan was issued.
  5. Loan Officer: Name of the officer responsible for the loan.
  6. Loan Amount: Total principal amount of the loan.
  7. Total Interest: Total interest amount to be paid over the loan term.
  8. Paid Off Date: The date when the loan was fully repaid.
  9. Loan Disbursement Date: Date when the loan amount was disbursed to the borrower.
  10. Expiry Date: The date when the loan term ended.
  11. Principal Amount Paid: Total principal amount that has been repaid.
  12. Interest Amount Paid: Total interest amount that has been repaid.
  13. Total Paid: Total amount repaid, including principal and interest.

Loan Insurance Report

This report helps track the insurance coverage for each loan, ensure that all loans are adequately insured, and manage the financial aspects of loan-related insurance premiums.

The Loan Insurance Report is a financial report that provides detailed information about the insurance associated with loans. It includes data on borrower details, loan specifics, insurance premiums, and the insurance service provider. This report is essential for managing loan insurance coverage, ensuring that loans are adequately insured, and tracking the cost of insurance premiums.

Contents
  1. Disbursement Date: Date when the loan amount was disbursed.
  2. Member Name: Name of the borrower.
  3. Reference Id: Internal reference number for tracking purposes.
  4. Loan Product: Type or name of the loan product.
  5. Branch: The branch where the loan was issued.
  6. Loan Amount: Total principal amount of the loan.
  7. Tenure Type: Type of loan tenure (e.g., days, months).
  8. Tenure: Duration of the loan.
  9. Insurance Premium: The cost of the insurance premium for the loan.
  10. Service Provider: The insurance company providing the coverage.

Previous Lesson
Back to Lesson
Next Topic