Retention Report

Thanks for posting here with this reporting concern, @Cindy Croft,

I want to make sure we're on the same page, so I can guide you further with this. What report in QuickBooks are you using at the moment? Our reports in QuickBooks has different preferences and filters so I need this information to help you.

In the meantime, here are some general customizations for the reports in QuickBooks:

1. Click the Customize Report button at the top and update the Report Date Range.
2. Once done, go to the Filters tab.
3. In the Filter search box, enter and select Transaction Type.
4. Choose Multiple Transaction Types and pick the bill payment and checks or other expense transactions you need.
5. Next, find the Posting Status filter then select Either.
   
6. Hit OK when you're done.
7. To save the custom filters, use the Memorize button at the top. You can use this for every Payment Method you want to track. Access saved reports in the Memorized Report List.
   
   

I'll be adding some articles to help you maximize the use of our reports in QuickBooks. See hem below:

• Customize reports in QuickBooks Desktop - Intuit
• Understand reports - QuickBooks - Intuit

I'll be waiting for your response and I'll be right here if you have any questions about QBDT reports. Have a nice day!

For the Outstanding Sub Retention by Job, I started with the Job Costs by Job and Vendor Summary report, and then changed the filters to specifically track just the Retention Payable account.

Also, I added the Posting Status - "either" to the filter, but it didn't change the report, and I was already using the Transaction Types - "multiple" as a filter.

Oh dear, I just realized why the journal entry amounts won't show up in the report by job. It is because in my journal entry I have them recorded by vendor in the "name" field.

Thank you for looking into this for me anyways. :)

Cindy