Loan Overall Summary
The Loan Overall Summary report provides a comprehensive, employee-wise overview of all loans issued within a selected period. It consolidates key loan details such as loan status, repayment progress, outstanding balances, and applicable perquisite values, helping you monitor loan recovery and compliance efficiently.
Access Loan Overall Summary
To access the Loan Overall Summary report:
- Go to Reports on the left sidebar.
- Under Report Category, click Loan Reports and select Loan Overall Summary.
INSIGHT: You can also search for Loan Overall Summary using the search bar at the top and navigate directly to the report.
- Use the period selector at the top left to choose the period you want to analyze. You can choose from predefined periods such as This Month, This Quarter, or This Year, or select a Custom date range.
The loan details for the selected period will be displayed in a tabular format.
Components of Loan Overall Summary
The following table explains the components displayed in the Loan Overall Summary report:
| Component | Description |
|---|---|
| Employee ID | Unique identifier assigned to the employee. |
| Employee Name | Name of the employee to whom the loan is issued. |
| Loan Number | System-generated reference number for the loan. |
| Loan Name | Name or type of the loan issued to the employee. |
| Loan Amount | Total loan amount sanctioned to the employee. |
| Loan Reason | Purpose for which the loan was issued. |
| Perquisite Rate | Interest rate used to calculate the taxable loan perquisite, if applicable. |
| Loan Status | Current status of the loan (for example, Open or Closed). |
| Disbursement Date | Date on which the loan amount was disbursed to the employee. |
| EMI Deduction Start Date | Date from which EMI deductions begin in payroll. |
| Instalment Amount | Amount deducted as EMI in each payroll cycle. |
| Loan Tenure | Total duration of the loan in months. |
| Loan Closure Date | Date on which the loan was fully repaid or closed. |
| Total EMI Paid | Total amount recovered from the employee through EMI deductions so far. |
| Perquisite Amount | Total taxable perquisite amount calculated for the loan. |
| Remaining Tenure | Number of instalments yet to be deducted. |
| Remaining Amount | Outstanding loan balance yet to be recovered. |
Export Loan Overall Summary
To export the report:
- Go to Reports.
- Under Report Category, click Loan Reports and select Loan Overall Summary.
- Click Export as at the top right.
- Choose the required export format: PDF, CSV, XLS, or XLSX.
- To protect the exported file, enable Protect this file with a password and enter a password with at least six characters.
- Click Export.