Get 50% OFF QuickBooks for 3 months*

Buy now
cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Simplify payday and set payroll to run automatically on QuickBooks.Explore Intuit QuickBooks Workforce
MarkMusgrove
Level 1

Can I bulk import my vendor tax number into QBO? will it sync?

Many of my vendors are missing tax numbers but I have them on an excel sheet. Can they be imported and synced?
2 Comments 2
Kevin_C
Moderator

Can I bulk import my vendor tax number into QBO? will it sync?

Hello there, @MarkMusgrove. I’ve got some information for you about importing vendor tax numbers into QuickBooks Online (QBO).

 

Yes, it's possible to import a tax ID number and it will sync with QBO if you include it with your vendor's information.

 

 

Otherwise, to import the tax ID number alone is unavailable at this time. What you can do is to manually add it to your vendor's profile.

 

 

 

I'd also recommend using a third-party app that can import a tax ID number into the vendors' profiles. I'll guide you to where you can find multiple apps that you can use: 

 

  1. Login to your QuickBooks Online account.
  2. Go to the Apps menu.
  3. Select the app you want to integrate and review the app if it is what you're looking for.
  4. Click Get App Now and complete the following on-screen instructions.

 

To learn more about preparing your Federal 1099s, you can check out this article: File 099s using QuickBooks Online.

 

I've also included an article about creating a 1099 report for vendors and vendor payments. This helps you see what you’ve paid to your vendors.

 

If you have any other concerns besides mana, please don’t hesitate to add a comment below. We’re always here to assist you. Take care!

Fiat Lux - ASIA
Level 15

Can I bulk import my vendor tax number into QBO? will it sync?

@MarkMusgrove 

Prepare the Vendor List with the following template

TitleCompanyNameFirstNameMiddleNameLastNameSuffixDisplayNamePrintOnCheckNameAddressLine1AddressLine2AddressLine3AddressLine4AddressCityAddressStateAddressPostalCodeAddressCountryWebSiteTaxIdentifierAcctNumVendor1099EmailPhoneNumberMobileNumberFaxNumberOtherNumberSalesTermCurrency
 Comcast    Comcast PO Box 1190   BostonMA02109 http://www.comcast.net 11335435FALSE[email address removed](603) 555-2000(603) 555-2001(603) 555-2002(603) 555-2003  
 Verizon    Verizon PO Box 5180   NashuaNH03060 http://www.verizon.com 43220909FALSE[email address removed](603) 555-3000(603) 555-3001(603) 555-3002(603) 555-3003  
 Mary SmithMaryL.Smith Mary Smith 1313 Mockingbird Lane   HollywoodCA90027    FALSE[email address removed](603) 555-4000(603) 555-4001(603) 555-4002(603) 555-4003  
 PG&E    PG&E PO Box 340   BostonMA02010   99053002FALSE (603) 555-5000(603) 555-5001(603) 555-5002(603) 555-5003  
 Mike's Traders    Mike's Traders 14 E. Main St.   WoburnMA01801 http://www.mikestraders.com  FALSE (603) 555-6000(603) 555-6001(603) 555-6002(603) 555-6003  

 

then utilize an importer tool

https://transactionpro.grsm.io/qbo

 

Need QuickBooks guidance?
Log in to access expert advice and community support instantly.

Need to get in touch?

Contact us