Using QuickBooks to Bill for Your Time 5

Crazy save money quickbooks guyMost of the time, line items that appear on an invoice are items that you have described in the Item list and then quantify directly on the invoice. However, in some service businesses, you may actually sell many units of the same item. For example, a lawyer may sell hours or partial hours of legal advice. This may be all that she sells. A CPA may sell hours of consulting or accounting or tax preparation work.
In these circumstances, you don’t want to have an invoice go out to the customer with one line on it that says, for example, “Legal services, 100 hours, $20,000.” Unless you don’t want to stay in business.
You instead want an invoice that details each of the tasks that the lawyer performed: estate planning for 1.5 hours, review of a contract for 4 hours, preparation of a new real estate lease for 2 hours, and so forth. To provide this level of detail — detail that is really beneath the item — you use the QuickBooks Time Tracking feature.
QuickBooks supplies two methods for tracking the time spent that will be billed on an invoice as an item. You can use the weekly time sheet, or you can time or record individual activities. I briefly describe how both time tracking methods work; neither is difficult. Professional service providers — accountants, attorneys, consultants, architects, and so on — should consider using one of these features to make sure that they accurately keep good records of the time spent working for a client or customer.

Using a weekly time sheet

To use the weekly time-sheet method, choose the Customers⇒Enter Time⇒Use Weekly Timesheet command. QuickBooks displays the Weekly Timesheet window, shown in the image below. To use the Weekly Timesheet window, first use the Name box to identify the employee, vendor, or other person performing the service. You should be able to select this person’s name from the Name box. If you can’t select a person’s name from the Name box, enter the person’s name into the box, and then, when prompted, tell QuickBooks which list (employee, vendor, or other names) should be added. After you’ve added the name of the person performing the work, use the columns of the Weekly Timesheet window to describe the customer or job for which the work has been performed, the service code, a brief description or note, the payroll item (if you’re using QuickBooks for payroll), the class (if you’re tracking classes), and then the hours spent per day. You can enter as many lines onto the Weekly Timesheet window as you want. Each line appears separately on an invoice. The notes information appears in the description area of the invoice. For this reason, you want to use appropriate and descriptive notes.

QuickBooks enter weekly time entries

Timing single activities

If you want to record service activities as they occur, choose the Customers⇒Enter Time⇒Time/Enter Single Activity command. QuickBooks displays the Time/Enter Single Activity window, as shown here:

QuickBooks enter single time entry

To time or record a single activity, record the activity date into the Date box. Use the Name box to identify the person performing the service. In the Customer:Job box, identify the customer or the job for which the service is being performed. Select the appropriate service item from the Service Item drop-down list and (if you’re tracking an employee) the appropriate payroll item from the Payroll Item drop-down list. If you’re tracking classes, predictably, you can also use the Class drop-down list to classify the activity. The Notes box should be used to record a brief appropriate description of the service. This description appears on the invoice, so be thoughtful about what you write. After describing or providing this general information about the service, you have two ways to record the time spent on the service:

  • Manually record time. You can manually record the time spent on an activity by using the Duration box to enter the time. If you spent 10 minutes, for example, enter 0:10 into the Duration box. If you spent 3 hours and 40 minutes, enter 3:40 into the Duration box.
  • Have QuickBooks record the time. You can also have QuickBooks record the time that you spent on the activity. Just click the Start button in the Duration box when you start the activity, and click the Stop button when you stop the activity. If you want to pause the timer (while you take a phone call, for example), click the Pause button.

After you describe the activity you’re performing in the Time/Enter Single Activity window, click the Save & New or Save & Close button to save the activity information.
Verify that the Billable check box is selected. The Billable check box appears in the upper-right corner of the Time/Enter Single Activity window. By selecting the Billable box, you tell QuickBooks that it should keep this record of a billable activity for later inclusion on an invoice.

You can use the Previous and Next buttons that appear at the top of the Time/Enter Single Activity window to page back and forth through your records of activity timing. Note, too, that the Spelling button is also available on the Time/Enter Single Activity window. You can, therefore, click the Spelling button to spell-check the notes description that you enter — which is a good idea, because this information will later appear on an invoice.
QuickBooks also allows your employees to enter their time directly. Choose the Customers⇒Enter Time⇒Let Employees Enter Their Time command to get information about how this web service works.
Including billable time on an invoice
To add billable time and cost to an invoice, create the invoice in the usual way, as I describe previously. After you identify the customer (and if you’ve entered time for the customer), and if you’ve been tracking time or costs for the customer, QuickBooks will ask if you want to bill for any of the time or costs using a message box. If you indicate “yes,” QuickBooks displays the Choose Billable Time and Costs dialog box, shown in the first image below. The Time tab of the Choose Billable Time and Costs dialog box shows each of the times that you’ve recorded for a customer. To add these times to the invoice, click the Use column for the time. (This is the left-most column and shows a check mark.) Or, if you want to select all the times, click the Select All button. Then click OK. QuickBooks then adds each of these billable times as lines to the invoice. The last image shows how billable time information appears on the Create Invoices window.

QuickBooks choosing billable time for invoice

QuickBooks create invoice from billable time

Leave a Reply

5 thoughts on “Using QuickBooks to Bill for Your Time

  • Peter Campberg

    Good to know that QB had started providing time billing facility again after a long gap. Any thoughts on when time tracking will be back?

    Since QB stopped providing time and billing facilities couple of years back, we had been using Quickbooks time tracking software tool.

  • Tad

    My CADD tech support forced me from winXP to win8.1-64 so I now shop for a replacement for
    Timesheet Professional 7 (Timeslips Corp)
    that invoiced via Crystal Reports (Seagate) templates,
    then I would have to duplicate this data in my checkbook
    Managing Your Money 2.1 for Windows (Kiplinger, Andrew Tobias, H&R Block)

    What ONE win8.1 compatible software could replace these old programs that win8.1 HATES? so my business can keep on track?

  • Rachel

    I am very curious to know if you can choose only those customers in customer center, for monthly invoicing, that have activitiy for a particular month on timesheets; rather than individually clicking all customers for a particular month. Any help will be beyond appreciated.

    • Jay Thompson
      Jay Thompson Post author

      I know exactly what you mean. Yes, you can. Please follow these steps:

      1) Simply go to the “Edit” menu and click on “Time & Expenses” (found on the very bottom of the list on the left panel).
      2) Click on the “Company Preferences” tab.
      3) Check the box under, “INVOICING OPTIONS”, that says, “Create invoices from a list of time and expenses”.
      4) Click “OK”.

      Now, in the home screen, when you click on “invoices”, you will get a drop-down list that has as an option, “Invoice for Time & Expenses”. This will bring up a list of only those customers who have had time tracked for them.
      Hope this helps!

      • Denise

        I followed your instructions but i do NOT have Step 3 and 4 available in my 2015 version?

        3)Check the box under, “INVOICING OPTIONS”, that says, “Create invoices from a list of time and expenses”.
        4) Click “OK”.

        any ideas?