cancel
Showing results for 
Search instead for 
Did you mean: 
Yacht Collector
Level 1

I created a credit memo for a refund, then issued a check for the refund amount, but now the refund amount is showing up as existing credit on the customers account.

I used the methods described and the customer balances went to zero. However, the AR 30/60/90 report now shows the customer as having an account balance due equal to the amount of the check. How do I get the AR report and the customer record to match?QB Report Issue.PNG

Yacht Collector
Level 1

I created a credit memo for a refund, then issued a check for the refund amount, but now the refund amount is showing up as existing credit on the customers account.

QB Report Issue.PNG


I can get the customer account to balance OK using the method, but the AR 30/60/90 report will now show the customer has having a balance due equal to the amount of the refund (or check). How does one get the AR report to accurately show the correct balance. Yes, I did refresh the report. 



 

qbteachmt
Level 15

I created a credit memo for a refund, then issued a check for the refund amount, but now the refund amount is showing up as existing credit on the customers account.

"How do I get the AR report and the customer record to match?"

 

If you have an overpayment from a Payment, you link the Refund by using opening their original payment and applying it to the Check, which is listed as if that is an open invoice.

 

If you have an overpayment from a Credit Memo but you created the check manually, and the check lists AR, the use the Receive Payment screen. Do not enter an amount; there is no New Money to enter. Here you see their Refund Check listed, and the amount that is an Available Credit; use the Icon on the ribbon at the top to Apply Credits.

DunedinMusicSociety
Level 3

I created a credit memo for a refund, then issued a check for the refund amount, but now the refund amount is showing up as existing credit on the customers account.

Thank you!

This has made life so much easier for our not-for-profit.

 

Now here's a follow-up:

 

So, a "customer" purchased something on behalf of the organization.

We have reimbursed them by issuing a credit and writing a check, linking them per your advice.

 

How do we now setup and pay a bill showing the original purchase from the original vendor?

Meaning: we need to record the line items correctly (product added to equity, shipping, etc.) and although the bill was paid, the organization did not send any money to the vendor.

 

Of course, if this whole process is backwards, please do let me know!

We're trying to stop our members spending on behalf of the org, but sometimes they just go ahead and do it anyway.

 

Thank you :)

IamjuViel
QuickBooks Team

I created a credit memo for a refund, then issued a check for the refund amount, but now the refund amount is showing up as existing credit on the customers account.

Greetings, @ DunedinMusicSociety.

 

I can share some information on how you can set up billable expense in QuickBooks Desktop.

 

Depending on the set up or agreement you have with your  vendor, here's how you can process and record vendor refund in QuickBooks Desktop.

  • The vendor sends you a refund check for a bill that is already paid.
    1. Record a Deposit of the vendor check.
    2. Record a Bill Credit for the refunded amount.
    3. Link the deposit to the Bill Credit.
  • The vendor sends you a refund check for returned inventory items.
    1. Record a Deposit of the vendor check.
    2. Record a Bill Credit for the returned items.
    3. Link the deposit to the Bill Credit.
  • The vendor sends a refund check that is not related to an existing bill.
    1. Record a Deposit of the vendor check.
    2. Record a Bill Credit for the amount of the Vendor Check.
    3. Link the Deposit to the Bill Credit.
  • A vendor sends a refund check on behalf of the original Vendor.
    1. Create a deposit for the vendor who sent the refund check.
    2. Create a Bill for the Amount of the Deposit and apply it to the Deposit.
    3. Create a Credit for the Original Vendor.
    4. Create a Bill for the Amount of the Credit affecting the Wash Account and apply the Bill to the Credit.
  • The vendor sends you the refund as a credit card credit.

Keep in touch with us here in the Community if you have other question about creating credit memo for your customers and processing vendor refunds. I’ll be here should you need further assistance.

SHarrisFinancial
Level 1

I created a credit memo for a refund, then issued a check for the refund amount, but now the refund amount is showing up as existing credit on the customers account.

Hi there, 

 

Thanks for sharing this. I am using QBO and cannot resolve this issue. Can you please assist?

MaryLandT
Moderator

I created a credit memo for a refund, then issued a check for the refund amount, but now the refund amount is showing up as existing credit on the customers account.

Hello there, @SHarrisFinancial,

 

I'd be glad to provide you the steps on how to write a refund check in QuickBooks Online.

 

You'll first need to create a bank deposit using the Accounts Payable so you can link the vendor credit to the deposit.

 

Here's how:

  1. Click the Plus (+) icon.
  2. Under Other, select Bank Deposit.
  3. Select the Bank Account where you want to deposit the funds.
  4. Scroll down and go to the Add funds to this deposit section.
  5. Select the name of the vendor in the Received from column.
  6. Pick Accounts Payable in the Account field.
  7. Enter other details in this table.
    createbankdeposit.PNG
  8. Click Save and close.

Then, link the deposit with the vendor credit.

  1. Click the Plus (+) icon.
  2. Select Check under Vendors.
  3. Select the vendor from the Payee drop-down list.
  4. Add the Deposit and Unapplied Payment that appears on the left side in the Check page.
  5. Click Print check to print it.
    linkdepositandvendorcredit.PNG
  6. Then, Save and close.

For your guidance with the solution above, you can go through this article: Manage vendor credits.

 

To learn more about printing checks, please check this out: How to print checks.

 

If you need assistance with this, just leave a comment below. I'd be glad to lend a hand.

ekrukttam
Level 2

I created a credit memo for a refund, then issued a check for the refund amount, but now the refund amount is showing up as existing credit on the customers account.

Changing the account, on the check I'd written, from sales to receivables did the trick, thanks!

LaurensPP
Level 3

I created a credit memo for a refund, then issued a check for the refund amount, but now the refund amount is showing up as existing credit on the customers account.

It's weird. Many things that are talked about in this thread are simply not on my screen. What I want should be way simpler:
1. Customer A: bought several products for 5000 USD.

2. It is decided that part of their purchase will be reimbursed, 1000 USD.

3. I create a Credit Note for 1000 USD and sent it to them. They decide they want a refund.

4. There is now -1000 USD on the customer account.

5. I transfer them 1000 USD.

6. Why does Quickbooks refuse to give the option to connect the bank transaction of 1000 USD to the Credit note that was written. It even says in the top right 'Amount to refund'. That single step would get their balance correct again. Why is it that only Refund Checks can be connected with Bank Transactions.

 

I've tried getting it back to 0 by also writing a Refund Receipt and subtracting the refund amount from the original payment of 5000 USD. The problem is that than the amount of 1000 USD is subtracted twice (or even thrice?) from the Product Account. Besides it is not really a truthful representation.

 

In the past I have circumvented this problem by just writing Refund Checks, which result in correct bookings, but now a customer wants a document that states 'Credit Note'. So now I just want to do it correctly. 

 

If I use the original tutorial it falls apart with Step 3: From the Received from drop-down, select the Customer. Then, select the Discounts and Credits Icon.

 

There is no such thing as a Discounts and Credits Icon?

LaurensPP
Level 3

I created a credit memo for a refund, then issued a check for the refund amount, but now the refund amount is showing up as existing credit on the customers account.

It's weird. Many things that are talked about in this thread are simply not on my screen. What I want should be way simpler:
1. Customer A: bought several products for 5000 USD.

2. It is decided that part of their purchase will be reimbursed, 1000 USD.

3. I create a Credit Note for 1000 USD and sent it to them. They decide they want a refund.

4. There is now -1000 USD on the customer account.

5. I transfer them 1000 USD.

6. Why does Quickbooks refuse to give the option to connect the bank transaction of 1000 USD to the Credit note that was written. It even says in the top right 'Amount to refund'. That single step would get their balance correct again. Why is it that only Refund Checks can be connected with Bank Transactions.

 

I've tried getting it back to 0 by also writing a Refund Receipt and subtracting the refund amount from the original payment of 5000 USD. The problem is that than the amount of 1000 USD is subtracted twice (or even thrice?) from the Product Account. Besides it is not really a truthful representation.

 

In the past I have circumvented this problem by just writing Refund Checks, which result in correct bookings, but now a customer wants a document that states 'Credit Note'. So now I just want to do it correctly. 

 

If I use the original tutorial it falls apart with Step 3: From the Received from drop-down, select the Customer. Then, select the Discounts and Credits Icon.

 

There is no such thing as a Discounts and Credits Icon?

IamjuViel
QuickBooks Team

I created a credit memo for a refund, then issued a check for the refund amount, but now the refund amount is showing up as existing credit on the customers account.

Hello, @LaurensPP.

 

When you create a credit memo, you have the option to apply it to an invoice or give a refund. Let me guide you on how it works.

 

Here's how to create credit memo:

  1. Click the Customers menu.
  2. Choose to Create Credit Memo.
  3. Select the name of the Customer: Job.
  4. Enter the credit memo details.
  5. Click Save and Close.

Once the credit memo is created, you can now write a check with the total amount of the refund.

 

Lastly, to avoid getting open credit memos and unapplied refund checks, let's link the credit memo to the check.  

You can refer to this article for more detailed steps: Give your customer credit or refund in QuickBooks Desktop for Windows.

 

Fill me in if you have other questions. I'm always here to help.

LaurensPP
Level 3

I created a credit memo for a refund, then issued a check for the refund amount, but now the refund amount is showing up as existing credit on the customers account.

Thanks for the reply. Problem is that my Quickbooks looks nothing like yours and many options are not available on my client. We're running the Quickbooks Essentials. I presumed the software is generally the same?

Mark_R
Moderator

I created a credit memo for a refund, then issued a check for the refund amount, but now the refund amount is showing up as existing credit on the customers account.

I appreciate you getting back to us, @LaurensPP.

 

The steps provided by my colleague above is for QuickBooks Desktop (QBDT). And I'd be happy to walk you through the steps on how to get this done in QuickBooks Online (QBO).

 

To create a credit memo, here's how:

 

  1. Click the Plus (+) icon.
  2. Select Credit Memo.
  3. Choose the customer in the Customer drop-down.
  4. Fill out the necessary information.
  5. Click Save and close.1.PNG

Once done, please follow the steps below to create a check with the total amount of the refund:

 

  1. Click the Plus (+) icon.
  2. Select Check.
  3. Choose the payee, then select the appropriate bank account from the drop-down.
  4. In the Category drop-down, select Accounts Receivable.
  5. Enter the credit memo numbers in the Description field.
  6. In the Amount field, enter the amount of the refund.
  7. Select the customer you want to refund from the Customer/Project drop-down.
  8. Click Save and close.2.PNG

Then, here's how to link the credit memo to the check:

 

  1. From the left panel, click Sales.
  2. Select Customers.
  3. Choose the appropriate customer from the list.
  4. Then click Receive payment from the Action column.3.PNG
  5. In the Outstanding Transactions section, select the Check.
  6. Choose the Credit Memos from the Credit section.
  7. Click Save and close.4.PNG

As always, you can visit our QuickBooks Community help website in case you need tips and related articles in the future.

 

Feel free to leave a comment below if you have any other questions with QuickBooks. We're always here to help.

annmareepreston
Level 1

I created a credit memo for a refund, then issued a check for the refund amount, but now the refund amount is showing up as existing credit on the customers account.

I created a CM and did a refund check from this CM but it's showing "open balance" on the customers transaction screen.  It is not showing on the AR report or balance for the customer.  I tried to go to the customer - receive payments but there is nothing there to apply.  

 

How do I get rid of the "open balance" credit showing on the transactions screen?

 

 

 

 

Charies_M
Moderator

I created a credit memo for a refund, then issued a check for the refund amount, but now the refund amount is showing up as existing credit on the customers account.

Thanks for the prompt response, annmareeprestonannmareepreston.

 

I'd like to help get this sorted out. To be able to do so, I may need additional details about your concern.

 

I would appreciate if you can share a screenshot of this to help me better understand the situation.

 

I'll be on the look out of your response. I'll be around to help you out. Have a good one.

annmareepreston
Level 1

I created a credit memo for a refund, then issued a check for the refund amount, but now the refund amount is showing up as existing credit on the customers account.

Please see attached print screens.  I can't clear the "open balance" on the transaction part of the customer tile.  The AR doesn't reflect a balance and I can't use the "receive payments" to offset.

KlentB
Moderator

I created a credit memo for a refund, then issued a check for the refund amount, but now the refund amount is showing up as existing credit on the customers account.

Thanks for attaching a screenshot, annmareepreston.

 

As I look into your screenshot, I've noticed that the account associated with the check was Total Cash and Cash Equivalent. This is the reason why there's an overpayment on your records. In creating a refund, we'll have to take note that we need to select Accounts Receivable as the account so that we'll be able to successfully offset the available credits.

 

We can simply edit the refund then choose AR as the account to fix this. I'll guide you how:

 

  1. Select Customers from the top menu bar.
  2. Choose Customer Center.
  3. Select the appropriate customer from the Customers & Jobs tab.
  4. In the Transactions tab, locate then double-click the check to open it.
  5. Select Account Receivable from the Accounts column.
  6. Click Save & Close, then choose Yes to confirm the changes.

I've added an article that will guide you in creating a credit memo or refund check in QuickBooks Desktop for Windows.

 

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

 

Do you have other questions in mind? Feel free to leave them below. I'll make sure to get back to you as quickly as I can.

annmareepreston
Level 1

I created a credit memo for a refund, then issued a check for the refund amount, but now the refund amount is showing up as existing credit on the customers account.

Hello, 

Thank you for your reply.  I do have the Accounts Receivable as the account on the check.  Please see the snip attached :).

 

Any other ideas?

 

Thank you!

ReyJohn_D
Moderator

I created a credit memo for a refund, then issued a check for the refund amount, but now the refund amount is showing up as existing credit on the customers account.

Thanks for providing a screenshot and following the steps provided by my colleague @annmareepreston.

 

Aside from making sure that the Credit memo and the Check use Accounts Receivable as the account, you'll also need to ensure to associate and apply them to avoid having an open balance.

I'll walk you through how:

 

  1. Go to the Customer menu then select Customer Center.
  2. Choose a specific customer under the Customer and Jobs tab.
  3. Open the Payment transaction then click on Discounts and Credits.
  4. Check the amount to apply the credits under the Credits tab.
  5. Click Done then Save and Close.

    a11.PNG


a12.PNG

Once done, go back again to that customer then select All Sales Transactions under the Transactions tab and set the Filter by to All.

Hit View as Report under the Run Report drop-down. This will show you a zero amount for the Open Balance column.

 

That should do it!

 

I've also included articles to know more about how to give refunds or credit, manage checks and accounts receivable workflows in QuickBooks Desktop:

 

Get back here again in the Community if you need further assistance. I'll be here to help. Take care and have a good one!

annmareepreston
Level 1

I created a credit memo for a refund, then issued a check for the refund amount, but now the refund amount is showing up as existing credit on the customers account.

Maybe I am misunderstanding but when I select the "payment transaction", which is a check created from the CM, it doesn't give me a Discounts and Credits option.  I have tried going to the receive payments screen and it doesn't show any balances to record a discount or credit to.  See attached.  

JasroV
QuickBooks Team

I created a credit memo for a refund, then issued a check for the refund amount, but now the refund amount is showing up as existing credit on the customers account.

Thanks for the screenshot, @annmareepreston.

 

Let's open the Transaction list of your customers and check if the credit memo was not closed. It could be the credit memo is still open, thus, it show a negative amount in your open balance. Let me guide you how.

 

In your QuickBooks Desktop (QBDT):

  1. Go to the Customers menu.
  2. Select the Customer Center.
  3. Locate and select the customer name.
  4. Go to the Transactions tab.
  5. Locate and select the Credit Memo transaction, then click Ctrl + H to open the transaction history.
  6. Then check if the credit is already refunded.
Also, you'll want to create a credit memo if you wish to use the credit for the next transaction of your customer.
 
However, if you've refunded your customer through check, you'll want to delete the credit to offset the amount of your Account Receivable A/R account
 
I also got you this article that provides detailed information on how you can remove a credit to an invoice: Remove or unapply a credit from an invoice or bill.
 

Let me know in the comment section if there's anything I can help you with. Take care!

annmareepreston
Level 1

I created a credit memo for a refund, then issued a check for the refund amount, but now the refund amount is showing up as existing credit on the customers account.

Please see attached.  The CM says refunded. 

KlentB
Moderator

I created a credit memo for a refund, then issued a check for the refund amount, but now the refund amount is showing up as existing credit on the customers account.

I appreciate all your efforts in performing all the troubleshooting steps provided by my colleagues, annmareepreston.

 

I can see that status of the credit memo is refunded yet there's still a negative balance showing. Also, it seems that all of the possible troubleshooting steps have already been given above. I'd recommend contacting our technical supports. This way, we'll be able to pull up your data and conduct a series of tests to rectify the underlying issue.

 

You can follow the steps below to get in touch with us:

 

  1. Open QuickBooks.
  2. Go to Help, then select QuickBooks Desktop Help.
  3. Select Contact Us.
  4. Enter "Unable to clear customer balance." in the desciption box, then select Continue.
  5. Choose Start messaging.

You can also use this link to connect with us: https://help.quickbooks.intuit.com.

 

I encourage checking out our support hours to ensure that we address your concerns on time.

 

To learn more about the AR account works in QuickBooks, you can visit this article: Accounts Receivable workflows.

 

Should you have any other concerns or questions about QuickBooks, you can always find me here. Assistance is just one comment away.

Susan Mooses
Level 1

I created a credit memo for a refund, then issued a check for the refund amount, but now the refund amount is showing up as existing credit on the customers account.

Working on DESKTOP - having a hsrd time finding help for QBDT

We occasionally have customers rescind their jobs and have to repay their deposit. Essentially we've taken $XX and posted it to their account as a sales receipt, but then the contract is voided and we issue them a refund for that money. No problem thus far. The refunded (check or CC or finance) is sitting there and needs to be resolved against something??  The boss has had me making an invoice for the amount and paying it, but that artificially inflates our sales income. I saw something that said to enter the sales receipt as a negative, but QB won't accept a negative there. We had the money, we gave back the money - how do we record that so the amount isn't showing up on any reports?

Candice C
QuickBooks Team

I created a credit memo for a refund, then issued a check for the refund amount, but now the refund amount is showing up as existing credit on the customers account.

Good afternoon, @Susan Mooses

 

Thanks for joining in on this thread. I hope your day is going well so far. I'd be glad to offer my assistance with your problem about a refund for your customers. 

 

If you want to get rid of the credit, you'll need to make a refund check to apply the credit to. Don't worry. It's a simple process. Here's how: 

 

  1. The check is filled out automatically. Hit OK
  2. Go to the Customers menu. 
  3. Choose Receive Payments
  4. Pick the customer from the Received drop-down box. 
  5. Select the Discounts and Credits icon. 
  6. Find the check you create in the Available Credits portion, and then tap Done
  7. The amount will be applied to the invoice if you hit Yes. This is a prompt to confirm the transfer. 
  8. Click Save & Close

 

For additional details on these steps, check out this guide: Give your customer a credit or refund in QuickBooks Desktop. In the end, if the issue persists, I recommend contacting our Customer Support Team. They have more advanced tools to help walk you through some additional steps. 

 

This steps should do the trick to fix your problem. If you have any other questions or concerns, don't hesitate to ask. I value you and the success of your business. I'm only a few clicks away if you need me. Have a great day! 

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us