Remove zero rows from A/R Aging Summary

Hello there, @FMPOA.

Thank you for reaching out in the Community. I'd be glad to assist you with being able to remove the zero rows on the A/R Aging Summary report.

 You can also add customization to remove zero rows in addition to the Except Zero Amounts feature.

Here's how:

1. On the left pane, select Reports.
2. Search for Accounts receivable aging summary.
3. Under Show non-zero or active only, click the drop-down.
4. Select All under Show rows. 
5. Click Run report.

I've included a screenshot and some articles for additional reference: 

• How to customize reports 
• How to memorize reports 

For additional help, you can also reach out to our Customer Care support. They have the tools that can help you get this resolved quickly.

Here's how:

1. Go to https://help.quickbooks.intuit.com/en_US/contact.
2. At the top right, select your QuickBooks version.
3. Select a topic.
4. Click on the Get Phone Number or Start a Message button.

That should point you in the right direction today.

Feel free to drop a comment below if you have any other questions about customizing the A/R Aging Summary report. I'll be happy to help you out. 

By definition, you see a name and it has unapplied amounts, because of this: " but this is not the case here"

Otherwise, they would not show on the report at all. You don't Hide them. Double-click the Zero in their Total Column. Here are the Unapplied Entries.

They need to be Applied.

If you had applied them and still see the invoice has the status of Paid, then you likely need to Rebuild this file, to relink that transactions behind the scenes.

The Zero is Math; double-clicking their Total of zero, just like double-clicking any value, shows the underlying transactions Causing that value. There should never be a Name on AR or AP aging if the total = 0.

@MaryGraceS

Please Learn from the input here.

The problem is that the AR keeps Aging, and the negative AR is never seen as income or sales tax liability even though it represents Funds.

You need to Fix this, not Hide it.

Thanks for the reply.  Unfortunately, I am using the Desktop Pro version, not QB Online.  The report feature that you point to does not appear to be available in the Desktop version.  Much appreciated.

Thank you for the response.  I did click down through the zeros in the Total column.  It led me to two transactions -- one payment and one invoice -- and it clearly showed that the payment had been applied to that particular invoice.  So I backed everything up and ran the Rebuild utility.  Unfortunately, that had no effect (there were no errors picked up when I ran the utility.)  Any other suggestions would be greatly appreciated!  

Thank you so much -- running the repair did the trick!

"The report feature that you point to does not appear to be available in the Desktop version."

I only answered for Desktop. Everything I explained is for Desktop.

Hi,

I have zero's in my a/r aging summary.

They result from a journal entry I posted to accrue a donation (revenue) to a prior fiscal year and the other to reverse that accrual in the fiscal year (and month) that the actual deposit to the bank was made.

So these two journal entries correctly wash each other out to zero but I'd like to remove them from the A/R aging summary. Because I did this as a journal entry, there is no invoice to link.

Thanks in advance for any guidance.

Sharlene

Welcome to the Community thread, @ssallet.

Let me share some insights on how you can remove the zero amount from your A/R Aging Summary.

Since you created a journal entry for this, you can go directly to the Receive Payments on the Customers menu. After selecting the customer, click the Discounts And Credits option. Go to the Credits tab and select the transaction on the Available Credits field. Click Done when finished.

You can also check this article in case you'll need it in the future: AR balance on the Chart of Accounts does not match AR balance on reports.

Please feel free to reach out to us here with all of your questions and concerns, I'm determined to ensure your success. Thanks for coming to the Community, and have a great day.

I'm using QB Enterprise Non-Profit 2020 version and I can't figure out how to remove zero rows from my A/R Aging Summary, does any know how to fix this problem?  Thanks in advance.

This creates an issue with Sales Tax if the item was a write off via the journal entry (an unpaid invoice). When applying the journal "credit" it then creates sales tax being due in the month the invoice was created - throwing all of previous year(s) sales tax reports/records off and showing a large due balance - this is often missed if someone does not have an accounting background or does not think to check old reports for discrepancies when applying the "credit" to the invoice to clear the line item from the A/R report. Is there anyway to apply the journal entries correctly? We have been trying to remove these A/R 0 balances for years to no avail.