FROM THE BLOG

Job List in QuickBooks Desktop – Report Customization

I was having a consulting session with one of my clients and they wanted to know how to get a list of jobs out of QuickBooks Desktop. There doesn’t exist a default report that will give you a list of jobs in QuickBooks, but using some advanced customization options you are able to get a detailed job list.

The first step in our customization will be to start with the default Customer Contact List.
Reports>List>Customer Contact List
CustomerContactList

 

 

You end up with the following report that shows all of your customers and jobs.

CustomerContactList2

 

From here we made a few key customization changes to come up with the report we wanted. Click the Customize Report button and select the columns you want to see.  In our case, we wanted to see the job description, the customer, start date, projected and actual end date. (see the following image)Columns

 

Next, I wanted to filter the report so that it only shows Jobs. I did this by including the Customer:Job Level filter. I filtered for the level to be greater than one.

JobFilter

 

Finally, I changed the header to reflect that this is a Job List.

JobListHeader

 

The result was a nice Job List report with meaningful information that the client can memorize for future use.

JobListReport

 

Comments are closed.