If you sell your employees’ time and skills, you can use QuickBooks to record those hours and bill your customers for them.

If your small business sells products, you know how precisely you must track your starting stock numbers, ongoing inventory levels, and your reorder points. QuickBooks provides tools to help with this process, but human factors can sometimes throw off your careful counts.

Fortunately, QuickBooks is remarkably flexible when it comes to recording the time your employees spend on customers and jobs. You can enter information about a single activity — either billable or unbillable — and/or document hours in a timesheet. A built-in timer (the “Stopwatch”) helps you count the minutes automatically; you can also type them in manually.

One Work Session

All versions of desktop QuickBooks include dialog boxes designed to help you enter all the details related to a single timed activity. To get there, either open the Employees menu and select Enter Time | Time/Enter Single Activity or click the down arrow next to the Enter Time icon on the Home Page and choose Time/Enter Single Activity.

QBC1014image1_zps1cb30c14

Figure 1: QuickBooks helps you create records for individual activities completed by employees, which can be either billable or unbillable.

You fill out the fields in this window like you would any other in QuickBooks. Click the calendar icon in the DATE field to reflect the date the work was completed (not the current date), and click the down arrows in the fields that contain them to select options from a list. If you already know the duration of the activity, simply enter it in the field to the right of the clock icon. Otherwise, use the Start, Stop, and Pause buttons to let QuickBooks time it.

The Time/Enter Single Activity dialog box is designed to record one activity, not necessarily an entire workday, unless an employee only provides one service for one customer in a day. If he or she provides more than one service for one or more customers, you’ll need a fresh record for each.

Note: If the employee selected is timesheet-based, an additional field will appear above the CLASS field asking for the related PAYROLL ITEM. And if you’ve turned on workers’ compensation (and the employee is timesheet-based), a field titled WC CODE will drop into place below it. This must be done absolutely correctly, and it can get complicated. We can help you manage this feature.

A Comprehensive View

At the top of the Time/Enter Single Activity dialog box, you’ll see an icon labeled Timesheet. If you click on this with an employee’s name selected, his or her timesheet will open and display the hours already entered for that period. Or you can open a blank timesheet by opening the Employees menu and selecting Enter Time | Use Weekly Timesheet. You can also click the Enter Time icon on the Home Page.

QBC1014image2_zps9e7c31d5

Figure 2: You can access an employee’s timesheet from the Time/Enter Single Activity dialog box, from the Employees menu, or from the Home Page.

If you’ve entered all of the hours individually for an employee in a given time period, the timesheet should be correct when you click through from the Time/Enter Single Activity box. If not, you can edit cells by clicking in them and changing the data. Be sure that the Billable box is checked or unchecked correctly.

You can also enter hours directly on a timesheet instead of recording individual activities. Just select the employee’s name by clicking on the arrow in the NAME field at the top of the Weekly Timesheet dialog box and fill in the boxes.

Note: Individual activities that you enter for employees are automatically transferred to the timesheet format and vice-versa.

Billing for Time

QuickBooks keeps track of all entered billable hours and reminds you of them when it’s time to invoice. If customers have outstanding time and/or costs, this dialog box will open the next time you start to create an invoice for them:

QBC1014image3_zpsec0d75b4

Figure 3: This dialog box is one of the ways QuickBooks helps you bill customers for everything they owe.

QuickBooks also provides several reports related to billing for time. We’ll be happy to go over them and – as always – help with any other questions you might have.


About Blackman & Sloop CPAs, P.A.:

Blackman & Sloop is a full-service CPA firm headquartered in Chapel Hill, North Carolina and is actively involved in auditing, taxation, management consulting, financial planning, and related services. The firm directs a large part of its services toward providing management with advice on budgeting, forecasts, projections, financing decisions, financial analysis, and tax developments. The firm also performs review and compilation services and prepares not-for-profit, corporate, individual, estate, retirement plan, and trust tax returns as well as technology consulting services regarding installation and training on QuickBooks. Blackman & Sloop provides services in Raleigh, Durham, Chapel Hill, RTP, Hillsborough, Pittsboro, Charlotte, and the rest of North Carolina. To find out more please visit http://www.blackmansloop.com

Contact: CPA cpa@blackmansloop.com

Toll Free: 1-877-854-7530
The Exchange West
1414 Raleigh Rd, Suite 300
Chapel Hill, NC 27517