How to turn the social security payment list into a table

Method of transforming social security payment list into form:

1. Export the electronic version: First, you can find the electronic payment list through the official website or APP of the social security agency. Generally speaking, these electronic data are presented in the form of PDF or pictures. You can use some online PDF conversion tools, such as SmallPDF or Adobe Acrobat, to convert the payment list in PDF format into Excel tables.

2. Hand-made form: If the social security agency does not provide the electronic payment list, or wants to make the form manually, you can follow the following steps:

Open Excel or other spreadsheet software.

Create a new worksheet.

Enter the corresponding data manually according to the contents of the payment list.

According to the need, use formulas or functions to calculate and sort out.

3. Use professional tools: Some specialized social security payment management software or tools can automatically convert the payment list into a form. If you often need to process social security payment data, you can consider using these professional tools.

General social security payment base:

The social security payment base is generally based on my salary income in the previous year.

1. If the wage income of employees is higher than 300% of the local average wage of employees in the previous year, 300% of the local average wage of employees in the previous year will be the payment base;

2. If the wage income of employees is lower than 60% of the local average wage of employees in the previous year, 60% of the local average wage of employees in the previous year shall be the payment base;

3, the employee's salary is between 300% and 60%, according to the actual declaration. When it is impossible to determine the wage income of employees, the payment base shall be determined according to the local average wage of employees in the previous year published by the local labor administrative department.

To sum up, the importance of social security payment list is to accurately record the social insurance premiums paid by individuals or units, and provide a basis for personal rights and interests and compliance management of units.

Legal basis:

People's Republic of China (PRC) social insurance law

Article 25

The state establishes and improves the basic medical insurance system for urban residents. The basic medical insurance for urban residents combines individual contributions with government subsidies. People who enjoy the minimum living guarantee, disabled people who have lost their ability to work, elderly people and minors over 60 years old in low-income families, etc. , subsidized by the government.