The template adds all the following amounts to form the gross salary. These allowances differ based on company policy, industry, job profile, and department. Allowances are an employer’s financial benefits above the Basic Salary to his employees. It uses the following formula to calculate the basic salary “=IF(H4=0, “”, ROUND ($J4/E4*H4*50%, -1))”. The basic Salary is proportionate to the working days. Usually, it is 40% or 50% of the basic salary. The template auto-calculates the basic salary based on CTC. For more information about Basic Salary, click here. Bonuses, overtime, dearness allowance, etc., are not a part of basic pay. The basic salary is the fixed amount to be paid to an employee in addition to any allowances or subtraction of any deductions. The Salary has three major components: Basic Pay, Allowances, and Deductions. Hence, the template calculates the CTC proportionately according to the working days for that particular month.
For more information on CTC, click here.ĬTC is calculated based on working days. CTC = Direct benefits + Indirect benefits + Saving Contributions. Insert CTC for each employee as per the employee contract. The template uses the “=IF(G4>=F4, E4-G4+F4, E4)” formula to calculate the working days. The allowed leaves are deducted from the total leaves, which is how the actual working days are calculated. Insert actual leaves availed by the employee, and the template automatically calculates the working days. When the user selects the month and year for the first employee, it automatically displays the same for other employees.Īllowed leaves are different according to the designation and company policy. The user can select the total days of the month (30, 31, 28, or 29) from the dropdown list. If you want to increase employee salaries, you can drag the same using the fill handle. 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 includes employee details such as name, designation, salary month, allowed leaves, leaves are taken, and working days. Major data in this sheet needs to be entered one time. The database sheet consists of the master data, where the data of each employee will be entered. The salary Sheet template consists of the following three sheets: Employee Database, Consolidation Sheet, and Employee Salary Slip Employee Database
#OPENOFFICE TEMPLATES HOLIDAY DOWNLOAD#
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: Save the file on your Google Drive using the “Make a Copy” option from the File menu to edit and customise the Google Sheet.Īdditionally, you can download other HR and Payroll related templates like Salary Slips, Attendance Sheets, Weekly Timesheets, and much more. The functioning and formulation in all four file formats are the same except for 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 multiple employees’ salaries within minutes with this template’s help. We have created an automated Salary Sheet Template with predefined formula. Hr and Payroll staff needs to micro-manage employee payroll data, including 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 differ for each employee. However, 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., in Payroll. It is also known as payroll or payroll sheet. The payroll or salary sheet is the Human Resource document companies use to calculate their employees’ salaries. In addition, it contains details like employees’ basic pay, allowances, deductions, 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.
0 kommentar(er)
