for a short time changed the paradigm of the importance of human resources within an organization. Therefore, having a good administration is a key success factor.
Having constant control and monitoring of the movements that employees make within the company is not an easy task. Therefore, payrolls are created to help the department in charge in its tasks.
This makes Excel an important tool to achieve success.. If you want to know how you should do to have control of your employees, continue reading.
What is a payroll and what are all the types that can be created in Excel?
Payrolls are lists with all the names of the people who work in a company. It has the characteristic that used for personnel and human resource administrationso they are very useful for monitoring and controlling each worker and also for a correct settlement of salaries at the end of the month.
There are different types of payroll. For example, you can find listings that are divided according to the weather, so you can find daily, weekly, biweekly, monthly and even annual periods. You can also find payrolls that are designed according to the hierarchical category of the staff or those that are dedicated to the control of nominal or extraordinary hours related to the presence in the company and the position they develop.
Finally, you can find payroll oriented to the liquidation of salaries. Therefore, each employee’s registrations and withdrawals must be included, as well as the absence and control of hours worked in each sector.
Steps to make a payroll of any type in Microsoft Excel like an expert
We will show you below the necessary steps that you must follow so that you can make a payroll quickly and easily. You can use a template or do it manually. With both methods you will have a perfect result.
Check out!
with a template
To create a template named you will have to follow this guide:
- Open a new spreadsheet in Microsoft Excel.
- Go to the File tab.
- Click on New.
- Type the word payroll in the Search templates online bar.
- Below, you will find a list of the best templates that Microsoft Office can offer.
- Choose the one that suits you best and click on it.
- You will see that a new sheet will open with the template. Start editing it to suit your needs.
manually
Take as an example that you need to have the data of your 5 employees updated. You must enter your ID, date of birth, address, position and date of entry into your company.
In case you want to do this task manually and have a complete payroll, you will have to do the following steps:
- Open a new Excel document.
- In cell A1 Begin by writing the names of the five people from top to bottom.
- Next, position yourself in A1 Y add a top row. In A2, A3 successively write the title of each column, which will be all the data you want to update. In this case it will be ID, date of birth, etc.
- When you’re done, you can start charging each employee for the items you need.
Once you have finished it is the turn to give it a professional format. For that you will have to follow these steps:
- Select everything you have written.
- go to “Start”look for the group “Font” and choose some border you like. To do this you will have to select the drop-down menu of the tool “Edges”.
- Now, you can choose the filling by selecting the function “Fill color”.
- If you prefer, you can change the font format choosing bold, changing the size or type. you can also rename sheet by double clicking on it. Or add color by right clicking on the tab.
So you can save timeyou can apply filter to more quickly find the employees or different categories of data you need to search for.
List of the best payroll templates that you can download to do in Excel
Next, we will present you the best payslip templates that you can download for Microsoft Excel:
payroll calculator
with this template you can have the information of all your employees and then deduct deductions and other expenses so that you can correctly print the payment receipts. It is characterized by having, by default, filters so that the user can work more comfortably.
Employee Time Card
If what you are looking for is to control daily or monthly the entry and exit times of each employee, you can use this template that will help you keep a record for each worker. You will have the possibility of obtaining information on nominal hours and overtime.
Timesheet to fill
This template will allow you to a follow-up of all the hours that the worker is in your company. You can also write down vacation days and sick leave. It is an Excel spreadsheet that you must take with you for each job.
payroll of hours
Like the previous template, this Excel sheet format It will help you have control over the monitoring of salaries of each of the people who work in your company. It is very simple to fill it out and in the end you will have the result of the salary that you must earn according to the hourly rate.
Timesheet Template
If what you are looking for is to have exhaustive control over the salary of one or several employees who are paid by the hour, you can take this template into account. will help you track according to hours worked and overtime that he has had in the month. It will also be possible to register the absences that are made due to illness or absenteeism.
Scheduling of Work Shifts
When you need to keep track of every single day worked, this template could come in handy. Unlike the previous ones, one must be carried out for each day and not one per employee. In this way all entries, intervals and exits made by each worker are recorded.
Employee Holiday Calendar
Each time the period for granting vacations to employees arrives, it is a headache, since the coordination that must exist in order not to leave positions vacant is a challenge. Agree with this, You can use this template that will help you by means of several sheets to carry out an exhaustive control of each working day so that the vacation period can be established correctly.
Hourly Work Calculation
This template is useful when you need to have a follow-up per week of the hours that must be worked so that the rhythm of production and other operations is not affected.
High and low of employees
With this template you will be able to have a complete knowledge of each employee who works in your company. You will be able to know the start date, the department that is assigned and the day the cancellations were made. Then you can have a graph to analyze the situation and be able to make correct decisions.
absence of employees
so you can control the absence of employees per month and for each reasonyou will have the possibility to use this template that will help you to carry out the task with excellent results.
Facebook Comments
Disqus