Handling a customer overpayment

Hello there, @NLA2.

In QuickBooks Desktop, the Customer List balance should ideally show $0 if you've created two invoices and successfully applied the payments and credits. Let me share insights into why the balance shows as -$75 on the Customer List in QuickBooks Desktop but appears as $0 on the invoice within the customer's page.

Based on the screenshot, it appears that only one invoice has been created for the customer. This is why the Customer List shows a balance of -$75—because the remaining balance of the payment has not yet been applied. When a payment exceeds the invoice amount (an overpayment), QuickBooks reflects the excess amount as unapplied, which results in a negative balance in the Customer List.

On the customer’s page, the invoice displays an Open Balance of $0 because the Open Balance reflects only the amount due for that specific invoice. Once the invoice is fully paid, the Open Balance for the invoice updates to $0, indicating that no payments are outstanding for that particular transaction.

I recommend ensuring that there are two invoices and the credits are applied properly to the correct invoice or customer.

Don't hesitate to comment below if you have further questions about managing invoices and payments in QuickBooks Desktop. 

Screencap #3 shows the original invoice for $75.00, that the $150.00 payment was first applied to.

Thank you for sharing an additional screenshot, @NLA2. It helps clarify your concern.

Based on the recent information you provided, the $150 payment has been correctly applied to the two invoices, so the Customer List balance should now be zero.

To ensure accurate payment records, it's best to keep your QuickBooks Desktop up to date.

If you’ve confirmed it’s updated, use the Verify and Rebuild Data tool to identify issues in your company file. I recommend creating a backup of your company file to protect your data before you proceed.

Let's verify your company data:

1. In the Window tab, tick Close All.
2. Select on File and click Utilities.
3. Choose the Verify Data.

Next, follow these steps to rebuild your company data:

1. Open the File menu and select Utilities.
2. Click Rebuild Data and tick OK.
3. Save your backup and click OK.
4. When a confirmation appears, click OK.

Hit the Reply button below if you have other questions. We're here to help.