How to filter Check Detail report by Job

Hi there, springvalleyhomes.

Currently, there's no option to filter by a specific job in the Check Detail report so that the report will only include payments made to bills that were assigned to a specific job.

However, I suggest pulling up the Job Profitability Details report. From there, you can filter to a specif job and show the payments made to bills that were assigned to a specific job.

Here's how:

1. Click the Reports menu at the top. 
2. Choose Jobs, Time & Mileage. Then, select Job Profitability Details.
3. Select the specific Customer: Job in the Filter Report by Job window. Then, click OK.
4. Double click the total amount and you'll be routed to the item Actual Cost Detail report.
5. Choose the Customize report button.
6. You'll be routed to the Modify Report page and choose the Filters button.
7. From the Filter search box, choose Transaction Type. Then, choose Bill on the Transactions Type drop-down arrow.
8. Hit the OK button. You can now click the bill transaction to show detailed information.

For additional information on how QuickBooks Desktop allows you to customize any report that you generate, you can click this article: Customize reports in QuickBooks Desktop.

Please also refer to this article to see different reports available that cater to your business needs and how QuickBooks generates them: Understand reports.

Please keep me posted on how it goes. I want to make sure everything you're all set with this concern. Have a great week.

Thanks so much for the quick reply and the very thorough and easy to follow details with screen shots. However this option does not give me what I need. The first problem is that the final report includes all bills entered for a specific job whether or not the bill has been paid. I need the report to only include paid bills. Secondly, I need the additional information that the Check Detail report provides, specifically the check numbers and dates of the payments.

Thanks for getting back to us, springvalleyhomes.

I appreciate you explaining how it would help you out. As referenced by my peer above, the option to filter the Check Detail report by a specific job is currently unavailable.

As a workaround, you can pull up and run the Check Detail and the Job Profitability Detail report and export them into Excel. From there, you have the option to combine the information into one report.

Here's how to export the reports:

1. On the Check Detail report screen, click the drop-down arrow beside Excel and choose to Create New Worksheet.
   
2. Select Create new worksheet in new workbook.
3. Hit Export.
   

You can follow the same steps to export the Job Profitability Detail report. Once exported, you have the option to combine all the information you need.

While QuickBooks aims to find new ways to make sure that your product meets your needs, I'll be sure to take note of these ideas. For now, you can visit the What's New section on your QuickBooks Desktop, to be updated with our latest news including product refinement.

Additionally, you can bookmark this link: Resource Hub. This will provide you with resources and videos about managing your QuickBooks Desktop account, income, expenses, inventory, and running reports.

If you have any other questions or need anything else in QuickBooks, let me know in the comment below. I'll be more than happy to help you in any ways I can. Have a lovely day!

Thanks for the suggestion about exporting. But can you explain more about where you say, once exported, I have the option to combine all the information I need? Do you have instructions on how to combine these reports?

Hi springvalleyhomes,

You're right. At the moment, the closest report that can provide the data you need is the Check Detail. We can export it to Excel and manually (copy and paste) rearrange the data in a way that the payment with the date, the check number, and the respective bills will be grouped under each job.

1. Export the report to Excel.
2. Put the check information on the right side of the bills. You can add a Split column to indicate that a check was applied to multiple bills.
3. Remove empty rows and columns, so you can sort the transactions and group them per job.

I got a sample below, where I highlighted some of the things I've changed so you can easily follow.

About your question on why there isn't a "per job" filter on Check Detail, the answer is the base information of the report comes from the check transactions. The payees of these checks are not the jobs, but the company name or the customers of those jobs. This is why there isn't an option to do so.

I'm just around if you have additional questions. You can also check out the Resource Hub that my colleague shared above if you want to see more references for QuickBooks Desktop. Have a good one!

Thanks for the additional reply and example to effectively illustrate your suggestion. The quickness of the replies to my question in an effort to help are quite impressive! :) Unfortunately in our business, we have hundreds of transactions for each job, so manually copying and pasting each one would be impractically laborsome. I may need to do some experimenting into whether some Excel macros could be set up to automate that process or something. But it would sure be nice if that large investment of time was not necessary if the report could simply filter by job. I understand what you are saying about the base information of the report being derived from the check transactions rather than the invoice transactions, but since the jobs are included with each line, that information is still clearly pulled from the invoice for each item on the report, so it would seem it should be possible to simply exclude those lines that don't match a chosen job. I have a bit of a background in programming and databasing, and a simple SQL "join" clause comes to mind for those who may know what I am talking about. :) Is there any chance that the ability to filter by job might be a feature added in the future? I've got to think there has to be many other businesses with this same need that we have.

I know it's tedious to copy and paste the transactions manually, Springvalleyhomes.

Although, for now it's the only way since we don't have the feature yet. I suggest sending feedback directly to our engineers. We're taking notes of our customers' insights and ideas. Most of our new features came from most of our users. Here's how:

1. Click Help inside QuickBooks.
2. Go to Send Feedback Online.
3. Select Product Suggestion.

Our software engineers will review this and might be added in future updates. 

If you have other concerns, please feel free to let us know. We're right here to help you. 

Will do! Thanks again for your time!