

It consists of the same number of sheets, columns, and rows.

This template operates similarly in each file format. Microsoft Excel OpenOffice Calc Google Sheet Click the link below to download the desired file format. This template is available in 3 different file spreadsheet programs: Excel, Google Sheet, and OpenOffice Calc. We have created a ready-to-use Salary Sheet Template with predefined formulas according to Indian rules of employment to simplify your payroll process. Net Salary or Take Home Salary = Basic + Allowances – Deductions Download Employee Salary Sheet Template in Excel, OpenOffice Calc, and Google Sheet as per the Indian Salary Structure Important Formulas To Calculate Components of SalaryĬTC = Gross Salary + PF + Health InsuranceĪllowances = HRA + Medical + Conveyance + Travel Allowance + Special Allowanceĭeductions = Professional Tax + TDS (Tax Deducted At Source) + EPF Employee Contribution Thus, the calculations include provident fund and employee allowances which are mandatory by law. These salary calculations are prepared according to the Indian salary structure and laws of employment. This involves keeping records of overtime, leaves, medical, health insurance, EPF (employee provident fund), ESI (employee state insurance), etc.Īn Employee Salary sheet is a document that helps you process the salaries of multiple employees in few minutes and generates salary slips of all employees in just one click. Payroll departments manage payroll data of employees on a micro-level.

How to calculate overtime for a salaried employee?.

