QuickBooksHelp
Intuit

Track job costs in QuickBooks Desktop

Job costing means tracking the expenses for a job and comparing those expenses to your revenue. With QuickBooks Desktop's job costing tools, you can see how much money you spend and make for each job.

Follow the steps below to make sure that you have an accurate record of your job costs.

Make sure to set up each item with enough info. The level of detail in your Item List will determine the preciseness of your job cost reports. Learn how to add, edit and delete items in QuickBooks Desktop.

Step 1: Set up a Customer:Job for each of your jobs

Even if you have only one job for a particular customer,  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 can simplify your bookkeeping if you add another job for that customer in the future.

Step 2: Assign all your expenses to jobs

To get a complete job cost picture, make sure to assign all your expenses to jobs. Select the appropriate job in the Customer:Job column whenever you enter a bill, check, or timesheet.

  • For billable time: Record the hours spent on the job, using either a weekly timesheet or a single activity entry. Assign the hours to the customer or job. Each entry is automatically checked in the Billable column on the form. Note: Timesheets are a non-posting entry. You must import time to a bill or invoice to include it 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.
  • For overhead expenses: If you choose to allocate overhead expenses to specific jobs, here's how to calculate and track overhead costs. Please speak to your accountant before you make any changes to your company file.
  • 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.

Step 3: 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.
  • 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, entering estimates in QuickBooks allows you to use the full range of Job Cost reports to make sure your project budget is on track. You can evaluate how accurate the estimates are and adjust them appropriately for future projects.

Note: If you enter time and expenses on estimates and also on timesheets 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 timesheet when adding it to an invoice. You have to do this manually. Learn how to create an estimate.

Step 4: Create appropriate 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 it includes the revenue in the Job Profitability reports. Learn how to create an invoice.

Step 5: Run job costing reports to see 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 helps you create better estimates, analyze how well each job is progressing financially, and identify problem jobs before it's too late to be saved.

To access various job reports:

  1. Go to the Reports menu.
  2. Select Jobs, Time, & Mileage.

QuickBooks Premier Contractor Edition and Accountant Edition offer a wider range of job costing reports, you can find them here:

  1. Go to the Reports menu.
  2. Select Industry Specific, then select Contractor Reports.

Learn more about reports in QuickBooks.

Advanced Reporting: Information at your fingertips.

QuickBooks Desktop Pro and Premier users can get advanced reporting features by upgrading to QuickBooks Desktop Enterprise. Give us a call at 888-566-4671 and see if it's right for you.