QuickBooks® for Contractors Bookkeeping Tips & Training
QuickBooks Add-On Trials
Request FREE 30-day Trials of QuickBooks add-ons for Certified Payroll, AIA Billing & Payroll Wage Management.
Free 30 day trials of QuickBooks integrated add-ons for certified payroll, aia billing and weighted-average overtime
Show Cart

VIDEO: Batch Timesheet Entry in QuickBooks 2012

Print Friendly, PDF & Email


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.


solutions to save you time and moneyIn 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.
  • Create a paid Holiday schedule and enter paid holidays automatically.
  • Perform “Weighted-Average” overtime calculations automatically.
  • Eliminate the need to manually update employee rates of pay.

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:

Email Delivered by FeedBurner

If you find this post to be helpful, please take a moment to leave a comment or share it with others on your favorite social networking site(s).

One Response to VIDEO: Batch Timesheet Entry in QuickBooks 2012

    Leave a Reply

    This site uses Akismet to reduce spam. Learn how your comment data is processed.

    About Your Host:
    Nancy Smyth, Certified QuickBooks ProAdvisor

    Nancy Smyth, Sunburst Software Solutions, Inc.
    QuickBooks Construction & Payroll Expert

    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.

    Get the latest news

    Sign up to receive information about our newest eBooks, live webinars, pre-recorded video's and free QuickBooks training via email:

    Enter your email address:

    Delivered by FeedBurner

    We promise not to sell, rent, or otherwise distribute your name and email address.

    QuickBooks Time Tracking:

    Save 10%/Free 14 day trial

    QuickBooks Time Tracker