Advanced customer payments report

I'm happy to see you again here in the Community, @pstodman.

You can pull up the Transaction Detail by Account report to see all the amounts on the account that holds the retainers. This also shows the list of customers who make up some balances.

To do that:

1. Click on Reports.
2. Select on Accountant & Taxes.
3. Hit Transaction Detail by Account.
4. Enter the date range of the details that you wanted to see.
5. Press on Customize Report.
6. Refer to the Filters tab.
7. On the Account section, and choose the account that holds the retainers.
8. Tick on OK.

I'm adding some screenshots below for your reference: 

Once done, the report will look like this:

To learn more about the available reports in QuickBooks Desktop and on how to customize them, please see these links below:

• Understand reports
• Customize reports in QuickBooks Desktop

I'm just a reply away if you have any other questions or any QuickBooks related concerns. It'd be my pleasure to help you out. Happy Holidays!

Thanks, this is good to see the total balance of deposits, but what I really need is just to see a list of the customers that have an unapplied balance. I have attached a screen shot. Is there a way for me to limit the "type" to just "sale receipt"? and to see just customers who have an unapplied deposit?

Hello there, @pstodman.

In QuickBooks, there's no way to filter the unapplied balance when you are using a sales receipt.

As a workaround,You'll need to pull up the Bank Deposit and Transaction Detail by Account to check the unapplied balance.

You can check this article, on how to customize the report: Customize reports in QuickBooks Desktop.

In case you need tips in the future, visit our QuickBooks Help Articles site. 

Please let me know how it goes, I’d be always here to help. Have a good day!