Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowWe 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?
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.
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.
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.
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.
@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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here