Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Work smarter and get more done with advanced tools that save you time. Discover QuickBooks Online Advanced.
Teeperry72
Level 1

AR Aging "checks"

We have "checks" for customer refunds sitting ion our AR Aging Detail Report for balances that are now paid in full. How do we get these off our Aging?

1 Comment 1
LieraMarie_A
QuickBooks Team

AR Aging "checks"

I've got your back, @Teeperry72. The instructions below will help you get that amounts off your A/R Aging report.

 

The Accounts Receivable Aging Detail report shows the total customer's outstanding balances and how long they're past due. Outstanding credits to customer should show as a negative amount in this report. To clarify, did you already record the refund in QuickBooks? After you create a check for the refund, you'll have to link or apply the refund to the customer's credit.

 

For example, I refunded the customer through check. I entered the Accounts Receivable account to offset the overpayment. Please refer to the screenshot below.

Capture.JPG


After that, the A/R Aging Detail report should show like this:

Capture.JPG

To get the amounts off the report, we'll have to link the refund to customer's credit by receiving a zero payment.

 

  1. Go to the Customers menu and then select Receive Payments.
  2. From the Received from drop-down, select the Customer.
  3. Then, select the Discounts and Credits icon.
    Capture.JPG
  4. In the Available Credits section, select the check you created and then Done.
  5. You may see a prompt to Confirm transfer. If you do, select Yes. The amount will be applied automatically to the invoice.
  6. Select Save & Close.


That should do it! This is how my report looks like after linking the refund to customer's credit:
Capture.JPG


Additionally, to see the customer's current outstanding balance, ensure to modify the date to Today.

 

  1. Go to Reports.
  2. Select Customers and Receivables and choose A/R Aging Detail.
  3. Click the Dates drop-down menu and select Today.

 

Refer to these articles to learn more about running an A/R Aging report and how to write off uncollectable balances:

 

Please let me know how it goes or if you have any follow-up questions. I'll be here if you need further assistance. Have a wonderful day

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us