Moreover, CTC/PM is the total salary of an employee without deductions. These reimbursements include excessive medical reimbursements, conveyance or travel reimbursements, or Telephone reimbursements. Reimbursements are those amounts that an employee gets reimbursed based on the amount spent actually under a particular head. Reimbursementsįurthermore, Reimbursement items depend on the designation of the employee. Exgratia or bonus consists of the amount that an employer pays to the employee with no obligation or liability to pay it back. Hence, if the gross salary is above that amount template will automatically display 0. ESI is only applicable if the salary of the employee is less than Rs. Thus, it automatically calculates the Provident Fund amount as well as the ESI amount. The cell consists of a predefined formula. The Employer contribution consists of Provident Fund (PF), Employee State Insurance (ESI), and Exgratia (bonus).Įmployer contribution to the Provident fund is a total of 12 % of the basic salary. Employer Contribution to ESI is 3.25 % of the gross salary. Gross salary = Basic + Total of all Allowances Employer Contributions The template adds all the following amounts to form the gross salary.Ĭlick on each Allowance to know more about it in detail. These allowances differ based on company policy, industry, job profile, and department. AllowancesĪllowances are the financial benefits an employer provides above the Basic Salary to his employees. For more information about Basic Salary click here.
Therefore, bonuses, overtime, dearness allowance, etc are not a part of basic pay. Basic Pay/Basic Salaryīasic salary is the fixed amount that an employer pays to an employee without adding any allowances or subtracting any deductions. Insert other applicable allowances like HRA, Conveyance Allowance, Transport allowance, Child Education Allowance, Special Allowance, etc. The major components of the earning section are basic salary, allowances, Employer contribution to PF/ESI, and reimbursements. The salary bifurcation section is further divided into 2 subsections: Earnings and Deductions. The template consists of 5 major sections: Header Section, Employee Details Section, Salary Bifurcation Section, Summary Section, and Approval and Notes Section.Īs usual, the Header Section consists of the company logo, document heading, and the company name.Įmployee details section consists of following employee details: Components of Corporate Salary Slip Template
Let us discuss the contents of the template in detail. Important Note: To edit and customize the Google Sheet, save the file on your Google Drive by using the “Make a Copy” option from the File menu.Īdditionally, you can download other HR and Payroll related templates like Employee Performance Evaluation, Attendance Sheet, Weekly Timesheet, Salary Sheet, and much more. The functioning and formulation in all the four file formats are the same except the SpellNumber Function as it is not supported in OpenOffice Calc, Google Sheets, or Apple Numbers.Ĭlick here to Download All HR & Payroll Excel Templates for Rs 199. Click on the button below to download the desired format:Įxcel Google Sheets Open Office Calc Apple Numbers This template is available in 4 file formats – Excel, Google Sheets, Open Office Calc, and Apple Numbers. You just need to enter a small amount of data and our salary slip is ready in a few minutes. This template can be useful for HR professionals, HR executives, Administrative staff, etc. It automatically calculates the Gross earnings and deductions.
We have created a Salary Slip template with predefined formulas.
Thus, Payslips are an important part of the Payroll process. Salary slip is a business document issued by the employer to the employee every month upon receipt of a salary. Components of Corporate Salary Slip Template.Download Corporate Salary Slip Template.