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. Other(Special) Allowances (Balance allowances) HRA (40% of the basic wage for nonmetro cities)Ĭonveyance Allowances ( 1600 Rs in urban areas) Step 5: In another column add deductions such as EPF, professional tax, ESI/health insurance, TDS, salary advances, etc…

Check out Salary of AAI Junior Executive at airport. Salary calculation formula for the total paid days = (Original gross salary/Total days in the month) X Paid days in that month. AAI Junior Executive In hand Salary - Latest Salary Slip, Work Profile Promotion & Benefits - YouTube. 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. It does not store any personal data.Download Excel How to Create a Salary Slip in Excel The cookie is set by the GDPR Cookie Consent plugin and is used to store whether or not user has consented to the use of cookies. The cookie is used to store the user consent for the cookies in the category 'Performance'. This cookie is set by GDPR Cookie Consent plugin. However, there isnt any particular guideline on what percentage this component of a salary slip should be. It is usually 30-50 of the total salary offered to an individual. The basic salary component in any salary pay slip is the total monthly take home. Basic Salary as mentioned on the salary pay slip. The cookie is used to store the user consent for the cookies in the category 'Other. Check the salary slip components below: 1. The cookies is used to store the user consent for the cookies in the category 'Necessary'. The cookie is set by GDPR cookie consent to record the user consent for the cookies in the category 'Functional'. The cookie is used to store the user consent for the cookies in the category 'Analytics'. These cookies ensure basic functionalities and security features of the website, anonymously. Necessary cookies are absolutely essential for the website to function properly.

Aai employees salary slip