Showing results for 
Search instead for 
Did you mean: 
Level 2

Advanced customer payments report

Could someone tell me how to create a report that will show me every customer that has an unapplied retainer on their account? When we take in a retainer we create a sale receipt that credits advanced customer payments. When we invoice we create a credit to the customer to apply the retainer to an invoice. 

I can look at my chart of accounts or balance sheet to see the balance for that account, but I can't run a report that would show me a list of customers that make up that balance.

3 Comments 3
QuickBooks Team

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:

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!

Level 2

Advanced customer payments report

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?

QuickBooks Team

Advanced customer payments report

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!

Need to get in touch?

Contact us