• Home
  • Services
    • Accounting Services
    • Bookkeeping
    • Payroll
    • Advisory Services
    • Cash Flow Forecast
    • Consulting for QuickBooks®
    • Training for QuickBooks®
    • Cloud Accounting
  • Products
    • QuickBooks Online
    • QuickBooks Online Advanced
    • QuickBooks Desktop
    • QuickBooks Enterprise Solutions
    • QuickBooks Point of Sale
    • QuickBooks Payments
  • Industries
    • Wholesalers and Distributors
    • Services
    • Construction
    • Real Estate
    • Non Profit
    • Manufacturing
  • Resources
    • Resources
    • Mobile Accounting
  • Blog
  • About
    • About
    • Testimonials
  • Contact
616-610-3750
info@denuylaccounting.com
August 20, 2020

How to Track Employee Time – Part 2 (QuickBooks Desktop)

Marti DenUyl Bookkeeping Tips, Payroll Tips, QuickBooks Desktop, QuickBooks Help

In a previous article, we introduced the concept of time tracking in QuickBooks. Using the software’s tools, you are able to record individual blocks of time that employees have worked and include them in payroll and billing customers when necessary. We went through the steps required to set up QuickBooks for time tracking and walked you through the process of creating individual time entries. A completed record for billable time should look something like this:

Any data you enter on a QuickBooks Timesheet will also appear as a Single Activity, and vice versa.

If you missed that article or need a refresher, you can view it here

Using a Timesheet

QuickBooks offers another way to enter time records that is especially useful if you have multiple employees and many work hours to track. Open the Employees menu and select Enter Time | Use Weekly Timesheet. You can also get there by clicking the down arrow next to the Enter Time icon on the home page. This screen resembles a paper timesheet, with columns for all of the information you would enter if you created a single activity.

At the top of the screen, click the down arrow next to Name and select the correct employee. To the right of that is the Week Of field. If you need to change the dates, click the small calendar, then click anywhere in the correct week. If you have already created individual records for that employee during that week, the information for each will appear in the corresponding date column at the end of the row. Anything you enter on the Timesheet will appear as an individual entry as well.

To create a new entry on the Timesheet, click the down arrow in the Customer column and select the correct Customer:Job. Next, choose the Service the employee provided by again clicking the down arrow in that field. Verify the Payroll Item code is the correct one. Entering Notes is optional, and then enter the number or hours the employee worked for that customer for the service in the date column. Be sure to click in the Billable box to create a checkmark if the service was billable (you plan to bill your customer).

Any data you enter on a QuickBooks Timesheet will also appear as a Single Activity, and vice versa.

Totals for each column appear at the bottom. Save the Timesheet and repeat the process for any other employees as needed. These hours will now be available to you when you run payroll and bill customers.

Time Reports and Invoicing

QuickBooks makes it easy for you to see the time data you have entered. It offers four pre-formatted reports that totals the information in different ways. Open the Reports menu and select Report Center. Locate Jobs, Time & Mileage in the left vertical pane and click on it. Scroll down to the Time heading to see these four reports. They are:

  • Time by Job Summary (tells you how much time your company spent on each job, broken down by services provided)
  • Time by Job Detail (shows you the same thing, but includes employee name and billing status)
  • Time by Name (lists employees and the hours they spent on each job)
  • Time by Item (tells you how much time your company has spent on each service type, broken down by job)

When you open a report, you can double-click on any number in the Duration column to see the underlying detail.

When you create an invoice for a customer who needs to be billed for services provided, QuickBooks displays this message:

To make this standard procedure, check the box in front of Save this as a preference.

QuickBooks offers another way to bill for time and expenses that allows you to create invoices in batches. Open the Customers menu and select Invoice for Time & Expenses. In the window that opens, specify your Date Range, and make sure the Template showing is the one you want.

Click in the column in front of each Customer:Job you want to bill and then click Next Step. You can Review Billables to see details and Edit Options by clicking on those buttons. Click on Create Invoices and make sure each customer’s Preferred Send Method is correct in the next window.

QuickBooks time tracking tools may be all your company needs. But if you find you need additional features, talk to us about adding TSheets, an integrated solution that adds more advanced features.

Watch Out for These Five Common Accounts Payable Errors Six Fun Ideas to Bring into Your Marketing

Related Posts

Blog, Bookkeeping Tips, QuickBooks Desktop, QuickBooks Help

How to Issue Credit Memos and Refunds in QuickBooks Desktop

Bookkeeping Tips, Cloud Accounting, QuickBooks Help, QuickBooks Online

QuickBooks Online Best Practices

Bookkeeping Tips, QuickBooks Desktop, QuickBooks Help

New to QuickBooks? Practice These Activities to Get Familiar with QuickBooks Desktop

Monthly Archives

Categories

  • Accounting
  • Blog
  • Bookkeeping
  • Bookkeeping Tips
  • Business Development
  • Business Growth
  • Business Tips
  • Cloud Accounting
  • Cool Tech Tools
  • Cost-Saving Tips
  • Customer Service Tips
  • cybersecurity
  • Decision-Making Tips
  • Expense Reduction Tips
  • Finance Management
  • Gadget
  • Management Tips
  • Marketing Tips
  • Money Management
  • News
  • Payroll Tips
  • Personal Development
  • Productivity Tips
  • Profitability Tips
  • QuickBooks Desktop
  • QuickBooks Help
  • QuickBooks Online
  • Tax
  • Time Management Tips
  • Home
  • Services
  • Products
  • Industries
  • Resources
  • Blog
  • About
  • Contact

Contact Us

Accounting Services and Services for QuickBooks®

DenUyl Accounting & Software Solutions LLC

Grand Rapids, MI
United States

616-610-3750

info@denuylaccounting.com

Client Login

Client Login DenUyl Accounting & Software Solutions LLC Grand Rapids MI


Intuit, QuickBooks, and QuickBooks ProAdvisor are registered trademarks of Intuit Inc. Used with permission under the QuickBooks ProAdvisor Agreement.
Copyright DenUyl Accounting & Software Solutions LLC 2020 | Site Design by Accelerator Websites | Privacy Policy