Salary Advance Deduction Format in Excel

Insert CTC for each employee according to the employment contract. CCT = Direct benefits + Indirect benefits + Savings contributions. More information about the CTC can be found here. Above you will find details that prepare the salary according to the Indian salary structure. An employer pays wage costs to its employees in the form of wages for their services/work and related expenses such as employee benefits and state and federal payroll taxes. The consolidation sheet consists of a monthly sheet with the salary data entered in the database sheet. This sheet connects the Database panel to each cell and automatically retrieves the date from the Database panel. You do not need to enter any data in this sheet. Then there is the section on allowances. Allowances are the financial benefits that an employer grants to its employees beyond the base salary. These allowances differ according to company policy, industry, job profile and department.

The template adds all of the following amounts to form the gross salary. Note: After downloading Excel and opening the Office template, remember to enable the content in the security warning pop-up window under the ribbon, as shown in the images below: the salary to be paid is the amount that remains after adding allowances and deducting deductions from the base salary. If an employee has opted for a salary advance, it is added to the amount of the deduction and then deducted from the gross salary. Therefore, this salary component must be properly determined. Where: Deductions include business taxes, other federal or state taxes, salary advances, etc. A simple salary sheet is a document that captures employees` monthly salary data. Like a detailed salary sheet, this sheet does not record each allowance or deduction separately, but contains the whole number. In other words, it declares the total amount of all allowances, as well as deductions. If the total amount of the deduction is deducted from the gross salary, the net salary to be paid to the employee results. The functionality and label 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. A payroll or payroll is the personal document that a company uses to calculate the salaries of its employees. It is also known as payroll or payroll.

HR keeps employees` financial records such as salaries, salaries, deductions, bonuses, vacation, vacation, sick leave, etc. in payroll. After changing the salary and printing your employees` pay slips, go to the pay slip and copy the cells from B6 to C33 and paste them in the respective month. From January to December, it consists of 12 leaves, one for each month. You can select the month and year of salary from the drop-down list. When the user selects the month and year for the first employee, the same is automatically displayed for the other employees. We have maintained a pension plan with 20 employees. If you want to earn the salary for more employees, you can pull the same with the fill handle. The model automatically calculates the base salary based on the CBA. As a rule, this is 40% or 50% of the basic salary. The basic salary is proportional to the working days. It uses the following formula to calculate the base content « =IF(H4=0, «  », ROUND ($J 4/E4*H4*50%, -1)) ».

For employees of a metropolitan city, it is 50% of the base salary, while for employees of a non-metropolitan city, it is 40% of the base salary. In general, if these rules are not applicable, it is 10% of the basic salary. For more information on the house rent allowance, click here. The net salary or net salary is the amount of an employee`s salary that remains after deduction of all deductions (taxes, health insurance, social benefits, etc.). Simply put, net salary is the amount an employee receives after all taxes/deductions during a given pay period. Base salary: Enter the employee`s base salary in this cell. The base salary is the fixed remuneration that an employer pays to its employee without compensation or deductions. According to the Indian Labour Code, an employee must pay part of the salary to the pension fund. Currently, it is 12%. The model uses the following formula to calculate « =ROUND (MIN (1800, IF (AG4= »Yes », SUM(K4: L4) * 12%, 0)), -1) ».

If you want to print a single pay slip, go to the respective payroll, select the cells and enter the print order via « CNTRL + P » and select the « Selection » option. There you go. Da is calculated automatically. Da (Dearness Allowance) is 4% to 10% of the base salary, depending on the contract. It uses the following formula to calculate DA « =IF(H4=0, », ROUND (J4/E4*H4*10%, -1)) ». For more information on the cost allowance, click here. HR and payroll employees need to micromanage employee payroll data, which includes base salary, RHS, TA, transportation, vacation details, pension fund deductions, etc. If you don`t want to scroll down to payroll, simply select the employee`s name from the payroll drop-down list. This payroll uses Vlookup and retrieves the data of the selected employee in the respective document.

The first section includes details about employees such as employee name, designation, month of salary, leave of absence, vacation taken and working days. The pay slip is filled in automatically and does not require any data entry. This sheet retrieves the data from the salary worksheet. Simply click the grey « Print » button on the right to print all 26 pay slips at once. Select Yes if PF applies. Select « Yes » if the employee has submitted the medical bills. If the user selects No, the template does not add health insurance to the salary. You can use this template to collect employee payroll data such as base salary, allowances, and deductions.

In addition, this template automatically prepares pay slips when you enter data. The payroll uses the VLOOKUP function to program the worksheet. On the far right, select the employee`s name from the drop-down list. The template displays the employee`s salary data. Click the Print button to print the pay slip. Click the Payroll button to access the payroll to print individual pay slips for employees. The annual salary report sheet is also filled in automatically. This sheet retrieves the final total amounts for each month under each header. The latter prepares the annual report on the salary paid throughout the year with the graphic representation. Enter the respective salary amounts in relation to each employee and you can print the pay slip. With the help of this template, you can print the pay slips of all employees with a single click.

You can print a singular by manually setting the print area. In addition, you can keep records for an entire year and create annual payroll reports. These benefits consist of additional financial benefits granted by an employer in addition to the base salary. The amount of the allowance varies from one company to another. Allowances also vary by industry, job profile, department, etc. Usually, the base salary is 40% to 45% of the CBA. This component of salary is fully taxable. Deductions: Paste the sum of the total deductions into this cell.

These include salary advances and other legal payroll deductions. For more information on sickness benefit, click here. Preparing the salary couldn`t be easier. 1-step process. You can print a monthly salary report for approval by senior management. Once the signing authority approves the salary, which you can pay to the employee by check or direct bank transfer. If an employer sets the base salary high, then the employee`s taxable income is higher and he has to pay higher taxes. .