We have kept a provision of 20 employees. When the user selects the month and year for the first employee, it automatically displays the same for other employees. You can select the month and year of salary from the dropdown list. The first section consists of employee details such as employee name, designation, salary month, allowed leaves, leaves taken, and working days.

Major data in this sheet needs to be entered one time. The database sheet consists of the master data where data of each employee will be entered. Salary Sheet template consists of the following three sheets: Employee Database, Consolidation Sheet, and Employee Salary Slip Employee Database Note: After you download the excel and open the office template, don’t forget to enable the content in the security warning pop-up below the ribbon as shown in the images below: 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 Salary Slip, Attendance Sheet, Weekly Timesheet, 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. Click on the button below to download the desired format:Įxcel Google Sheets Open Office Calc Apple NumbersĬlick here to Download All HR & Payroll Excel Templates for ₹299. This template is available in 4 file formats – Excel, Google Sheets, Open Office Calc, and Apple Numbers. You can prepare the salary of multiple employees within minutes with the help of this template. We have created an automated Salary Sheet Template with predefined formula. Hr and Payroll staff needs to micro-manage payroll data of employees, which include basic salary, HRA, TA, Conveyance, Leave details, provident fund deductions, etc. Take-Home Salary = Basic Salary + Allowances – Deductions. Thus, each month working days, overtime, leaves, and other variables are different for each employee. It differs from one period to another as it is calculated based on actual working days.

Generally, Payroll is made daily for wages, weekly, biweekly, or monthly for salaries. HR maintains financial records of employees like wages, salaries, deductions, bonuses, holidays, leaves, sick leave, etc. It is also known as payroll or payroll sheet. of employees.Ī salary sheet or payroll sheet is the Human Resource document that a company uses to calculate the salaries of their employees. It includes details like basic pay, allowances, deductions, and overtime, etc. A salary Sheet is a document that includes complete details of the amount payable to an employee for work done during a particular period.

Monthly employee schedule template