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 a report that shows the customer who are active and have not purchased since may
Including sales rep, email , company name and phone. I tried one that showed everyone who hasn’t purchased since may but it show inactive accounts with kinda defeats the point
Solved! Go to Solution.
Allow me to chime in and provide more information to achieve the report you need, Bryan.
The reports given by my colleague are correct. However, we can generate another kind of report, such as Sales by Customer Detail, which offers a broader scope. This report can be tailored to meet your needs and provides detailed information on active customers, including their sales representative, email, and phone contact details.
Here's how:
1. Open your QBDT software, then go to Reports.
2. Select Sales, then choose Sales by Customer Detail.
3. Click on the Customize Report.
4. In the Display section, go to Columns.
5. Type in, and ensure to marked check the following:
6. Go to the Filter tab, then on the Choose Filter enter Name.
7. Under the Name dropdown, there's an Active status. Make sure to select Active to show only your active customers.
8. Once done, click the OK tab.
Moreover, you have to run the Customer List to access company names. You can then export this data to an Excel file and seamlessly merge it with the Sales by Customer Detail report. You can follow the guidelines provided by my colleague above.
You can also refer to these resources to learn more about QBDT reports and personalizing them:
Additionally, this article can give you details on reports that can be exported to Excel: Export reports as Excel workbooks in QuickBooks Desktop.
Don't hesitate to return to this thread for more questions, Bryan. The Community is here to assist you at any time. Keep safe!
Customizing your financial information allows you to tailor your documents to serve your business operations and customer relationships, Bryan. I’m here to assist you in accessing and generating the reports that best suit your needs. Having the right reports at your fingertips is crucial for effective decision-making and strategic planning within your business. I’m committed to ensuring you can easily pull up your preferred report.
You'll need to generate the Sales by Customer Detail report, which will provide you with a list of customers who have made no purchases, as well as sales reps, phone numbers, and email addresses. Regarding the company names, you'll have to pull up the Customer Contact List. After gathering this information, export both reports into an Excel file and merge them into a single document.
Here's how:
Once completed, proceed to export the Sales by Customer Detail report. Next, pull up the Customer List to obtain the name of the company. Let me guide you through the process:
Feel free to comment below with any questions or topics you'd like us to address regarding financial customization, Bryan. Your inquiries not only help us provide you with the best possible guidance but also contribute to a broader discussion that may benefit other users facing similar challenges.
That shows inactive and active accounts I'm only looking to get Active accounts
That shows inactive accounts as well I need only active accounts
Allow me to chime in and provide more information to achieve the report you need, Bryan.
The reports given by my colleague are correct. However, we can generate another kind of report, such as Sales by Customer Detail, which offers a broader scope. This report can be tailored to meet your needs and provides detailed information on active customers, including their sales representative, email, and phone contact details.
Here's how:
1. Open your QBDT software, then go to Reports.
2. Select Sales, then choose Sales by Customer Detail.
3. Click on the Customize Report.
4. In the Display section, go to Columns.
5. Type in, and ensure to marked check the following:
6. Go to the Filter tab, then on the Choose Filter enter Name.
7. Under the Name dropdown, there's an Active status. Make sure to select Active to show only your active customers.
8. Once done, click the OK tab.
Moreover, you have to run the Customer List to access company names. You can then export this data to an Excel file and seamlessly merge it with the Sales by Customer Detail report. You can follow the guidelines provided by my colleague above.
You can also refer to these resources to learn more about QBDT reports and personalizing them:
Additionally, this article can give you details on reports that can be exported to Excel: Export reports as Excel workbooks in QuickBooks Desktop.
Don't hesitate to return to this thread for more questions, Bryan. The Community is here to assist you at any time. Keep safe!
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