Loan & Leave Reports
Loan & Leave Reports - User Guide
1. Introduction 👥
The Loan & Leave Reports module bridge the gap between financial accounting and HR administration. It ensures that any financial assistance provided to employees is recovered accurately and that leave entitlements are managed according to labor laws and company policy. These reports are critical for ensuring payroll accuracy and maintaining employee financial records.
ℹ️
Purpose of this Report:
- Loan Recovery Tracking: Monitor the repayment of employee advances via monthly payroll installments.
- Leave Audit: Review how employees are utilizing their leave buckets (PL, CL, SL).
- Financial Risk Management: Identify large outstanding loan balances for employees nearing retirement or resignation.
- Encashment Planning: Track leave encashment payouts for tax and accounting purposes.
This report is essential for HR Managers, Payroll Executives, and Finance Heads.
2. Report Modules 🚀
A. Loan Analysis Report
Tracks the “Closing Balance” of every employee loan through its monthly lifecycle:
- Opening: The debt brought forward from the previous month.
- Disbursed: Any new loans or advances approved in the current month.
- Recovered: Installments automatically deducted from the month’s salary.
- Pre-Payment: Extra manual payments made by the employee outside of payroll.
- Write-Off: Loans cleared by the company due to specific policy decisions.
B. Leave Utilization Report
A detailed log of all leave applications processed within the selected pay cycle:
- Used Leaves: Standard leaves taken (Sick, Casual, etc.).
- Credited Leaves: New leave points earned based on service tenure.
- Encashment: Leave days converted into cash payments.
- Without Pay (LWP): Leave days that resulted in a salary deduction.
3. Key Analysis Features 🛠️
- Finalized Month Control: To ensure reporting integrity, these reports can only be printed for months where the payroll has been “Marked as Final.” This prevents data mismatches during the draft payroll stage.
- Employee Type Filtering: Run separate reports for Staff, Workers, or Contractors to match your departmental reporting structure.
- Pending Loans Only: A specific filter that hides employees who have fully repaid their debts, focusing your attention only on active recoveries.
4. Understanding Data Columns 📊
- Installment Amount: The fixed monthly amount agreed upon during the loan approval.
- Loan No: The unique tracking ID for each specific loan (enabling one employee to have multiple loans concurrently).
- Pay Date: The specific salary disbursement date the entry is linked to.
- Category & Dept: Groups employees by their department or skill category for better organizational oversight.
5. Source Transactions 🔄
The reporting engine synthesizes data from:
- Loan Modules (Loan/Loan1): Captures the primary loan contract and the repayment ledger.
- Leave Master (LeaveMst): The central repository for all leave applications and manual balance adjustments.
- Payroll Finalization (PayDatesMst): The authority record that “Locks” the month’s data.
- Employee Master: Source for HR details like designation, category, and department.
6. Best Practices / Tips 💡
- Pre-Resignation Audit: Before an employee is relieved, always run the Loan Report for that specific individual to ensure no “Closing Balance” remains.
- Installment Verification: If the “Recovered” amount in a month is less than the “Installment Amount,” check the employee’s attendance—they may have had excessive LWP, resulting in a partial recovery.
- Year-End Leave Planning: Run the Leave Report at the end of the financial year to plan for “Leave Encashment” budgets or to notify employees of expiring balances.
- Matching with Accounts: Periodically tally the “Grand Total” of closing loan balances in this report with the “Employee Advance” ledger in the General Ledger Report for 100% financial alignment.