cancel
Showing results for 
Search instead for 
Did you mean: 
VintageAF
Level 2

Importing Customers and Vendors

I am new to QB Online but have been using QB Manufacturing Desktop for some time now.  I am beginning the process of importing my customers and vendors to Online.  Am I missing something, QBO does not allow you to import the Payment Terms or Shipping Data from your desktop CSV file?  It appears I have to enter this information manually.  When I go to Import Vendors or Customers QBO gives you 15 different fields that you can pull data from your CSV file.  If I use the Manual entry of a Customer or Vendor there are 30 different fields that you can input data.  Correct me if I am wrong, but it looks like I am going to have to manually enter a lot of data for my 200 customers and 400 vendors?

4 Comments 4
4Gal
Level 10

Importing Customers and Vendors

Why do you need to convert your data from QB Desktop to QB Online? Any specific concern?

If you are a manufacturing company, you will need to use a 3rd party app with the assembly feature to integrate with QB Online.

 

If you insist to convert your data to QB Online, prepare your data with the following template

 

Customer

TitleCompanyFirstNameMiddleNameLastNameSuffixDisplayNamePrintOnCheckNameBillingAddressLine1BillingAddressLine2BillingAddressLine3BillingAddressLine4BillingAddressCityBillingAddressStateBillingAddressPostalCodeBillingAddressCountryShippingAddressLine1ShippingAddressLine2ShippingAddressLine3ShippingAddressLine4ShippingAddressCityShippingAddressStateShippingAddressPostalCodeShippingAddressCountryPhoneNumberMobileNumberFaxNumberOtherNumberWebSiteEmailCustomerTypeSalesTermDefaultTaxCodeTaxExemptionReasonResaleNumberPaymentMethodPreferredDeliveryMethodBillWithParentCurrencyNotes
Mr.Abacus IndustriesJanice Johnson

 

 

Janice Johnson 110 Main StreetSuite 2000  DallasTX99875 400 East Street   DallasTX99875 (603) 555-2000(603) 555-2001(603) 555-2002(603) 555-2003 [email address removed]ResidentialNet 30  12345678CheckPrintY  
Mr.Walker AssociatesLeonard Walker Leonard Walker 9 Winding Road   WinchesterNY12345 9 Winding Road   WinchesterNY12345 (603) 555-3000(603) 555-3001(603) 555-3002(603) 555-3003 [email address removed]CommercialNet 30   CheckEmail   
Mr.Pinnacle PartnersLisa Smith Lisa Smith 19 Jerico Drive   BensalemPA84256 19 Jerico Drive   BensalemPA84256 (603) 555-4000(603) 555-4001(603) 555-4002(603) 555-4003 [email address removed] Net 30   CheckNone   

 

Vendor

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 use the importer tool to proceed.

https://get.transactionpro.com/qbo

 

AlverMarkT
QuickBooks Team

Importing Customers and Vendors

Hi, @VintageAF. I'm here to help.

 

You are correct. QuickBooks Online (QBO) allows only 15 different fields more or less that you can pull data from your CSV file when importing customer and vendor lists.

 

Although manually entering data is a viable option, you can consider what 4Gal advised, or look for a third-party app that allows you to customize mapping your fields to include Payment Terms or Shipping Data upon importing. Here's how you can look for the app within QBO:

 

  1. In your QBO account, go to Apps.
  2. Select Find apps.
  3. Choose Browse categories or type in keywords in the search field.

 

When moving from QuickBooks Desktop to QBO, there are noticeable differences in how your books appear. I'm adding this one as a guide: Learn how features and data move from QuickBooks Desktop to QuickBooks Online

 

Let us know if you have updates on the situation or further questions about importing customer and vendor lists in QBO. We'll do our best to assist. Take care.

VintageAF
Level 2

Importing Customers and Vendors

I guess I am surprised at the current answers and potential solutions.  I am failing to understand the thought process on how this was developed.  There are 30 potential fields but yet you are only allowed to enter 15 from an Import.  So now I have to manually enter my data or go with a third party app that someone has developed to fix QB's software issues.

 

At some point in the software development I would have thought there would have been a round table discussion by the software engineers and the other internal employees developing this platform that discussed shortcomings such as this.

 

If QB Online is a refined software as it should be, I wouldn't need third party software to import data or make it work as it should.  For no further than I have ventured into this software, it feels like a beta version that has not been fully thought out.  I hope things get better the deeper I get, we are not off to a good start.

 

Is there a different subscription level that I need to invest in to get a version of QB Online that can import all 30 fields?

4Gal
Level 10

Importing Customers and Vendors

Is there a different subscription level that I need to invest in to get a version of QB Online that can import all 30 fields?

 

They limit many data fields even for migration tools. You have no choice but to use a third-party tool or stick with QB Desktop.

Need to get in touch?

Contact us