How to track time in QuickBooks Desktop
When you sell a product to a customer, you know it. It goes away, and your inventory count in QuickBooks is reduced by one. This tracking helps you know what is selling and what is not, and it signals when a reorder is due.
If your business provides services to customers, though, you are selling your employees’ time and skills. There’s no inventory count; you can sell as many hours as you have workers to fill them. Tracking time accurately and comprehensively, though, is as important as knowing how many hard drives or tote bags you’ve sold.
QuickBooks contains tools to help you record the number of hours employees spend doing work for customers, so you can bill them for services rendered. There are also QuickBooks Add-Ons like TSheets Time Tracking Software that improve on these features and add additional functionality to help with reporting, job costing, real time GPS tracking, etc. If you would like to schedule a demo of TSheets, please contact us at 503-885-0776.
For basic time tracking, you can use the features within QuickBooks to enter employee time for payroll purposes. The software offers two options here: single-activity records and timesheets.
Building the Foundation
QuickBooks’ Preferences have been around many times before. The software was designed to support small businesses with a wide variety of structures and needs, so it needs to be flexible. For that reason, we always recommend that you check in with your “Preference” options before you explore new features.
To get to the preference options open the Edit menu and select Preferences. In the left vertical pane, click on Time & Expenses, then on the Company Preferences tab at the top. Take a look at the top part of the window that opens:
Figure 1: The Company Preferences window for Time & Expenses displays multiple options.
To make sure that QuickBooks’ time-tracking features are turned on before you start, click the button next to Yes under Do you track time? Specify the First Day of Work Week by opening that drop-down list. If you know that all your time entries will be billable, click in the box in front of that statement.
The other options in that window will be discussed next month in Part 2.
Creating Service Items
Before you can start tracking billable time, you have to create a record for each service offered–just like you would for a physical product. Click the Items & Services icon on the home page or open the Lists menu and select Item List. The window that opens will eventually display a table containing all the items and services you’ve created.
To define a service item, click Item in the lower left corner, then New, to open a window like this:
Figure 2: You can create numerous types of items in QuickBooks; Service is one of them.
Click the down arrow in the field under Type to see your options here. There are many, ranging from Service to Inventory Part to Sales Tax Group. Select Service. In the field under Item Name/Number, enter a word or phrase and/or number that describes the service, and that won’t get confused with another.
If you had already created an item like “New Construction Services” and you wanted “Carpet Installation” to appear as a subitem of it, you would click in the box in front of Subitem of to create a check mark, then open the drop-down list below it and select “New Construction Services.”
Ignore the Unit of Measure section. If this designation is important to your business, call the office about upgrading your version of QuickBooks. You should also contact the office if the service you are defining is used in assemblies or is performed by a subcontractor or partner, as these are more advanced situations.
Enter a brief Description in that box and your hourly charge–to the customer–in the field to the right of Rate. Click the down arrow in the field next to Tax Code to select the item’s taxable status.
It is very important that you get the next field right. QuickBooks wants to know which account in your company’s Chart of Accounts should be assigned to this item. In this case, it would be “Construction Income.” If you are not yet familiar with the concept of assigning accounts, please call to set up a session with a QuickBooks pro in the office to deal with this and other basic knowledge you should have.
When you are done, click OK.
Stay tuned for next month when the focus is on entering time items in records and time sheets.