prepare a salary slip of an employee in ms excel

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 ₹299. 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.

Prepare a salary slip of an employee in ms excel