Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
fmkport
Level 2

Project Reporting - Estimate vs Actuals report

We use Project Cost accounting and the Estimate versus Actual reports on a daily basis. Most of our projects consist of estimates for equipment, freight and labor. My question surrounds ensuring the actual costs are reporting against the corresponding estimate line. 

For equipment and freight this is generally not an issue as the actual costs are generally coming from purchase orders, bills or inventory, all of which require we input a Product/Service and Description (which corresponds to the estimate descriptions).

The issue surrounds labor costs. We use ADP which requires us to input payroll costs into QBO via a journal entry. Since the journal entry format does not include Product/Service and Description, any costs associated with the journal entry are assigned to a line by themselves on the Estimate report  and do not have any description. I'm assuming that a Product/Service description is needed to assign these costs to the corresponding line. Ultimately the bottom line is correct but the report would be more useful if the actual costs lined up with the estimated costs. Is there a step I am missing?

I did find a workaround which is to enter the payroll costs via a dummy bill (which requires the Product/Service information) which assigns the costs to the correct estimate line but this is inefficient and just adds anther step to the process. 

Any insight would be appreciated.

1 Comment 1
JanbonN
QuickBooks Team

Project Reporting - Estimate vs Actuals report

Based on the information you've provided, fmkport, you're on the right track. Your workaround for tracking the labor cost using a dummy bill is a practical solution.

 

We understand the importance of having the Product/Service included in your Journal Entries for more accurate reporting. I recommend submitting feedback to our product development team so they can analyze your suggestion and consider implementing it in future updates.

 

Here's how to submit your request:

 

  1. Go to the Gear icon.
  2. Select Feedback.
  3. Enter your comments or product suggestions.
  4. Tap Next to submit.

 

Also, it would be beneficial to work with your accountant to explore alternative methods for recording labor costs in a way that aligns with the actual expenses incurred. For now, please continue utilizing the dummy bill as your current solution.

 

We'll be in the comment section of this thread if you need further assistance. 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us