Tips for using company payroll How to prepare company payroll?
Salary can be divided into basic salary, commission, performance and additional allowances, etc.:
Basic salary: It is a fixed amount per period per month.
Commission: It is based on the turnover of individual employees such as salesmen, salesmen, real estate agents, travel agency tour guides, etc., the more you work, the more you get.
Performance: It is the amount of output produced by the company's employees in their labor.
Subsidies: including high temperature allowance, mid-night shift allowance, transportation allowance, rent allowance, telephone allowance, meal allowance, etc.
General tips for company payroll forms
1: Automatic line wrapping
After typing the text in the cell, find the "Automatically wrap" button on the toolbar and you can freely switch the text between wrapping and not wrapping.
2: Quickly select specific columns
Select the table area, click the "Create from selected content" dialog box under the [Formula] tab, select "First Row", after the settings are completed, open the name box in the upper left corner, click the corresponding list to jump to the specified column.
3: Format brush
The use of Format Painter is very simple. Just click on Format Painter, then select the format you want to copy, and finally select the cells you want to modify. You can modify it in batches.
Recommended by the editor of Huajun Software Park Company salary scheduleIt is a free Excel template, download it if you need it! Huajun Software Park provides high-quality Excel template downloads.Account password management form,Total employee bonus tableDownload to get the source file, which you can edit, modify and replace. To download the company salary table, go to Huajun Software Park.





















Useful
Useful
Useful