Download Employee Payroll Register Excel Template

Contents

Popular Categories in Excel Template
Trednding in Excel Template

Checkbook Register

Normally, we use a hand-written check register because of debit cards, credit cards or online …

Read More

Family Tree 6 generations

Family tree 6 generations for my research, I wanted to see more than 4 generations …

Read More

Marketing Budget

A marketing budget is a target amount of cost that is essential to promote existing …

Read More

Wedding Guest List

Use our free Wedding Guest List template  or withjoy guest list template to help you track …

Read More
Search
Generic filters

As a new employer, I am about to create a Payroll Calculator but in the process learned that there were too many laws and regulations associated with payroll while using a spreadsheet for calculating payroll. I did create a Paycheck Calculator to estimate tax holdings and calculate net take home pay. But, instead of integrating that into a payroll calculator spreadsheet, I have an accountant process for my payroll and I use a Payroll Register spreadsheet to keep a record of employee informationpayroll payments, and hours worked

Payroll registration

This Employee Payroll Register spreadsheet is design for small businesses that choose to use an accountant. I’ve kept this spreadsheet basic, so depending on your business and policies, you may need to add more columns.

The Employee Payroll Information worksheet is where you can record information. Just 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 the track of summary of hours worked, payment dates, federal and state tax withholdings, FICA taxes, and other deductions.

Depending on how you keep your records, you may want to add information to the payroll register, or remove it.

There may be specific record-keeping requirements. So check with the accountant to make sure that you are keeping appropriate records.

Payroll register report

Recording Daily Hours Worked

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

Recording Regular Pay, O.T. Pay, and Reimbursements

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.

Download Employee Payroll Register Excel Template

To use this free Excel Template, you should have Microsoft Office/ Microsoft Excel. You can only use this template if you have these applications in your system. or Use, Google Sheets. 

After installing Excel or Spreadsheet, download the xlsx file of this template to use it

Once extracted, you can open the file using Excel and start entering data or customizing the template.

Click The Button Below To Download Employee Payroll Register Excel Template

Instruction :

All Excel templates and tools are sole property of xlsxtemplates.com. User can only download and use the excel templates for their Personal use only. All templates provided by XLSX templates are free and no payment is asked. However, you are not allowed to distribute or share in any other website for sole purpose of generating revenue from it.

 You can also download and use our 1000 Best PowerPoint Presentation Templates and 500 Resume Samples from PPTXTemplates.com  Completely Free. All our templates are designed by Professionals

Popular Excel Templates: