cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Experienced Member

2 company files were changed seperatly.

I have a company where we moved the QB server over to a new computer, and for a few weeks now our 2 financial people have been putting information into separate databases. 1 person was putting it into the old company file, and one was putting it into the new company file.

 

We have quickbooks pro 2018 on each computer, is there a way to get the information entered from the old database into the new one?

Solved
Best answer 06-20-2019

Accepted Solutions
QuickBooks Team

Re: 2 company files were changed seperatly.

Hey there, @kzieres61.

 

You'll need to verify that the data between the two companies are different. Then you can redo the export and import process. Let me provide some details about this and help you through the steps.

 

In QuickBooks Desktop, you're only able to export lists using the Intuit Interchange Format (IIF) file. Thus, exporting transactions from one company file to another isn't available.

 

To redo the exporting and importing of your lists, you can follow the steps provided by my colleague above.

 

You can also download the IIF Import Kit and create an IIF file for your transactions and import it to QuickBooks.

 

I've found an article which you can read: Import/Export Overview.

 

Please let me know if you have any other concerns. I'll be around to assist you.

7 Comments
Moderator

Re: 2 company files were changed seperatly.

Good day, kzieres61.

 

You can either enter the data manually or use the Intuit Interchange Format file. I'm here to help and guide you through.

 

Before doing so, make sure to gather the information entered from the old company file.

 

To export the list from the old company file, follow these steps:

  1. From the QuickBooks File menu, go to Utilities and select Export.
  2. Choose Lists to IIF Files.
  3. Select the list you want to export and click OK.
  4. Browse the location where you want to save your file and then Save.

To import the list to the new company file:

  1. Open the new company file. Make sure that you are logged in as the Administrator and you are on Single user mode.
  2. From the File menu, select Utilities.
  3. Choose Import and click IIF Files
  4. Locate the file.

For further guidance, refer to these articles:

Let me know if you have any questions. I'll be back to help you further. Have a good one.

Experienced Member

Re: 2 company files were changed seperatly.

This will not overwrite anything on the new company file correct?

Established Community Backer ***

Re: 2 company files were changed seperatly.

hi @kzieres61 ,

If you a newbie to IIF, you should consider to use Transaction Pro Importer or Business Importer instead. Just my 2 cents.

QuickBooks Team

Re: 2 company files were changed seperatly.

Yes, that's correct, kzieres61.

 

Importing IIF files will not override the data on your new company file. What this process will do is add the imported files to your existing entries in the program.

 

You can follow the steps shared by my colleague above. Also, you can consider @Fiat Lux - ASIA's suggestion to use a different importer program. Just give them a try so you'll know which one works best for you.

 

Just leave another reply if you need more assistance. Thanks.

Experienced Member

Re: 2 company files were changed seperatly.

I exported ALL the items in the IIF Lists,Then imported them and the actual account info, money, debits, credits, transactions, never got changed.

QuickBooks Team

Re: 2 company files were changed seperatly.

Hey there, @kzieres61.

 

You'll need to verify that the data between the two companies are different. Then you can redo the export and import process. Let me provide some details about this and help you through the steps.

 

In QuickBooks Desktop, you're only able to export lists using the Intuit Interchange Format (IIF) file. Thus, exporting transactions from one company file to another isn't available.

 

To redo the exporting and importing of your lists, you can follow the steps provided by my colleague above.

 

You can also download the IIF Import Kit and create an IIF file for your transactions and import it to QuickBooks.

 

I've found an article which you can read: Import/Export Overview.

 

Please let me know if you have any other concerns. I'll be around to assist you.

BRC
Established Community Backer ***

Re: 2 company files were changed seperatly.

QB doesn't have a built in feature to copy transactions between files or merge files.

 

To pull transactions from one company file and import them into another file, use our BRC Transaction Copier   It will pull transactions for a date range and of the types you specify from one company file and help you import them into another company file.