Useful Salary Slip Formulas 1īasic wage + HRA + Conveyance + Medical + Special allowancesĠ.75% of employee gross wage. Step 7: Now take out the printout of the salary slip and sign it and distribute to employees. Step 6: Now subtract all the deductions from the earned gross salary of the employee in that particular month, the balance amount will be the net salary of the employee. Mostly, several salary components are calculated as the percentage of your basic pay. The basic salary is an important part of your pay slip format as it comprises 35 to 50 of your salary. Basic Salary mentioned in simple salary slip format. Other(Special) Allowances (Balance allowances) Find the components of a salary slip template described in detail below: 1. Press F11 (Company Feature) > Accounting Features (F1) > Set both given options Yes Maintain Payroll >Yes More than one Payroll / Cost Category > Yes Now Save the information. HRA (40% of the basic wage for nonmetro cities)Ĭonveyance Allowances ( 1600 Rs in urban areas) Easily Prepare Pay slip and Payroll report in Tally. Step 5: In another column add deductions such as EPF, professional tax, ESI/health insurance, TDS, and 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 total days in the month. Step 3: Now enter the number of days in the month, and LOPs (Loss of Paydays) of the employee. Step 2: Now enter employee general details like name, designation, department, date of joining, gross salary, bank details, and any other required information as per your choice. Step 3: Choose the first option to print the payslips. How can I make salary slip Step 1: Select a Salary Period. It means, no salary will be paid for a particular day.
8868 GROSS SALARY 44340 PF NoESI No. What is lop in salary slip What is LOP (Loss of Pay) Loss of pay is done when an employee does not come to work and apply for leave. 5 How does HR verify salary slip 6 Can I print my own payslips 7 What is lop in salary slip 8 What do employers need to know about payslips 9 When did the new payslip law come into effect 10 Can a freelancer get a payslip from a contractor 11 What makes an offer to purchase a legally binding contract 12 When do you need a payslip from a.
Received Pay slip cumTime card for the Month of May 2012 Emp Code EmpNoEmployee Name EmployeeNameF / H Name FathersNameHusbandsName Designation Designation Department Department Doj DOJ FIXED SALARYBasic+DA 26604HRA 8868 Con. 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. Please find attached payslip in word format.
Download Excel Format How to Create a Salary Slip in Excel