Making Old Vendors Inactive

Ryanwess4 · ‎September 29, 2023

Hello.

I am working with Quickbooks Desktop.

I am tasked with making all vendors within a company inactive that haven’t seen activity since 2020. So if I don’t see anything activity in 2021-2023 I need to make them inactive. There are thousands of vendors and this hasn’t been done since 2000. Is there a way I can either sort the companies to see only the ones I need to make inactive or a way to make a mass amount inactive at the same time following that criteria? Or if not, is there a way I can make a custom keyboard shortcut to make them inactive in the vendor center so I don’t have to click make inactive every time?

thanks!

Rainflurry · ‎September 29, 2023

@Ryanwess4

You probably know this already but I think the best you can do is to go to the Vendor Center and select 'All Vendors' from the drop-down on the Vendors tab. Then, you just need to make a single click on each vendor to make them inactive.

As far as how to filter your vendors by no activity since 2020, there's no easy way to do that as far as I'm aware. You can run a report that shows what vendors have had activity since 2020 and you can make the others inactive, but I'm not familiar with any report that will show only vendors with no activity.

AlcaeusF · ‎September 29, 2023

Hello Rainflurry,

Thank you for sharing your input about managing vendors in QuickBooks Desktop. We love to see members supporting one another! Have a great day.

PineLakePark · ‎February 06, 2024

Hi,

This same exact question was asked back in 2020 about customers. See this link:

https://quickbooks.intuit.com/learn-support/en-us/reports-and-accounting/re-is-there-a-way-to-create...

Use "expenses by vendor summary" instead of the customer support and export to excel.

Topics

Training

Community

Resources

Making Old Vendors Inactive