It is always a good practice to hire a good professional or consultant who is an expert in these matters. You need to calculate TDS after deducting exemptions, so maintain a separate working for this. Income Tax calculation should be as per the rules and regulations of the government. PF will be 12% of basic pay PT will be 200 if the gross salary is more than 15000 or else 150. When you include deductions, you need to be careful in terms of Professional Tax, Provident Fund, and Income Tax calculations. The deduction part may include Provident Fund, ESI, Professional Tax, Income Tax (TDS), Salary Advance (If Any), and you can include any other deductions as well.
You can include any other information regarding the company. It should include Company Name, Address, Phone Number, and Company Logo.
First thing you need to set up is general information about the company.
Let’s follow the below steps to build a Free Payslip excel template on your own.
You are free to use this image on your website, templates etc, Please provide us with an attribution link How to Provide Attribution? Article Link to be Hyperlinked
Pay Slip consists of all kinds of earnings and deductions under various heads as per the norms are given by the government in the respective financial year. Pay Slip or Salary Slip template in excel is the receipt given by the employer to their employees every month upon payment of salary to the employee for the services rendered in the month. In this article, we will show you how to build a Free Payslip template in excel.
In the modern world, corporate companies use sophisticated software to prepare their employee’s payslip, but we can still rely on excel to prepare payslip. As an employee, we all get salary receipts so-called “Payslip” from our employers, which is an acknowledgment for salary credited to employee account from the employer.