by Sunburst Software Solutions, Inc.
Archives by Month

QuickBooks Tip – Correcting a Job Assigned to Wrong Customer

Print Friendly, PDF & Email

A common conundrum for some bookkeepers is to create a job prior to receiving the contract paperwork, so that materials could be ordered – and then finding when the actual contract arrives that the job was assigned to the wrong customer in the QuickBooks Customer List.

QuickBooks TipWhile this may not be an every day occurrence, it does leave one wondering if there is a “correct procedure” for moving the job to the correct parent customer, if it can be done at all, or if you just have to start deleting things and starting from scratch.

In most cases, this situation can be correct easily, however, the smaller the amount of transactions associated with the job that you need to move the better.

Follow these instructions carefully:

  • Make a BACKUP of your QuickBooks file.

Generate Reports for Job Costing details, to be used for comparison AFTER you have moved the job from one customer to the other.

  1. Run a Time by Job Detail Report – filtered for only this job (Reports menu -> Jobs, Time & Mileage -> Time by Job Detail -> Modify Report -> Filters ->  Customer:Job -> this Job).
  2. Run a Profit & Loss Report – filtered for only this job.
  3. Run an Unbilled Costs by Job – filtered for only this job.
  4. Run an Open Purchase Order Report – filtered for only this job.
  5. Run a Job Costs by Job and Vendor Detail – filtered for only this job.
  6. Additional Reports as necessary.

When you have your printed reports and have made a BACKUP of your QuickBooks data file:

  • In QuickBooks, you MUST be logged in as the Administrator in Single-User mode.
  • Go to the Customer Center -> Customers & Jobs tab -> select this job -> click EDIT.
  • On the Address Info Tab you’ll see a Customer drop down menu, use this to select the correct customer.
Change customer

Right click on the image to enlarge it.

  • Change the Company Name, Bill To Address, Contact, Phones, etc. to be the correct information.
  • Click OK.
  • The Job should now be associated with the Customer you selected.
  • REBUILD your QuickBooks file (File menu -> Utilities -> Rebuild Data).
  • Run the reports to verify that all the associated transactions also moved.

We hope you have found this tip to be helpful, if so please take a moment to leave us a comment.

4 Responses to QuickBooks Tip – Correcting a Job Assigned to Wrong Customer

  • Pingback: Tweets that mention QuickBooks Tip - Correcting a Job Assigned to Wrong Customer | QuickBooks for Contractors blog --
About Your Host:

Nancy Smyth, Certified QuickBooks ProAdvisor

Nancy Smyth, Sunburst Software Solutions, Inc.
QuickBooks Construction & Payroll Expert

I've been using and supporting QuickBooks products since the early 1990's. I've worked with thousands of contractors, assisting them with QuickBooks setup, Certified Payroll Reporting requirements, AIA Billing and Weighted-Average Overtime.

QuickBooks is a powerful product, but learning how to use it in your construction business can be difficult. I hope you find resources available here to be helpful.

Top QuickBooks blogs to read in 2018
We've been selected by TSheets as a Top QuickBooks blog to read in 2018!
Stay updated!

Sign up to receive our latest QuickBooks Tips, Tricks & News via email:

Enter your email address:

Delivered by FeedBurner

We promise NOT to sell, rent, or otherwise distribute your name and email address!

FREE 30-Day Trials

Request FREE 30-day Trials of QuickBooks add-ons for Certified Payroll, AIA Billing & Payroll Wage Management. Save time and increase accuracy on time-consuming error prone tasks; so you get paid on time!

Free 30 day trials of QuickBooks integrated add-ons for certified payroll, aia billing and weighted-average overtime

Certified Payroll Training:
Learn how to complete a Certified Payroll (Prevailing Wage) Report and fulfill your reporting requirements - 2 hour recorded webinar - $99.99. Click here for more info.

certified payroll requirements webinar
QuickBooks Training

Frustrated with QuickBooks?

QuickBooks Premier ContractorLearn how to get the MAXIMUM possible results from QuickBooks in your construction business! Visit our new QuickBooks training website, Learn to use QuickBooks in your construction business.

QuickBooks Time Tracking

Save 10%/FREE 14-day trial!

QuickBooks Time Tracker