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

Processing a refund in QB Desktop for Mac 2019 creates a false Accounts Receivable Balance

I had attempted to get help for this problem in another thread, but things got way off track without it ever being solved, so I’m going to start fresh and try to boil things down to the essentials.

 

I am the Treasurer of a nonprofit organization holding a national convention. I use Quick Books Desktop 2019 for Mac. When a “customer” (one of our members) sends in payment for the convention registration fee and for any optional items he or she chooses (tours and the like), I record the payment to the members account using “Create Sales Receipts.”  That works just fine.

 

For various reasons, it has been necessary to refund several members' registration payments.  I do that by clicking on the "Refunds and Credits" button on the QB home page.  This opens a credit memo form that I complete with the members' name in the “Customer/Job,” list the various items they purchased being refunded with quantity and cost, etc., in the normal way and save it.  I then click on the refund button on the top of the “Credit Memos/Refunds” screen and complete the check form that opens and save it. QB automatically chooses “Accounts Receivable” as the account to charge the check to. 

 

The problem is that while this does what it should in most respects (charges the amount of the checks against the bank balance, corrects sales items account registers to reverse the sales and leaves affected customer accounts with zero balances).  However, it creates a false Accounts Receivable asset on the balance sheet equaling the sum of the amounts refunded.

 

One thing I do want to mention because it is a red herring that shows up here and there on the internet and it does not work is opening the Receive Payments window, entering the customer’s name, and checking the linked refund check to apply it against the credit memo.  This just substitutes a false Undeposited Funds asset on the balance sheet for the false Accounts Receivable asset on the balance sheet.

 

Solved
Best answer September 16, 2021

Best Answers
LieraMarie_A
QuickBooks Team

Processing a refund in QB Desktop for Mac 2019 creates a false Accounts Receivable Balance

Yes, you're right, @Florida Clay

 

In reality, that shouldn't touch the Accounts Receivable account. However, QuickBooks uses this account to link the credit memo and the check. Additionally, since they're already linked together, you won't need to do the same process in the Receive Payment window.

 

You can also share your thoughts and ideas about this matter through your account. Our product development team reviews all the feedback we receive to ensure we’re meeting the needs of our customers. 

 

Here's how:

  1. Choose QuickBooks and select Preferences
  2. On the Preferences pane, select Feedback
  3. Click the Enable sending usage data to Intuit check box. The preference is enabled by default. 
  4. Close the Preferences window. 
  5. From this pane, you can follow a link to the QuickBooks Desktop Mac online forum and/or to an online form for submitting feedback.

 

I'm always here if you need further assistance in creating a customer refund. Have a good one.

View solution in original post

5 Comments 5
LieraMarie_A
QuickBooks Team

Processing a refund in QB Desktop for Mac 2019 creates a false Accounts Receivable Balance

Yes, you're right, @Florida Clay

 

In reality, that shouldn't touch the Accounts Receivable account. However, QuickBooks uses this account to link the credit memo and the check. Additionally, since they're already linked together, you won't need to do the same process in the Receive Payment window.

 

You can also share your thoughts and ideas about this matter through your account. Our product development team reviews all the feedback we receive to ensure we’re meeting the needs of our customers. 

 

Here's how:

  1. Choose QuickBooks and select Preferences
  2. On the Preferences pane, select Feedback
  3. Click the Enable sending usage data to Intuit check box. The preference is enabled by default. 
  4. Close the Preferences window. 
  5. From this pane, you can follow a link to the QuickBooks Desktop Mac online forum and/or to an online form for submitting feedback.

 

I'm always here if you need further assistance in creating a customer refund. Have a good one.

Mirabilis
Level 1

Processing a refund in QB Desktop for Mac 2019 creates a false Accounts Receivable Balance

I've been using QB for two decades now and I still don't understand this.  I teach private lessons and I charge monthly using statement charges.  This allows me to keep track of all charges with a single entry (especially because most of the charges are automatic every month) instead of using invoices which then have to be paid.  If a student stops lessons early in a month I have to issue a refund.  Following the steps shown in QB help, I write a credit memo and then write the check.  But the debit for writing the check to the customer does not show up on her account.  What am I missing?

Jovychris_A
Moderator

Processing a refund in QB Desktop for Mac 2019 creates a false Accounts Receivable Balance

Let's record a customer payment, @Mirabilis.

 

Recording a received payment is to show to the customer's account that the credit memo was returned as a refund check. Let me show you how:

 

  1. From the Customers menu, select Receive Payments.
  2. Select Create a Payment.
  3. Fill out the fields.
  4. Select the outstanding check and credit memo.
  5. Choose how you want to deposit the payment.
  6. Select Save.

 

Once completed, you can run the Sales by Item Detail report. By doing so you'd see whether the credit memo is properly applied.

 

If you need assistance running reports such as Profit and Loss or for your sales transactions, I recommend checking out our articles in the Reports topic page. They can help you build specific and detailed reports in QuickBooks Desktop.

 

I'll share what else you want to know in QuickBooks Desktop. If you have other concerns with your customer transactions, let me know. I'll assist you again.

Mirabilis
Level 1

Processing a refund in QB Desktop for Mac 2019 creates a false Accounts Receivable Balance

Thank you for your reply, however I don't think addresses my issue.  I have already entered the original payment for $120.  That money was deposited into my account.  I also entered the statement charge for the same amount.  Then the student took only one lesson (at $30) and couldn't continue.  I need to refund $90 to the student.  When I enter $90 using the Credit Memo/Refund it leaves a credit on the student's account of $90.  However when I write the check for the same amount it does not zero-out the balance on the account.  In fact, it does not affect the students account at all.  So according to the account the student has a $90 credit.  I don't understand the logic here.

ReymondO
QuickBooks Team

Processing a refund in QB Desktop for Mac 2019 creates a false Accounts Receivable Balance

Thanks for getting back to us, @Mirabilis.

Let me join in this conversation and share the right steps on how to record this transaction in QuickBooks Online (QBO). 

 

Once you create a credit memo, this will only apply to your open invoices. Since you're only using statements, then this won't affect your customer's balance. 

 

If your customers made a prepayment for a service but canceled it before fully receiving it, then you can create a check or expense to record the refund. This reduces your bank's balance and offsets the customer's open credit, overpayment or prepayment. Let me show you how:

 

  1. Click + New and choose Expense or Check
  2. Select the customer you want to refund from the Payee ▼ drop-down list.
  3. From the Payment account ▼ dropdown menu, chose the bank account where you deposited the overpayment to.
  4. On the first line of the Category column, select Accounts Receivable.
  5. Enter how much you want to refund in the Amount field.
  6. Fill out the other fields as you see fit, then click Save and close.

 

Once done, follow these steps to link the refund to customer's credit:

 

  1. Select + New and click Receive payment.
  2. Choose the same customer you used for the check or expense when recording the refund.
  3. Fill out the other fields as you see fit.
  4. Under the Outstanding Transaction section, check the box for the expense or check you created when recording the refund.
  5. Make sure the payment is equal to the open balance, then click Save and close.

 

When you're done, you can delete the credit memos you've created and record the refund using these steps. This way, you can correct the customer's credit balance.

 

For additional reference, please check out this article: Record a customer refund in QuickBooks Online.

 

Keep me updated on how it goes, @Mirabilis. I'll be around to help if there's anything else you need with handling your transactions. Wishing you well!

Need to get in touch?

Contact us