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

How to quickly locate all "Unapplied" payments

Is there a report (or filter) that will allow me to quickly identify all payments with the status of "Unapplied" at once? I'm referring to payments that have been linked to a client's account but have not yet been linked to a specific invoice. The only method I've found thus far is to manually check each and every client account with an open balance. I'm seeking a quick method to routinely confirm that we have no payments floating around which haven't been properly allocated. 

 

Payments with status of unapplied.png

Solved
Best answer September 29, 2020

Best Answers
MarshallA
Intuit

How to quickly locate all "Unapplied" payments

Hello,

 

Run a "Transaction List By Date" report

 

Add Column: OPEN BALANCE

Filter For: Transaction = PAYMENT

 

That will show all payments in the date range you set and if they have an open balance. 

 

Anything that has an open balance means all or part of that payment is still sitting in the customers account as a credit and hasn't been applied to an invoice.  Once you have this report, you can export to Excel, resort by the open balance and then delete any records that dont have an open balance.  Or, you can setup a filter or sort list in excel and just tell it to not include anything with open balance is blank.

 

 

picture attached

View solution in original post

2 Comments 2
MarshallA
Intuit

How to quickly locate all "Unapplied" payments

Hello,

 

Run a "Transaction List By Date" report

 

Add Column: OPEN BALANCE

Filter For: Transaction = PAYMENT

 

That will show all payments in the date range you set and if they have an open balance. 

 

Anything that has an open balance means all or part of that payment is still sitting in the customers account as a credit and hasn't been applied to an invoice.  Once you have this report, you can export to Excel, resort by the open balance and then delete any records that dont have an open balance.  Or, you can setup a filter or sort list in excel and just tell it to not include anything with open balance is blank.

 

 

picture attached

RR7620
Level 2

How to quickly locate all "Unapplied" payments

Thank you so much for the quick and clear solution, @MarshallA ! 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us