SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends June 27

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.
rkembroidery
Level 1

Why does my accounts receivable show the wrong total in the chart of accounts?

Accounts Receivable is showing a negative balance.

1 Comment 1
CharmieH
QuickBooks Team

Why does my accounts receivable show the wrong total in the chart of accounts?

The negative balance in Accounts Receivable (AR) on the Chart of Accounts (COA) is typically caused by one of two factors, Rkem.

 

The accounts receivable transaction has affected the balance sheet account, or there is an unapplied payment. Therefore, negative receivable balances typically arise from customer credits or overpayments.

 

If you are using QuickBooks Online (QBO), you can directly adjust the customer's accounts receivable balance. The customer should use credits to pay off the invoice through the Receive Payments feature. If there is a link attached to your invoice, please verify any credit transactions that can be applied to it. I suggest consulting with your accountant before proceeding.

 

You can also address the issue by creating a journal entry if there are no transactions to apply. For this process, debit the AR account and credit the Sales Income or another income account. However, for more accurate guidance, I recommend consulting your accountant.

 

For more information and processes in resolving the negative balance, please visit this article: Resolve accounts receivable balance in QuickBooks Online.

 

If you are using QuickBooks Desktop, I recommend running the A/R Aging Summary report to check the associated transactions and review the possible overpayments.

 

Here's How:

  1. Click the Reports menu at the top.
  2. Choose Customers & Receivables.
  3. Select the A/R Aging Summary report.
  4. Double-click the negative amount. Then, it opens the A/R Aging QuickZoom report.
  5. Open the payment that shows an open balance. Then, you're able to verify the payment amount entered.

 

For more information, please check this helpful resource: AR balance on the Chart of Accounts does not match AR balance on reports.

 

After completing the process, you have three options for handling the credit. You can click this article: Learn how to give your customer a credit or refund in QuickBooks Desktop for Windows.

 

You may also visit these articles for QBO and QuickBooks Desktop to guide you on matching your bank and credit card statements:

 

If you have any other questions, you're always welcome to revisit this thread and leave your queries below.

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

Need to get in touch?

Contact us