Skip to main content
new code with p banner - black friday

BLACK FRIDAY SALE 70% OFF QuickBooks for 3 months* Ends 11/29

Buy now
Switch to QuickBooks and 70% off for 3 Months
Feb 28, 2019 6:06 PM UTC
Question

Customer overpayment, refund and account receivable

A customer paid $200 on an invoice of $150 i.e. they overpaid $50 on the invoice. 

I sent them a check for $50.

Then followed the Refund Receipt workflow to record the payment of $50 to customer.

 

But the Accounts Receivables still show negative $50  (-$50) balance against that customer.

Since I already paid back to the customer, the Account Receivable should be zero'ed out.

 

How do I fix this? 

25 replies

Regina_Lend_A_Hand_Accounting
Level 2
Feb 28, 2019 6:24 PM UTC

1. Click on the plus (+) icon

2. Select Check or Expense under Vendors header

3. Select the customer from drop down that need refund

4. Go to Account under Account details = Accounts Receivable (A/R).

5. Enter the Amount = refund amount

6. Click on Save.

 

Refund receipts are often used when a customer credit card or ACH charge is rejected or returned and a bank feed deposit will need to be reduced by the amount "taken back", the refund receipt is posted to undeposited funds so that it can be included with other deposits.

Mar 3, 2019 11:58 PM UTC

I am using Quickbooks online.

When I go to Expense screen, I do not see "Accounts Receivables" in the Payment Account drop down. 

Level 4
Feb 28, 2019 10:20 PM UTC

@somani_vivek wrote:

 

I sent them a check for $50.

Then followed the Refund Receipt workflow to record the payment of $50 to customer.

 

 


Did you match the Refund Receipt with the check in For Review? Or did you record the check separately?

Mar 4, 2019 12:11 AM UTC

I sent the check outside of Quickbooks. 

When the debit bank transaction was pulled in automatically by QBO, I matched it with the refund receipt.

The bank balances match all fine, but I have the negative entry in the AR.

IamjuViel
Level 8
Mar 4, 2019 6:56 PM UTC

Pleased to have you here, @somani_vivek.

 

To zero out your customer's balance and Accounts Receivables, let's create an expense transaction here's how:

 

  1. Click the Plus Icon (+).
  2. Go to Expense.
  3. Choose the name of the customer.
  4. Select the same bank account used in processing the refund.
  5. In the Category Details section, choose Accounts Receivables in the Category column.
  6. Enter the complete expense details.
  7. Click Save and Close. 

 

That should do it! For additional insights about processing customer's refund, you may check out these articles:

Please don't hesitate to visit us here in the Community if you have other questions about clearing out your customer's balance. I'm always here to help.

Apr 3, 2020 5:32 PM UTC

Hi This was really helpful.  And

I did my refund correctly.  

went into checks, put the customer name in, category= A/R and the refund amount. 

 

But when I go back into the customer's profile I now see $200 OVERDUE but 0.00 due in the transaction list? 

What did I do wrong? 

 

Moderator
Apr 3, 2020 6:38 PM UTC

Thanks for getting back here in the Community, @michella.

 

There are two possible reasons you're seeing this Overdue amount. First is overpayments for the customers' refund.

 

Second,  Refund Receipt may have not been used when processing your refund. To do this, here's how:

 

  1. Click + New.
  2. Select Refund Receipt.
  3. Fill out all the necessary information.
  4. Hit Save and Close.

 

Also, to remove the Overdue amount, you'll have to create a Credit memo and make sure to link it to the check associated with the refund. Here's how to create a credit memo:

 

  1. Click + New.
  2. Select Credit Memo.
  3. Fill out all the necessary information.
  4. Hit Save and Close.

 

You can go back to your Accounts Receivable section to make sure everything is in place.

 

Check out this article to learn how to refund a credit card payment in QuickBooks Online: Refund a credit card payment in QuickBooks Online.

 

Feel free to share your thoughts or concerns here in the Community. I'll be around to back you up. Have a great day and take care always!

Apr 3, 2020 8:27 PM UTC

Hi! 

Thank you for your quick reply.  

If I do a credit memo what do i put as the category? 

A/R? 

Oct 25, 2021 5:20 PM UTC

Someone suggested to me to open an Income Reimbursement account and apply the overpayment there which will take the overpayment back from the income previously received. How accurate is this?

Level 8
Oct 25, 2021 6:43 PM UTC

Good afternoon, @erinebas. 

 

Hey newcomer! Thanks for joining in on this thread. I hope your day is going well. 

 

To see if this information is accurate for your business, I suggest consulting with your accountant. They'll be able to give you the best accounting advice. 

 

Let me know how it goes when speaking with your accountant. We're always here to have your back in the Community. Have a great day!