Customer Contact List - Last Transaction
Using Quickbooks Online, I'd like to pull a customer contact list that includes a column saying when their last transaction was. I can customize the current report to show terms, created date (like when the customer was created), last modified date (if we changed the customer info like address or business name).
I'd like to create a mailing list with customer business name, contact name, mailing address and only select the customers who have purchased in the last two years. We are hosting a customer appreciation dinner and don't want to invite folks from 5-10 years ago who only used our services once or twice. I don't want to pull up two reports and have to go through two reports where there could be a column displaying the last transaction date that I can use to sort the report.
Thanks!
