'No installation, no macros - just a simple spreadsheet' - by Jon Wittwer Using the Payroll Register Recording Daily Hours Worked

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. 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.ĭepending on how you are keeping your records, you may want to add information to the payroll register, or remove it. 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. I've kept this spreadsheet fairly basic, so depending on your business and policies, you may find that you need to add more columns. This Employee Payroll Register spreadsheet was designed for small businesses that choose to use an accountant or online payroll service (like or ).