how to find inactive vendors in quickbooks online

Rapidly Identify Inactive Vendors in QuickBooks Online

By Steven Harris
AD

Are you struggling to manage inactive vendors in QuickBooks Online? Keeping track ofvendor status and activity can be crucial for maintaining healthy business relationships and streamlining your accounting process. Here's a comprehensive guide on how to find and manage inactive vendors in QuickBooks Online.

QuickBooks Online provides an efficient way to identify and cleanup inactive vendors, helping you maintain a neat and updated vendor list. Let's dive into the steps to find and manage them effectively.

Understanding Inactive Vendors in QuickBooks Online

Before we delve into the process, let's understand what inactive vendors are. In QuickBooks Online, vendors are marked as inactive when they haven't been used for a specified period or when you manually change their status. Identifying and managing these vendors helps in decluttering your list and ensuring accurate accounting.

AD
a computer screen with the words how to add vendors and contrators on it
a computer screen with the words how to add vendors and contrators on it
How To Record Inventory Purchases And Sales In QuickBooks Online - Small Business Sarah
How To Record Inventory Purchases And Sales In QuickBooks Online - Small Business Sarah
How to Merge Vendors with similar names in QuickBooks Desktop
How to Merge Vendors with similar names in QuickBooks Desktop

QuickBooks Online allows you to filter vendors based on their activity, making it easy to find inactive vendors. However, the platform doesn't provide a dedicated report for inactive vendors. So, you'll need to use a combination of filters and custom reports to identify them.

Using Filters to Find Inactive Vendors

QuickBooks Online offers filters to narrow down your vendor list based on various criteria, including activity. You can use these filters to find vendors who haven't been active recently. Here's how:

How To Record Bank Deposits in QuickBooks Online
How To Record Bank Deposits in QuickBooks Online
Step by Step Instructions for QuickBooks Online
Step by Step Instructions for QuickBooks Online
  1. Go to the Vendors tab in the left menu.
  2. Click on All on the top-right corner and select Inactive from the drop-down list.
  3. Set the time frame for inactivity. For example, you can choose to view vendors inactive for the last 12 months .

Creating a Custom Report for Inactive Vendors

While the filters help in quick identification, creating a custom report gives you more control and flexibility. Here's how to create one:

  1. Go to the Reports tab and select Accountant & Taxes .
  2. Choose Vendor Balance Detail by Date .
  3. Customize the report by adding the Vendor Inactive Date field. This field appears under the Advanced Filter section when you click on the Customize button.
  4. Set the report criteria to show vendors based on the desired inactivity period.
  5. Run the report and review the results.

Managing Inactive Vendors

Once you've identified inactive vendors, it's time to manage them. This could involve reactivating them, deleting them, or merely keeping an eye on them. Here's how to do these:

AD

Reactivating Inactive Vendors

If you need to work with an inactive vendor again, you can easily reactivate them:

  1. Select the inactive vendor from the list.
  2. Click on the Make Active button at the top of the page.

Deleting Inactive Vendors

If you no longer need a vendor, you can delete them from your list:

  1. Select the inactive vendor from the list.
  2. Click on the Edit button at the top of the page.
  3. Scroll down to the Activity section and select Deleted from the Status drop-down list.
  4. Click Save to confirm the deletion.

Well, that's a wrap on finding and managing inactive vendors in QuickBooks Online. Regularly reviewing and maintaining your vendor list ensures accurate accounting and helps build stronger vendor relationships. Happy accounting!

AD
AD