cancel
Showing results for 
Search instead for 
Did you mean: 
jolenehawes
Level 2

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? 

Solved
Best answer December 28, 2022

Best Answers
JamesAndrewM
Moderator

Clearing $0.00 in A/R Aging Summary

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 solution in original post

7 Comments 7
JamesAndrewM
Moderator

Clearing $0.00 in A/R Aging Summary

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!

jolenehawes
Level 2

Clearing $0.00 in A/R Aging Summary

Thank you! This cleared the transactions as we needed.

Rasa-LilaM
QuickBooks Team

Clearing $0.00 in A/R Aging Summary

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.

JeanG
Level 3

Clearing $0.00 in A/R Aging Summary

I have a similar situation, but the JE didn't show when I tried to creating a payment. In my case I need to apply a JE against a payment.

I also have situations where I need to apply a JE to a JE so that there is not a $0 displaying in A/R.

Screenshot 2023-10-19 110025.png

MJoy_D
Moderator

Clearing $0.00 in A/R Aging Summary

I can share some information with processing a customer payment from a journal entry transaction, @JeanG.

 

A journal entry transaction will only show as an Unused Credits if you set the Accounts Receivable as Credit. If you set it as Debit, it'll show as a transaction that you need to process a payment (works like an invoice). Here's more information about adding, editing, reversing a journal entry: Create a journal entry in QuickBooks Desktop for Windows or Mac

 

Refer to the following article on how to clear up the net zero balances in your A/R Aging Summary report: Clear up customers with zero net balances in the Accounts Receivable Aging report

 

Here's how you can write off bad debt in QuickBooks Desktop to ensure your accounts receivable and net income stay up-to-date. It'll guide you with recording invoices that becomes uncollectible. 

 

Let me know if you need further information about journal entries or customer payments in QuickBooks Desktop. I'm always glad to help in any way I can. Have a great rest of the day!

JeanG
Level 3

Clearing $0.00 in A/R Aging Summary

In this case the JE is  debit is an A/R account and credit is the checking account. I need to apply it to a payment. How do I have the JE show in the payment screen?

GlinetteC
Moderator

Clearing $0.00 in A/R Aging Summary

I can provide the information needed to view the JE on the payment screen, JeanG.

 

To see the Journal Entry (JE) on your payment screen, ensure to include the customer's name on the debit side of the JE under Accounts Receivable (AR). This will link the JE to the customer and allow you to view it on the payment window. I have attached a screenshot for your visual reference:

 

Additionally, I encourage you to explore our Customer Transaction Workflow Guide, which offers helpful tips and strategies for efficiently tracking your sales and receivables in QuickBooks Desktop.

 

If you have questions or need further help managing your account, reply to this thread. I'll be ready and waiting to assist you again.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us