Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
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! Go to Solution.
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:
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!
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:
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!
Thank you! This cleared the transactions as we needed.
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.
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.
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!
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?
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.
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