Tracking Time in QuickBooks, Part 2
Last month, we learned about getting QuickBooks ready for time-tracking by activating it in Preferences and creating a record for a service item. This month, the focus is on using that record in the two different ways you will be using it in QuickBooks: to pay employees for their hourly work and to bill customers for services.
Recording Employee Hours
There are two ways to enter hours for your employees who provide services to customers and are paid by the hour. The first is to create a work ticket for a single activity. Click Enter Time on the home page, and then Time/Enter Single Activity to open this window:
Figure 1: Single-activity work tickets for employee hours are especially useful if you need to set a timer.
First, check the date to make sure it displays the day when the work was actually done, not recorded. Click the arrow in the field next to Name and select the employee’s name from the drop-down list that opens, then do the same in the Customer: Job field below. The Service Item field needs to display the name of the service performed by the employee.
If you want to time a period of activity, use the Start, Stop, and Pausebuttons under Duration. You can also replace the 0:00 that appears by default with the number of hours and minutes that were worked.
In the middle column, select the correct Payroll Item from the drop-down list. You can add a new employee if necessary without completing his or her entire record, but be sure to go back and complete it before your next payroll.
Hidden behind the drop-down menu is a field titled WC Code, which stands for Workers’ Compensation Code. It will only appear if you are using QuickBooks Enhanced Payroll and have that feature turned on.
Tip: If these two fields do not appear, you have selected an employee who is not timesheet-based.
In the upper right hand corner, you will see a field labeled Billable. Be sure you click in the box to create a checkmark if you will be invoicing a customer for the work done.
Save the activity record when you have completed it.
Using Timesheets
Figure 2: You can enter employees’ hours directly on a timesheet instead of creating a single activity record.
QuickBooks offers a second option for entering employee hours: timesheets. You will notice that there is a Timesheet icon in the toolbar of the Time/Enter Single Activity window. If you click on it with a completed record open, a new window opens containing a graphical representation of a paper timesheet.
If you enter employee hours in a single activity record, they will appear on a timesheet, and vice versa. There are two advantages to entering hours directly on the timesheet, though. The first is that it is faster. Second, you can click the Copy Last Sheet icon if you are just going to duplicate an employee’s previous pay period’s hours. If you want to go there straight from the home page, click Enter Time | Use Weekly Timesheet.
Billing Customers for Time
QuickBooks makes it easy to transfer billable hours worked by employees to the corresponding customers’ invoices. After you have entered blocks of time spent on services, open an invoice form and select the customer. This window will open:
Figure 3: Once you’ve entered billable hours worked by an employee, simply open an invoice form and select that customer to open this window.
By default, Select the outstanding billable time and costs to add to this invoice? is checked. When you click OK, a new window opens displaying a grid that contains all of that customer’s billable time. You can Select All or click in front of each entry you want to include. You will notice here that there are also tabs on the grid for Expenses, Mileage, and Items that can be billed back to the customer.
If you choose not to carry billable hours over to the invoice at the present time, you can always add them by clicking Add Time/Costs in the invoice’s toolbar.
Questions? One of our QuickBooks experts is always available to help ensure that you are billing customers for all costs they incur–and to talk about any other element of accounting that affects your cash flow.
By Leon Clinton