Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I need to run a report that filters down to just my inactive customers and see their sales for the year prior.
One of our customers switched ownership and renamed with something very similar. They have 9 locations. To avoid confusion, we needed to make the old customer inactive. But now I would like to do a side by side comparison of last year's revenue to this with the old customer name and the current customer name, but I am not able to select the inactive customers on the filter list because they do not appear there.
I cannot make them active again, so this is not an option.
How to I make them appear as a selection under filter on my sales by class summary/detail report? I am using Quickbooks online.
Yes, there is an option to do that, rlw. Let me show you the step-by-step process.
Running a report in QuickBooks online and customizing the Sales by Customer Summary will let you view all necessary information you need. You must filter the report correctly to achieve the specific report for inactive customers. Here's how:
There is also a way to make inactive customers active again. Here's how:
A browser-related issue might be happening if you can't run the report for specific inactive customers after following the steps.
To fix this, let's access your account through an incognito window to eliminate the possibility of a webpage issue. Below are the keyboard shortcuts:
Moreover, to save the current customization settings, follow these steps: Memorize reports in QuickBooks Online.
Keep in touch if you need more help managing reports in QuickBooks Online. Thank you for using our services, rlw. Take care and be safe.
Unfortunately, this did not work for me. I had already tried running a report with the customization feature and the names of inactive customers do not show on the list to filter down.
I tried an incognito window as well and it didn't work either.
I cannot make an inactive customer active either due to the fact that we retain customers when they change ownership but we set them up as new accounts in our system and zero the other out.
So it is looking like I can't simply run a report with inactive customers only selected. This is for a year to year sales comparison and should be a report that is simple to run. Mind boggling to me that it is not.
Neither option worked. I have tried running that report before and filtering down and the names of inactive customers do not appear on the filter list.
I tried the private browsing as well and they are not there either.
Due to the fact that we retain customers when they change ownership and set them up as new accounts in our system, we cannot make inactive customers active again. Too confusing for billing.
This should be a simple report I can run. It is mind boggling to me that I can't run a simple report with inactive customers.
This is for a year to year sales comparison and I would like to use it for this function, but looks like I need to find some other program that can do it for me.
I appreciate your effort in following the suggested troubleshooting steps provided by my colleague above, Rlw. I know you're finding ways to get the report you need. I'm here to share another workaround to achieve this sales report specific to your inactive customers in QuickBooks Online.
You can pull up a Sales by Customer Summary, and look for a filter that allows you to select All Customers. Applying this filter will enable the report to encompass every customer in your database, both active and inactive. Please refer to the screenshot below:
Next, export the report to an Excel file to enhance customization options, enabling you to edit the report and eliminate any unnecessary details.
Here's how:
If the inactive customer isn't showing on your end, I recommend calling our support team to investigate this error further and verify if there are ongoing cases.
You can follow the steps below:
To learn the best time to get in touch with our support team, tap the link for the full details: QuickBooks Online Support.
If you have further questions or need assistance as you navigate the process, comment below. I'm here to help you facilitate your client sales and ensure everything runs smoothly.
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