How to do the payroll with social security?

1. How to make the payroll of workers is as follows: 1. Enter payroll information. Create an empty workbook and enter the corresponding payroll information in the workbook. 2. Calculate the attendance award. Select the F4 cell, enter the formula "= if (E4) 22, E4 * 20,0" and press Enter to calculate the bonus. Drag fill handle to calculate the attendance bonus of other cells. Note: here, bonuses are paid according to the attendance days of more than 22 days, and the bonus is multiplied by 20, and there is no bonus for less than 22 days. 3. calculate social security. Select cell G4, enter the formula "=(C4+D4+F4)*8%", press Enter to calculate the social security, and drag fill handle to calculate the social security of other cells. 8% of the total income is paid here. 4. To calculate the take-home pay, select cell H4, enter the formula "=C4+D4+F4-G4" to calculate the take-home pay, and then drag the fill handle to calculate the take-home pay of other cells. Second, what should I pay attention to when making a payroll? 1. Salary payment period and date. The enterprise pays wages at least once a month, that is to say, no matter how often the enterprise and employees agree to pay wages (such as annual salary system or paying wages according to the assessment cycle), the wages are paid in advance at least once a month, and the prepaid wages shall not be lower than the local minimum wage standard, and other wages shall be settled at the end of the year or when the assessment cycle expires. The specific date of wage payment shall be determined through consultation between the enterprise and the employees. Once the salary payment date is agreed, the enterprise can only pay the salary in advance, but not postpone it. If the wage payment day is a rest day or a legal holiday, the enterprise shall pay it on the previous working day. 2. In practice, because the basic salary is a fixed part of the wage structure, once it is agreed in the labor contract, the enterprise cannot adjust it unilaterally. Enterprises will make a fuss about the floating part of salary composition for their own autonomy in employing people. Enterprises can determine welfare standards according to actual needs. For example, enterprises can give employees more benefits when the economic benefits are good, and less benefits or even no benefits when the benefits are not good. As the rules and regulations of the enterprise, the welfare treatment system is different from the contract, and the enterprise has more operating space. In addition, when employees' performance is poor, enterprises can adjust the performance appraisal part of the salary structure by themselves, but the fixed part of the salary still needs to be paid normally. 3. Social insurance costs Social insurance is the so-called "five insurances", namely, pension, medical care, unemployment, work injury and maternity. It is a security system that the state forces employers and workers to charge certain insurance premiums to ensure that workers can get economic help from the state in the case of old age, illness, unemployment, disability and childbirth. Pension, medical care and unemployment are paid by both parties, and maternity and work-related injuries are paid by the unit. It is a legal obligation for an enterprise to pay social insurance for its employees, and it cannot be abandoned by agreement. 4. Check-in procedure for payroll (Part 1) Employees need to sign the payroll or payroll when they receive their wages. When an enterprise pays wages, it shall provide employees with a list of wages. The content of the payroll should be consistent with the content of the payroll or payroll. If the employee has any objection to the salary list, the enterprise shall give a reply.