Was this page helpful?
Thank you!

Comments or suggestions?



Enter Email Address (optional)
email

Track Job Costs in QuickBooks Desktop

Job costing can tell you if you are making money or not. Simply put, job costing means tracking the expenses for a job and comparing those expenses to your revenue. Using the job costing tools available in QuickBooks Desktop, you can see exactly how much money you spent and made for each job. It can also tell you which job to take in the future since it can help you identify which job is profitable and which is not.

Estimating is one of the most important - and difficult part of running a contractor business but unless you compare your estimated cost and actual costs after the work is complete, there is no way for you to know if your estimates are on point or way off. You can easily address this by utilizing job costing reports available in QuickBooks Desktop.

Detailed instructions
  1. Set up a Customer:Job for each of your job.
    • Even if you have only one job for a particular customer, it is a good idea to set up an individual job for that customer. This enables you to keep track of your income and expenses on a job-by-job basis, and it can simplify your bookkeeping if you add another job for that customer in the future.
    • If you have previously recorded transactions to the Customer, QuickBooks moves those transactions into Job 1 when you create a job.
       
  2. Set up your items to optimize for job costing. The level of detail in your Item list determines the level of detail in your job cost reports.
     
  3. Assign all your expenses to jobs. To get a complete job cost picture, make sure to assign all your expenses to jobs. Make sure you select the appropriate job in the Customer:Job column whenever you enter a bill, check, or time sheet.
    • For billable time: Record the hours spent on the job, using either a weekly time sheet or a single activity entry. Assign the hours to the customer or job (if you're tracking by job). Each entry will automatically be checked in the Billable column on the form.
      Note: Time sheets are a non-posting entry. Time must be imported to a bill or invoice to be included in the Job Profitability or Company Financial Reports.
    • For job-related purchases: (items purchased for a job, subcontracted services) Use a bill, check, or credit card charge to record the purchase. On the Items tab, enter each item or service you purchased. In the Customer:Job column, be sure to assign each item or service to the customer or job (if you're tracking by job).
    • For overhead expenses: Expenses not caused by any specific job (rent, office supplies, etc.) should not be assigned to a Customer:Job. However, you might still want to see these expenses on job costing reports. To do that, create a dummy Customer:Job called "Overhead" and then assign all of your overhead costs to that fake job.
    • For mileage: Record the mileage in the Enter Vehicle Mileage window. If you want to change the amount for this expense (to charge the customer more than the standard rate), you can change it on the invoice.
    • For other expenses: (freight charges, postage, etc.) Use a bill, check, or credit card charge to record the expenses. On the Expenses tab, enter each expense. In the Customer:Job column, be sure to assign each expense to the customer or job (if you're tracking by job).
       
  4. Enter your estimates in QuickBooks Desktop.
    • You can create your estimates in or outside of QuickBooks. If you prefer to create estimates with a spreadsheet or outside the program, you can just record summary estimates into QuickBooks Desktop. Finally, if you create estimates outside of QuickBooks, but you create invoices in QuickBooks, you can simply enter your invoice information in the Create Estimates window and turn your estimates into invoices.
    • You can use some job costing reports without recording estimates in QuickBooks Desktop. However, if you enter estimates in QuickBooks Desktop, you'll be able to use the full range of QuickBooks job cost reports to make sure your project budget is on track and to evaluate how accurate the estimates are and adjust them appropriately for future projects. Estimating more accurately can in turn help you make more money from each job and win more jobs in the future.
      Note: If you enter time and expenses on estimates and also on time sheets or bills, you will need to pick one to transfer to an invoice. For example, QuickBooks Desktop will not automatically correlate time from an estimate and the same time on a time sheet when adding it to an invoice. You have to do this manually.
       
  5. Create Invoices
    • Make sure to Choose the right Customer: Job when creating invoices.
    • If you prefer to create invoices outside QuickBooks Desktop, make sure to enter at least a summary of each invoice into the program so the revenue is included in the job profitability reports.
       
  6. Use the QuickBooks job cost reports to learn how your business is doing on a job-by-job basis.
    • You can utilize job reports to identify which job is profitable and which is not. It will help you create better estimates, analyze how well each job is progressing financially, and identify problem jobs before it's too late to be saved.
KB ID# HOW13339
3/28/2017 10:24:47 PM
QYPPRDQBKSWS09 9138 Pro 2017 4c3ca6