Who should do the payroll? How to do the salary scale

It depends on the company's regulations, and each company's regulations are different. Most of the companies I have experienced are in charge of the human resources department or the administrative personnel department, and the finance department mainly plays a supporting role. The formulation of this ** is a common matter for the human resources department or the administration department (personnel department) and the finance department.

It's best if the two departments sit down and work out together. The relevant data is filled in by the department that calculates the salary. The accounting of the finance department is only a review; Finally, it is approved by the general manager.

The cashier is responsible for paying wages. Sign the payroll when you pay your salary.

It should be done by the human resources department, after summarizing the assessment, calculating the salary, and then submitting it for approval, and finally sending it to the finance for distribution, the finance should only be distributed, regardless of the assessment!!

It should be done by the system: first, the information department should design a program for attendance card and payroll forms; Secondly, before the end of each month and the last day of work, the personnel department will settle the attendance assessment of all personnel in the month into the system (in fact, it is a matter of entering the form every day, and each department must also report every day); Thirdly, after the financial department enters the information such as tax deduction into the program, it can go through the procedures for the release of wages. If there are any problems, the personnel department will convene the information department and the finance department to discuss and solve them.

Finance, of course, but the office can provide the data, and you can even calculate it first and then let the finance reconcile.

1. In this salary table, two formulas need to be used: addition (basic salary + performance salary) and quiet subtraction (total salary, salary deducted from sick leave).

2. Click the enter key on the keyboard, and the calculated number will be displayed in the number **. Take advantage of the ability to copy cells. Put the mouse on the right side of the number of ** to lift the corner of the town, press the left mouse button, the computer will show a black + word mark, pull the mouse down, and the following ** will be substituted into the calculated formula with the positive luck rough sample.

3. Save the good ** and open it next time you need to use it. If you need to make a lot of the same kind of **, such as the monthly salary value will be different, you can copy the good ** or establish a copy.

If you want the company to pay pay slips more formally, you can give advice to the company and use a professional pay slip tool to send everyone's pay slips in a few seconds.

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

And the professional pay stub tool is more powerful in terms of features.

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.

The payroll is as follows:

1. When making wages, labor-management personnel generally use the format shown in the figure below, which is convenient and easy to use.

2. Copy the content of row 1, and then paste it to the bottom of the table, and determine the number of rows to be copied and pasted according to the specific number of people.

3. In the last column of **, start with the first person and number it sequentially until the last person, and the copied header row is also numbered sequentially.

4. Select the "Data" menu and click "Sort" to open the sorting dialog box.

5. In the sorting dialog box, select the last column of ** for "Main Keywords", and then click OK.

Payroll

Wage statements should generally be prepared in triplicate. One is stored and checked by the labor and labor department; One copy is cut into a "wage slip" according to the first employee, and is issued to the employee together with the salary.

A copy of the salary is signed by the employee and submitted to the accounting department as a voucher for wage accounting, and is used to replace the detailed accounting of wages. Since the wage settlement statement is prepared separately according to each workshop and department, it can only reflect the wage settlement and payment of each workshop and department.

In practice, enterprises pay wages to employees and handle wage settlements through the preparation of "wage settlement tables". Wage statements should generally be prepared in triplicate. One is stored and checked by the labor and labor department, and the other is cut into a "wage slip" according to the first employee, and issued to the employee together with the salary.

A copy of the salary is signed by the employee and submitted to the accounting department as a voucher for wage accounting, and is used to replace the detailed accounting of wages. Since the wage settlement statement is prepared separately according to each workshop and department, it can only reflect the wage settlement and payment of each workshop and department.

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 you passed the page, and the balance of the previous month, including the previous month, will all be carried forward to your current month's balance.

Excel sheet making1. Sort the pay slips1. Let's add an auxiliary column next to it, enter the sequence, fill it down, and copy it.

2. Copy the header row, then fill it in the blank sequence below, then position the cursor to the auxiliary columns, enter the data - sort and filter, select ascending or descending order, and finally remove the extra auxiliary columns before deleting the group.

3. Finally, add a border line to our pay slip.

Second, the function generates pay slips1. Let's add an auxiliary column at the very beginning of the pay scale, and then enter the series.

Copy the header row to the sheet2 sheet, enter the number 2 in cell A1, and enter the formula::in cell B2

vlookup($a2,sheet1!$a:b,column(b:b),)

2. Add border lines to the payroll.

3. Finally, select these two rows of cells, fill them down, and you can drag out all the payroll records.

After we make the pay slips, we can print them and cut them into one by one to become pay slips.

Made with an electronic pay slip toolOpen the official website of Enjoy Pay Slip (

1. Upload the salary statement.

2. Select a pay slip template.

3. Carry out the configuration of the search and release of the hair.

4. Immediate or regular distribution.

Have we learned now?

It can be made with an excel sheet.

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 breakdown.

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 of the previous page is on the line. 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.

Name, post salary, annual merit allowance, skill allowance, performance salary, health allowance, night shift allowance and safety award, overtime salary, back wages, wages payable, pension insurance, medical insurance, unemployment insurance, housing provident fund, other insurance, income tax base, personal income tax, other deductions, actual wages, and the signature of the recipient.

Among them, the salary payable = post salary + annual merit allowance + skill allowance + performance salary + health fee + night shift allowance and safety award + overtime salary + retroactive salary.

Here's how to make a payroll:Tools:macbookair、。

1. Hit the base pure open excel**, and select the cells that are needed to disturb Zheng.

2. Click on the merge cell above.

<>4. Enter the required header: name and salary.

5. Box select the cells you need.

6. Click on all the boxes above.

7. The salary production template operation has been completed.

Summary. Hello dear, happy to answer your <>

1. First of all. Open Excel and enter the header information for Payroll starting from the second row cell.

2. Add a frame; Select the table header and the blank cell row below, add a border line, and adjust the row height and column width. 3. Add a title; Enter the title of the payroll at the top of the header, set the title in large font, and align it in the center. <>

How to do the salary scale

Hello dear, happy to answer your <>

1. First of all. Open Excel and enter the header information for Payroll starting from the second row cell.

2. Add a frame; Select the table header and the blank cell row below, add a border line, and adjust the row height and column width. 3. Add a title; Enter the title of the payroll at the top of the header, set the title in large font, and align it in the center. <>

1. New **: On the computer, create a new worksheet 2. Enter the title; Enter the title of the worksheet, the work release schedule. Enter the month and header; 3. Enter the month in the second row of the worksheet.

In the third line, enter the header of **, number, name, department, job category, basic salary, bonus, subsidy, payable salary, social security deduction, provident fund deduction, other deductions, actual salary, etc. set the header and header; 4. The 13 cells of the title are merged and centered, and the 3 cells of the month are merged and centered. Add borders; 5. Select the area where you need to add a frame, click [Start] in the menu bar, find the frame setting, and add a frame to **.

Set Font & Adjust**Click Start in the menu bar to find the font settings and alignment settings, and set the font and position of the title, month, and table header. Adjust the row height and column width of **.

The so-called standard working hour system, which is now the mainstream working hour system, is to do 5 days off and 2 days off per week, working 8 hours a day, and working 40 hours per week. Overtime is up to 3 hours per day and no more than 36 hours per month.

Among them, attendance deduction = monthly salary income actual salary days in the month * number of days that should be deducted. Note that the monthly salary income here refers to the fixed part of the employee's salary, such as basic salary, post salary, allowance, subsidy, etc.

The actual number of paid days in the current month = the number of days of attendance in the current month + the number of statutory holidays. Note that the actual number of paid days in the current month is different from month to month, excluding rest days, only the number of days of attendance and statutory holidays in the current month. Don't use days as the number of pay days, but the system pay days are an average number, which is mainly used to calculate overtime pay.

Individual contribution accumulation = pension + medical care + unemployment + provident fund.

Payable salary = basic salary + post salary + performance salary - attendance deduction - other deduction + subsidy. Attendance deductions include: sick leave, personal leave, tardiness, and absenteeism. Other deductions cannot exceed 20% of the current month's salary.

Actual salary = salary payable - individual payment accumulation - individual income tax. The pre-tax figure in the individual income tax is to deduct the attendance deduction, other deductions, social security, provident fund, special additional deductions, and other deductions determined in accordance with the law, etc., and then subtract the amount of the threshold (5,000 yuan in Beijing), and then calculate the individual income tax according to the tax base.