cancel
Showing results for 
Search instead for 
Did you mean: 
boss429
Level 2

Credit Memo Applied Still Appearing in AR

I have a credit memo on A/R that was applied and I don't understand why it is still appearing on A/R.  The transaction history shows 2 invoices.  1 invoice with a 0 in credit balance column and the 1 that appears on A/R report showing the full amount in the credit balance column.  The credit memo is from a prior year.  How can I remove this credit memo without affecting prior periods?  Thank you in advance.

Solved
Best answer February 26, 2021

Best Answers
Rubielyn_J
QuickBooks Team

Credit Memo Applied Still Appearing in AR

Let me provide some insights about this matter, @boss429.

 

Based on the screenshot you provided, let's ensure to link the credit memo to the invoices successfully. This way, it will not appear in the A/R. 

 

Here's how: 

  1. Open your QuickBooks file.
  2. When you create the credit memo, make sure you select Customer: Job. This will open the Apply Credit to Invoice window.
  3. Choose the credit you want to apply automatically.
  4. Lastly, click Done.

 

Let's also ensure that the date of the credit memo is the prior date for this not to show the present date. 

 

Moreover, you can also delete and recreate the transaction with the assistance of your accountant. This is to make sure you're book will not be messed up.

 

For more details, I encourage you to view this link: Give your customer a credit or refund in QuickBooks Desktop for Windows.

 

I've also added this article for future reference: Write off customer and vendor balances.

 

I'm just a post away if you have any questions. I'll be glad to help you more. Have a lovely day.

View solution in original post

11 Comments 11
JoesemM
Moderator

Credit Memo Applied Still Appearing in AR

Hello there, @boss429.

 

Since the credit memo is already applied, you don't have to remove this from your A/R report. Also, the possible reason why there's a balance in the report is that the credit memo has different dates with your invoice.

 

To get the zero balance, you'll have to adjust the period of your report and include the dates of your credit memo and invoice. Let me show you how:

 

  1. Click on Reports at the top menu bar.
  2. Select Customers and Receivables then choose A/R Aging Report.
  3. Click the Customize Report and filter the necessary details.
  4. Set the desired reporting date.

 

To learn more about customizing reports in QuickBooks Desktop (QBDT), consider checking out this article: Customize reports.

 

You can save this report so you won't have to go through the same customization again. Just click the Memorize button and follow on-screen instructions. Check out the Create, access, and modify memorized reports link for more details.

 

I also encourage checking out this link to know more about the AR account works in QuickBooks: Accounts Receivable workflows.

 

If there's anything else you need help with, please reach out to me. I'd be sure to jump in as soon as I can. Thanks for posting and have a great day.

boss429
Level 2

Credit Memo Applied Still Appearing in AR

The credit memo is from over a year ago.  I'm still confused.  My A/R report is dated today and I don't understand why the A/R report should be modified as I do not see this same scenario for other customers where credit memos were applied.  See image attached and let me know what you think.  I believe something was done incorrectly but I can't determine how.Credit Memo Question.PNG

Rubielyn_J
QuickBooks Team

Credit Memo Applied Still Appearing in AR

Let me provide some insights about this matter, @boss429.

 

Based on the screenshot you provided, let's ensure to link the credit memo to the invoices successfully. This way, it will not appear in the A/R. 

 

Here's how: 

  1. Open your QuickBooks file.
  2. When you create the credit memo, make sure you select Customer: Job. This will open the Apply Credit to Invoice window.
  3. Choose the credit you want to apply automatically.
  4. Lastly, click Done.

 

Let's also ensure that the date of the credit memo is the prior date for this not to show the present date. 

 

Moreover, you can also delete and recreate the transaction with the assistance of your accountant. This is to make sure you're book will not be messed up.

 

For more details, I encourage you to view this link: Give your customer a credit or refund in QuickBooks Desktop for Windows.

 

I've also added this article for future reference: Write off customer and vendor balances.

 

I'm just a post away if you have any questions. I'll be glad to help you more. Have a lovely day.

srsebia
Level 1

Credit Memo Applied Still Appearing in AR

This is happening to me. Did you ever get this credit memo issue resolved?

Carneil_C
QuickBooks Team

Credit Memo Applied Still Appearing in AR

Welcome to the Community, @srsebia. I'm here to lend a hand with your concern about reports in QuickBooks Desktop.

 

Beforehand, I just need some more information to help me get on the same page. Have you tried following the steps provided by my colleagues above?

 

If issue persists, I recommend attaching a photo of your concern on this post. This way, I can provide you with the best resolution.

 

In the meantime, I recommend checking out this article to learn more about credit memo QBDT. I appreciate any details you can provide.

 

I’m looking forward to your reply. Have a great rest of the day.

Fazil94
Level 2

Credit Memo Applied Still Appearing in AR

This is happening to our company file as well. 

Is there something wrong with the software? 

Why is the system allowing you to over apply your credit memo? 

katherinejoyceO
QuickBooks Team

Credit Memo Applied Still Appearing in AR

Thanks for letting us know about your concern in this thread, @Fazil94

I've checked our records and couldn't find any active reports about the credit memo being over-applied. 

 

In your case, we can run the Verify and Rebuild Data tool to help us identify the most commonly known data issues within a company file. 

 

Here's how: 

 

  1. From the File menu, click on Utilities.
  2. Select Verify Data.

 

QuickBooks may detect problems with your dat. If there's none, no further action is needed. However, if a specific error message appears, you can search that out in our Articles hub

 

Once done, run the rebuild utility:

  1. From the File menu, click on Utilities.
  2. Select Rebuild Data.

 

After that, close and re-open the company file. Then, log in as the company Admin. That should help get past the hurdle you're experiencing.

 

For a more detailed instructions, see thi article: Verify and Rebuild Data in QuickBooks Desktop.

 

Feel free to come by again and post some more of your experience and cocnerns. We're always around to help. 

 

lisaniles
Level 1

Credit Memo Applied Still Appearing in AR

This is also happening to our file as well. Two credit memos keep appearing in the Receive Payments screen although I have applied them to previous invoices in the same 'Receive payments' window.

Moet
Level 1

Credit Memo Applied Still Appearing in AR

I'm having the same problem.

JoesemM
Moderator

Credit Memo Applied Still Appearing in AR

Greetings, @lisaniles, Moet. Just like you, we want this issue resolved. To solve the problem, let's do some troubleshooting to fix the credit memo that keeps showing on the receive payments screen. 

 

Before we do so, I'd like to know if you've already tried performing the Verify and Rebuild. This feature allows QuickBooks to check for possible data issues within your company file. Once it detects data damage, the program will begin fixing it.

 

If you haven't tried this method of troubleshooting, I'll gladly input the steps below so you can proceed.

 

Verify your company data

 

  1. Go to Window then select Close All.
  2. Go to File, then select Utilities.
  3. Select Verify Data. If you see: 
    • QuickBooks detected no problems with your data—your data is clean, and you don’t need to do anything else.
    • An error message—search for it on our QuickBooks Desktop support site for how to fix it.
    • Your data has lost integrity—Data damage was found in the file. Rebuild your data to fix it.

Capture.PNG

Rebuild your company file data

 

  1. Go to FileUtilities, and then select Rebuild Data.
  2. QuickBooks will ask you to make a backup before it rebuilds your company file. Select OK. A backup is required before you can rebuild.
  3. Select where you want to save your backup, then OK. Don’t replace another backup file. Enter a new name in the File name and select Save.
  4. Select OK when you get the message Rebuild has completed.
  5. Go to File, select Utilities then select Verify Data again to check for additional damage. 
    1. If the verification finds more damage, you’ll need to fix it manually. Search for the error(s) in the qbwin.log on the QuickBooks Desktop support site for how to fix it.
  6. If your error can't be found, you can restore a recent backup. Go to File then select Open or Restore Company.
    • Note: Don’t replace your existing company file. You’ll need to enter the info into your company file again since the backup was created.

Capture.PNG

Please see this article for further guidelines: Verify and rebuild data in QuickBooks Desktop.

 

If you're still encountering the same issue after doing the recommended steps, I suggest reaching out to our customer care support. A phone or chat agent has more tools to investigate your issue further.

 

I also recommend visiting the following website: Accounts Receivable Workflows to learn more about how QuickBooks handles AR accounts.

 

Please let me know if there is anything else I can do to assist you by leaving a comment below. I'll be here to help.

LadyFarmer
Level 1

Credit Memo Applied Still Appearing in AR

I'm having same issue-customer overpaid.   the credit memo created, used the  "use credit to give refund" feature- check created, customer:job is correct on the check AND STILL the report for  Accounts receivable has the credit on it- not applied! ! 

 

What can I do    this is stupid.

 

Frustrating when you can do a transaction with pen and paper but can't get QB to do it!  been a user for over 25 years.

 

Need to get in touch?

Contact us