Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
J
jlangr
November 23, 2022
Solved

Accounts Receivable Entry Errors

  • November 23, 2022
  • 2 replies
  • 7 views

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. 

 

Best answer by BigRedConsulting

@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.

2 replies

BigRedConsulting
BigRedConsulting
Level 15
November 23, 2022

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

J
jlangrAuthor
November 23, 2022

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

JessT
JessTModerator
Moderator
November 23, 2022

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!

S
SirielJeaBModerator
Moderator
November 25, 2022

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!

J
jlangrAuthor
November 25, 2022

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

L
lin_jcaj
Level 9
November 25, 2022

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.

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.
Terms & ConditionsAccessibility statement