Skip to main content
December 28, 2022
Solved

Clearing $0.00 in A/R Aging Summary

  • December 28, 2022
  • 1 reply
  • 0 views

Hello I am trying to clear 2 lines in our A/R aging summary report that show $0.00 but I would like to not have the lines show at all. The first line shows the customer owes $1,029.80 but it's in a general journal entry.

 

The second line is a deposit that was not recorded correctly years ago. Is it possible to somehow apply the deposit to the general entry to clear this? 

Best answer by JamesAndrewM

Welcome to the Community, Jolene. 

 

I'd gladly help you clear transactions in the A/R Aging summary that net to zero. 

 

You might want to modify the customer payment transaction and then pay it as if it were an invoice. Here's how:

 

  1. Open the Receive Payments window and choose the customer.
  2. Click in the Payment column for the General Journal which will appear in the table.
  3. Select Discounts & Credits, then you'll see the other General Journal there. Double-check that the Amount to Use is correct.
  4. Choose Done.
  5. Click Save & Close

 

If you want the same settings of the customized report to be available for future use, you can memorize reports in QuickBooks.

 

Feel free to reply to this post if you need further assistance. Have a great day ahead!

1 reply

December 28, 2022

Welcome to the Community, Jolene. 

 

I'd gladly help you clear transactions in the A/R Aging summary that net to zero. 

 

You might want to modify the customer payment transaction and then pay it as if it were an invoice. Here's how:

 

  1. Open the Receive Payments window and choose the customer.
  2. Click in the Payment column for the General Journal which will appear in the table.
  3. Select Discounts & Credits, then you'll see the other General Journal there. Double-check that the Amount to Use is correct.
  4. Choose Done.
  5. Click Save & Close

 

If you want the same settings of the customized report to be available for future use, you can memorize reports in QuickBooks.

 

Feel free to reply to this post if you need further assistance. Have a great day ahead!

February 15, 2023

Thank you! This cleared the transactions as we needed.

February 15, 2023

Thank you for coming back to the Community, jolenehawes.

 

I'm delighted to hear that my colleague's solution helped clear the transactions in your A/R Aging Summary report.  This information will surely help other users who are experiencing the same issue.

 

Let me also give this link to assist you with future accounting tasks: Community guide. You'll find the resources you need to run and grow your business there. Simply select the article that deals with your concern.

 

Keep me posted below if you have other QuickBooks concerns or additional questions about managing your customer's transactions. I'm always ready to assist you further, jolenehawes.