LIMITED TIME 90% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
Kigsby2021
Level 1

Customer has credit balance under Customer name, but not on AR report.

I have a very odd situation where a customer is showing a credit balance (negative amount) on the customer information list, but when I run an AR summary or detail report, it shows they have no balance due.  I've checked that all payment dates are after the invoice date and all the payments and invoices add up to zero.  There are no credit memos or discounts.  Just doesn't make sense.   

4 Comments 4
Mich_S
QuickBooks Team

Customer has credit balance under Customer name, but not on AR report.

Good day, @Kigsby2021.

 

We appreciate your time posting in the Community. I'd be glad to help you today.

 

To match the customer's balance from the Accounts Receivable report, make sure to input the correct date range and accounting method of the report pulled up.

 

For cross-checking, you can also run any other sales or customer reports on QuickBooks Desktop.

 

Let me show you how to run a report:

  1. Go to the Reports menu.
  2. Select Reports center.
  3. Choose the type of report you want to run and select it.
  4. Locate and click on the report.

Please feel free to read these handy articles for your reference:

We're always available if you have further questions. Have a wonderful day!

Kigsby2021
Level 1

Customer has credit balance under Customer name, but not on AR report.

I ran an AR summary and detail report using ALL as the date and even that still shows no balance for that client.  I've checked all invoices and bills associate with that client and all the accounts are correct.   I checked all invoice payments and all show as applied.

MadelynC
Moderator

Customer has credit balance under Customer name, but not on AR report.

I’m here to help so client balance will show up on Account Receivable reports, @Kigsby2021.


Missing information is mostly caused by data issues. QuickBooks offers several ways to make sure your company file is error-free.


You can utilize the Verify Rebuild Data tool. It helps identify and resolve your situation right away. Before that, make sure your software is up-to-date so you’ll have the latest feature and fixes. Then follow the outlined steps below:

 

  1. First, choose Window and then select Close All.
  2. Go to the File menu, and then click Utilities.
  3. Select Rebuild Data.
  4. Follow the onscreen instruction to back up your data.
  5. When the tool finishes, select OK.
  6. Navigate to the File menu, then hover over Utilities.
  7. Click Verify Data and select Rebuild Now once QuickBooks finds an issue with your company file.


Please know that you'll need to log in to your Desktop account using the single-user mode when performing this process.


Here’s information that contains tips on how to manage Accounts Receivable efficiently in QuickBooks. It includes details about the Accounts Receivable aging schedule and its turnover ratio.


Don’t hesitate to let us know if you have other concerns besides this credit balance. We’re always here to help you out. Take care!

Kigsby2021
Level 1

Customer has credit balance under Customer name, but not on AR report.

Rebuilding the data worked!  It found 54 issues and the customer balance is now correct.    Thank you!!

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

Need to get in touch?

Contact us