The "Loan Statement" feature in HRMex Time and Attendance software, accessible from the "Loan and Advance" menu, is a powerful tool for viewing complete loan statements of employees. This feature allows users to select the transaction month, apply filters based on loan type, category, company division, and then view detailed loan statements. Additionally, the data can be easily exported to an Excel spreadsheet for further analysis.
Accessing the Loan Statement
- Log in: Begin by logging into the HRMex Time and Attendance software using your credentials.
- Navigate to Loan and Advance Menu: In the main menu, click on the "Loan and Advance" menu option.
- Access the Loan Statement: Within the Loan and Advance menu, locate and select the "Loan Statement" option. This opens the Loan Statement interface.
Viewing Employee Loan Statements
The Loan Statement interface provides the tools necessary for viewing employee loan statements. Here's how to use this feature:
Select the Transaction Month: Start by choosing the specific month for which you want to view employee loan statements.
Apply Filters: If needed, you can filter the list of loan statements based on loan type, category, company, and division. This allows you to focus on specific groups of loan statements.
Click "Show": After selecting the transaction month and applying filters, click the "Show" button to display the loan statements. The statements will include employee names, codes, loan types, balances, installments, and other relevant information.
Exporting Data
To export the displayed data to an Excel spreadsheet for further analysis:
- Click "Excel Export": Use the "Excel Export" button to export all the presented loan statement data into an Excel spreadsheet. This facilitates additional analysis and reporting.
Benefits of Loan Statement
- Efficiency: Quickly access and review detailed loan statements for a specific month and specific groups of employees.
- Customization: Apply filters to focus on specific groups of loan statements.
- Data Export: Export loan statement data for further analysis and reporting.
The "Loan Statement" feature in HRMex Time and Attendance software streamlines the process of viewing and exporting employee loan statements, enhancing your ability to manage and analyze loan data efficiently.