Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks.Explore Intuit QuickBooks Workforce
QueueBeeNewbie2024
Level 1

I corrected a customer payment in 'Receive Payments' screen, now Balance Total is negative. How do I correct this?

Series of events:

  1. Invoice amount was $240.00
  2. Received paper check for $240.00
  3. In 'Receive Payments' screen, entered payment amount as $280.00 and saved.
  4. This made the 'Balance Total' column in the 'Customer Center' show as -$40,00
  5. I attempted to correct this by reopening the 'Receive Payments' box, selecting payment, and editing to say $240.00, and saved
  6. The total payment in the 'Receive Payments' box is now $240.00, but the 'Balance Total' column in the 'Customer Center' still shows as -$40,00

 

Questions:

  • Does it matter that the 'Balance Total' column shows negative?  Will this be corrected when I run the next batch of invoices?
  • Is there a step I missed that would result in the 'Balance Total' column being zero, which it would be if I had entered the payment correctly in the first place
  • Is it as easy as un-applying the payment in the  'Receive Payments' screen, and then entering and receiving the correct amount, as if nothing had ever happened??

 

Thank you

1 Comment 1
jenop2
QuickBooks Team

I corrected a customer payment in 'Receive Payments' screen, now Balance Total is negative. How do I correct this?

Thanks for sharing a detailed screenshot and walking us through how you specifically recorded the payment, QueueBeeNewbie2024. Your thorough explanation is really helpful in understanding the situation.

 

However, we had to delete the screenshot for security reasons, as it includes the full names of your clients.

 

Now, let's focus on resolving the customer balance issue to ensure we get this sorted out correctly.

 

I followed the same steps, and the balance was reset to zero as soon as the payment was adjusted back to $240. This is because there were no remaining payments or credits after correcting the payment amount.

 

In your situation, there appears to be a discrepancy between the actual payment and the balance in the customer's profile. Let's utilize the Rebuild and Verify Utility tool to assess whether this is a data issue. Here’s how:

 

Run the Rebuild Utility

 

  1. Go to the Utilities menu and choose Rebuild Data.
  2. Select OK if you receive a prompt to back up your company file.
  3. Click OK when you get the message "Rebuild has completed" and proceed with the next step.

 

Run the Verify Utility

 

  1. Go back to the File menu, select Utilities, and then choose Verify Data.
  2. Select OK when you see the message "QuickBooks detected no problem with your data".
  3. If Verify finds an issue with your data, you will be prompted to Rebuild Now or View Errors.
  4. Click Rebuild Now.

 

veridyrebuild.png

 

Here's an article for more details about using this tool: Resolve potential data issues in QuickBooks Desktop.

 

Once done, go back to the customer's profile to check if the balance has been zeroed out.

 

To help you navigate other scenarios when managing various payment situations, I'll share these articles as well:

 

 

Don't hesitate to reply or post new questions if you need anything else. We're here to support you with all aspects of QuickBooks, from tracking customer payments to managing your day-to-day bookkeeping tasks.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us