Loan Reports & Analytics — Octal HR Help Center

Monitor your organisation's loan portfolio with a built-in KPI dashboard covering disbursed, outstanding, collected, and overdue amounts — plus a one-click Excel export of the full loan list.

Loan Reports Dashboard

The Loans → Reports screen gives a snapshot of your loan portfolio, with four headline KPIs plus supporting charts.

PKR 14.2M

Total Disbursed

PKR 8.6M

Outstanding

PKR 5.6M

Collected

PKR 210K

Overdue

Total Disbursed — principal across all active and disbursed loans.
Outstanding — current outstanding balance across active and disbursed loans.
Collected — principal recovered on settled loans.
Overdue — total amount of instalments currently in overdue status.

The dashboard also shows a monthly disbursement chart for the selected year and a breakdown of loans by repayment mode (EMI, bullet, manual), followed by the full loan list.

Opening the Reports

Go to Loans → Reports.

Filter by Year (for the disbursement chart) and by Status to narrow the loan list.

Review the KPI cards and charts, then scroll to the loan list for row-level detail.

Excel Export

Use the Export to Excel button on the Loans screen to download the full loan list as an .xlsx file. The export includes employee name and code, department, loan type and repayment mode, principal, total amount, outstanding balance, monthly EMI, total and paid instalments, status, disbursement date, and bullet date.

Tip: Excel is the single export format for loan data. Open the file in your spreadsheet tool to build pivot tables or share it with your finance team.