Excel template for payroll calculations

This Employee Payroll Register spreadsheet was designed for small businesses that choose to use an accountant or online payroll service like Intuit. I've kept this spreadsheet fairly basic, so depending on your business and policies, you may find that you need to add more columns. The Employee Payroll Information worksheet is where you would record information like name, ID, address, sex, occupation, hire date, salary or wage basis, exempt status, federal allowances, and other information about current deduction and contribution elections.

The Payroll Register worksheet is where you can keep track of the summary of hours worked, payment dates, federal and state tax withholdings, FICA taxes, and other deductions. Depending on how you are keeping your records, you may want to add information to the payroll register, or remove it. There may be specific record-keeping requirements that apply to you, so check with your accountant to make sure that you are keeping appropriate records.

In the Payroll Register worksheet, columns E-K Daily Hours Worked are hidden by default, because if you are keeping a record of employee timesheets elsewhere, you may not want to duplicate that information in the register.

If you want to record payroll payments broken down into regular pay, overtime pay, and reimbursements, you can unhide Columns R-T and then make the Gross Pay column a formula. The guide, both in text and video, will take you through some important questions like how to set up employees, enter hours worked, review calculations, and so on.

I recommend you go through everything before using the template. Time for some freemium options. The Spreadsheet has created a free or light and paid payroll calculator Excel template.

Try the free version and go through their guide before buying the paid version. One of the benefits is updates that reflects changes made in taxes at the state and federal levels. They recently updated the sheet to incorporate changes made in the year There is a demo video that will walk you through the steps. It also supports OpenOffice. Another Excel sheet to manage and track payroll and time of the employees.

Nothing fancy here. A simple sheet with columns for entering names, daily rate, and title of the worker in case you have more than one,. The template is color-coded where working days are denoted by blue and non-working days are denoted by off-red color. That makes it easier to get an understanding of the activity level of the workers at a glance.

Note that the free version cannot be modified and has a single user license. Different businesses have different needs, operating in different niches, sizes, and sectors. As such, there is no one size fits all payroll management and timesheet Excel template.

For travel business folks, there is a payroll template for tracking mileage. Do you have employees working multiple shifts? Employee Shift Schedule or Work Rotation should help. There are more than 18 templates and you can always edit them to your liking. Note that these templates are for private use only and not meant for redistribution or resale. Employee timecard. Blue timesheet. Employee attendance record. Time sheet weekly. Employee payroll calculator.

Weekly time sheet by client and project. Biweekly timesheet with sick leave and vacation. Biweekly time sheet with sick leave and vacation. Weekly timesheet. Employee attendance tracker.