Salary Certificate is a Human Resource document to verify an employee’s employment, salary, pay grade, location, etc.

Microsoft Excel OpenOffice Calc Google Sheet What is Salary Certificate? You can manage employee salary data monthly and issue salary certificates with CTC and complete salary breakup with just a click of a button. A fully automated Salary Certificate Generator. To simplify your hassle, we have created a ready-to-use Salary Certificate Template with predefined formulas and formatting.

Can an employee demand a salary certificate if he/she gets his/her salary in cash?ĭownload Salary Certificate Format (Excel, OpenOffice Calc & Google Sheet).

Is there any limit to Salary Certificates issued to an employee?.

Printable Salary Certificate With Salary Breakup.

Salary Certificate With Salary Breakup on Letterhead.

Salary Certificate With CTC On Letterhead.

Download Salary Certificate Format (Word, OpenOffice Writer & Google Docs).

Salary Certificate Template (With CTC and With Salary Breakup).

Components of Salary Certificate Template.

How To Use Salary Certificate Excel Template?.

Download Salary Certificate Format (Excel, OpenOffice Calc & Google Sheet).

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… 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.

Salary slip format excel