QuickBooks Tips

How To Track Employee Time, Part 2

10/15/2020

Last month, the concept of time tracking in QuickBooks was introduced. As a reminder, using the software’s tools makes it possible to record individual blocks of time that employees have worked and include them in payroll and billing customers when necessary. Each step required to set up QuickBooks for time tracking was discussed as well as the process of creating individual time entries and a completed record for billable time should look something like this:

How To Track Employee Time Part 2

Figure 1: To enter an individual time record, you open the Employees menu and select Enter Time | Time/Enter Single Activity.

Using a Timesheet

QuickBooks offers another way to enter time records that is especially useful if you have multiple employees and a lot of work hours to track. Open the Employees menu and select Enter Time | Use Weekly Timesheet. You can also get there by clicking the down arrow next to the Enter Time icon on the home page. This screen resembles a paper timesheet, with columns for all of the information you would enter if you created a single activity.

At the top of the screen, click the down arrow next to Name and select the correct employee. To the right of that is the Week Of field. If you need to change the dates, click the small graphical calendar, then click anywhere in the correct week. If you have already created individual records for that employee during that week, the information for each will appear in the corresponding date column at the end of the row. And anything you enter on the Timesheet will also appear as an individual entry.

To create a new entry on the Timesheet, click the down arrow in the Customer column and select the correct Customer:Job. Next, choose the Service the employee provided by again clicking the down arrow in that field. You want to be sure that the Payroll Item code is the right one, so choose carefully there; the WC Code (Workers’ Comp) should fill in automatically. Enter Notes if you’d like, then the number of hours the employee worked for that customer for that service in the date column. Be sure to click in the Billable box to create a checkmark if the service was billable.

Track Employee Time Part 2

Figure 2: Any data you enter on a QuickBooks Timesheet will also appear as a Single Activity, and vice versa.

Totals for each column appear at the bottom. Save the Timesheet and repeat the process for any other employees as needed. These hours will now be available to you when you run payroll and bill customers.

Time Reports and Invoicing

QuickBooks makes it easy for you to see the time data you’ve entered. It offers four pre-formatted reports that tally this information in different ways. Open the Reports menu and select Report Center. Locate Jobs, Time & Mileage in the left vertical pane and click on it. Scroll down to the Time heading to see these four reports. They are:

  • Time by Job Summary (tells you how much time your company spent on each job, broken down by services provided)
  • Time by Job Detail (shows you the same thing, but includes employee name and billing status)
  • Time by Name (lists employees and the hours they spent on each job)
  • Time by Item (tells you how much time your company has spent on each service type, broken down by job)

When you open a report, you can double-click on any number in the Duration column to see the underlying detail.

When you create an invoice for a customer who needs to be billed for services provided, QuickBooks displays this message:

How To Track Your Employee Time Part 2

Figure 3: To make this standard procedure, check the box in front of Save this as a preference.

QuickBooks offers another way to bill for time and expenses that allows you to create invoices in batches. Open the Customers menu and select Invoice for Time & Expenses. In the window that opens, specify your Date Range, and make sure the Template showing is the one you want.

Click in the column in front of each Customer:Job you want to bill and then click Next Step. You can Review Billables to see details and Edit Options by clicking on those buttons. Click on Create Invoices and make sure each customer’s Preferred Send Method is correct in the next window before dispatching them.

QuickBooks’ time tracking tools may be all your company needs, but if you find them lacking, please call to discuss adding TSheets, an integrated solution that adds more advanced features. As always, don’t hesitate to call if you need help using any of QuickBooks’ own tools or with any other accounting needs.

Ask a Question

Find comfort in knowing an Expert in accounting is only an email or phone-call away.

We Are Here to Help

We will happily offer you a free consultation to determine how we can best serve you.

Blog

Attestation Services: Compilations, Reviews, and Audits CPAs offer attestation services as unbiased options

frequently asked questions

  • What Is A Virtual CFO & How Can It Transform My Business?
    • a. A Virtual CFO can be a much-needed sounding board, coach, and guide. Outsourced Virtual CFO is generally not just one person, but an experienced team of professionals providing a full-stack Accounting and Finance Department at a fraction of the cost that it would otherwise cost a business to hire even just one full-time CFO internally. The right virtual CFO service team, such as the one at Perpetual CPA, can deliver timely, detailed, comprehensive financial reporting, interpret the financial data, prioritize recommendations, give expert guidance on how to execute those recommendations, and ultimately give a better path to business success.
  • How can a Virtual Accounting Department help small businesses scale and grow?
    • a. A growing number of small businesses are opting to outsource services such as IT, human resources, or accounting. The benefit of a Virtual Accounting Department is that the company can reduce or increase services to accommodate current business needs. Because the service provider has multiple clients they can absorb fluctuations in workflow more easily than the average small/medium business can on its own.

      b. A Virtual Accounting Department can integrate with a company’s own accounting department to create a blended solution or provide a full-stack accounting department, including Accounting Staff, Manager, Controller, and Virtual CFO. By using a Virtual Accounting Department Small business owners don’t have to worry about hiring, training, figuring out compensation, and payroll compliance for the internal accounting team. Also as the business grows and new and more complex accounting and tax issues come up, the outsourced Virtual Accounting Department can provide all the needed expertise to facilitate continued business success.
  • What are the benefits of hiring a CPA firm?
    • a. Certified Public Accountants (CPAs) do a lot more than just crunch numbers and prepare taxes. They provide valuable expertise and strategies to help businesses and individuals achieve their business and financial goals. A CPA firm can help small businesses with management financial reporting, tax compliance, strategic business advice, and much more. Firms like Perpetual CPA, that specialize in helping small and medium-sized businesses achieve growth, can also provide Virtual CFO services, that help the business owners have the foresight into the short-term future cashflows and be able to more successfully navigate their business performance.
  • What are the best strategies for small business growth?
    • a. A business growth strategy is, simply, a plan of how a business gets from where it is today to where it wants to be in the future.

      b. Some of the questions to consider when coming up with a growth strategy are:
      i. Where will the business get new customers from?
      ii. How will the business expand into new markets?
      iii. What new products could the business offer?

      c. In reality, what happens with many small businesses, is that they generally achieve a specific level of business activity or sales and then the business growth trend flattens. In those cases, working with a firm like Perpetual CPA, which provides Virtual CFO services, can help small businesses avoid stagnation. Virtual CFO services, aside from providing timely accounting and tax reporting, can also provide valuable insight into the current performance of the business, as well as, foresight into the future cash flows for the business. Perpetual CPA Virtual CFO team helps small businesses interpret their financial information and come up with business strategies to help improve business performance and achieve growth.
  • What are the best strategies for small business risk management?
    • a. A risk management plan helps a business develop a detailed strategy to deal with certain risks that are particularly important for the businesses’ success.

      b. For many small and medium-sized businesses, the easiest way to develop and implement a business risk management plan is to work with a reputable CPA firm, such as Perpetual CPA. Large corporations invest a lot of resources and time into managing risk, which is a material factor that allows those large corporations to continue to generate billions of dollars in revenue every year. Small businesses, however, almost never manage any business risks, which is the major reason that over half of all the small businesses do not survive for more than 5 years. Generally, small business owners are not experienced corporate business professionals and lack the needed business knowledge, yet they often have to wear many hats while trying to get their businesses off the ground. In those situations, a CPA firm such as Perpetual CPA, can help small businesses better manage tax compliance risks, cash flow, internal controls, business administration, financial reporting, and much more.
  • What is Strategic Advisory and Virtual CFO? / How do Strategic Advisory and Virtual CFO services work?
    • a. When small businesses start spinning wheels, it is a good time to consider hiring a reputable CPA firm, such as Perpetual CPA, which can provide both Strategic Advice and Virtual CFO services.

      b. As a strategic advisor, the CPA firm will work with business management to improve the effectiveness and profitability of the business. They will look holistically at the business and find ways to operate the business more efficiently, increase customers through additional or improved marketing or improve customer touchpoints and service.

      c. As a Virtual CFO, the CPA firm is like a part-time version of a traditional CFO or Chief Financial Officer plus a full Accounting support team. They perform the tasks that in a larger organization would be performed by the CFO, Controller, and Accounting Staff such as preparing and overseeing the budget process, identifying and analyzing current and future trends, and developing strategies for the business growth.
  • How can timely financial visibility and management reporting help with better business decisions and growth?
    • a. A simple way to a successful business is to prioritize the timely financial visibility and management reporting as it means:
      i. Timely financial information and analysis are essential for making informed decisions, evaluating your company’s results, improving financial performance, and ensuring you are on the path to meet your strategic goals.
      ii. Management reporting is a source of business intelligence that helps business leaders make more accurate, data-driven decisions. But, these reports are most useful if they are available timely and the management receives proper interpretation of the business financial information.

free initial 30-minute consultation

    © Perpetual CPA 2023   •   Privacy Policy   •   Disclaimer   •   Accessibility Statement   •   Powered By   Designed by Dot Com Media Moguls