Get 50% 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.
jlangr
Level 1

Accounts Receivable Entry Errors

Because of long past errors (not mine, lol), my Accounts Receivable detail report lists the same customer twice, once with a negative $48.31 balance and once with a positive balance of the same amount. The books are closed for the original entries, so they cant be changed. The entries resulted from an attempted payment collection for a bounced check. I have attached GJ entries for the transactions so far (2 pages). I'd like to get to a zero balance in the customer's account (so no remaining AR) and get the positive and negative amounts off of the AR detail report. No payment was ever received, and payment is no longer being sought. 

 

Thank you. 

 

Solved
Best answer November 25, 2022

Best Answers
BigRedConsulting
Community Champion

Accounts Receivable Entry Errors

@jlangr  RE: As far as I can find there is only one customer account and name.

 

Oh. I misread. And I didn't look at your attachment, either.  Sorry about that.

 

Now I have, but it's just a Transaction Journal report, not an A/R report.

 

If you mean you have two unapplied line items on the AR report that cancel each other out, then the trick is to apply them to each other. You can usually do this using the Receive Payments window, buy selecting the customer name and then applying the customer's unapplied credit to the open invoice (or other transaction type) that increases the customer's balance, which will appear in the table.

View solution in original post

8 Comments 8
BigRedConsulting
Community Champion

Accounts Receivable Entry Errors

I'd merge the names together by editing one and renaming it to match the other.

jlangr
Level 1

Accounts Receivable Entry Errors

As far as I can find there is only one customer account and name. 

JessT
Moderator

Accounts Receivable Entry Errors

Hi jlangr!

 

Have you tried checking the list of inactivated customers? If not, change your filter to All Customers and find the other name. If the name has an X mark, click that mark to make its profile active again. Then, you can merge the two customers.

 

 

Let me know how it goes. Take care and have a good one!

jlangr
Level 1

Accounts Receivable Entry Errors

No, I only have one customer with that.  name, active or inactive.  

SirielJeaB
Moderator

Accounts Receivable Entry Errors

Hello there, jlangr.

 

Names can be combined by editing one and renaming it to match the other. Since you only see one customer, please re-sort the customer list to restore the default order. Then, click the duplicate customer in the A/R report to see if they truly have the same name. 

 

To re-sort your customer list:

 

  1. Go to the Customer Center tab.
  2. At the top left of QuickBooks, click Edit.
  3. Select Re-sort List.
  4. Click OK.

 

Fore detailed process, please see this article: Re-sort lists in QuickBooks Desktop.

 

You can check this article if you need to merge accounts and customers in QuickBooks Desktop: Merge list entries in QuickBooks Desktop.

 

Please click the Reply button below if you have further concerns in managing your customers or reconciliation process. We're always here to help. Have a great day!

jlangr
Level 1

Accounts Receivable Entry Errors

It's not an issue with duplicate names, which I knew before I asked my initial question.

GlinetteC
Moderator

Accounts Receivable Entry Errors

The unusual behavior might be caused by data damage, 

jlangr.

 

You can run the verify and rebuild data to ensure your company file is free from any data damage. It helps narrow down the source of this error. 

 

Here's how:

 

  1. Go to the File menu, then Utilities.
  2. Select Verify Data and wait until the diagnosis is done.
  3. If you see: "Your data hast lost integrity", proceed to rebuild the company file.
  4. Tap the File menu and Utilities again
  5. Follow the onscreen instructions to save a backup copy of your company file.
  6. Use Rebuild Data and click OK.
     

If the issue persists after performing the suggestions, I recommend working with our Technical Support Team to get this reported. They have the tools to check your company file and help you resolve this issue. To get our support, follow the steps below:

 

  1. Open QuickBooks and click the Help menu.
  2. Select QuickBooks Desktop Help.
  3. On the pop-up screen, select Contact us.
  4. Click the Search for Something else button then type your concern in the Ask us anything box.
  5. Tap Search, then scroll down to get your contact options.

 

Please reach back out to me here with any additional information on the issue, so I can get you taken care of. Thanks for coming to the Community.

BigRedConsulting
Community Champion

Accounts Receivable Entry Errors

@jlangr  RE: As far as I can find there is only one customer account and name.

 

Oh. I misread. And I didn't look at your attachment, either.  Sorry about that.

 

Now I have, but it's just a Transaction Journal report, not an A/R report.

 

If you mean you have two unapplied line items on the AR report that cancel each other out, then the trick is to apply them to each other. You can usually do this using the Receive Payments window, buy selecting the customer name and then applying the customer's unapplied credit to the open invoice (or other transaction type) that increases the customer's balance, which will appear in the table.

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

Need to get in touch?

Contact us