How to convert a pay slip into a pay slip

Its practical excel printing salary slips, in the final analysis, is to let excel make a salary **, a line of salary breakdown data, a line of employee records. If we insert a line of payroll breakdown data on top of each employee data, it is obvious that our requirements have been completed, of course, it is obviously an "impossible task" to insert a line by line, and a little skill is needed here.

Step 1: In the two columns on the right side of the salary breakdown, cross enter any number (mainly for the empty value of the "empty space" at the back, so the number can be entered arbitrarily), and then select the four cells that are crossed, and double-click the "fill handle" in the lower right corner, so that this format can be filled until the end row of the salary table (as shown in Figure 1 and Figure 2).

Figure 1 The four intersected cells are selected.

Fig.2 This is the result of the filling.

Step 2: Execute the Start Find & Select Positioning Criteria(s) command, click the Positioning Criteria button in the Positioning dialog box that opens, select Null Value in the Positioning dialog box that opens, and then click the OK button (Figure 3, Figure 4).

Figure 3 Select Targeting

Figure 4 Operation in the Targeting Criteria dialog box.

Figure 5 shows the phenomenon before insertion.

Fig.6 This is the result of insertion.

Step 4: Copy the payroll breakdown data in the header (as shown in Figure 7), select the data area of column A of the payroll table, execute the "Start" "Find and Select" "Positioning Condition(s)" command (as shown in Figure 8), select "Null Value" in the "Positioning Condition" dialog box that opens, and then click the "OK" button (as shown in Figure 9), then execute the "CTRL+V" command, then the payroll slip is completed (as shown in Figure 10 and Figure 11).

Figure 7 Copy the payroll breakdown data in the header.

Figure 8 Select column A of the salary schedule.

Figure 9 Operation in the Positioning Criteria dialog box.

Figure 10 This is the interface that you see after performing the operations shown in Figure 9.

Figure 11 This is the result of the Ctrl+V command (the finished screen).

If you have a certain foundation, it is recommended to use the formula method, put the basic data into Sheet1, and then enter the following formula into A1 of Sheet2, first drag the copy formula to the right, select the data in the first row and drag down to copy the formula.

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

f,int((row()+6)/4),column())

Joyful Payslip Support Quickly convert payslips to payslipsBatch ** million people

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

Companies can be advised on the use of professional payroll toolsA few secondsYou can pay all the pay slips for everyone.

Upload the excel worker quietly hand salary table - the machine automatically disassembles it into a salary slip - for the issuance of the distribution of the dispenser - 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

You can use the vlookup function to apply the column function, and the formula is explained

vlookup (lookup value, area of lookup value, column number in region containing returned value, exact match or approximate match).

column() indicates the column in which the formula is located.

1. For example, the following picture is the auspicious ruler salary table, the header is the red frame area, and the salary slip format is that the same header needs to be inserted on each name:

2. Enter the function content in the red box in box b8, that is, =vlookup($a 8,$a$2:$g$5,column(b1),0), where $a 8 represents the absolute reference sequence number, $a$2:$g$5 represents the absolute reference to the data region to be found, and column(b1) represents the sequence to be searched each time:

3. After entering the formula in the above figure, press the enter key to get the result, and then put the mouse on the small red box of the next early rental figure, when the cross appears, stretch to the right to ensure that the formula logic of the blue box is consistent, and release the mouse to get all the results:

4. Select the area inside the big red box in the figure below, and then place the mouse on the small red box, and when the cross appears, stretch it down

5. At this time, you can see that the header of each name is automatically inserted into it

Steps to make a salary**:

1.Open the software on your computer, such as Microsoft Excel or Google Sheets.

2.Create a new workbook and name it Payroll** or similar.

3.In the first row, enter a title for the salary**, such as the Employee Name, Base Salary, Allowances, Deductions, and Actual Payroll columns.

4.Fill in the employee information and the relevant payroll data on lines 2 to n. Among them, "basic salary" refers to the basic salary received by employees, "allowance" refers to various benefits and subsidies received by employees, such as performance bonuses, transportation subsidies, etc., "deductions" refer to various expenses and fines that need to be deducted from employees' wages, such as social security, provident fund, taxes and fines such as late arrival and early departure, and "actual salary" is the actual salary received by employees.

5.In the last line of **, the "actual salary" of each employee can be calculated using the formula of the number of trips, such as "actual salary = basic salary + allowance - deduction", etc.

6.After the calculation is completed, the table header and data format can be beautified and typeset, which can make the table header and data format more beautiful and easy to read.

7.Finally, save**.

The steps to generate a pay slip for a payslip are as follows:

Tools Raw materials: Dell XPS13-9350-3708, Win10, Excel2019.

1. Open Excel**, add an auxiliary column on the right side of the salary table, and fill in the serial number in the auxiliary column.

2. Select the serial number of the auxiliary column, copy and paste it below.

3. Select the ruler row of the salary table, move it to the bottom, and paste the title on the rows with the auxiliary column number.

4. Move the mouse to the auxiliary column, click "Data-Rank Lose-Ascending" on the menu bar, and re-sort the data according to the auxiliary Lingmin Pin.

5. Select the auxiliary column and the extra header row below, delete it, and the payroll will be converted into a payslip.

Hello, I am glad to answer for you how to generate a payslip in the payroll: to generate a payroll slip in the payroll, it only takes five simple steps to achieve, and the specific operation methods are as follows: 1 5 Add auxiliary columns to open excel**, add auxiliary columns on the right side of the payroll, and roll in the auxiliary columns to fill in the serial number.

2 5 Copy the serial number, select the serial number of the auxiliary column, copy, and paste it below. Big Rock 3 5 Copy Header Row Select the header line of the payroll sheet, move it to the bottom, and paste the header on the auxiliary column numbered rows. 4 5 Sort** Move the mouse to the auxiliary column, click "Data-Sorting-Ascending" on the menu bar, and re-sort the data according to the auxiliary column.

5 5 Delete the auxiliary column, select the auxiliary column in the burning coarse and the extra header line below, delete, and the salary table will be converted into a salary slip. Hope it helps

1.What is Payroll.

Salary table refers to a kind of salary made by the human resources department or financial department of an enterprise in order to manage employee salary, bonuses, allowances and other salary information. The salary schedule generally includes the employee's name, department, position, salary item, actual salary, etc.

2.How pay slips are generated.

The prerequisite for generating a pay slip is that you need to have a complete pay sheet, and here are the steps:

The first step is to calculate the salary according to the salary items in the employee's gross salary list, such as basic salary, performance bonus, overtime pay, etc.

The second step is to fill in the calculated salary items in the salary slip**, and also need to fill in the social security, provident fund and other information.

The third step is to calculate the actual salary after tax deduction and fill it in the pay slip.

The fourth step is to send the pay slip to the employee.

3.The role of the payroll.

The payroll can provide a basis for enterprises to manage employees' salaries, and at the same time, it can provide employees with a way to understand their own salary composition. In addition, the payroll can also provide accurate information on the wages of enterprises and employees for legal, tax, social security and other departments.

4.Considerations for Payroll.

Here are a few things to keep in mind when making a payroll:

First, protect employee privacy and avoid leakage of sensitive information.

Second, ensure the accuracy of the salary schedule to avoid deviations in employees' wages due to errors.

Third, update the salary schedule in a timely manner to avoid salary disputes and legal problems for employees. Posture Pants Town.

5.How to keep your pay schedule confidential.

To protect employee privacy, businesses need to take a few steps:

First, establish a sound authority system, and only authorize relevant personnel to view the salary schedule.

Second, strengthen management and prohibit mobile phone photography, transcription and other behaviors.

Third, increase the publicity and let employees know that it is important to maintain their privacy.

6.The relationship between the payroll and the employment contract.

The wage schedule is a supplement and cooperation to the employment contract, and both parties need to clarify the wage standard and payment method when signing the employment contract. The salary schedule is not only the protection of the legitimate rights and interests of enterprises and employees, but also an important means to avoid legal risks.

7.The importance of pay stubs.

As a carrier to show the salary structure and payment of employees, it is very important. It can intuitively provide employees with necessary salary information and protect the legitimate rights and interests of enterprises and employees. At the same time, the salary slip is also a necessary voucher for credit evaluation, loan application, social security payment, etc.

8.Summary.

Businesses need to create and manage complete payslips in order to generate payslips for their employees and ensure that payslips are accurate, confidential, and timely. The core of the pay slip is to record the composition and actual payment of wages, which has an important legal, administrative and social role. Enterprises and employees need to work together to comply with relevant laws and regulations, protect employees' privacy and rights, and prevent salary disputes and other risks.

The specific steps to automatically generate a salary slip are as follows:

1.Collect employee salary information: First, you need to collect each employee's salary information, including basic salary, performance bonuses, subsidies, deductions, etc. This information can be obtained from the company's personnel system or other payroll management system.

2.Design a payslip template: Design a payslip template based on the company's salary structure and employee information, including headers, payroll items, calculation formulas, etc. It can be designed and produced using office software such as excel.

3.Write calculation formula: According to the company's pure sparrow salary structure and employee information, write a calculation formula to automatically generate the salary information of each employee. Calculation formulas can be written using office software such as excel or using tools such as programming languages.

4.Automatically generate payroll: Use Excel and other office software to quickly generate payroll according to employee information and payslip templates. Payroll can be exported to PDF format or other formats for employees to view and save.

5.Check and review the payroll: After the payroll is generated, it needs to be checked and reviewed to ensure the accuracy and legitimacy of the payroll calculation. It can be checked and reviewed by the finance department or the human resources department.

It should be noted that the automatic generation of salary statements requires accurate information and correct calculation formulas, and at the same time, it needs to be checked and reviewed to ensure the accuracy and legitimacy of salary calculations. It is recommended that companies use professional payroll management software or personnel management systems to improve the efficiency and accuracy of payroll calculations.

The process of automatically generating a pay stub for pay stubs includes the following steps:

1.Determine the salary structure. First of all, it is necessary to determine the salary structure of employees, including salary composition, salary and treatment, and calculation and destruction time, so that the subsequent preparation of salary schedule can be handled in accordance with the prescribed methods and standards.

2.Count attendance hours. Count each employee's attendance hours in order to calculate their actual working hours and thus determine their actual salary.

3.Count the workload. Count the amount of work done by each employee based on their actual working hours, so as to determine their actual salary.

4.Generate a payroll. Based on the information prepared above, use financial software or other special software to generate a salary table according to the formula set for each employee, so as to calculate the actual salary of each employee.

5.Publish the salary schedule. The generated salary schedule is published to each employee so that each employee has a clear understanding of their salary payment and the company's compensation for them.

6.Verify the information. Finally, verify that the information in the payroll is accurate to ensure that the data in the payroll is accurate so that the correct salary can be paid to the employee.