How can I make customers inactive in QB Online by year?

Good day, @ZCC2024! I've got some alternatives to help you make your customers who haven't worked for you for 5 years inactive in your QuickBooks Online (QBO) account.

At this time, there is no integrated way to automatically inactivate customers who haven't worked for you last five years. However, you can pull up a report instead and make it inactive by batch, just as you mentioned. Let me guide you through the steps easily.

We can start by running the Transaction List by Customer report and customize it to show the transactions by year. Follow the steps below to proceed:

1. Go to the Reports menu and look for the Transaction List by Customer report.
2. Select All Dates or Custom dates in the Report period dropdown.
3. Click Group and select Date by year to sort out your transactions yearly.
4. From there, review those customers that don't have transactions for the last 5 years.
   

Furthermore, you may also pull up the Customer Contact List report and customize it to show the created date. I'll show you how:

1. Go to the Reports menu and look for the Customer Contact List report.
2. Click Columns and place a checkmark on the Created date.
3. You can customize the report for your preference.

You can also export and download it to Excel for further customizations and filtering out the customers' data.

Once you have the list of the customers you need to make inactive, proceed with these steps to complete the process:

1. Go to Sales, then select Customers.
2. Place a checkmark beside their names.
3. From the Batch actions dropdown, choose Make inactive.
4. Then confirm by selecting Yes, make inactive.
   

You may also visit this article to learn more about tailoring your reports, displaying particular accounts or customers, and configuring the layout for precise data placement: Customize reports in QuickBooks Online.

Please let me know if there is any other way I can help you use QuickBooks the way your firm needs it. I'm always around to provide answers and clarifications to your questions. Goodbye for now and have a good one!