Skip to main content
January 8, 2019
Solved

Job Costing - Employees Time

  • January 8, 2019
  • 3 replies
  • 0 views

I have been searching everywhere for a way to job cost employee time.  I enter each job they work on in their paycheck, but when I run my reports, it never shows up there.  Should I be using the timesheets instead?  I'm not crazy about QB timesheets as our payroll is in two week increments and timesheets is only in one week increments.

 

This has been frustrating me for years.  I don't want to purchase a support plan, as it costs too much and I'll be on the phone for two+ hours.  I've searched the Q&A here and Googled this question with no luck.  I am using Desktop 2019 Contractors Edition.  Thank you.

Best answer by qbteachmt

for #5....What version do you have?  I don't see where you can do multiple employees!  I don't see in 2019 where you can do this.

 

New question, how can I easily go back to previous payrolls and add all the time that I entered directly into the paychecks to make sure it shows up on my job cost report?  Do I have to do this through timesheets?  A whole years worth?


Open New Timesheet. At the top, in Name, Scroll all the way UP to find Multiple Names is listed. Reports that you Filter, you scroll to the Top of that filter to see Multiple and All as the options. In fields, you also scroll Up to see Add New.

 

In Timesheet Name, at the Top, Multiple Payroll (for employees only) or Multiple Non-Payroll (for vendors and other names).

 

You cannot list this in Prior Paychecks now; You need to be able to open Paycheck Details and see the Service item and the Job Name, as you see in my attachment.

 

You can make some $0 bills to offset all of this. Example:

Vendor Name = Allocate Payroll.

Make a Service item and name it Allocate PR. Link it to an Other Expense account and name that PR Allocation.

First paydate of the year, you see Payroll Expense for that date. You break it out by Job Name.

 

Enter a Bill for the Allocate vendor, listing the Allocate Service item over and over on the Items tab. Put the amount and job track; all entries are Not Billable.

 

Now you have a Total on the Items tab. Click on the Expenses tab. Post to that same Other Expense account here, putting the total as Negative, One Line, No Job Tracking here. Hit Recalc. You have a $0 Bill with fairly generic but Job Tracked details.

3 replies

January 8, 2019

QB is not good at job costing in my experience. QBO is worse and QB Payroll makes even harder.  I am sure someone will pipe in here to tell you some complicated convoluted way to do this in QB so hopefully you get the help you need.  My suggestion is a different system that does job costing as it should not be from payroll, it should be from timesheet where you allocate gross labor not net pay.  Please feel free to contact me if you need to do true job costing, like for Govt contracts as I must do.

nchamblerAuthor
January 8, 2019

Are you trying to sell me another accounting program?

January 9, 2019

No, I do not sell any accounting programs, but I know which ones do job cost well.

qbteachmt
January 8, 2019

This is marked as a desktop topic.

 

This is so Easy, in Desktop. Yes, you start from the Timesheet. Set the Employee Default, and each existing Employee name, to be Paid from Time Data.

 

Now you see two columns: Payroll item and Service Item. This will tag the Service Item with the payroll cost, when you Pay from Time Data.

 

Your misunderstanding of Timesheets is something I just explained in detail here:

https://quickbooks.intuit.com/community/Employees-and-payroll/Employee-Time-sheets/m-p/217358#M3294

 

You need to set Preferences to Job Track per Earnings item, and Job Track Expenses, as well.

 

All of this is so easy. It starts with Timesheets.

 

I also have an Image attached for that setting and will make others with examples of the many reports that show this works Great.

 

qbteachmt
January 8, 2019

Attached is Job Costed reporting showing Payroll Costs.

qbteachmt
January 8, 2019

Attached, a Job report side by side with P&L for the same Job. Follow the Colors.

December 13, 2020

I dont understand none in the community. So take me out and help me get my accounts and my right banks linked running to everything.i have no more time to waste wondering if i got it right.

Rose-A
December 13, 2020

I'd be glad to assist you today, Michael6340.

 

Are you trying to connect to your bank account to QuickBooks Desktop? If so, there are two ways on how to connect with QuickBooks, depending on your financial institution, you can either access your account using Direct Connect (automatic) or WebConnect (manual).

 

If you're trying to connect using the Direct Connect feature, you might want to verify first if your bank requires a fee for this service. Once verified, you can follow the steps below:

 

  1. Click Banking at the top menu bar and go to Bank Feeds.
  2. Select Set up Bank Feeds for an account.
  3. In the Enter your Bank’s name field, enter and select your bank.

 

If you choose to connect using the WebConnect feature, you can follow the steps in this article: Set up bank accounts for Bank Feeds in QuickBooks Desktop.

 

The following write-up is a good reference: Fix OL and OLSU Bank Feeds errors in QuickBooks Desktop. It includes errors like OLSU-1011, OLSU-1014, OL-202, and OL-206 to name a few.

 

If you're referring to something else, please let me know. I need to make sure this is resolved and you're back to running your normal business processing. Have a good one!