Questions about how to make a payslip!! Hurry!!

There is a relatively simple way, if you have 10 rows of data on this page, copy the corresponding header of the 10 rows, and then enter the number in the last column, enter the data 2, 4, 6, 8, etcEnter 1, 3, 5, 7 for the header....Then select them all, sort them, and sort them by the last number you entered, in ascending order, and that's good!

Your ** is OK, select the printing area when printing, don't want the last column, or just delete the last column and then type. I've also found a lot of ways online, and this one is the most practical. However, when previewing, be careful not to cause the table header to be on one page and the data to be on the next page.

I used execl when I was doing payroll and wanted to print it like this. The advantage of this is that after printing, you can make a pay slip by cutting n strips on one page.

Unfortunately, I didn't make it happen. This ideal format is the format that comes out when people print it out of HR software.

I can only use that stupid way of paper. It's a one-page print of each person's salary. That is, that page shows a row of table headers, a row of employees' wages. Although this is paper-consuming, it only ensures confidentiality.

In addition, in order to save paper, I will finish typing one side, and then turn it over and walk on the other side, and print it on both sides, so that I can use one piece of paper on a piece of A4 paper, the salary of one employee above, and the salary of one employee below, and then the middle cut can be used for two of them. Of course, if it is set up, you can also go through the paper a third time, so that the salary of the third employee is hit in the middle of the paper.

As for the way to implement it, I think you probably know. The first thing to do is to set the watch head in the print settings. Then each employee's payroll is set to one page (i.e., pagination settings).

The most I do this is less than 100 people, more than that, and I think it's probably a little bit of a lot of work.

I'm just offering my experience to see if I can help you.

Be sure to calculate it before you do it, otherwise you will print more than 100 sheets at the beginning, so you must try it first. If it is for 100 people, if you want to print a piece of paper for two people, you can prepare 50 sheets of paper in the paper box, and it will stop automatically, and then put the printed paper back in the opposite direction and continue.

Select the menu "File" - "Page Setup" - Worksheet in the menu "Top Header Row" in Excel to select the header row.

It's easy to go and see the big companies.

1.Payroll**.

Payroll** Employee salary** and how is it calculated?

Different companies may have different employee format tables, but the general format is as follows:

Unit: Date of tabulation: Name Standard salary Post allowance Benefit award Overtime pay Total salary Water Fee Electricity Fee Rent Other deductions Medical insurance Housing provident fund Loss of life insurance Union fee Total deductions Actual wages Remarks.

The actual salary can be calculated without calculation, and it will be displayed on the employee's salary sheet.

Extended information: Salary slips, also called salary sheets, are notes that the employee's unit regularly reflects the salary to the employee, but not all units give the employee a pay slip, some units will send the salary schedule to the employee, but some units do not.

There are two types of salary slips, paper and electronic, which record the monthly income breakdown and total income of each employee.

1. Information. A simple salary schedule usually includes: job number, employee's name, basic salary, job salary, welfare expenses, basic insurance deductions (basically refers to five insurances and one housing fund), housing provident fund, payable wages, personal income tax and actual wages.

Salary income has always been a big taboo in Chinese conversations, and it is generally not mentioned casually.

2. Content. 1. Part 1 Income.

2. Part 2 Deduction.

3. Part III Tax deduction.

4. Part IV Actual wages.

As the name suggests, it is called to the bank card, and various fees are removed, and the salary income that can really be obtained can be obtained.

3. Evidence. The salary slip can also reflect the total monthly salary of the employee, whether it is lower than the minimum wage standard, and whether the enterprise has deducted the employee's endowment insurance, medical insurance, work-related injury insurance, unemployment insurance, housing provident fund and personal income tax from the salary, as for other items that cannot be deducted under special circumstances.

At the same time, the collection of individual income tax is based on a certain starting point of wages, and the wage slip can also show whether the employer pays wages according to the time specified in the labor contract, which is reflected in the wage slip, and in the event of a labor dispute, the wage slip should be used as an important evidence for labor arbitration.

Before making a payroll, you need to prepare some materials.

1. The list of personnel, who needs to be included in the salary list.

2. Salary amount information.

3. Personnel attendance.

4. Commission rewards for sales personnel.

5. Fines and rewards for the month.

With a three-column type, the three-column type has three columns: debit, credit and balance. The details of the remuneration payable to employees generally include wages, benefits, social insurance, employee education funds, and trade union funds, and the account pages should be broken down according to the clear description.

The balance of the next page and the previous page should be recorded in the total of the current year, so that the future account does not need to look at the data before the addition, only the data on the previous page. The balance is, of course, the balance of the current month, or the balance as of the time when you pass the page, and all the balances of the previous month, including the previous month, will be carried forward to your current month's balance.

Summary. Hello, I am inquiring for you here, please wait a while, I will reply to you immediately Urgent need for payslip** If you want to be specific, can you help Thank you!

Hello, I'm inquiring for you, please wait a while, I'll reply to you right away I hope the above will help you If you're satisfied with me, please give a 5-star like