cancel
Showing results for 
Search instead for 
Did you mean: 
pharmaboy
Level 1

Report on new customers

Hi.  I am using QB Desktop.  

I'd like to do a report wherein I can find who are the NEW customers for the current year. 

Manually, I can look at each customer's history, and see when the first invoice was sent.  However, this is cumbersome when there are more than 50 customers. 

Is there a way to get the entire customer data exported to excel, including history?  I could then do some of this in Excel.   Or is there an an alternative way to do this? 

Thanks. 

Solved
Best answer August 03, 2024

Best Answers
BigRedConsulting
Community Champion

Report on new customers

@Ivan_G  RE: However, we can utilize the Customer Contact List report to determine when you started creating transactions for them. To do so, let's enable and customize the Start Date column:

 

What? No, the Start Date does not in any way tell you when you started creating transactions for a customer. 

 

The Start Date is one of the Job fields. It can be empty or it can contain a value the user has entered - any value:

Capture.JPG

 

Why do I know this when you don't? It's literally your job to know how QuickBooks works...

 

View solution in original post

4 Comments 4
Ivan_G
QuickBooks Team

Report on new customers

It's possible to export QuickBooks reports to Excel, pharmaboy. I can show you how and provide the report we can run based on your needs by navigating through the Reports Center.

 

We can optimize the Transaction List by Customer report to have a complete view of the transactions under each customer in a given period:

 

  1. Open your QuickBooks Desktop (QBDT) company file.
  2. Navigate to the Reports menu and select Reports Center.
  1. Enter or modify the reporting period accordingly and alter the Sort By section if needed.
    Transaction list by customer.png
  2. You can also explore the Customize Report option if necessary.
  3. Click the Excel dropdown and choose Create New Worksheet.
  4. Follow the onscreen process of exporting a report.

 

Meanwhile, there's no specific option to determine when you've added your customer to the system. We can only identify the Start Date you've entered on the Job linked to them. If you want to check it out, let's utilize the Customer Contact List report:

 

  1. Go back to the Reports menu and select Reports Center.
  1. Navigate to the Reports menu and select Reports Center.
  2. Enter Customer Contact List on the Search bar. Then, hit the Run icon.
  3. Click the Customize Report button.
  4. From the Display tab, input the Start Date on the Columns field.
  5. Tick the Checkbox column. Then, modify the Sort by and Sort in fields accordingly.
    Display to start date.png
  6. Go to the Filters tab and enter the Start Date in the Choose Filter section.
  7. Select the date period from the All dropdown or alter the From and To fields to display specific info for the chosen period.
  8. Once done, click OK. After that, hit the Excel dropdown, then Create New Worksheet to export the data.

Filter Start Date.png

 

Finally, you may also save your report customization for future use. It helps save time in the modification process as it memorizes your previous inputs on its data.

 

Drop by again on this thread if you have more questions about your customer reports or the exporting process. I'll be here at any time to assist you.

BigRedConsulting
Community Champion

Report on new customers

@Ivan_G  RE: However, we can utilize the Customer Contact List report to determine when you started creating transactions for them. To do so, let's enable and customize the Start Date column:

 

What? No, the Start Date does not in any way tell you when you started creating transactions for a customer. 

 

The Start Date is one of the Job fields. It can be empty or it can contain a value the user has entered - any value:

Capture.JPG

 

Why do I know this when you don't? It's literally your job to know how QuickBooks works...

 

BigRedConsulting
Community Champion

Report on new customers

@pharmaboy  RE: Is there a way to get the entire customer data exported to excel, including history? I could then do some of this in Excel. Or is there an an alternative way to do this? 

 

Yes, you could do this. I'd start with the Transaction Detail report found on the Reports menu under Custom Reports.

On the Filters tab for the report:

- Add the Detail Level filter and set it to Summary Only.

- Add the Name filter and select All Customer:Jobs.

- Remove the Date filter.

 

The resulting report will show all posting transactions for every customer. If you also want to include Estimates, then on the Filters tab Add the Posting Status filter and set it to Either.

 

Once the report runs, send it to Excel and then process it from there to get the oldest transaction for each customer, which for you may be a reasonable stand-in for when the customer was added.

 

------------------------------------------------------------------------

 

Another way to do it, which is easier, is to use our BRC List Reporter   It pulls records directly from QuickBooks and creates reports in Excel from the records.  Using it you can select various data fields from your customer records (name, address, phone, and so on) and also the calculated fields First Sale Date and Last Sale Date. Then, for your purposes, you can sort the resulting report by First Sale Date to see your recently added customers.

 

There's also a Creation Order field available, and you can sort the customers that was as well:

 

Capture.JPG

 

For example, a report the product created from a QB Sample company:

Capture2.JPG

pharmaboy
Level 1

Report on new customers

Thanks to all for these ideas which I am trying out!  Gary

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us