Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowRecently my a/r againg summary is including inactive customers. according to QB help the only way to only have active customers on this list is to hand pick from names under the customize filters. Is this correct? I thought there was a customize option to pick active, inactive or all..
Hi @CAROLYNSHHI,
Welcome to the Community. Let me share some clarification about the AR report in QuickBooks.
When you run the A/R Aging Summary report, it defaults to show all customers including those who are inactive. Currently, the option to choose only active customers is unavailable.
For now, you'll need to hand pick each one of the names you want to reflect in the report. In case you need the steps, here's how:
If you need a report of your active and inactive customers, you can go to the Customer Center section. This way, you'll be able to export the list to Excel and view all of them.
Please follow these steps:
I appreciate your input on this feature. We always update the features in QuickBooks Desktop, and this preference might be added in the future. As we assess this, I suggest you visit our New Features section by clicking the Help menu at the top menu bar.
For additional reference, you can use the following article to learn how to get the latest version of the report you exported from QuickBooks: Export reports as Excel workbooks in QuickBooks Desktop.
Please let me know if you need anything else regarding customizing reports. The Community and I will be here to help you.
RE: Recently my a/r againg summary is including inactive customers. according to QB help the only way to only have active customers on this list is to hand pick from names under the customize filters.
The AR Aging summary only shows customers who have unpaid transactions - which is its purpose.
Generally, transactions-based reports in QuickBooks pay no attention to the active/inactive status of list records like names, because if they did report results would be incomplete. Using this case as an example, if inactive customers with open and unpaid transactions were excluded, the open balance total wouldn't agree with your balance sheet.
How would excluding customers from the report based on their active/inactive status - instead of whether or not they have unpaid A/R transactions - be helpful?
QuickBooks needs to fix this. I have a number of inactive customers that are cluttering up my aging report and to have to go and hand-pick just the active accounts doesn't make any logical or accounting sense!!
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.