Loan Outstanding Summary
The Loan Outstanding Summary report provides an employee-wise overview of active loans and their repayment status. It helps you track loan amounts, instalments, outstanding principal, and perquisite details for accurate payroll processing and compliance.
Access Loan Outstanding Summary
To access the Loan Outstanding Summary report:
- Go to Reports on the left sidebar.
- Under Report Category, click Loan Reports and select Loan Outstanding Summary.
INSIGHT: You can also search for Loan Outstanding Summary using the search bar at the top and navigate directly to the report.
The loan outstanding details for employees will be displayed in a tabular format.
Components of Loan Outstanding Summary
The following table explains the components displayed in the Loan Outstanding Summary report:
| Component | Description |
|---|---|
| Employee ID | Unique identifier assigned to the employee. |
| Employee Name | Name of the employee for whom the loan is issued. |
| Loan Number | System-generated reference number for the loan. |
| Loan Name | Name or type of the loan (for example, Salary Advance or Housing Loan). |
| Loan Amount | Total amount sanctioned for the loan. |
| Instalment Amount | Fixed amount deducted per instalment for loan repayment. |
| Principal Paid | Total principal amount repaid till date. |
| Paid in Period | Loan amount deducted and paid during the selected period. |
| Principal Balance | Outstanding principal amount yet to be repaid. |
| Instalment(s) Remaining | Number of instalments pending for loan closure. |
| Perquisite Rate | Interest rate used to calculate the perquisite value, if applicable. |
| Perquisite Amount | Taxable perquisite amount calculated on the loan for the selected period. |
| Disbursement Date | Date on which the loan amount was disbursed to the employee. |
| Start Date | Date from which loan repayment begins. |
| End Date | Expected date of loan completion based on instalments. |
Export Loan Outstanding Summary
To export the report:
- Go to Reports.
- Under Report Category, click Loan Reports and select Loan Outstanding Summary.
- Click Export as at the top right.
- Choose the required export format: 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.