How to make an employee roster based on payroll

1. The wage payment table of employees of the enterprise shall have the content of "serial number, name, wages payable (sub-items and totals under the column), deduction amount (sub-items and totals under the column), actual amount, front of the recipient, and remarks and suspicions".

2. The roster of employees of the enterprise.

It should have "serial number, name, gender, date of birth, culture, place of origin, job rotation position, working hours of the unit, contract period, body early basic certificate number, remarks" and other contents.

3. The payroll is mainly to record the basic information of the payroll, such as name, gender, age, entry time, position, bank and other information.

4. The wage table is the actual calculation of wages, which specifically lists the salary composition and corresponding amount of each person.

Excel is our commonly used office software.

Then you know how excel hires the staff roster.

Excel**, a computer.

01 First of all, let's create a new electronic ** and add the content of the employee roster.

02 Determine whether the data in ** is correct.

The first method is to enter data selectively.

Such as column items"department"、"Whether you are married or not"、"Education"、"Political outlook.

Nation"、"Type of insurance"。

03 The second method: shortcut the data entered.

Date data can be directly pressed and held "Ctrl" + to quickly enter the current date.

04 The third method: enter the data directly by hand.

Slowly enter the data content by yourself.

05 The fourth method: formula entry.

Date of birth--- date(mid(g2,7,4),mid(g2,11,2),mid(g2,13,2)).

Gender---if(mod(mid(g2,if(len(g2)=15,15,17),2)=1,"Male","Female")

Age---year(now()))year(h2)) is a phase --- mid("Monkeys, chickens, dogs, pigs, rats, cows, tigers, rabbits, dragons, snakes, horses, sheep",mod(year(h2),12)+1,1)

Seniority. --datedif(e2,today(),y"Number of days of annual leave -- hlookup(n2,,2) contract duration ---t2-s2) 365

Let's choose the formula you need.

You can just do it yourself with **. For example, a summary table of basic information of employees, the transportation shed mainly includes:

1. Serial number 2, surname and name 3, gender 4, date of birth 5, ID number 6, professional 7, position 8, professional title 9, remarks side shed.

The salary roster of employees of the enterprise is made according to the bonus payment table of personnel, and the financial form is mainly for the signature of the recipient. According to the amount determined by the boss, the payment amount is made according to the head of the unit, and the payee must sign and enter the account, but the form should be signed and approved by the boss before the distribution.

The Social Security Administration requires employers to provide a pay slate. This has to be true, otherwise it would be incorrect to pay for social security, which is a serious financial problem. A company's HR department is generally sound and often has an employee salary template that calculates employee salary income based on employee salary, work allowances, performance appraisals, bonuses, five types of insurance, and one payment (company and individual payment), among other things.

The wage payment form of employees of an enterprise shall have the contents of "serial number, name, wages payable (sub-items and totals under the column), deduction amount (sub-items and totals under the column), actual amount, front of the recipient, and remarks column".

The roster of employees of an enterprise shall have "serial number, name, gender, date of birth, culture, place of origin, position, working hours of the unit, contract period, ID number, remarks" and other contents.

1. First open Excel work**, as shown in the figure below.

2. Then enter the title of the employee roster on the first line of **.

3. After that, enter the elements of the employee roster on the second line, which can be referred to the figure below.

4. Then under the "Start" menu bar, find "Frames", select "All Frames", and frame all the areas in the range, as shown in the following figure.

5. Merge and center the "Title" cells, first circle the area to be merged with the mouse, and then find "Merge" on the upper menu bar, as shown in the following figure.

6. Next, merge the elements such as "Number", "Department", "Position" and so on (Note: The order of merging cells must be noted, first select the area that needs to merge cells, and then click Merge), as shown in the figure below.

7. Finally, enlarge the ** title, and adjust the line height and column width of **, try to keep it in the printing area of A4 paper, and the effect of adjustment is as follows.

1. On the computer desktop.

wps is found on as shown in the image below.

2. After opening WPS, click New at the top of the page, as shown in the figure below.

3. Click ** at the top of the page, as shown in the figure below.

This is shown in the figure below.

This is shown in the figure below.

6. Click on the employee roster that appears below, as shown in the figure below.

7. Choose a template you like, as shown in the figure below.

<>9. As shown in the figure below, the employee roster is ready, and the content can be entered in the corresponding position by dyeing back.

You can just do it yourself with **. For example, a summary table of basic employee information mainly includes:

1. Serial number 2, name 3, gender 4, date of birth 5, ID number 6, major 7, position 8, title 9, remarks.

1. Open Excel** and enter the title of the roster in the shed grid of unit A1.

2. In the second row of cells, enter the serial number, name, gender, origin, education level, position, title, contact**, time to enter the company, remarks and other information.

3. Select the entered text and blank line, click [Start] on the menu bar, and find [Border is Sleepy] to add the upper cousin and the frame line.

This question can be answered like this!

When filling out the employee roster, you need to collect and record the basic information of each employee. Here's what you need to fill out for a common employee roster:

1.Name: The employee's full name or name.

2.Gender: The gender of the employee.

3.Job title: The employee's position or job position.

4.Department: The department or branch to which the employee belongs.

6.ID Number: The employee's ID number (to ensure the authenticity of the identity).

7.Date of Birth: The employee's date of birth.

8.Onboarding date: The employee's start date or contract start date.

9.Termination date (if applicable): The date the employee left the contract or the date the contract was terminated (if the employee has left the company).

10.Bank account: If the employee needs to be paid, the bank account information of the employee needs to be provided.

In addition to the above basic information, you can add other custom fields according to your actual needs, such as the employee's skills, certificates, emergency contacts, etc.

When filling out the employee roster, you can choose to use Excel** or specialized HR source management software to record and manage employee information. Choose the right tool based on your data volume and management needs.

Ensure that employees' information is kept confidential and take appropriate measures in accordance with personal privacy regulations and company policies. At the same time, the employee roster is regularly updated to maintain accuracy, especially when there are employee departures, transfers, or information updates.