Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
P
PAQS
January 28, 2021
Question

Job costing report for non-billable parts and labor?

  • January 28, 2021
  • 1 reply
  • 3 views

I am new to quickbooks so sorry if this is a newb question. My company mostly does contract jobs with a set price and therefore we do not bill for materials or labor. I would like find a way that i can enter the non-inventory parts and labor I have per job and have them show up on a report that way I can see if we need to increase our bids on future jobs. Currently my plan is to have a "Vendor" set up and create a "item receipt" and enter the materials and assign the line items to the job and deselect billable. I then add my hours and assign them using the "use weekly timesheet". 

 

I run a report for "Company & Finance", "Profit & Loss by Job" however this only returns the items I entered against the total invoice. I would like it to factor in the non-billable labor as well. Is there a better report for doing this, or even a standard accepted practice that I should be using instead?

1 reply

M
MirriamMQuickBooks Team
QuickBooks Team
January 28, 2021

Welcome to the Community space, @PAQS. I'm here to lend a hand. 

 

On your first concern, you can create Non-Inventory Part items in QuickBooks Desktop. Let me show you how:

  1. Go to the Lists menu at the top. 
  2. Select Item List.
  3. Click the Item button in the lower-left corner of the list window.
  4. Choose New.
  5. In the New Item window that opens, select Non-inventory Part from the Type drop-down.
  6. Enter the necessary information. 
  7. Click OK once done.

As for the reports, you can pull up the Unbilled Costs by Job, which lists the costs you assigned to a specific customer or job but have not yet billed as reimbursable expenses. The report groups the unbilled costs by customer so you can see how much of your unbilled costs apply to each customer. If you did more than one job for a customer, the report shows a subtotal for each job. Then, as for the labor, you can run the Time by Job Detail. On this report, it will lists each time activity and shows whether the work is billed, unbilled, or not billable. 

 

To run these reports, here's what you'll need to do:

  1. Click Reports at the top menu.
  2. Select Jobs, Time & Mileage.
  3. Choose  Unbilled Costs by Job or Time by Job Detail. 

Let me also share these great resources for additional reference:

If you have other questions concerning QuickBooks, let me know by commenting below. I’m here to help. Have a great day!

P
PAQSAuthor
January 30, 2021

Ok so I set it up like you said but i have 2 questions.

First when I run the time by detail report it returns the hours assigned to the given job but I would like it to return the total wages paid.

 

Second I would like to only run one report not 2 reports. How can I combine these 2 reports together to give me a overview of my total expenses subtracted from my total income for each job. For reference I am looking for a solution similar to how the "Project" feature works in QBO. It should look something like this:

 

Income:

      Invoice: $2000

Expenses:

      Labor: $500

      Materials: $500

Profit: $1000

Profit Margin: 50%

S
ShiellaGraceA
Level 9
January 30, 2021

Let me help you with your job reports, @PAQS.

 

You can pull up two reports (Payroll Item Detail and Time by Job Detail) and export them to Excel. This way, you can view the wages and hours at the same time. Here's how.

 

To pull Payroll Item Detail:

 

  1. Go to Reports at the top. Then, select Employees & Payroll.
  2. Choose Payroll Item Detail.
  3. Tap the Customize Report button. In the Search Columns field, type Billing Status.
  4. Click OK.
  5. Tick the Excel drop-down at the top, then Create New Worksheet.

 

After that an Excel spreadsheet will open, just cut and paste the columns from there to create one report.

 

With your second question, you can run the Profit and Loss by Job report. This report will display your income, expense, and the net associated with the jobs. You can also filter it to show the unbilled status.

 

Here's how to get there:

 

  1. Go to Reports. Then, select Company & Financial.
  2. Choose Profit and Loss by Job.
  3. To filter, click the Customize button at the top and then the Filters tab.
  4. Search for Billing Status. Then, tick on of the radio button.
  5. Hit OK.

 

 

If you need help with other tasks in QBDT, you can browse for specific topics here and look for responses that fit your concern.

 

Get back to me if you still have questions or concerns with reports. I'll be around to assist you. Take care and have a good one.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement