Job Cost WIP Report Excluding Retention Adjustments

Welcome aboard to the Community, @Holly31.

We want to assist you with your question about memorizing reports in QuickBooks Desktop. However, we need more details to provide the right resolution and to get this sorted out right away.

Can you provide a screenshot of the drilled-down report that you want to memorize? Any information you can to your response would be much appreciated. 

Memorizing reports should retain the same settings you did from the Customize Report section. However, the changes you make to only show totals using the arrow symbols within the report will not carry over to the memorized report (see screenshot below).

Also, drilling-down reports to show a more detailed view of the data you need should work.

For additional information, I've attached some articles you can use about memorizing reports in QuickBooks:

• A memorized report does not open or opens a different report
• Create, access and modify memorized reports

Please know that I'm just a post away if you have any other questions. Have a great day ahead.

Drilling down takes about 15 minutes per job!  Not reasonable.  I think that the report I customized works if I run the standard Job Actual Detail Report first then run the memorized version...each takes several minutes waiting time.   

This company posts transfer invoices to move non billable materials to jobs from the warehouse which pollutes the number of records.  I need to filter for AMOUNT <> 0.  How do I do that?

Hi there, @Holly31.

Including the zero amounts on your reports will depend on the type of reports you have opened. Let me walk you through the steps on how to filter the amount in your customized report.

Here's how:

1. On the report's page, click on the Customize Report.
2. Go to the Filters column from the Modify Report window.
3. Search for Amount and hover your mouse to the >= button then enter 0 on the space provided. If you wanted to add the negative, you the option to choose <=.
4. Once done, click OK.

Once completed, the report you open will now show the transactions that have zero amounts.

For additional reference about running and customizing reports in QuickBooks Desktop, read this article: Understand reports.

Please let me know how it goes in your end. I'm just around to help if you need further assistance with your custom report.

Need to clarify...I need to exclude zeroes.  I want everything >0 and everything <0.  How do I do that?  

Hey there, @Holly31. 

Thanks for following up with us. Let's drill this down a bit. 

To clarify, can you provide a screenshot of the report that you're using? Also, do you mean that you're using a memorized report, and you're unable to change the filter on the report?

When using the <= and >= filter on a report, you'll need to toggle it back and forth to see the <= details and then the >= details. Check out the short clip I've included below to toggle the report. 

I'll be sure to keep an eye out for your response. You can reach out to us here in the Community any time you need a helping hand. Have a great weekend! 

From the WIP report drill in revenue then when the result returns, filter for only REVENUE accounts so that the transfer from revenue to a retention receivable account is not included in the results.  That's what I memorized.  However, I cannot make the drill in feature open the memorized version of the report.

Really need a solution for how to drill into the Actual Revenue field in the WIP report using a memorized transaction.  I have to drill in and filter to remove all adjustments for retention to get gross revenue.  It's tremendously time consuming and brain deadening.  I cannot copy and paste pics in due to the confidential nature of the information.

Hello, Holly31.

Thanks for getting back to us. I have a couple of recommendations to fix the memorized report issues. 

In your case, this might be a case of corrupted data or a damaged list. First, re-sort the memorized reports list to fix the odd behaviors (not saving the drilled down filters and other issues) when opening the Job Cost WIP report. Here's how: 

1. Open the list by clicking on Reports, hovering on Memorized Reports, then selecting Memorized Report List.
2. While it is opened, click the View menu.
3. Choose Re-sort List. 

Second, let's also fix a potential data integrity issue regarding the memorized report. Check this article for the full guide and information about the process: Verify and Rebuild Data in QuickBooks Desktop.

Do you need help with pulling up other reports after fixing the issue? Try checking our report articles for QuickBooks Desktop. Other topics are found here. 

Visit this thread again if you have more questions for QuickBooks Desktop. I'm here to answer them and help you out. 

Where can I get this report?  It's what I've been looking for.

Hello there, Joshua. I can show you how to get the report you need in QuickBooks Desktop (QBDT).

You can run the Job Cost WIP report by following these steps:

1. Open your QBDT file.
2. Go to the Reports tab, then Jobs, Time & Mileage.
3. Click on Job WIP Summary.

From there, you can customize your data, and add or delete columns and other information by going to the Customize Report menu. If you need more references, open this article: Customize reports in QuickBooks Desktop.

 By the time you want to memorize your report, select the Memorize tab from the report's window.

Let me know if there's anything else you need help with your QBDT reports by leaving a comment below. I'm just a few clicks away to help. Keep safe!