Skip to main content
K
kvanheuk
April 24, 2023
Question

Project Reports not showing all labor

  • April 24, 2023
  • 5 replies
  • 0 views

I love the Projects feature in QB, however, I recently discovered that not all of our project time is being reported. It shows it is coded to the correct project in the Weekly Timesheet, however, when I pull a P&L for the project, it is missing some of the labor. It is hit or miss which hours/time gets sent to the projects and which don't. There doesn't seem to be any rhyme or reason to it, but it does seem to be getting worse. Some of the time does go correctly - so I know it's supposed to. But currently this year, I have almost $160k in labor costs that are unassigned to a project. Again, when I dive deeper to the exact time sheet that is "unassigned", it is correctly assigned there. It also doesn't allow me to "fix" it. I have tried erasing the assigned project and adding it back in on the timesheet and it doesn't fix anything.

 

I have been on the phone, chats, and requested a manager to help me with this issue. I have spent over 5 hours on QB support trying to resolve this and I either get transferred or dropped. No one has been able to help me solve this yet, but it is a big deal for my company. We need to be able to track our projects and their labor accurately.

    5 replies

    DivinaMercy_N
    DivinaMercy_N
    April 24, 2023

    Hi there, @kvanheuk. I'm here to help you track the project labor cost in QuickBooks Online (QBO).

     

    In QuickBooks Online (QBO), project labors will only reflect on your Profit and Loss report once you've invoiced the time that is billable. This may be the reason you're unable to see some of the labor cost in the report. Same goes with vendor hourly cost, they won't appear in the report unless you created an expense transaction using the hourly service item. 

     

    Additionally, you'll have to make sure that you use the correct report period and accounting method. 

     

    On the other hand, we can also run the Time cost by employee or vendor report. This will show the project's cost rate, cost, billable rate, and total billable amount.

     

    For more information, check out this article: Track hourly labor costs and profitability by project in QuickBooks Online.

     

    I've also include this helpful resource that you can use to have a guide in setting up payroll expenses for projects: Set up payroll expenses in the chart of accounts. 

     

    I'm always here ready to lend a hand if you have any other concerns managing your projects. Have a good one and stay safe. 

    K
    kvanheukAuthor
    April 25, 2023

    The problem is that the time costs aren't going to the project they've been assigned to. One interesting thing I noticed today, is that in the memo/description, it does state "Gross amount of wage types not in project" - which it doesn't say that on pay that has been properly linked to the project.

     

    These entries are all correct in the weekly timesheets, so they were entered correctly - they just aren't connecting for some reason. 

    C
    Carneil_C
    April 25, 2023

    I admire you for getting back on this thread, @kvanheuk.

     

    I appreciate the screenshot you've provided. Thus, this helps us get on the same page when sorting out your concern. Please know that my colleague already updated her response above to clarify things.

     

    Based on the visual reference you've provided, it's likely that the Hourly cost rate of the vendor was updated on the vendor profile after creating the Weekly timesheet. That said, the cost rate was unable to show the updated information. However, it'll show up in the next time range. 

     

    That's why erasing the assigned project and adding it back in on the timesheet won't let you see the information. 

     

    To get around this, we can manually enter the cost on the individual timesheet.

     

     

    Otherwise, we can delete and recreate the affected weekly timesheet. 

     

    For more information, I'll add this resource again to help you use projects to track your labor costs and profitability: Track hourly labor costs and profitability by project in QuickBooks Online. 

     

    Click the Reply button if you need more help organizing your projects or any QuickBooks-related concerns. Take care and have a pleasant day.

    E
    everydaysolution
    November 10, 2023

    I too just discovered that paychecks are not always posting to Projects. We pay weekly and on the Project screen, the 10/20 payroll posted just fine into the Time Activity AND the Project Transactions AND the Salaries Expense Total (Overview screen). However, the 10/27 and 11/03 did not post to the Project Transactions or the Salaries Expense Total (Project Overview screen). The time posts to the Time Activity tab on the Project just fine. 

     

    Any resolution as to why this is occurring?

    F
    FateCandylaneT
    November 14, 2023

    I'm here to address your issue about payroll paychecks not posting accurately on your Project expenses, everydaysolution.

     

    We've received similar reports about this concern, and the investigation of this case is still in progress. Our product engineers are already aware of this issue and are implementing measures to provide a resolution.

     

    In the meantime, I suggest reaching out to our customer care team, so they can include you in the list of affected users. This way, you'll receive updates through email notifications regarding the status of the investigation. To do this:

     

    1. Go to the Help icon and choose the Search tab.
    2. Select Contact Us.
    3. Describe your concern and select Continue.
    4. Choose between Chat with us and Have us call you.

     

     

    For future reference, I'm adding this article to help track profitability and labor expenses: Track hourly labor costs and profitability by project in QuickBooks Online.

     

    I appreciate your patience and understanding as we work on resolving this issue. Let me know in this thread whenever you have additional questions about projects. I'll keep an eye on your response to further assist you anytime. Keep safe.

    M
    MissBrown444a
    November 14, 2023

    Unrelated question, yet QuickBooks is blocking me from asking this question, and I'm frustrated. I want to use QuickBooks to become a self-taught bookkeeper. How does this work? 

    B
    Bill Mc
    February 24, 2024

    I have spent so much time on this problem with Intuit.  We need to add Cost of Burden - and it's not working properly.  The Payroll Expense report is good - Hourly Expense report is not working properly.

     

    To add Cost of Burden the Hourly Expense report is used.  Every employee has been updated to reflect the Cost of Burden.  The report shows that some employees will have all the Cost of Burden showing for the project going back to 2022.  Some only show only a portion.  They all show hours (Duration Column) however the Cost Rate column is spotty and no calculations are being made so cost is showing.

     

     

     

    I have to use a workaround for the problem by exporting the two project report types (payroll expenses & hourly expenses) to Excel and then I add the total Cost of Burden to the Payroll Expense report.  Total Duration x Cost of Burden. Thus we have a better picture of profitability.  

     

    What a waste of time since we have several projects.  This should be a simple mathematical equation within the report since all the information is in the database.  

     

    The Hourly Expense report needs to be fixed.

     

    Bill

     

     

     

    T
    tedward77
    September 3, 2024

    I am having same exact issue and no one could help me at QuickBooks. Rediculous 

    Terms & ConditionsAccessibility statement