VIDEO: Batch Timesheet Entry in QuickBooks 2012

Need a productivity boost? Try the Batch Timesheet Entry feature in QuickBooks 2012 to enter hours for multiple employees (or Vendors) at the same time.

Entering employee time in the Weekly Timesheet in QuickBooks is a painstakingly slow process, especially if you have a lot of employees – QuickBooks 2012 solves “some” of that with the new Batch Timesheet Entry feature, but it’s still not perfect or very flexible.

Entering timesheets for multiple employees or vendors all at the same time will be a huge productivity booster for some companies – but only in very specific situations.

All employees {or Vendors} must:

Work on the same Job

Be costed to the same Service Item

Be paid under the same Payroll Item

Work the same hours each day

These requirements only exist in a “perfect” world, one which seldom exists in a busy construction company!

Here’s a YouTube video that shows you the Batch Timesheet feature in action and discusses some of the potential pitfalls that you can encounter.

In the real world, the QuickBooks Batch Timesheet feature will not be much of a productivity booster for many construction companies – they will want a more robust solution that will solve nine (9) critical and missing needs for their QuickBooks employee time card entry processes.

Automatic Overtime calculations, based on the laws that your state requires you to follow.

The ability to create “crews or groups” of employees who regularly work on specific jobs or projects.

Assign employees to the same group multiple times with different rates of pay OR assign employees to multiple crews.

Enter time by crew, by job, by day; using ALL straight time hours – and post this back to your QuickBooks Weekly Timesheet.

Enter timecards for hundreds of employees with a few clicks of your mouse.

Eliminate the need to manually calculate or enter Overtime or Double time hours worked by each employee.

If you are looking for a more robust solution that eliminates the need for numerous manual calculations, check out Crew/Overtime Entry Solution – a QuickBooks integrated application designed specifically to solve real world problems.

Want more QuickBooks tips & training like this? Enter your email address below to be notified via email each time we add something new to this site:

I've been using and supporting QuickBooks products since the early 1990's. I've worked with thousands of contractors, assisting them with QuickBooks setup, Certified Payroll Reporting requirements, AIA Billing and Weighted-Average Overtime.

QuickBooks is a powerful product, but learning how to use it in your construction business can be difficult. I hope you find resources available here to be helpful.

Sunburst Software Solutions, Inc. has been an Intuit Developer Network member since 2001; first as a Premier Member and then one of the first 13 developers to achieve Gold Developer status in 2006.
QuickBooks and the Gold Developer logos are trademarks and/or registered trademarks of Intuit Inc., displayed with permission.

Learn to use QuickBooks® in your construction business - QuickBooks® for Contractors Bookkeeping Tips & Training is part of the Sunburst Software Solutions, Inc. family of QuickBooks® related products and services.