cancel
Showing results for 
Search instead for 
Did you mean: 
Jvance1
Level 1

Cash application report showing invoices applied

QBO user - I'm looking for a report that shows how I applied cash in a deposit.  For example, if a customer sends $1,000 for 4 invoices, I'd like a report showing the payment, invoices applied to, and a total.  I cannot seem to get the invoice number to populate on any reports.  This seems so intuitive.  Our auditors are asking for the payment detail (what invoices cash was applied to) on a couple of deposit selections.  All I can do is "print screen" from editing the deposit, then clicking on the customer transactions inside the deposit, which shows the check marks selecting the invoices to pay.   I can run a report showing the total crediting AR and bank account by customer, but there's no invoices paid detail.  We'd also like this report internally for approval accounting controls.   Any ideas, community?  I'm stumped.

5 Comments 5
AileneA
QuickBooks Team

Cash application report showing invoices applied

Hello, Jvance1. 

 

Thank you for reaching out to the Community. Your best bet is to look at the Transaction List by Customer. If you're looking to filter through these invoices and payments for each customer and the total. 

  

 

 

  

 

 

 

You can also export the report to the Excel. Consider checking out this article for further guidance: Export your reports to Excel from QuickBooks Online.  

 

Just in case, I'll add this article for future reference: 

 

 

Let me know if you have other questions in mind. Stay safe!

Jvance1
Level 1

Cash application report showing invoices applied

This solution seems to include invoices created on my selected date, as well as payments.  I'm strictly looking for payments.  I think the "Invoices and Received Payments" report will show my payment detail; it's just missing a grand total which we could easily compare to the deposit total.  Only filter avail is customer.  

 

Jvance1
Level 1

Cash application report showing invoices applied

Also, it does not show the customer invoice number.  The "num" is actually the customer check number from the apply cash detail screen, NOT the invoice number.  

 

Jvance1
Level 1

Cash application report showing invoices applied

 
Rose-A
Moderator

Cash application report showing invoices applied

I appreciate the details and screenshot you've provided, Jvance1.

 

Since the option to show the deposit total in the Invoice and Receive Payments report is currently unavailable, as a workaround, you can pull up and run the Deposit Detail report, export them into Excel and combine the information from there.

 

Also, the NUM column on the Invoice and Receive Payments report is for Invoice no. You might want to open your transaction and verify its number.
 

 

I recommend customizing the report to get the specific details you need. You can also memorize it to save its current customization settings. It serves as your record and helps you quickly access it for future use. 

 

You can always get back to me if you have any other concerns or have follow-up questions about QuickBooks. I want to make sure you're all set and got you covered. I'm here if you need further guidance. Have a nice day!

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us