Reports - Add report to identify lapsed customers (include last invoice date column)
We need a report that will give us a list of lapsed customers. We as a small business need to be in touch with customers who haven't had any transactions with us for 6 months or a year. It would be great to have a feature or report where we can easily find these customers. On our old accounting system, all of our customers had a " last invoice date" column so we could easily pull a report for any of these customers who hadn't been invoiced for 6 months or more.
-
Stuart Palm commented
Dear Xero Developers,
Could this be done - put in a last invoice date entry against each customer record which is sortable (newest/oldest) and is also exportable to Excel.
-
Stuart Palm commented
I completely agree - I'm guessing it was Sage that you're referring to as I have the exact same requirement. Love or hate Sage, it did have some better features for sales tracking. However, you can build a Smart List in your Customers section - I have attached what you need to do - it's not perfect but better than nothing.