cancel
Showing results for 
Search instead for 
Did you mean: 
jdj6268-outlook-
Level 2

Have 2 businesses in1QB got 2nd QB need to export some vendors to new QB. when I export 1 vendor and save to desktop, import in new QB. all i get a large list of dates.

have 2 businesses in1QB got 2nd QB to move 1 business. need to export some vendors & customers to new QB. To test it when I export 1 vendor and save to desktop, import in new QB. all i get a large list of different dates. (01/01/2000) upon importing to 2nd QB 1  Have gotten info from you on how to do this but just cannot make it work. Just want to take all vendors and customers that belongs to one of the business to a 2nd QB. Need Help Please. When all is done want to have 1 business in each QB that i have.
6 Comments 6
Fiat Lux - ASIA
Level 15

Have 2 businesses in1QB got 2nd QB need to export some vendors to new QB. when I export 1 vendor and save to desktop, import in new QB. all i get a large list of dates.

Are you using the class tracking to separate data between 2 companies on your old account?

DivinaMercy_N
Moderator

Have 2 businesses in1QB got 2nd QB need to export some vendors to new QB. when I export 1 vendor and save to desktop, import in new QB. all i get a large list of dates.

Making sure you'll be able to import your customer's and vendor's lists is my priority, @jdj6268-outlook-. I'd be glad to help you with the process. 

 

When importing contacts in QuickBooks Online (QBO), there are several things you need to consider. One of those is ensuring the the format of your spreadsheet matches the required fields of the program. Please refer to the following:

 

  • Column headers are in the first row.
  • Contacts are on Sheet1 of the spreadsheet.
  • The spreadsheet doesn't have any formulas, charts, or blank rows.
  • The spreadsheet doesn't have any errors, such as #REF!, #NAME?, #N/A or #VALUE!.
  • Names don't contain colons (:) or quotation marks (").

 

You'll know more about this by visiting this article: Import customers or vendors from email contacts to QuickBooks Online. 

 

Then, to determine what's causing the issue when importing your vendor's list, I recommend comparing the fields of your spreadsheet with a sample file found in the Import vendors page. I'll guide you on how: 

 

  1. In your QBO account, click the Gear icon.
  2. Next, select Import data. 
  3. Then, click the Vendors icon.
  4. The Import vendor page will open. From the Select a CSV or Excel file to upload section, click the Download a sample file hyperlink. 

 

If confirmed that the fields don't match, you can re-export the vendor's list from your first QBO company.

 

However, If verified that you have the correct format and you're still unable to import the lists. I suggest performing some browser troubleshooting steps. Let's start with accessing your QBO account using an incognito browser. This will provide you a clean slate and prevent web page issues. Below are shortcut keys you can use:

 

  • Google Chrome: Press CTRL + Shift + N.
  • Microsoft Edge: Press CTRL + Shift + N.
  • Safari: Press Command + Shift + N.
  • Mozilla Firefox: Press CTRL + Shift + P.

 

Once opened, import the list again. If it works, I recommend clearing the cache of your regular browser to eliminate old files that might caused the problem. Cache speeds up the loading process of your browser but can also cause problems once damaged or corrupted. If the same result, I suggest using another supported browser or device. It might be that the current one you're using has temporary issue with QBO.

 

That should do it. The process can be also applied when importing your customer's lists

 

Let me know how the steps works. I'd be happy to hear any updates about the import process. Please add a reply if you have additional questions. Have a good one. 

jackjackson1977
Level 2

Have 2 businesses in1QB got 2nd QB need to export some vendors to new QB. when I export 1 vendor and save to desktop, import in new QB. all i get a large list of dates.

yes

jackjackson1977
Level 2

Have 2 businesses in1QB got 2nd QB need to export some vendors to new QB. when I export 1 vendor and save to desktop, import in new QB. all i get a large list of dates.

I imported the vendors and customers names and info ok but how do i bring over the invoices and bills for each?

Rasa-LilaM
QuickBooks Team

Have 2 businesses in1QB got 2nd QB need to export some vendors to new QB. when I export 1 vendor and save to desktop, import in new QB. all i get a large list of dates.

Welcome back to this thread, jackjackson1977.


I’m glad to know that you have successfully moved your vendors' and customers' information to the new company. Let’s utilize the Import data feature to bring the invoices into the correct QuickBooks Online (QBO) account and then use a third-party application to import the bills in bulk.


When importing your invoices, there's some information that you can and can't bring into the program. Please note the following:

 

  • You're unable to add discounts, credit memos, and negative amounts in general.
  • You'll be able to import a maximum of 100 invoices at a time and a 1,000 row limit per spreadsheet.
  • You can import invoices with single or multiple line items.
  • Also, you'll be able to import a large volume of customers, vendors or products, and services. 


When you're ready, follow the steps below to move the invoices into your new QuickBooks. Here's how:

 

  1. Open your new company, head to the Gear icon, and choose Import data under Tools.import invoices.png
  2. Click the Invoices tile icon to open the Import invoices screen.import invoices.1.png
  3. Tap the Browse button and select the spreadsheet of your invoices.
  4. Press Next to open the Map your column headings screen.import invoices.2.png
  5. Review the setup and make sure your spreadsheet’s column headings match with QuickBooks fields.
  6. Click Next and follow the online instructions to complete the import procedure.


For more insights into this process, you can go over this article: Import multiple invoices at once. From there you'll learn how to prepare your spreadsheet and set the custom transaction numbers.


In regard to your bills, let me help run a search to find a third-party application that best suits your needs. Go to the Apps menu on the left panel in your company and enter a keyword in the search bar (bill importer) to expedite the process. Or, head directly to the QuickBooks Online Apps Store.


Once you have all the bills added to the company, the following reference will guide you on how to access each supplier’s records and manage the status of their entries: View vendor transactions.


I want to make sure you’re feeling supported when using the product. That’s why I’m adding a link to our online resources: QBO self-help articles. They’re arranged according to topics so you can view each one easily.


Reach out to me again if you have other QuickBooks concerns or questions about handling customer or vendor data. I’ll be right here ready to assist you. Have a great rest of the day.

Fiat Lux - ASIA
Level 15

Have 2 businesses in1QB got 2nd QB need to export some vendors to new QB. when I export 1 vendor and save to desktop, import in new QB. all i get a large list of dates.

@jackjackson1977 

You can use the migration tool and filter transactions by class to export them to XLS.

https://transactionpro.grsm.io/qbo

 

Another option, you can purchase a 3rd party migration service.

Sign in for expert help
Ask questions, post replies & join our community of QuickBooks users.

Need to get in touch?

Contact us