Skip to main content
jolenehawes
Dec 28, 2022 2:25 PM UTC
Solved

Clearing $0.00 in A/R Aging Summary

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? 

JamesAndrewMAnswer
Dec 28, 2022 4:13 PM UTC

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!

View in thread

7 replies

JamesAndrewMAnswer
Dec 28, 2022 4:13 PM UTC

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!

    jolenehawesAuthor
    Feb 15, 2023 6:41 PM UTC

    Thank you! This cleared the transactions as we needed.

      Rasa-LilaM
      Feb 15, 2023 8:00 PM UTC

      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.

      Terms & ConditionsAccessibility statement