Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
LIMITED TIME 90% OFF QuickBooks for 3 months*
Buy nowI 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.
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:
Please feel free to read these handy articles for your reference:
We're always available if you have further questions. Have a wonderful day!
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.
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:
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!
Rebuilding the data worked! It found 54 issues and the customer balance is now correct. Thank you!!
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here