How to do the electronic version of the payroll? Is there any good way to do this?

Steps to make a payroll: 1. Enter the payroll information, create an empty workbook, and enter the corresponding information of the payroll in the workbook; 2. Calculate the full attendance award, select the F4 cell, enter the formula, press the enter key, you can calculate the bonus, drag and drop the filling handle to calculate the full attendance award of other cells, note that the bonus is more than 22 days according to the number of days of attendance, and the bonus is multiplied by 20 according to the number of days of attendance, and there is no bonus for less than 22 days; 3. Calculate social security, select G4 cell, enter the formula and press the enter key to calculate the social security, and drag the filling handle to calculate the social security of other cells. 8% of all income is paid here; 4. Calculate the take-home wage, select the H4 cell, enter the formula and press the enter key, you can calculate the take-home wage, and drag the filling handle to calculate the take-home pay of other cells.

The electronic version of the payroll can be used directly in Excel**.

To make, it is necessary to list the salary details of employees, and the electronic salary statement needs to be issued to employees in a timely manner, so that the electronic salary slip can be made on the personnel platform.

Use Excel for it. You can import the employee's name and employee's salary into Excel. In excel, you can clearly see the salary of employees, sort them, and filter them.

You can use excel to make payroll**, and it's fast, there are relevant data patterns, and you can quickly make an electronic version of the payroll.

The salary ** is made as follows:Tools Ingredients: MacbookAir

1. Box select cells: Box select the cells you need.

2. Click Merge Cells: Click [Merge Cells] above.

<>4. Enter the header: Enter the required header: name, salary.

5. Box select cells: Box select the cells you need.

6. Click all frames: Click [All frames] above.

The salary ** is made as follows:Tools Ingredients: MacbookAir

1. Box select cells: Box select the cells you need.

2. Click Merge Cells.

Click Merge Cells above.

<>4. Enter the header.

Enter the required headers: name, salary.

5. Box select cells: Box select the cells you need.

6. Click all frames: Click [All frames] above.

7. The operation is completed: the salary **production** template operation has been completed.

The template of migrant workers' wage table includes the employee's work name, employee's name, basic salary, benefit salary, overtime wages, various subsidies, total wages payable, pension deductible, and unemployment deductibleMedical insurance premiums should be withheld, provident fund should be deducted, sick leave wages should be deducted, other expenses should be withheld, individual income tax should be withheld, and subtotals should be deductedActual wages.

Each unit can adjust and use it according to the above items.

According to the Labor Law of the People's Republic of China, workers enjoy the right to receive labor remuneration, the right to submit labor disputes for settlement, and other labor rights stipulated by law.

1. The internal wage payment method of the enterprise shall include the following contents: payment items, payment standards, payment methods, payment cycles and dates, overtime wage calculation base, wage payment under special circumstances and other wage payment contents.

2. The enterprise shall pay the wages on a monthly basis according to the wage standards for migrant workers agreed in the labor contract, and on the date agreed in the collective contract or labor contract signed in accordance with the law, and shall not be lower than the local minimum wage standard.

3. Enterprises should pay wages directly to migrant workers themselves, and it is strictly forbidden to pay them to contract foremen or other organizations and individuals that do not have the qualifications of the employing entity, and enterprises can entrust banks to pay migrant workers' wages.

4. Enterprises paying migrant workers' wages shall prepare a wage payment table, truthfully record the payment unit, payment time, payment object, payment amount and other wage payments, and keep them for more than two years for future reference.

The steps to make the salary ** are as follows:

Material preparation: computer, excel.

1. Create a new excel sheet.

2. Enter information such as "name, gender, position, basic salary, subsidy, attendance, insurance, actual salary" in the header.

3. Add basic data in **.

4. A column of full attendance awards, with 22 days as the number of full attendance days, the base number is 10 as an example, calculated with a formula, enter "if(f2>22,f2*10,0)" in the f2 cell, press the keyboard enter key to get the full attendance salary.

5. In the insurance column, take 9% of all inputs as an example, calculate with a formula, enter "=(D2+E2+G2)*9%" in H2 cell, and press the Enter key on the keyboard to get the insurance payment amount.

6. In the column of Qiaochong posture actual salary, calculate with formula, enter "=d2+e2+g2-h2" in cell i2, and press the keyboard enter key to get the actual salary.

7. Select the three cells of the input formula, place the mouse on the filling handle, turn it into a cross, hold down the left button and drag it down, you can get the full amount.

8. Select all and click all the frames. So that a salary schedule is ready.

1. Commission salary: also known as "split wage system" or "split wage system". It refers to a wage system in which individual employees or small collectives are divided into net income (or gross income) and paid labor remuneration according to a fixed proportion of their net income.

2. Structural wages: also known as "decomposition wage system". It refers to a basic wage system in which wages are divided into several parts and paid separately according to the factors that restrict the amount of labor provided by employees, or according to the different functions of wages.

3. Hourly wages: Hourly wages refer to the form of wages that inspect and pay labor remuneration according to the actual working hours and wage levels of workers and wage standards.

4. Contracted wages: refers to a wage system in which the completion time, product quality requirements, economic and technical indicators and the amount of wages to be paid after the completion of the contract are contracted to individual employees or team collectives through the contract, and then wages are paid according to the performance of the contract, regardless of the amount of labor.