how to make daily expenses sheet in excel for mac 2018

#How to make daily expenses sheet in excel for mac 2018 download

Allowances are the financial benefits an employer provides 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))”. 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. There are three major components of the Salary: Basic Pay, Allowances, and Deductions.īasic salary is the fixed amount to be paid to an employee addition of any allowances or subtraction of any 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 and this 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 make the salary for more employees, 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 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

#How to make daily expenses sheet in excel for mac 2018 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: 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.