How to make a pay slip and what it includes

The wage slip shall be prepared by the employer to which the employee belongs when paying the salary, and shall include the following contents: the employee's income (basic salary, non-basic salary); deductions (endowment insurance, medical insurance, unemployment insurance, housing provident fund, enterprise annuity); tax deductions; Actual wages. The employer must keep a written record of the amount and time of payment of the employee's wages, the name and signature of the recipient, and keep it for at least two years for future reference.

Legal basisArticle 6 of the Interim Provisions on Payment of Wages.

The employer shall pay the wages to the employee. If the worker is unable to receive wages for any reason, his relatives or entrusting others to collect the wages on his or her behalf.

The employer may entrust the bank to pay the wages on behalf of the employer.

The employer must keep a written record of the amount and time of payment of the employee's wages, the name and signature of the recipient, and keep it for at least two years for future reference. When paying wages, the employer shall provide the employee with a list of his or her personal wages.

The details are as follows:

Salary, bonuses, subsidies, overtime pay and other income items

After the salary slip is in hand, you can check whether the salary payable is paid in full according to the amount signed in the labor contract. Specifically, it can be divided into basic compensation and benefits compensation.

Basic salary, such as basic salary, post salary, salary scale salary, performance salary, seniority salary, overtime pay, etc.

Benefits, such as housing allowance, transportation allowance, meal allowance, telephone bill allowance, as well as various bonuses, allowances, etc.

Deductions such as five insurances and one housing fund, individual income tax, and annuity

Generally speaking, the social insurance paid by enterprises for employees is the "five insurances", including endowment insurance, medical insurance, unemployment insurance, work-related injury insurance and maternity insurance.

Employers need to withhold individual income tax for employees in accordance with the methods prescribed by the state, and employees should check their individual individual income tax withholding declarations in a timely manner.

Enterprise annuity is a supplementary pension insurance system established by enterprises and their employees through collective negotiation on the basis of participating in basic pension insurance in accordance with the law. Specifically, you can check whether the enterprise payment is included in the personal account of the enterprise annuity in accordance with the proportion and method determined by the enterprise annuity plan, as well as the individual payment of the employee.

If you want the company to pay pay slips moreEfficient, compliant, and secure

It is possible to give advice to the company and useProfessional payslip toolA few secondsYou can pay all the pay slips for everyone.

Upload the excel payroll - the machine automatically disassembles it into a payslip - for issuance configuration - one click**).

And the professional pay slip tool is inFunctional aspectsMore powerful.

Enjoy pay slips

2. It can be signed and signed, and the signature record can be exported. It can be recalled, retransmitted, and sent at a regular time. Customizable pay stub templates.

4. With the security support of Alibaba Cloud, we have signed a confidentiality agreement with customers, and our salary data is encrypted in multiple ways.

Register on the official website to try it out

Generally speaking, the format of the pay slip is fixed, including the employee's work number, name, basic salary, performance salary, welfare expenses, housing**, payable salary, personal income tax and actual salary. Employees should be aware of the following when receiving their pay stubs:

First of all, it is necessary to pay attention to whether the wage details comply with the regulations, among which the minimum wage must meet the standards of the city, the minimum wage does not include overtime wages, allowances under special working conditions and special conditions, and does not include labor insurance, welfare benefits and various non-monetary income; In addition, it is necessary to look at endowment insurance, medical insurance, work-related injury insurance, maternity insurance, unemployment insurance and housing provident fund. Have these expenses been deducted from the employer to your personal account? Is it paid according to local standards?

Finally, it depends on whether the employer withholds the individual income tax in accordance with the methods stipulated by the state.

1. Open the employee's salary table, as shown in the following figure.

2. Then copy the sequence number column twice as shown below. The number of copies is one less than the actual number of people.

3. Copy the title to the second set of serial numbers, as follows.

4. Use the sorting tool to sort the serial number columns in ascending order.

5. Select "Expand Selected Area Sorting" and click Sort.

6. After the sorting is completed, the following ** appears, and it can be seen that the salary slip has been made.

Payroll summary commonly used excel function.

1) Insert auxiliary columns (2) Sort.

How to make a payroll to a payslip.

Step 1: Open the excel payroll we want to work onStep 2: Fill in the serial number in the back column of the payroll (tip:

After filling in 1 in g2, place the mouse in the lower left corner of g1, a + appears, click + 2 times, and it will be autofilled), and then copy twice.

Step 3: Copy the header 6 times.

Step 4: Sorting, the main keywords are in column g (that is, the column we add the serial number), ascending; The secondary keywords are listed in column F (that is, the column that should be paid) and click OK.

Tool: magicbook.

Operating system: Windows 10.

1. Open the employee's salary table, as shown in the following figure.

2. Then copy the sequence number column twice as shown below. The number of copies is one less than the actual number of people.

3. Copy the title to the second set of serial numbers, as follows.

4. Use the sorting tool to sort the serial number columns in ascending order.

5. Select "Expand Selected Area Sorting" and click Sort.

6. After the sorting is completed, the following ** appears, and it can be seen that the salary slip has been made.

1. Open the employee's salary table, as shown in the following figure.

2. Then copy the sequence number column twice as shown below. The number of copies is one less than the actual number of people.

3. Copy the title to the second set of serial numbers, as follows.

4. Use the sorting tool to sort the serial number columns in ascending order.

5. Select "Expand Selected Area Sorting" and click Sort.

6. After the sorting is completed, the following ** appears, and it can be seen that the salary slip has been made.

It's actually quite easy to make a pay stub, you can use excel electronically**, right? Use electronically ** to list the details of wages and deduct insurance items, and the last item is take-home pay. Then you typeset the ** well, and print out everyone's name in front of it.

And then use scissors to cut each person's corresponding salary details into one by one, and then distribute it to individuals, wouldn't it be good?

First, enter the serial number in the auxiliary column, copy the serial number downward, copy the table header below and paste it into the ** below, click the serial number, and then click ascending in the data, and delete the auxiliary column.

excel how to make pay slips, I teach you!

1. Open the employee's salary table, as shown in the following figure.

2. Then copy the sequence number column twice as shown below. The number of copies is one less than the actual number of people.

3. Copy the title to the second set of serial numbers, as follows.

4. Use the sorting tool to sort the serial number columns in ascending order.

5. Select "Expand Selected Area Sorting" and click Sort.

6. After the sorting is completed, the following ** appears, and it can be seen that the salary slip has been made.

This is all easy depending on the unit. Different pay slips can be made for different requirements, and there is no one-size-fits-all version of the stereotyped category. The simplest is to use excel to make a **, and finally cut a long salary slip and send it to the individual.

excel how to make pay slips, I teach you!

Do you do it for yourself or for the company?

Insert a column at the front, enter 1 for the salary item line, copy the line (determine how many lines need to be copied according to the number of people), and enter 3 for the second line, so as to automatically fill in the amount of funds in the Gongwei Wheel and enter it in front of the wide mountain Qi column ——

Then sort it in the first column and it will become a pay slip.

The salary schedule should include: the employee's work number, which is the same as the ID number, in order to avoid having the same name; Name of the key stool worker; Employee level, such as junior employee, intermediate employee or senior employee of the manuscript brigade; the department in which the employee belongs; the number of days the employee was in attendance; the employee's basic salary; the employee's salary; Employees' performance commissions, such as the percentage of sales targets; Attendance awards for employees; personal income tax; The amount of five insurances and one housing fund for employees; the number of days the employee is absent from work; Employees are paid actual wages.

The salary schedule should include: the employee's work number, which is the same as the ID number, in order to avoid having the same name; Employee's name; Employee level, such as junior, mid-level, or senior; the department in which the employee belongs; the number of days the employee was in attendance; the employee's basic salary; the employee's salary; Employee performance commissions, such as percentage of sales targets; Attendance awards for employees; personal income tax; The amount of five insurances and one housing fund for employees; the number of days the employee is absent from work; Employees are paid actual wages.

excel how to make pay slips, I teach you!