Timesheet Register Template
Download a free Timesheet Tracking Template for Microsoft Excel®Our Timesheet Register is a helpful tool for small businesses that do not require sophisticated timesheet tracking software. This spreadsheet is a combination of the Employee Payroll Register and the Timesheet Register borrowed from the Payroll Calculator I developed a few years ago. Use the Employee Register to record employee information and the Timesheet Register to keep a record of the hours worked and payroll payments. Although we do offer more sophisticated tools which relatively complex solutions, such as our Payroll Calculator and the Paycheck Calculator to compute net pay, the Timesheet Register might be all you need for your business. Continue below to learn more and download this spreadsheet.
Timesheet Tracking Template
for Excel, Google Sheets & OpenOffice.org Calc
Categories
Timesheets & Payroll BusinessScreenshots
1 2License
Specifications
Description
The Timesheet Register is a relatively basic spreadsheet and, for most parts, it is self-explanatory. I have incorporated all essential elements into the design, which corresponds with the majority of our timesheet templates, in order to facilitate synchronized use of several templates. This is a highly flexible spreadsheet and it is easily adaptable to specifics of your business. I recommend consulting your accountant to make sure you are keeping appropriate records in compliance with record-keeping requirements applicable to your organization.
Our spreadsheet includes two parts on separate worksheets, the Employee Register and the Timesheets Register.
The Employee Register worksheet is intended for recording employee payroll information, such as employee ID, name, sex, higher date, occupation, salary or hourly wage, tax filing status, federal allowances, state and local taxes, as well as information about other current deductions and contributions.
The Timesheet Register worksheet is where an employer can keep track of the summary of employee hours, which can include regular and overtime hours, vacation hours, etc. Additionally, you may also want to record payment dates, federal, state and local tax withholdings, social security and Medicare taxes (FICA), insurance and other deductions.
Using the Timesheet Register
Recording Weekly Hours Worked
The timesheet register allows entering regular hours, overtime, holiday, vacation and sick pay hours. In addition to hours, you can also enter the amounts broken down into reimbursement, taxable compensations and non-taxable deductions. Some of the columns include formulas, which may need to be adjusted, if you decide to add new columns.
The intention behind creating this Timesheet Register was to save as much time as possible in a business, without compromising other important work. We hope it helps you accomplish just that for your organization.
Related Content
Timesheet & Payroll References and Resources
- American Payroll Association at AmericanPayroll.org - An extensive source of information about everything payroll related. Includes certification programs.
- Record Keeping Obligations for Employers UK at XpertHR.co.uk
- Record Keeping Requirements for Employers US at www.dol.gov
