cancel
Showing results for 
Search instead for 
Did you mean: 
miller0987
Level 1

How to make bulk changes to vendors?

Coming from desktop to online pro: How can I make bulk changes to my vendors? In desktop I could import an IIF file to add to current vendors and/or use "add multiple vendors" and cut/paste from Excel to make changes to multiple vendors at a time. In QBO it seems I can only import new vendors, not import changes to current vendors (I get an error highlighting the name saying a vendor already exists and no import will happen). Any way in QBO to make bulk changes to vendors (and customers)? Thanks!

Solved
Best answer March 31, 2020

Best Answers
MarsStephanieL
QuickBooks Team

How to make bulk changes to vendors?

Hello miller0987,

 

In QuickBooks Online, the feature for bulk update of your existing vendors is unavailable at this time. I can send this as a feedback to our product developers so that they will make an assessment for future updates.

 

For now, you can manually edit your Vendor's details to avoid duplicates. Here's how:

 

  1. Go to the Hamburger icon and select Expenses.
  2. Choose Vendors and click on the Vendor's name.
  3. Click on the Edit button on the top-right corner of the page.
  4. Enter the updated details, verify and click Save. (I added a screenshot to show you where you can update your Vendor's detail).


Let me know if you have questions in mind. I'll around to answer. Take care.

 

View solution in original post

10 Comments 10
Fiat Lux - ASIA
Level 15

How to make bulk changes to vendors?

Utilize the trial period of this 3rd party migration tool. Export the data out, modify them, and reimport back. Make sure to set some filter to avoid any duplication.

https://transactionpro.grsm.io/qbo

 

Should you need to purchase it, use promo code 20PERCENTOFF at checkout, valid until April 30th, 2020. 

 

 

miller0987
Level 1

How to make bulk changes to vendors?

Thanks for the tool info! No native way within QBO however?

MarsStephanieL
QuickBooks Team

How to make bulk changes to vendors?

Hello miller0987,

 

In QuickBooks Online, the feature for bulk update of your existing vendors is unavailable at this time. I can send this as a feedback to our product developers so that they will make an assessment for future updates.

 

For now, you can manually edit your Vendor's details to avoid duplicates. Here's how:

 

  1. Go to the Hamburger icon and select Expenses.
  2. Choose Vendors and click on the Vendor's name.
  3. Click on the Edit button on the top-right corner of the page.
  4. Enter the updated details, verify and click Save. (I added a screenshot to show you where you can update your Vendor's detail).


Let me know if you have questions in mind. I'll around to answer. Take care.

 

asha_kanta_sharma
Level 6

How to make bulk changes to vendors?

Simply not possible in QB.

GRbhaso
Level 1

How to make bulk changes to vendors?

Has there been any update for this subject?  We are needing to make bulk changes to vendors and hoping that product development made some changes?

Rose-A
Moderator

How to make bulk changes to vendors?

Thanks for following up on this thread, GRbhaso.

 

I know how beneficial this is to your business, however, we haven't added this option yet.

 

We'd love to hear your feedback. You can send comments and suggestions by selecting the Gear icon, then Feedback. Tell us how it’s going and what we can do to make the Vendors option better.

 

For the time being, you can visit our blog and register for our Newsletter. This way, you’ll receive email updates about what new changes and features, and hopefully this option would be one of them.

 

Here's how to register for our Newsletter:

 

  1. On your QuickBooks Online account, click the User icon at the upper right corner and select Manage your Intuit Account.
  2. Tap Data & Privacy in the left panel.
  3. Select QuickBooks.
  4. Turn on QuickBooks Newsletter.

 

Additionally, you can visit the following write-up: Expenses and vendors. This will provide you with links on how to manage your company expenses as well as other vendor transactions.

 

I'm always here should you have any follow-up questions or concerns. Wishing you and your business continued success!

TruckingEnterprise
Level 1

How to make bulk changes to vendors?

I use Enterprise for multiple companies.  I need to know how to make Class changes to a large group of invoices.  

katherinejoyceO
QuickBooks Team

How to make bulk changes to vendors?

Thanks for asking us here in this forum, @TruckingEnterprise.

 

We can use the Reclassify Transactions tool to makes changes on your classes individually or all at once. 

 

I'll show you how:

  1. Choose a transaction or Select All, then mark the  Account to checkbox to reclassify by account.
  2. Click the dropdown arrow next to Account to, then find the account where you want to move the transactions.
  3. Select the Class to checkbox to reclassify by class.
  4. Select the dropdown arrow next to Class to, then select a new class for the transactions.
  5. Click Reclassify.

 

For additional reference, you can visit this link should you need to find and correct transactions that have been assigned to incorrect accounts or classes.

 

You can bookmark this article in case you need some steps to filter, sort or total reports by Class in the future. 

 

Feel free to post again if you need more help in reclassifying your transactions. We're always around to be your QuickBooks guide. 

userUser212
Level 1

How to make bulk changes to vendors?

Are there any updates on this request? This ability would be extremely helpful and it is a bit baffling QBO has yet to roll something like this out (if an update does not exist).

ChristieAnn
QuickBooks Team

How to make bulk changes to vendors?

Thank you for visiting the QuickBooks Community, userUser212.

 

The ability to make bulk changes to vendors is currently unavailable, and I understand how important this feature is in running your business. With this, I'll ensure you can send feedback so our product developers can consider adding the feature in the next updates.

 

Please know that our engineering team is aware of this feature request and is reviewing implementing it in the future. However, I still recommend going to the Gear icon in QBO and selecting Feedback. This way, you can make a further request for the ability to make bulk changes to vendors. Any suggestions are forwarded to our engineers to be considered in future updates.

 

Additionally, your valuable feedback goes to our Product Development team to help improve your experience in QBO. You can track feature requests through the QuickBooks Online Feature Requests website.

 

Lastly, you may refer to this article to see steps on how you can run a speicifc report that will reflect all payments made to vendors: Run a report with vendor totals.

 

Please know that you can add a comment below if you still have concerns related to vendors in QBO. I'm always around to help, userUser212. Have a great day!

Need to get in touch?

Contact us