cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
eddie-paterson
Level 4

How to generate a report of all customers with no transactions in 2 years?

I want to make customers inactive that have had no transactions for two years on QBO.
So I either need a report on customers with no transactions in two years, or a list of customers that have had transactions in the last two years.
Solved
Best answer November 19, 2023

Accepted Solutions
AlcaeusF
Moderator

How to generate a report of all customers with no transactions in 2 years?

Hi Eddie,

 

Thank you for posting here in the Community space. I can help you generate the report you need to help determine customers with no transactions in a specific period.

You can go to the Reports section and use the Transaction List by Customer to show this data. The report lets you view all customers and the related transactions depending on the date you enter.

 

  1. On the left navigation bar, click Reports.
  2. Select Transaction List by Customer under Sales and customers.
  3. Set the custom date to two years.
  4. Review the filters to show all customers and transaction types.
  5. View the report.

 

Alternatively, click the Download icon under the All Sales section to get a copy of the transactions under the customers (see sample screenshot below).

 

 

Also, did you know memorizing a report allows you to save it with its current customization settings? I've attached an article you can visit to learn about the steps and how to export data to Excel: Memorise reports in QuickBooks Online.

 

Leave a comment below if you have other concerns about running sales reports. The Community and I will be around to lend a hand. Take care.

View solution in original post

eddie-paterson
Level 4

How to generate a report of all customers with no transactions in 2 years?

Thank you - that worked

View solution in original post

3 REPLIES 3
AlcaeusF
Moderator

How to generate a report of all customers with no transactions in 2 years?

Hi Eddie,

 

Thank you for posting here in the Community space. I can help you generate the report you need to help determine customers with no transactions in a specific period.

You can go to the Reports section and use the Transaction List by Customer to show this data. The report lets you view all customers and the related transactions depending on the date you enter.

 

  1. On the left navigation bar, click Reports.
  2. Select Transaction List by Customer under Sales and customers.
  3. Set the custom date to two years.
  4. Review the filters to show all customers and transaction types.
  5. View the report.

 

Alternatively, click the Download icon under the All Sales section to get a copy of the transactions under the customers (see sample screenshot below).

 

 

Also, did you know memorizing a report allows you to save it with its current customization settings? I've attached an article you can visit to learn about the steps and how to export data to Excel: Memorise reports in QuickBooks Online.

 

Leave a comment below if you have other concerns about running sales reports. The Community and I will be around to lend a hand. Take care.

eddie-paterson
Level 4

How to generate a report of all customers with no transactions in 2 years?

Thank you - that worked

ChristieAnn
QuickBooks Team

How to generate a report of all customers with no transactions in 2 years?

I'm glad to hear that the solution shared by my peer is extremely helpful for what you need in QuickBooks. This motivates us to provide the best solution that our customers need.

 

Please don't hesitate to click the Reply button below if you have other concerns related to QuickBooks. I'm always here to help, eddie-paterson.

Need to get in touch?

Contact us