cancel
Showing results for 
Search instead for 
Did you mean: 
rwellman80
Level 1

We are a flooring company and I need to figure out how to determine the profit and loss per job.

 
9 Comments 9
Catherine_B
QuickBooks Team

We are a flooring company and I need to figure out how to determine the profit and loss per job.

I’d be glad to help you determine that, rwellman80.

 

In QuickBooks Online, we call jobs as Projects.

 

Here's how to run profit and loss report by job:

  1. On the left menu, click Projects then select the project.
  2. In the Project reports tab, choose Project profitability.
  3. You can customize and save this report.

Customized reports will show in the Reports page under the Custom Reports tab.

 

Reach out to me if you have other questions. Have a good one!  

KB27529
Level 1

We are a flooring company and I need to figure out how to determine the profit and loss per job.

Good afternoon.  It is my understanding that if you process payroll through QBO full service payroll that payroll expenses are not included in the profitability report.  Is there another way to determine the profit and loss per job?  I tried to run the profit and loss report from the reports menu, customize, filter, and selected by my customer:project, but still could not get the payroll expenses to appear (probably because the weekly timesheet used to enter the hours is a non-posting transaction, but I am not certain).

KB27529
Level 1

We are a flooring company and I need to figure out how to determine the profit and loss per job.

Good afternoon.  It is my understanding that if you use QBO Full Service payroll that the payroll expenses will not be included on the profitability report.  Is there a work around to determine the profit and loss per job that includes payroll?  I tried to run a P&L report, customize, filter by customer: project, but that still did not include the payroll expenses (I am guessing because we use the weekly timesheet feature which are non-posting transactions).

Charies_M
Moderator

We are a flooring company and I need to figure out how to determine the profit and loss per job.

Hello there, KB27529.

 

Thanks for joining this thread. I want this to be taken care of.

 

Profit and Loss report doesn't include customer jobs. However, you can run the Job Profitability report to determine how much money your company has made to date on the customer or job. Here are the steps that were also provided by my colleague CatherineB:

  1. Go to Projects.
  2. Choose a project name.
  3. Under Project reports tab, click the Project profitability.

I want to ensure that you get the most out of the Projects feature. With this, let me share some helpful articles below:

That's it. Let me know if you have clarifications or questions about this. I'm always here to help.

KB27529
Level 1

We are a flooring company and I need to figure out how to determine the profit and loss per job.

Unfortunately the profitability report under the projects area is not including payroll expenses. I was working with QBO chat support yesterday and was told that this was a known product issue. I came to the community boards hoping to find a workaround for this issue because currently the information on the profitability reports is not accurate.

Anonymous
Not applicable

We are a flooring company and I need to figure out how to determine the profit and loss per job.

We've got a new update, KB27529.

 

Payroll expenses are now part of the Project's profitability. Please go to Projects and select the project name. In the Overview tab, you can see the Payroll Expenses under Cost.

 

 

When you enter hours for payroll from the Project's profile, you'll be routed to the Single Time Activity page and enter the hours from there. Once you're ready to pay the employee, go to the Employees page and click on Run payroll. Select the pay period that has the date for the timesheet. Then, you'll see that the system automatically fills in the hours worked. Click on the Preview payroll button and click on Finish payroll.

 

Let us know if you have any questions. Thanks! 

vpcontroller
Level 11

We are a flooring company and I need to figure out how to determine the profit and loss per job.

@KB27529 

 

"could not get the payroll expenses to appear (probably because the weekly timesheet used to enter the hours is a non-posting transaction, but I am not certain)."

 

With currently rolled out new Projects update, payroll expenses should be a posting type transaction in QBO Projects, if you see Overview tab under Projects.

 

KB27529
Level 1

We are a flooring company and I need to figure out how to determine the profit and loss per job.

Thanks for your help.  For some reason, this is not working as the payroll expenses are not showing on the project overview even though I see the payroll transactions in the project transaction list as well as time activity on the time activity tab within projects.  I will continue to work on figuring out the issue.

JanyRoseB
QuickBooks Team

We are a flooring company and I need to figure out how to determine the profit and loss per job.

Thanks for joining this thread, KB27529.

 

Allow me to jump in and help provide some additional information about the Project's profitability. 

 

Are you using QuickBooks Online version? If so, the payroll expenses are not showing on the project overview since there isn't an option to add a customer on the employee's paycheck.The only expenses that will show on the project overview once you created an expense transaction with a customer's name. 

 

However, if you're referring to tracking an hourly time cost, you can check this article for further information: Track income, costs, and profitability by project

 

Don't hesitate to leave a comment below if you have any other questions about the project feature in QuickBooks. Have a good one. 

Need to get in touch?

Contact us