Rapidly Identify Inactive Vendors in QuickBooks Online
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.
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:
- Go to the Vendors tab in the left menu.
- Click on All on the top-right corner and select Inactive from the drop-down list.
- 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:
- Go to the Reports tab and select Accountant & Taxes .
- Choose Vendor Balance Detail by Date .
- 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.
- Set the report criteria to show vendors based on the desired inactivity period.
- 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:
Reactivating Inactive Vendors
If you need to work with an inactive vendor again, you can easily reactivate them:
- Select the inactive vendor from the list.
- 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:
- Select the inactive vendor from the list.
- Click on the Edit button at the top of the page.
- Scroll down to the Activity section and select Deleted from the Status drop-down list.
- 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!