Accounting for Time in QuickBooks

June05, 2017

Georgene

If you sell services to your customers, you’ll need to understand how to use QuickBooks’ time-tracking features.

Small businesses that sell products have to do a constant balancing act. Keep too much inventory on hand, and you’re sitting on potential profits. If you don’t order enough and you run out, your customers may go to a competitor. QuickBooks provides tools and reports that can help you manage this ongoing challenge.

Selling time and services is a different story. There’s no real inventory tracking involved — except in terms of knowing how much manpower you have available at any given time. But just like you wouldn’t want customers to walk off with merchandise they haven’t bought, you don’t want any billable minutes or hours to be ignored. Both scenarios eat into your profits.

Gone are the days when you had to count on employees to fill out detailed timecards and hope that they remembered to document everything. QuickBooks can help ensure that you’re getting paid for all time and services rendered.

Building Your Records

Before you can ask employees to start tracking the hours they put in, you need to create a record for every time-based activity so that QuickBooks knows how much to charge when billable time is entered. The software creates and stores these in the same way it builds records for physical inventory items.

Start by clicking on the Items & Services icon on the home page (or go to Lists | Item List). Click the down arrow next to Item in the lower left of the screen that appears, and then select New from the menu (or right-click in the main part of the screen and select New).

Figure 1: Once you’ve created a record for a service item, you can use it throughout QuickBooks.

A list of options will drop down under TYPE. Select Service. Type in the Item Name/Number and click in the box to the left of Subitem of if the time item should be grouped under another. In this example, the relationship is Labor/Removal (labor). U/M Set is not an option in your version of QuickBooks.

Note: If you will be working with subcontractors, let us help you set up these services. It’s a little more complicated.

Enter a description for your service and a rate, then click on the drop-down arrow and select a tax rate if appropriate (click on <Add New> to create one on the fly). Select an Account from the list. It should be some kind of income; in this case, it’s Construction Income. Ask us if you have any doubts here. Click OK when you’re done. Now this service will appear in your Item List.

Tracking Time

When you want to create a record for a work session, click the arrow to the right of Enter Time on the home page and select Time | Enter Single Activity (or open the Customers menu and select the same). Make sure the date for the activity is correct; you can click on the calendar and select if it’s not. Click on the arrow in the field below to select the correct employee.

Figure 2: You can either start the timer to record an activity’s duration or simply enter it in the box.

Click the arrows next to the CUSTOMER:JOB and SERVICE ITEM fields to open those drop-down menus and select the desired options. If you want to time the activity, use the Start, Stop, and Pause buttons below the duration box, or simply enter the amount of time it took. The CLASS and NOTES fields are optional.

If the time spent is billable, be sure that there’s a check in the box next to Billable in the upper right corner. If it’s not, click on the box.

Data you enter here will automatically appear on timesheets. You can enter time directly on timesheets by clicking Enter Time | Use Weekly Timesheet.

When you start an invoice for a customer who has accumulated billable time, you’ll see this message:

Figure 3: If you’ve entered billable time for a customer, this message will appear the next time you create an invoice for him or her.

Make sure that your employees understand the importance of documenting every billable minute. Lost time can eat into profits, and that has an impact on everyone in the company.

We are so thrilled to have found Georgene to help with our small business. My husband and I own and operate our business, we have 4.5 employees. I had been taking care of the books as well as the administrative duties associated with our shop. The accounting end was not getting taken care of the way it should.
I am happy to report they have done an amazing job taking over these tasks and given me more time to concentrate on our customers,
We are very happy with their services and recommend them to all we come in contact with.

I have had the pleasure of working with Georgene Jones and Holliday Bookkeeping Services for well over a year now. In that time she has been exceptionally helpful and professional in taking care of the business needs I require as a small business. I can say with all honestly, without Georgene and her services I would be lost. I owe a great gratitude to her and her company.

Sonny Robbins, CEO

Rebel Consulting Group LLC

I asked Georgene if she would be interested in helping out a nonprofit that I volunteer with, to get their bookkeeping house in order. She graciously accepted the job (this is a paid job) and never once complained at the state that our books were in, or that figuring out the short hand entrees that were in horse terminology was challenging, she just somehow, dug in and got us on track! (Please note that I was not the treasurer at this time)

We now have balanced books and are able to meet and make plans knowing exactly where we stand financially and know where we need to focus our efforts.

It is one place that nonprofits should not skimp to save a few bucks, as I have seen more turmoil caused in volunteer organizations by this problem of the volunteer in charge of book keeping not having the numbers ready, than any other single problem in any organization.

As the President of the Duvall Chamber of Commerce I rely on Georgene to handle all of our Payroll needs. She takes care of everything so payroll is totally seamless. Georgene is organized and thorough and makes my job so much easier.

Holliday Bookkeeping is an absolute godsend to me and my business! Whenever I have problems to resolve concerning my business Quickbooks account, I know I can rely on Georgene Jones to get the job done in a timely and professional manner. She is pleasant to work with, and is my number one stress reducer when it comes to my business accounting!