cancel
Showing results for 
Search instead for 
Did you mean: 
Accounting4050-2020
Level 1

Customer balance

I have negative balances for some of my customers.  However, when I view a Statement, it's blank.  If I view a QuickReport on the transactions, it doesn't match up to the negative balance.  If I view an Open Balance report, it's -0-.  Client cost reports are -0-.

Where would these negative balances be coming from and how do I get rid of them?  These customers were never invoiced.

Thank you.

3 Comments 3
QueenC
Moderator

Customer balance

Hello there. 

 

When running reports, it's necessary to ensure that the correct filters have been applied to show the desired information. I'd suggest filtering the report Date to All. 

 

Then to resolve the negative balance, feel free to utilize this article as your reference: Resolve accounts receivable and accounts payable balances on a cash basis balance sheet.

 

Additionally, here's an article that'll help you organize your cash flow, and track sales, receivables, and profitability more efficiently: Get started with customer transaction workflows in QuickBooks Desktop.

 

Keep in touch if you need any more assistance in managing customer transactions in QuickBooksDesktop or if there's something else I can do for you. I've got your back. Have a good day and stay safe.

Accounting4050-2020
Level 1

Customer balance

I ran a Customer Detail report with date filter set to “All”. Balances are -0-.

When I run a Client cost report, it has a different balance from the “Balance Total” under Customers & Jobs in customer center. For example:

Jane Doe
Customer Balance Detail: $0
Client cost Report: $164.39
Balance Total: $171.64

We run Enterprise Desktop Solutions 23.0 and are current on upgrades.

Shania_C
QuickBooks Team

Customer balance

Greetings, @Accounting4050-2020.

 

Allow me to share some insights about your concern, when you run a client cost report, it has a different balance from the “Balance Total” under Customers & Jobs in the customer center in QuickBooks Desktop.

 

There are several potential reasons why balances in the customer balance detail may appear as zero in QuickBooks Desktop. A negative balance means there is an unapplied/overpayment or credit. You have to click the amount of the total to review the transaction.

 

 Here are a few things to consider:

 

 

To address the zero-balance issue, begin by examining these factors and correcting any identified discrepancies.

 

You can also check this article to learn more about the difference between Cash and Accrual methods for QuickBooks Online and how to change between the two: Choose between cash and accrual accounting methods in QuickBooks Online

 

If you need further assistance or clarification, just leave a reply and the Community will be here to lend a hand. Keep Safe!

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us