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

Refund overpayment to third party that paid for customer account

We received a payment from an insurance company for a customer account. The insurance company overpaid for the customer account, and I need to refund the overpayment to the insurance company. I've applied the payment to the customer account and tried to refund the overpayment, but it only allows me to create a refund for the customer, not the insurance company.  I've tried a journal entry, but that still leaves the customer's account reflecting in our A/R aging report (thought with a zero balance.) What would be the best way to apply the payment to the customer's A/R and create a refund to the insurance company so everything reflects correctly in our accounts and reports?

4 Comments 4
BigRedConsulting
Community Champion

Refund overpayment to third party that paid for customer account

After creating the refund check, edit the check (in your checking account) and change the payee name to the insurance company.  Leave the customer:job on the detail row of the check that uses your AR account.

JHawkins218
Level 1

Refund overpayment to third party that paid for customer account

I've tried that.  While it does remove the the balance from the customer account, and the check is correct as to payee and amount, it still leaves the customer showing in my A/R Aging Summary.  I also tried applying payment by creating a journal entry, but it's the same issue.  

Rea_M
Moderator

Refund overpayment to third party that paid for customer account

Let me share further details as to why the payment for the customer account still shows in your A/R Aging Summary report in QuickBooks Desktop (QBDT), @JHawkins218.

 

You're already on the right track in refunding an overpayment to a third party that paid for a customer account in QBDT. The steps provided by @BigRedConsulting are already correct.

 

Since A/R Aging Summary will let you find out how much your customers owe and when it is due, you'll have to make sure you've set the report date (i.e., includes the sales, payment, and refund transactions date) accordingly. This way, you'll see a zero amount under the customer's account.

 

Pull up the A/R Aging Summary report again, then update the date period in the Dates field. Please see the screenshot below for your reference.

83.PNG

 

To understand further how QuickBooks generates reports, I'd recommend checking out this article: Understand reports.

 

Also, you can customize reports in QBDT to focus on the details that matter to you the most. Then, memorize them if you want the same settings of the customized report to be available for future use. You can refer to this article for the complete details: Create, access, and modify memorized reports.

 

Keep me posted on how it goes. If you have other reporting concerns, please don't hesitate to leave a comment below. I'll gladly help. Take care, and wishing you continued success.

BigRedConsulting
Community Champion

Refund overpayment to third party that paid for customer account


@JHawkins218 wrote:

I've tried that.  While it does remove the the balance from the customer account, and the check is correct as to payee and amount, it still leaves the customer showing in my A/R Aging Summary.  I also tried applying payment by creating a journal entry, but it's the same issue.  

 

 


It sounds like the refund check isn't linked to the over-payment.  I had thought that would happen automatically when creating the refund from the over-payment.  Perhaps not.

 

In this case, edit the payment received and apply it to the refund check, which will look like an invoice.

 

Once both transactions are "paid" by each other, then if there are no other unpaid transactions the customer won't show up on the A/R Aging Summary.

Need to get in touch?

Contact us