Step 5: In another column add deductions such as EPF, professional tax, ESI/health insurance, TDS, salary advances, etc… Salary calculation formula for the total paid days = (Original gross salary/Total days in the month) X Paid days in that month. The sum of all the earnings will be called the actual gross salary of the employee. Step 4: Now in one column add all the earnings of the employees such as basic wage, house rent allowances, conveyance allowances, medical allowances & special allowances. To calculate total paid days subtract LOPs from the total days in the month. Step 3: Now enter the number of days in the month and the LOPs (Loss of Paydays) of the employee. Step 2: Now enter the employee’s general details like name, designation, department, date of joining, gross salary, bank details, and any other required information as per your choice.

Step 1: To create a salary slip/pay slip open a new Excel sheet and write your company name, address, and payslip month & year in the first three rows of the Excel file.

Thank you for your ongoing interest in iEnergizer and your support.Download Excel How to Create a Salary Slip in Excel As we do, you have our commitment that we will be working to extend our performance in areas where results are already strong, while diligently addressing those aspects of our performance in which we see the greatest opportunities for improvement. We strive toward our vision of industry leadership and our company goals in the year ahead. Some of our major achievements over the past few years have been our ability to settle into the new work environment, update our web presence, stabilize and strengthen our existing client relationships, define and institutionalize operational processes, and start conversations with new prospective clients. While retaining our personnel is always our top priority, we also focus on attracting and hiring the best talent in the market as new opportunities unfold within the company. At iEnergizer, our people are our most important asset. To achieve this, we are always investing in our people, and improving our culture through various campaigns, initiatives, and activities. We recognize the importance of tactical and strategic initiatives that our clients entrust us with, and we ensure we take special care to meet and exceed their business objectives. iEnergizer is committed to delivering business process excellence by exceeding client expectations and meeting our commitments through business innovation and outstanding customer experience. Over the last few years, iEnergizer has undergone a noteworthy evolution as we have pursued our vision to become a world-class service provider.

Salary slip format uae