Created with Sketch.Learn about PPP and Loan Forgiveness, stay informed with the latest changes.
Created with Sketch.Need help with 1099's or other Year End topics? Visit our Year End Resources page.
Created with Sketch.New to QuickBooks or using a new product? Visit our Get Started resource page to help you get going.
Created with Sketch.Need to make changes to your account? Visit the Account Manager Portal.
cancel
Showing results for 
Search instead for 
Did you mean: 
Level 1

Change Credit Memo to Over Payment Refund after the check has been cashed

Hello. I am the treasurer of small HOA. One member sold her house and paid twice the Transfer Fee by mistake. I did a credit memo for the extra Transfer Fee, did a refund check for her and the check has been cashed. Now the A/R Aging Summary Report shows a total of $0.00 for her, but also shows a positive $275.00 on one month for the check when it was cashed and a negative -$275.00 the next month for Credit Memo. Since she moved out of the HOA and she is listed "Customer is inactive", I don’t want her to showing the A/R Summary since it’s a total of $0.00.

 

My first time doing a credit and looks like I should do a credit for over payment instead a credit memo. I tried changing to an over payment but I can’t figure how to make the cashed check merge with an over payment, and take her off the A/R Aging Summary. Any ideas?

 

This question might be answered before but my brain was exhausted looking at the posts and comments on this forum.  I  thought about the changing the filters the A/R Aging Summary but there a lot of filters there.

Solved
Best answer January 09, 2019

Best Answers
QuickBooks Team

Change Credit Memo to Over Payment Refund after the check has been cashed

Hello, @jeffbales.

 

Allow me to join this thread and provide additional information with this A/R Aging Summary report concern.

 

To zero out the amount of the check and credit memo on your A/R Aging Summary report. You'll need to make sure that the date for both transactions is the same. Also, ensure that the credit memo was linked to the invoice. However, before making any changes, I'd suggest reaching out to your accountant. This way they'll be able to check on your transactions and keep your records accurate. 

 

You've got us here if there's anything else you need. The Community is always ready to lend a hand. Have a great day!

View solution in original post

6 Comments
Level 15

Change Credit Memo to Over Payment Refund after the check has been cashed

Doing the Credit Memo was the mistake; if, you already have negative AR from the double-payment, you just made another Negative AR using the CM. Delete it.

 

This is not correct: "and looks like I should do a credit for over payment instead a credit memo"

 

When you first got paid, you would have used Receive Payment and it was too much money = leaves negative AR. Or, you processed it anyway as Transfer fee, so yes, that is what you put on the CM, and you never had Negative AR all this time.

 

It's one condition or the other.

 

The name at total = 0 never shows on the AR reporting unless you forgot to Make the one from the other = they need to be linked. With the CM, there is an icon at the top to Refund; that Links them.

 

Or, you simply use the Transfer fee on the check to refund, and never needed all of this to run through AR at all.

 

To take ZERO names off of the AR Aging Summary, double-click their 0; here are the Unlinked transactions. Example:

You have an earlier payment and a later invoice, so now you open that original payment to Apply it to the new invoice, and their name disappears from the AR Aging Summary.

 

In your case, you use Receive Payment, leave the amount as $0 and apply the Available Credit to the refund check, which is a row like an invoice, because you listed AR on it.

 

Try not to do too many steps for any one thing.

Level 1

Change Credit Memo to Over Payment Refund after the check has been cashed

Did you my read question?  I did this over two months ago and the check has already been cashed.

QuickBooks Team

Change Credit Memo to Over Payment Refund after the check has been cashed

Hello, @jeffbales.

 

Allow me to join this thread and provide additional information with this A/R Aging Summary report concern.

 

To zero out the amount of the check and credit memo on your A/R Aging Summary report. You'll need to make sure that the date for both transactions is the same. Also, ensure that the credit memo was linked to the invoice. However, before making any changes, I'd suggest reaching out to your accountant. This way they'll be able to check on your transactions and keep your records accurate. 

 

You've got us here if there's anything else you need. The Community is always ready to lend a hand. Have a great day!

View solution in original post

Level 15

Change Credit Memo to Over Payment Refund after the check has been cashed

@BettyJaneB

 

No, this is a Mistake, to give this guidance: "You'll need to make sure that the date for both transactions is the same." Please learn from my input here.

 

They are dated for Reality. You don't need them to be the same, if in reality they didn't happen on the same date. You are telling someone to make an error by changing their financial activity dates.

 

I gave instructions for how to Fix this by applying them Now. This fixes the Status that this is showing Not Applied. All this has is Unapplied Credits and open AR Balances that need to be Applied.

Level 1

Change Credit Memo to Over Payment Refund after the check has been cashed


@BettyJaneB wrote:

Hello, @jeffbales.

 

Allow me to join this thread and provide additional information with this A/R Aging Summary report concern.

 

To zero out the amount of the check and credit memo on your A/R Aging Summary report. You'll need to make sure that the date for both transactions is the same. However, before changing the date, I'd suggest reaching out to your accountant. This way they'll be able to check on your transactions and keep your records accurate. 

 

You've got us here if there's anything else you need. The Community is always ready to lend a hand. Have a great day!


Thanks!  I looked at the both the Credit Memo and Check, and I saw at the top the Credit Memo it was checked to Print Later.  I unchecked and it ask me what to do with the credit.  I said apply to invoice, clicked the Check invoice and viola, it's fixed.  Once again, Thanks! 

QuickBooks Team

Change Credit Memo to Over Payment Refund after the check has been cashed

I appreciate you reaching back out to me, @jeffbales.

 

I'm glad to hear that this A/R Aging Summary report concern has been resolved and you are most welcome. 

 

Don't hesitate to post any questions you may have with QuickBooks. We're always here to help you out. Wishing you and your business continued success!

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us