Job Recruitment Website - Social security inquiry - How to turn the social security payment list into a table
How to turn the social security payment list into a table
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.
- Previous article:20 19 Shanghai Social Security Remittance Base
- Next article:Chengdu gaoxin west area operating social security bureau
- Related articles
- How to change the bank password of social security card
- Can tooth extraction in Qingdao be reimbursed by medical insurance?
- Pay your own social security, including medical insurance?
- How many months does the Shanghai medical insurance fund arrive every year?
- Division of leadership of suyu district Human Resources and Social Security Bureau
- Zunyi social security personal inquiry personal account inquiry balance
- Minimum base of Kaili social security payment
- Xinxiang labor and social security bureau
- How to reimburse Beijing medical insurance for seeing a doctor in Hebei?
- What is the reimbursement rate of Beijing medical insurance card?