cancel
Showing results for 
Search instead for 
Did you mean: 
Arzini
Level 3

Best Report for Cash Receipts Encoded

I just finished encoding hundreds of customer payments. However, I couldn't find the best report for a summary for all these cash receipts. I've been using Deposit Detail from Banking but it doesn't show the overpayment of some customers. For example, I have a customer with an Invoice amounting to 500. He paid 600, in which 100 is overpayment. Whenever I print a summary using Deposit Detail report, it only shows 600 amount of payment, not splitting the invoice payment and the over payment. 

1 Comment 1
MaryLandT
Moderator

Best Report for Cash Receipts Encoded

Hi there, Arzini,

 

Let me clarify this situation. The Deposit Detail shows deposits and other transactions they're linked to, such as invoice and its payment. However, it won't include overpayments.

 

As another workaround, you can pull up the Customer Balance Detail report. It will the invoice and the deposit to see the overpayment. Here's how:

  1. Go to Reports.
  2. Select Customers & Receivables, then Customer Balance Detail.
  3. Modify the date when necessary, then hit Refresh.
  4. Find the customer to see the invoice and deposit.
  5. The negative (-100) amount on your deposit is the overpayment.

Also, you'll see ununsed credits the next time you receive a customer's payment. Please see the attached screenshot below for your guidance.

 

I've added this article, Use Check or Deposit Detail Reports to learn more about the report in QuickBooks Desktop.

 

Let me know if there's anything else you need 

Need to get in touch?

Contact us