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

Remove zero rows from A/R Aging Summary

I wish for my A/R Aging Summary to exclude zero rows.  Previous posts have indicated that these are due to payments and invoices that were not linked, but this is not the case here -- all of the invoices in question are showing as paid and they were linked to the payments at the time that the payments were entered (I have Auto-Apply turned on as well.)  Other prior responses have said that the report could be filtered using Amount > 0 but that has not worked for me either.  I could use the Except Zero Amounts feature on the Fonts tab, but that only removes the zeros, not the rows.  And the Advanced button on the Display tab does not include an option for excluding zero rows.  Does anyone have any other options for clearing these rows off of the A/R Aging report?  Thanks in advance for any help!

Solved
Best answer January 26, 2019

Best Answers
Kristine Mae
Moderator

Remove zero rows from A/R Aging Summary

Hello there, FMPOA.

 

Thanks for doing the troubleshooting step @qbteachmt suggested. Running the verify and rebuild utilities help resolves data integrity issues.

 

In your case, since there are no errors found, you can try to repair QuickBooks. Repairing the software fixes program-related issues.

 

Before doing so, create a backup copy of your company file. This way, we have a copy of your data in case it will be messed up.

 

Then, here's how to repair QuickBooks:

  1. Click the Windows/Start icon on your computer.
  2. Choose Programs and Features, then look for Control Panel.
  3. Choose QuickBooks, then click Uninstall/Change.
  4. Click Continue, then Next.
  5. Choose Repair, then Next.
  6. Wait for the repair to complete, then click Finish.
  7. Restart your computer if prompted. 

Open the report again.

 

If you still have the same issues after repairing QuickBooks. I suggest contacting our technical support to have this investigated further. You can check my colleague @MaryGraceS's post on how to contact them.

 

You can always visit us if you have other concerns. We'll be happy to work with you again. 

View solution in original post

11 Comments 11
MaryGraceS
Moderator

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: 

 

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. 

qbteachmt
Level 15

Remove zero rows from A/R Aging Summary

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.

FMPOA
Level 2

Remove zero rows from A/R Aging Summary

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.

FMPOA
Level 2

Remove zero rows from A/R Aging Summary

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!  

Kristine Mae
Moderator

Remove zero rows from A/R Aging Summary

Hello there, FMPOA.

 

Thanks for doing the troubleshooting step @qbteachmt suggested. Running the verify and rebuild utilities help resolves data integrity issues.

 

In your case, since there are no errors found, you can try to repair QuickBooks. Repairing the software fixes program-related issues.

 

Before doing so, create a backup copy of your company file. This way, we have a copy of your data in case it will be messed up.

 

Then, here's how to repair QuickBooks:

  1. Click the Windows/Start icon on your computer.
  2. Choose Programs and Features, then look for Control Panel.
  3. Choose QuickBooks, then click Uninstall/Change.
  4. Click Continue, then Next.
  5. Choose Repair, then Next.
  6. Wait for the repair to complete, then click Finish.
  7. Restart your computer if prompted. 

Open the report again.

 

If you still have the same issues after repairing QuickBooks. I suggest contacting our technical support to have this investigated further. You can check my colleague @MaryGraceS's post on how to contact them.

 

You can always visit us if you have other concerns. We'll be happy to work with you again. 

FMPOA
Level 2

Remove zero rows from A/R Aging Summary

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

qbteachmt
Level 15

Remove zero rows from A/R Aging Summary

"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.

ssallet
Level 1

Remove zero rows from A/R Aging Summary

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

IntuitLily
Moderator

Remove zero rows from A/R Aging Summary

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.

tmauler
Level 1

Remove zero rows from A/R Aging Summary

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.

MAWP
Level 1

Remove zero rows from A/R Aging Summary

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.

Need to get in touch?

Contact us