How to make a pay slip, how to print, more convenient!! Thank you

Two approaches. It can be made with excel

Insert row after row header into the payslip and sort it to create a payslip.

Then print it out, cut it out for distribution, or send a screenshot directly to the employee.

However, the amount of work required for this approach is relatively large.

2. Using a professional payslip tool will be more efficient and convenientIn a matter of seconds, everyone's pay slips can be issued

Fill in the form with the employee's ** or email address.

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

featuresIt will also be more comprehensive.

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.

Feel free to try it out

First of all, we need to make a basic data table, the header.

It is each salary item (it is strongly recommended to set only one line, do not.)

Merge cells.

and so on), one line of data per person below.

Do. Pay slips.

It is a line of table headers and a line of wages per person.

Amount. There are two ways to do this:

1. A copy will be made, starting with 、...Such an ordinal number, copy the header under the table, there is.

How many people. Copy as many lines as you want, for example, 50 people copy 50 lines. Then sort by serial number, arrange the first row of the table, and the name of the person is completed. This method is simple, but it can only be a piece of paper.

Multiplayer. 2. Use word.

Mail. This method may seem complicated, but it is convenient to use by inserting notes and other content in the pay slip. Here's how:

1) Create a new Word document (2003 version), copy the table header and add a blank line below.

**。**Add one car return. If you have a note, you can add it here.

2) Click on Tools

Letter. Merge with Mail Mail, select.

Directory. Use the current one.

Documentation. Use an existing list

Insert the merge field.

3) Complete and merge the individual documents merged to.

New documentation. All OK.

This method can be done by one person.

A piece of paper. It is also possible to multi-person on a piece of paper and then divide it by hand.

1. Income. It mainly includes various wages, bonuses, subsidies, allowances, etc., and the differences between different enterprises are still relatively large, but most of the income can be understood according to its name, such as full attendance awards, overtime pay, transportation subsidies, scientific research allowances, etc.

2. Deduction. Some of these deductions are union dues (a fixed deduction from an individual's salary) and a performance deduction due to absence, non-compliance, etc., but these are only a small part. An important part of the deduction is actually "three insurances and one housing fund" or "three insurances and two funds", such as pension insurance.

Medical insurance, unemployment insurance, housing provident fund, occupational annuity, enterprise annuity, work-related injury insurance and maternity insurance.

Therefore, it is often said that there are five insurances and one housing fund.

If it is reflected on the salary slip, the personal deduction will only have three insurances and one housing fund.

3. Tax deduction. According to the regulations, the wages, salaries, bonuses, year-end salary increases, labor dividends, allowances, subsidies, and other income related to the position or employment obtained by an individual due to his or her position or employment shall be subject to individual income tax.

The more income you make, the more income tax you pay. The national individual income tax adopts the calculation method of graded excess progressive tax rate (individual income tax.

Taxable income Applicable tax rate Quick deduction).

Pay slips are printed out one by one

1.The situation of a single line header is the easiest, there is only one line of headers, and any method is possible!

2.Sorting: This first method is the cliché sorting.

It's simple. Add a secondary column next to the data and enter a continuous sequence of numbers. Copy the sequence to the bottom of the entire data region, and copy the region to the table.

3.Positioning method: You can also use [Positioning Condition] to find the pattern of the data, and add the payslip header to the fixed position.

Add a secondary column next to the data and fill in the S-type. Leave the selection, [Ctrl+G] to open [Positioning] - [Positioning Condition], and select a constant. Right-click and select Insert-Entire Row.

Select the header to copy, then select the entire region, [Targeting] - [Null], and paste.

Hello, the steps to print the payslip are as follows: 1. Prepare the completed payroll, then click on the data, select the classification summary, check the pagination of each group of data, and click OK. 2. After confirming, click Preview to see that only one person's salary slip information will be displayed, if you need to delete the summary column, select any row, click Ctrl+G, then select [Null], click [OK].

Now that the payroll is ready, how can I quickly generate a payslip? It's great to use this method.

Do you want to write a pay stub? Wouldn't it be better to make it into ** printing? The specific subjects include name, position, date of entry, length of service, basic salary, post salary, other subsidies, overtime pay, leave deduction, social security deduction, other deductions, monthly total, individual income tax, actual salary, etc.

Name Monthly Salary Leave Deduction Advance Deduction Other Deduction Actual Salary Signature.

Not knowing what your boss's intentions are, it is advisable to take a look at the wage payment regulations.

This month's salary, insurance premiums, overtime pay, allowances, and more.

If you have a salary slip, you can go to the bank and print it directly, and he has a running salary. And which card you have is a salary card, you should know for yourself.

How do I print my pay stub? Just go to the company's finance and ask him to type out your payslip.

How to print the payslip after the payroll is done Hello dear I am also studying this problem, the method is as follows, print the payslip Method 1: 1, first copy the first line of the payroll details (header), paste it on any line below the payroll, and use the filling handle to drag and copy multiple rows (the number is not less than all the rows of the payroll, assuming that the payroll has 200 rows). Next, insert two columns in front of column a, the first column uses the fill handle to enter the ordinal number, and the odd number is filled (1 3 5......).) to the last line of the payroll (excluding the header copied above) 2. The second column starts from the first row of the copied header and is filled with an even number (2 4 6 ......3. Select all, execute the "Data" "Filter" and "Auto Filter" commands, click the drop-down button in column b, and select "Ascending Sort" in the pop-up drop-down menu, so that the pay slip is ready.

Finally, delete the ab column. But there is only one line in the header of the table, and you can learn from this method.

First of all, make a basic data table, the head of the table is each salary item (it is strongly recommended to set only one row, do not merge complex formats such as cells), and the following is one row of data for each person.

To make a salary slip is a line of table headers and a line of salary amount for each person. There are two ways to do this:

1. A copy will be made, starting with 、...With such a serial number, copy the header under the table, and copy as many rows as there are people, for example, 50 people will copy 50 rows. Then sort by serial number, arrange the first row of the table, and the name of the person is completed. This method is simple, but it can only be done by more than one person.

2. Use the mail merge method of word, which seems complicated, but it is convenient to use to insert notes and other content in the payslip. Here's how:

1) Create a new word document (2003 version), copy the table header and add a blank line below**, **add a carriage return below. If you have a note, you can add it here.

2) Click on the tools Letters & Mail Mail Merge, select the Table of Contents Use Current Document Use Existing List to insert the merge field.

3) Complete and merge the single document into a new document in the All OK.

This method can be one person on one paper, or one paper can be divided by multiple people, and then divided by hand.

Made into excl, one person has two lines, this formula is more convenient, and a lot of people can be printed on a piece of paper.

In accordance with the requirements below, you can also make a ** on the pay slip.

1. Create a new excel file and store the original data of the payroll in sheet1, assuming there are n columns. The first line is the payroll item, and from the second line onwards is the salary of each person.

2. In sheet2, let's set up the pay slip. According to the actual situation, the pay slip consists of three lines, one line corresponding to the salary item, one line corresponding to the salary data of one person, and then a blank line for easy cutting. These three lines form a pay stub.

The payroll item is on the line where the line number is divided by 3 and the remainder is 1; The blank line is on the line whose line number is divisible by 3. The above two rows are not difficult to set, the key is the salary data row, which involves the correspondence between the data in sheet1 and sheet2, and it is not difficult to see that "the data row in sheet1=int((data row in sheet2+4) 3)".

3. In this way, we enter the formula "=if(mod(row(),3)=0," in the a1 cell of sheet2"",if(mod(row(),3)=1,sheet1!a$1,index(sheet1!$a:

n,int((row()+4) 3),column())) to confirm and select cell A1, put the mouse in the lower right corner of cell A1, when the mouse becomes "+", drag the mouse to the right to automatically fill in column n, so that the first line in the pay slip will come out. Select A1:

N1, put the mouse in the lower right corner of the N1 cell, when the mouse becomes "+" again, drag the mouse down to automatically fill in the last line of the data, and the pay slip is all made.

Remember the formula "=if(mod(row(),3)=0,"",if(mod(row(),3)=1,sheet1!a$1,index(sheet1!$a:

n,int((row()+4) 3),column())) should remove the quotation marks from the front and back.

1. Select the area you want to print first.

2. Select File to Print.

3. In the box that pops up, select the second item "Selected Range" for the page range

You'll be able to print the pay slips you've selected.