Solved

Customer center list showing wrong balance

Forum|Forum|5 years ago
January 26, 2021
1 reply
25 views

Just recently some of the balances on my customer list are wrong. It will show that a customer has a balance on the list, but then when I run a report, their balance is actually zero (which is right). I've attached a couple screenshots. I've went through some troubleshooting that I found here online like comparing reports etc., but nothing seemed to help. There are not any credits for the customer, and it is not happening with every customer. This customer in particular is not part of a subcategory and doesn't have any separate jobs listed. The transaction is straightforward with payment applied like usual. Is this just a glitch? It seems to be new since I downloaded premier 2020.

Any help would be greatly appreciated!

QuickBooks Desktop

Best answer by SarahannC

Hello there, Amber15lynn.

Thanks for including screenshots along with the details. It seems like unusual behavior. Let's go ahead and resort to your customer balance. This helps you fix the incorrect balance showing on the lists. Here's how:

Go to the Edit menu and select Find.
Select the Advanced tab.
From the Filter list, select Name.
Click the Name drop-down arrow, then press Ctrl+L on your keyboard.
Select the Include Inactive checkbox.
Select the Name drop-down arrow, then select Re-sort List.
Select OK.
Close and reopen your company file. This ensures to reflect the changes after resorting to your company file.

If the same thing happens, let's run the verify rebuild. This can help fix data-related issues on a company file. Here's how:

Go to the File menu.
Select Utilities.
Click Verify Data then select OK to close all windows.
Then, go back to the File menu.
Select Rebuild Data under Utilities.
QuickBooks will ask to make a backup before rebuilding your company file, select OK.
Once the rebuild is done, click OK.

Also, you can check these articles to learn more about managing customer reports in QBDT:

Let me know how it goes. If there’s anything else you need, please comment below. Keep safe always.

S

SarahannCAnswer

Level 9

Hello there, Amber15lynn.

Thanks for including screenshots along with the details. It seems like unusual behavior. Let's go ahead and resort to your customer balance. This helps you fix the incorrect balance showing on the lists. Here's how:

Go to the Edit menu and select Find.
Select the Advanced tab.
From the Filter list, select Name.
Click the Name drop-down arrow, then press Ctrl+L on your keyboard.
Select the Include Inactive checkbox.
Select the Name drop-down arrow, then select Re-sort List.
Select OK.
Close and reopen your company file. This ensures to reflect the changes after resorting to your company file.

If the same thing happens, let's run the verify rebuild. This can help fix data-related issues on a company file. Here's how:

Go to the File menu.
Select Utilities.
Click Verify Data then select OK to close all windows.
Then, go back to the File menu.
Select Rebuild Data under Utilities.
QuickBooks will ask to make a backup before rebuilding your company file, select OK.
Once the rebuild is done, click OK.

Also, you can check these articles to learn more about managing customer reports in QBDT:

Let me know how it goes. If there’s anything else you need, please comment below. Keep safe always.

A

Amber15lynnAuthor

Hi!

Thank you for the troubleshooting. That worked!!

There were a few customer balance errors found in the verify data step, so I'm assuming the rebuild did the trick.

Thanks again!

Amber

Sign up

Login with SSO

Let's get you signed in

Login with SSO