This document outlines the process to be followed in generating the necessary input reports for your monthly Payroll processing.
In this writeup, we will cover everything you need to know about preparing various inputs needed to process your monthly payroll within hrEntries.
For a typical monthly PayRun Process, the following set of inputs are required:
In hrEntries, all these inputs are provided as summary reports. Sections below describe how to prepare these inputs for processing.
There are two ways of providing these inputs:
a. In bulk through excel import (Settings -> Load Employees)
b. Individually through the UI (Employees -> New Employee)
In each case, certain fields are mandatorily required as listed below. For bulk uploads using excel, please download the latest version of the template from the application itself. The template is available for download on the same page as the upload functionality (please refer the image below).
In addition to the mandatory fields listed below, additional data elements (such as bank account details, unified account number/Aadhaar/PAN etc.) can also be provided through the excel file or through the UI. In case additional fields are missing while the new employee data is being created, the employee records can be incrementally updated with various data elements as and when they become available.
You can also use the bulk upload facility, to incrementally update various attributes on the Employee Masters. For example, if you wish to update the relieving dates/last working dates for all exiting employees in bulk every month, you can do the same by providing the following fields for such employees in the template excel file:
Attendance details required for payroll processing are primarily the number of days of loss of pay for various employees during the relevant pay period. The Loss of Pay (LOP) data will be inferred based on the leave transactions recorded in the system.
For processing your monthly payroll, you need to provide an Attendance Summary Report as input (incase you have any loss of pay for any of the employees). There are two ways of preparing this input Attendance Summary Report needed for payroll processing as listed below:
1. Creating an Attendance Summary Report through the UI with Manual LOP inputs: A new Attendance Summary Report can be created for the specified period and Loss of Pay (LOP) details can be specified for relevant employees in the report. This a manual process of specifying only the Loss of Pay (LOP) details for relevant employees for the concerned month. This can be done from: PAYRUN -> ATTENDANCE SUMMARY -> NEW SUMMARY REPORT
2. Generate Attendance Summary Report which will determine the LOP data based on leave transactions available in the system. If you have enabled Leave management capability, these transactions are automatically generated when Leaves are applied for by employees and the same get approved by the respective approving managers. This can be done from: PAYRUN->ATTENDANCE SUMMARY->GENERATE SUMMARY REPORT
In case, you have not enabled Leave management within hrEntries, there is another way to import processed leave summary data using the timesheets import template provided. You can fill in all the relevant leave summary details for all employees in the organization along with their respective time sheet specific inputs and import the same in bulk. This will automatically generate all the necessary leave transactions. Once the leave transactions are generated, you can go ahead and generate the Attendance Summary Report as specified above.
TimeSheet data using the provided template can be imported from:
SETTINGS -> LOAD TIMESHEETS
The required template file for TimeSheets is available on the same upload page as well.
This set of inputs comprise all changes that need to be considered while executing payrun outside of the pre-defined salary structures. For example, items like one off bonus, one off deductions, business expense reimbursements etc. are ideally loaded through Adhoc adjustments. There are two ways of generating Adhoc Adjustments summary report needed for payroll processing:
1. Creating an Adjustments Summary Report through the UI: In this approach, you will be creating a new Adjustment Summary Report and specifying the required adjustments by various payheads for the relevant employees. This approach is suitable if the number of such adjustments are limited. In case you have a large number of such adjustment transactions across many employees in the organization, an easier approach is to upload the adjustments data in bulk using the provided template. A new Adjustments Summary Report can be created from:
PAYRUN->ADHOC ADJUSTMENTS->NEW ADJUSTMENT
2. You can import the adjustments data in bulk from:
PAYRUN->ADHOC ADJUSTMENTS->IMPORT ADJUSTMENTS
Any arrears to be processed from previous periods can be specified through the Arrears Summary Report. The arrears inputs are specified in terms of days of pay for a specified period. Arrears are computed on different basis as listed below. You can choose the relevant calculation basis as is applicable in your case:
The arrear inputs can be specified in two ways, either manually or via bulk import using the provided template. A new Arrears Summary Report can be created manually from: PAYRUN -> ARREARS SUMMARY -> NEW SUMMARY REPORT.
You can import the arrears data in bulk from: PAYRUN -> ARREARS SUMMARY -> IMPORT ARREARS
In case there are any loans or advances that have been given to employees and the same needs to be recovered from the monthly payroll, such inputs can be specified using the Loan Settlements Summary Reports.
When the loans or advances issued to employees get recorded, the system will automatically generate the listing of all monthly deductions for the entire loan tenure. The monthly recoverable amount will be computed based on the interest and tenure specified. As part of the monthly Payroll process, in case there are loan related settlements to be taken into consideration within the payroll, you can generate the Loan Settlement Reports. The system will automatically determine the deductibles for the relevant employees and include the same in the Loan Settlement Report. You can override these numbers in case required for whatever reasons as required by modifying the Loan Settlement Report. Once the Loan Settlement Report has been finalized, you can use the same as part of your Payroll process.
A new Loans Settlements Summary Report can be created from: PAYRUN -> LOAN SETTLEMENTS -> NEW SETTLEMENT REPORT.
Incentives are applicable for employees who have part of their compensation tied to performance and target attainments. For example, sales teams usually have a part of their compensation tied to the sales revenues attained. Similarly, in case of manufacturing companies, a part of the compensation might be tied to production targets.
As part of preparing inputs for the monthly payroll process, you can create a new Incentives Summary Report from: PAYRUN -> INCENTIVES SUMMARY -> NEW SUMMARY REPORT.
Inputs needed for this report are the employee specific target and attainment numbers. These inputs can be either revenue attainments or the units produced/manufactured/sold. Based on the incentive plans defined and how the various employees have been mapped to various incentive plans, depending on the target/attainment inputs provided, the system will automatically compute the payouts that the employees are eligible for. The Incentives Summary Report will be used as part of the periodic payroll process.
Variable Pay is applicable for organizations that follow a practice of withholding a portion of the employee’s salary under any Payhead(s) and pay out the same on a periodic basis. The quantum of the payout may be based on multiple parameters such as overall performance of the organization, department, division and the individual concerned. Typically, in such organizations, the compensation structure agreed with the employees will have one or more payheads which are classified as Variable Pay and the corresponding payheads need to be classified as Withholding payheads in the system.
If your organization follows such a philosophy of including variable pay as part of the salary structure, you will need to use the Variable Payouts Summary Report for the months when you will make the actual payouts under Variable Pay for your employees. For other periods, i.e. pay periods when Variable Payout is not done, you need not specify any inputs under Variable Pay Section for your monthly PayRun processing.
You can generate new Variable Payout Summary Report from: PAYRUN -> VARIABLE PAYOUTS -> GENERATE SUMMARY REPORT.
Once the Variable Payout Summary report is generated, you will be able to allocate payouts based on your specific criteria. After all the allocations are completed, the Variable Payout Summary report is now ready to be used as part of your Payroll process.
The image below, the organization had withheld earnings under the Payhead Bonus, for the period from July to Sept 2019. The same was to be paid out during the month of October 2019, with appropriate allocations (in this case 100%).
Leave encashments are done typically at the end of the financial year, in the month of March, for employees who in continued employment with the organization. On the other hand, leave encashments are also done on a periodic basis for employees who have already exited the organization as part their Full & Final Settlements. In both the cases, the essential inputs here are the number of days of leave that are encashable for each of the employees for the given Financial Year. The number of days of leave to be encashed depends on the leave policies of the organization.
Once you have the leave tracking enabled in hrEntries, it is a breeze to generate the leave encashment reports at any point in time. As all leave transactions are already recorded in the system, you can create a new Leave Encashment Report in one of two ways listed below: