Free bi-weekly timesheet template

Download our free bi-weekly 2019 timesheet template to track employee hours, overtime, vacation days, and more.

How to use the bi-weekly timesheet template

The bi-weekly timesheet template is a semimonthly, or two-week, timesheet for tracking employee time. The template is printable and optimized for Excel. Use our bi-weekly timesheet template for employee hours, overtime, vacation days, and even lunch breaks.

Want to do away with manually tracking and entering time for payroll? QuickBooks Time is an  online time tracking  solution, available free for two weeks. Use QuickBooks Time accurate time tracking to grow your business and better manage employees.

Step 1: Download the bi-weekly timesheet template of your choice. Please note, values on XLS files can be filled in on your computer. Make a copy of the Google Sheet to fill in values on your computer. If you’re using the Google Sheet online, “Total (Hours)” will need to be added manually based on clock in/out times. Hours, rates, and sub-total formulas will calculate automatically. Word and PDF files are read-only, so print a paper copy for best results.

Step 2: Fill in your employee’s name, their manager, your company’s name, the pay period start date, your employee’s standard pay rate, and your employee’s overtime pay rate.

Step 3: Employees can fill in the day, date, job/shift, job/shift code, their time in/out (including breaks), and any remaining hours (overtime, sick, holiday, and vacation).

Step 4: When it’s time to hand the timesheet in, employees sign the top of the form. Managers can then calculate the employee’s total time for payroll.

Government compliance checklist

Before using any timesheet, we highly recommend checking to ensure you and your employees are adhering to government compliance guidelines. Here are three of the most common laws being broken, though there are many to be aware of. To avoid any trouble (and paying out too much on payroll), consider these important questions.

More templates and timesheet options

Interested in handy timesheet solutions from QuickBooks Time? Here are four more timesheet solutions for you to try.

Timesheet software

QuickBooks Time timesheet software is a cloud-based time tracking solution. Accurately track time against employees, jobs, or materials. For mobile workforces, GPS enables you to see who’s working where, at any time. No more guesswork. Precision timesheets.

Image Alt Text

Time card calculator

This time card calculator is useful for the unique needs of both managers and employees. Employees can easily calculate their expected pay for the week based on their hours worked. Managers can calculate break times and overtime options.

Image Alt Text

Weekly timesheet template

This weekly timesheet template for Google Spreadsheets, Adobe Reader (PDF), Microsoft Word, and Microsoft Excel is free and easy to use. The template factors in your employees’ breaks, lunches, and in/out times.

Image Alt Text

Bi-weekly time card calculator

This bi-weekly time card calculator tracks two weeks of work at a time. Tracking time on a bi-weekly (or semi-monthly) basis means your payroll department saves time on processing. Submitting timesheets and reviewing documents less frequently gives your team more time to perfect processes that grow the business.

Image Alt Text