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 QuickBooks Payroll
Jessica-Bolanos
Level 1

Can we mass import net terms for vendors in QB? I tried but it is not showing Net terms as a field to import.

 
Solved
Best answer a month ago

Best Answers
GenieBabe_L
QuickBooks Team

Can we mass import net terms for vendors in QB? I tried but it is not showing Net terms as a field to import.

Welcome to the Community, Jessica. In QuickBooks Online (QBO), you can't bulk import payment terms since there's no option for mapping those during import.

 

You'll need to edit each vendor manually and add the net terms.

 

To manually update, go to the All apps > Expenses & Bills > Vendors. After that, select the vendor's name, then click Edit. Scroll down until you find the Additional info section, then click the dropdown menu in the Terms field and select the correct Net.

 

You can also use a third-party app to bulk update vendor terms for an easier process.

Feel free to comment below if you have more questions about QuickBooks.

View solution in original post

2 Comments 2
SIAB
Level 8

Can we mass import net terms for vendors in QB? I tried but it is not showing Net terms as a field to import.

Like this one?

 

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  

 

You need to use a 3rd party importer tool.

https://get.transactionpro.com/qbo

 

GenieBabe_L
QuickBooks Team

Can we mass import net terms for vendors in QB? I tried but it is not showing Net terms as a field to import.

Welcome to the Community, Jessica. In QuickBooks Online (QBO), you can't bulk import payment terms since there's no option for mapping those during import.

 

You'll need to edit each vendor manually and add the net terms.

 

To manually update, go to the All apps > Expenses & Bills > Vendors. After that, select the vendor's name, then click Edit. Scroll down until you find the Additional info section, then click the dropdown menu in the Terms field and select the correct Net.

 

You can also use a third-party app to bulk update vendor terms for an easier process.

Feel free to comment below if you have more questions about QuickBooks.

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

Need to get in touch?

Contact us