※ Download: Salary sheet format in excel file free download
We will guide you and provide you Salary Slip Format and Templates for free download. Employer Contribution to ESI is 4.
Format and Put your all data in to Excel Sheet and use the mail merging function of Microsoft Word. But it is short of; Yearly Consolidated statement, Leaves statement Excess leaves will not identified in this sheet Single page Bank statement for payout for direct pay from Bank Date of joining, Account Number, Bank Name PAN Number, PF account Number, UAN number, etc. Normally it also include tax deduction details of tax paying employee and the employees should keep it in record for income tax department and for submission of tax returns.
- Sample salary slip format in Ms Excel available for free download with auto calculations and maximum options a salary slip contain.
What Is Corporate Salary Slip? Salary slip is a business document issued by the employer to the employee every month upon receipt of salary. It is also known as Payslip. Payslips are an important part of the Payroll process. Salary slip consists of all earnings fixed and variable and deductions fixed and variable along with the mandatory tax deductions like TDS and FBT. We have created a Salary Slip Excel template with predefined formulas. It automatically calculates the Gross earnings and deductions. 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 staffs etc. Additionally, you can download other accounting templates like , and Excel Templates from here. Let us discuss the components of this template in detail. Components of Corporate Salary Slip Excel Template The template consists of 5 major sections. Approval and Notes Section. Header Section As usual, the Header Section consists of the company logo, document heading, and the company name. Employee Details Section Employee details section consists of following employee details: Name. Salary Bifurcation Section Salary detail section is further divided into 2 subsections; Earnings and Deductions. Basic salary is the amount which an employee is eligible without any additional allowances or any kind of deductions. HRA stands for House Rent Allowance. It is either fixed or variable. All stands for the conveyance allowance. All stands for Transport allowance. CEA stands for Child Education Allowance. All stands for Special Allowance Category. The Employer contribution consists of Provident Fund PF , Employee State Insurance ESI and Exgratia bonus. Employer contribution to the Provident fund is the total 12 % of the basic salary. Employer Contribution to ESI is 4. A formula has been setup which calculates the amount by itself. ESI is applicable if the salary of the employee is less than 15000. Thus, if the basic salary is above that amount template will automatically display 0. Exgratia or bonus is the sum of money paid with no obligation or liability to pay it back. Reimbursements items depend on the designation of the employee. One thing is to be kept in mind it also includes the employee contribution, which is not payable every month but is a part of the salary. The Employee contribution to Provident fund is total 12 % of the basic salary. Employee Contribution to ESI is 1. A formula has been set up which calculates the amount by itself. Summary Section The summary section consists of the final calculation of the net receivable salary amount. Approval and Notes Section The last section consists of Approval and Notes section. The Notes include the instruction of the company if any for the employee. We thank our readers for liking, sharing and following us on different social media platforms. If you have any queries please share in the comment section below. I will be more than happy to assist you.
Salary sheet template is a pre designed document made by professionals to help others when making salary sheets for employees or workers. We are continuously increasing this number. If you want us to do the same for you, you need to contact through email to us and send complete details to us. After adding values your salary slip is ready to be printed on the plan paper and get it signed from the relevant authorities. Sample Payslip Format in Excel Sheet with auto calculation formula for office, business, production units and factories in Asia,UK, USA and Europe. Below we have added different salary sheet templates that anyone can use to make and print free salary sheets on desktop computer. Semioffice deliver free sample of letters, applications, Emails, business proposals, business reports, essays, speeches, forms, certificates, planers and resumes for our visitors.
