QuickBooks – Enter Time for Employees and Customer Jobs

Posted by on Mar 1, 2011 in Payroll Module | 28 comments

If you have a number of hourly employees, you will find that the Enter Time function is the quickest way to process your payroll. Most companies that have hourly personnel, have them fill out their time sheets on a daily basis, so you can enter in the time sheets at the end of each week leading up to the payroll.

Once you have completed the timesheets, QuickBooks will pull that information into the detail portion for  each employee when you start the scheduled payroll.

I am using a QuickBooks sample company which sells sports equipment and gives lessons,  to demonstrate this for you. I am assuming that by this stage of the QuickBook segments I have provided for you, you will know how to set up any missing information such as Items, Accounts and Employees. If not, then do a search on this site and look for a blog segment to help you.

Many people do not realize that you can cost any portion of an Employees wages to a Customer Job. To do this you would use the Enter Time function in Payroll. This function is found on your Home page in the Employees module and by clicking on the Enter Time icon. This will open up a smaller window:

  •  – Use Weekly Timesheet
  •  – Time/Enter Single Activity

The Use Weekly Timesheet is the most used selection but if you were tracking time, as in minutes and hours, you could use Time/Enter Single Activity also.

I have only seen the Time/Enter Single Activity used in relation to a company that was building a transportation customer counter. They wanted to pinpoint an exact cost to build the different components during the research and development stages. We are going to select Use  Weekly Timesheet.

I am going to use an Employee in this sample company, whose name is Christine Girard. She was the instructor who gave two customers some lessons. The selection of Christine immediately activates a pop-up window with the message Would you like to set this employee to use time data during pay cheque creation? The choices are Yes & No.

What QuickBooks is asking me is, do I want this information that I will input to be used when it is time to create a pay cheque for this Employee? This will save me time on the day that the payroll run is being generated for the pay period. So I will choose Yes. I need to choose from the Week Of field, what week this information pertains to. I have chosen Jan 14 to Jan 20, 2011. 

This takes me back to the Name field and my first tab to the Customer field. The customer in question is Martin Brault, so I choose him. The next field is the Service Item from which I will choose from the drop-down box – snowboarding lessons. The Payroll Item is Hourly and in the Notes field I type in 3 hrs. of instruct.

The rest of that line shows the week and date starting with M (Monday) the 14th, where I will enter the number 3, extending to S (Sunday) the 20th. After that is two columns, Total and Billable.

The Total column will add up the number of hours in that week and the Billablecolumn has a box for checking if I wanted to include this cost as part of the billable time to this customer (Martin Brault). I am going to check the Billable box.

Since there are more hours to enter and M (Monday) the 14th is not completed, I will tab until the cursor takes me back underneath the Customer Job field.

The remaining five hours for M (Monday) are not associated with a Customer or Service Item so I will tab to the Payroll Item field, choose Hourly again, and underneath the 3:00 hours in M (Monday) the 14th column, add 5 hours to make up an 8 hour day. The Totals column for M (Monday) the 14th will now show 8:00 but I need to uncheck the Billable box that is beside the 5 hours on that line, because it is not Billable to a job.

You would not be able to leave the Billable box checked anyway, because you would receive a message stating that you need to include a Customer and Service Item on that line.

Christine only worked four days that week, in which one day was costed to a job,  so I am going to enter T (Tuesday) through to Th (Thursday) as eight hour days, paid Hourly.  Christine will now have 32:00 hours as a Total for that week. I will now choose Save & New since there still is another week to process.

This takes me back to Name field where I will repeat the steps as per the first week using Christine Girard, but with a different week – Jan 21 to Jan 27, 2011. The following will be the information for that week: Customer: Job is Jeffrey Lin, Service Item - Lessons: Skiing lessons, Payroll Item - Hourly, Notes – 4 hrs. ,  4 in M the 21 column, and Billable is checked off.

The line below will have no Customer or Service Item, Payroll Item - Hourly, no Notes, 3 in M the 21 column and uncheck Billable. The Totals for M the 21 will be 7:00. On a new line I will add 8 hours for T (Tuesday) through to F (Friday). That line will total 32:00 and the Totals of all the columns will be 39:00.

I can now choose either Save & New to enter in another Employee or Save & Close if I am finished. Since I am only using one Employee for this demonstration, I will choose Save & Close.

You have just learned how to use the Enter Time function in payroll to cost a portion of an Employee’s wages to two Customer Jobs, and the rest of the time was for a normal two weeks of hourly earned wages.

The next segment will be to Pay Employees and see how the Enter Time function flows to this area.

Remember that you can follow me on Twitter @twitter.com/QuikBooksTrainr for tips and updates or if you want to make sure you don’t miss an article, then use the RSS Feed button.

www.quickbookstrained.com is now mobile friendly. From the web address you can choose Options/Mobile formatted and the site will appear in all its living colour for you to view. Check it out.

Share

28 Responses to “QuickBooks – Enter Time for Employees and Customer Jobs”

  1. I am trying to find a simpke way to add employer on-costs when entering employee times using QuickBooks. Is there some way to change the rate which is appled to the jobs? Currently only the hourly rate & suoer costs are carried across to the job. Does anyone know how this can be done easily?

  2. I only bill my customers for days or half days. Is there a simple way to use the Enter Time functionality (short of entering 8 hours or 4 hours) to capture this information for the monthly billing?

    • Larry Johnson says:

      Hi Adam, that depends whether your Customers have requested that you supply them with the days your employees or sub-contractors have worked.
      But yes, there is a way to by-pass the Enter TIme function. When you start a Scheduled Payroll the next window will be Enter Payroll Information.
      There you will see a tab that says Open Pay Cheque Detail, click on that. In that window you can assign the number of hours you want to bill to the Customer: Job. Each Job will require a separate line using Hourly only, meaning Salary (Payroll Item) will not work.
      You can then pull that info into an Invoice when you bill as QuickBooks will give you a message that you have Items to bill do you want to use them. Say yes, and use the Time tab to pull that info on to your Invoice.
      Hope that helps. If not we can always video chat.

  3. This is some good quality stuff. It took me some time to locate this site but it was worth the time. I noticed this post was buried in bing and not the first spot. This website has a ton of decent stuff and it does not deserve to be burried in the search engines like that. By the way I am going to add this web site to my list of favorites.

  4. I have a part time employee who gets paid hourly while in the office and by the job when in the field. How do I tie the per job rate to her hourly pay.

  5. alesha maalouf says:

    I am unable to find the enter time function or time sheets on my payroll. I am using QB for Mac. Would this make a difference? I also am using payroll on Intuit the on line service. I am wanting to assign hours for an employee to several different jobs during his pay period? Is this possible?

    • Larry Johnson says:

      It should not make a difference in Mac or PC. Is your Payroll turned on? Go to Preferences and look for the Payroll & Employees on the left hand column. See if the Company Preferences in Payroll is turned on (Full Payroll).
      Also, you can press Control 1 and the seventh line down will tell you if your Payroll has expired or not.
      One final way to check also is to go to Help, My License Information and that will also tell you about your Payroll.
      Otherwise, you may have to call QuickBooks Tech Support.

  6. I am just starting with Quickbooks and I do not want to turn on the payroll service at this time. However I want to track my employees times to customer jobs and profit & loss charts. I have managed to enter their times, however I am not seeing where it comes off the jobs or bottom line, what should I do since I am not utilizing the payroll services?

    Many Thanks

    • Larry Johnson says:

      Hi Ashley, the Timesheet function is just that. Remember you have to check off the BILLABLE column in the Timesheet.
      When you have Payroll, you don’t need to check off the BILLABLE column as the info that you key into Timesheets is kept and then is pulled into Payroll for processing. At that time the Employer deductions becomes a part of the expense in Job Costing. Without P/R, you will only get the hourly or salary portion allocated to the Customers/Jobs from your Timesheets.
      IF, you not using the P/R function then when Invoicing, you MUST answer the question correctly about using TIME & EXPENSES on your invoice or else it won’t show up OR get billed.
      You can also print Reports found in Jobs/Time & Mileage in regards to your Timesheets.
      Hope this helped.

      • Without P/R, you will only get the hourly or salary portion allocated to the Customers/Jobs from your Timesheets
        Why wouldn’t this calc the cost from the employee info??? just updated to enterprise 2014 from premier 2013….
        Any thoughts, after all i’m running a cost report not hours??
        Thanks Ray

  7. Tami Hunt says:

    I am using quick books 2013 and I have an hourly employee who forgot to put his hours on his time sheet for Friday. The total hours that he was paid for were 32. How do I now go back and pay him for another day that should have been on the time sheet?

    • Larry Johnson says:

      Hi Tami,
      You can either wait and include that hour in the next pay cycle or your can do an unscheduled payroll. Just check that employee off that you want to pay, then select the tab that says “Open Pay Cheque Detail” and use the hourly pay item and book to a job if appropriate.
      Make sure to change the date range that this pay is for. Save and then print the pay cheque.
      Hope this helps.

  8. I have 3 men crews. Is there a way to enter the info once for the employees instead of three times for each employee?

    Thanks,
    Michelle

    • Hi Michelle, you need to elaborate that question for me. Why are you entering it in 3 x a week? Are you not using the Timesheet function? You should only have to enter in the Timesheets once a week, taking the info from the manual timesheets the employees fill out and hand in.

  9. After I enter my time into the timesheet, it isn’t showing up on my payroll detail. Do I have to schedule payroll, or can I just go and pay employees?

    • Hi Jill. What version of QB’s are you using? If 2011-2013 once you enter the times in when you process your PR, it will pull over that info into your PR Detail. Yes you will need to schedule your PR to activate. Hope that helps.

  10. I have 5 employees who all work the same jobs everyday, is there a way to copy the first employees timesheet and paste to the remaining four employees timesheets. This way I am not forced to enter the same same data on five timesheets.

    • Hi Rachel, on the very left hand bottom of your Weekly Timesheet screen is a tab that says “Copy Last Sheet”. This will save you from entering the same info. Don’t forget to change the Week Of at the top since it will be a new one. Hope this helps.

  11. What if my enter time function is not being saved even when I hit the save and new tab. I have been on the phone with intuit for 4 hours and they could not help me.

    I’m useing Quickbook Enterprise Solution:Contractor 13. I would enter an employee time hit save and new but when I go back to that employee what I have done is not there. I would hit file and pick print forms and click on timesheets and it would have nothing to print- I have checked to make sure it was on the correct payweek but still no luck and as I stated above I was on the phone iwth Intuit for hours and they were not able to help me.

    Mickie

    • Hi Mickie. I have not worked with QB Ent. PR enough to comment. But, the first thing I would do is run a data integrity check.
      If there is a problem, then Backup your data and run a ReBuild. Then run a integrity check again.
      If that doesn’t solve it, uninstall QB Ent. and re-install.
      If that doesn’t help, contact your nearest QB Pro-Advisor.

  12. Tina Campbell says:

    I currently have Enterprise 12. I process payroll through Bank of America, because it’s free. I download the payroll checks into my Quickbooks file. Is there a way to manually connect a Quickbooks time sheet to the downloaded paycheck or manually add time? I do not currently have the Payroll function turned “on” in Quickbooks, because I process payroll manually.

    Also, should I leave my Employees as “Vendors” to make this easier.

    • Hi Tina, I guess my first question would be, why wouldn’t you use the QB’s payroll (turned on) so that the timesheet is loaded automatically when you process the payroll? You could then download from the bank – the payment of them. Very much like a Direct Deposit to the Employee’s account.
      To answer your question, to be honest, I have never tried to connect a QB’s timesheet to a downloaded paycheck. Thinking about what I do know, I don’t see how that could be done, since both of those functions, timesheet and payment of them, are done through the QB’s Payroll module.
      If you are using the Job Costing feature, you would definitely not be able to allocate to Jobs without the Payroll function turned on, that is if you have Employees.
      Hope this helps.

  13. My company is switching to the Intuit Payroll online service…can we still use the time sheets in QB to create paychecks? How do we transfer this data to Intuit Payroll online? Thanks!

    • Hi Lindy, I have not used the Payroll online service. If you are switching from QB Desktop to QB Online, then unless Intuit has developed a bridge for the two separate products, then you can not transfer the data, i.e. Timesheets. Check out my blog on the Skinny of QB Online.

      • Thank you so much for the reply! We use the desktop version of QB (with the time sheets), but our new accountant typically uses the Intuit Online Payroll service for her clients instead of Quickbooks payroll. After an hour and a half on hold with Intuit Payroll support, they told me that it is not possible to transfer the time sheets as they are two different platforms….

  14. Is it possible to track in Quick books if an employee is late? If their normal start time is 8:00 for example, and they do not show up until 8:05, is there a place to mark them Tardy and reference at a later date how many times they have been tardy in a certain timeframe?

    • Hi Gina, there is a way to track this. In the Employee Centre, highlight an Employee that you would like to create this tracking info for. Then click on the icon that looks like a pencil and when highlighted will say EDIT. You will now be in the Personal screen where you will see 4 tabs starting with Address & Contact. Highlight ADDITIONAL INFO and enter.

      On the right hand side is already a CUSTOM FIELD called NOTES. Below it there is a Define Fields tab. You can click on it and set up a FIELD called Late and use for Empl (click underneath). You could set up one for each month as the field has a limited amount of space (25 characters I believe) for info. Hope this helps.

Leave a Reply