Skip to main content
S
smtwtfs
February 19, 2019
Solved

How to move a bank register to a different company file?

  • February 19, 2019
  • 2 replies
  • 0 views

I accidentally created a bank register under the wrong company file (realized this after I was all done with it) and need to move it under the correct company.    Is there a way to do this or do I need to go to the correct company and recreate the bank register?

I am using quickbooks 2016 pro desktop

Best answer by JenoP

There's a way to import Chart of Accounts into a company file, smtwtfs.

 

You can export an IIF file of the Chart of Accounts and import it to the correct one. Here's how:

 

  1. Go to the File menu and click Utilities.
  2. Select Export and look for List to IIF Files.
  3. Select Chart of Accounts and click OK.

Once exported open the correct company and follow these steps to import the file:

 

  1. Go to the File menu and click Utilities.
  2. Select Import and click IIF Files.
  3. Look for the file and click Open. 

Let me also share this article that'll give you more information about exporting and importing list or IIF files in QuickBooks: Export or import Intuit Interchange Format (.IIF) files.

 

You're always welcome to visit us again if you need further assistance. The Community is always to help you again.

2 replies

JenoP
JenoPAnswer
February 19, 2019

There's a way to import Chart of Accounts into a company file, smtwtfs.

 

You can export an IIF file of the Chart of Accounts and import it to the correct one. Here's how:

 

  1. Go to the File menu and click Utilities.
  2. Select Export and look for List to IIF Files.
  3. Select Chart of Accounts and click OK.

Once exported open the correct company and follow these steps to import the file:

 

  1. Go to the File menu and click Utilities.
  2. Select Import and click IIF Files.
  3. Look for the file and click Open. 

Let me also share this article that'll give you more information about exporting and importing list or IIF files in QuickBooks: Export or import Intuit Interchange Format (.IIF) files.

 

You're always welcome to visit us again if you need further assistance. The Community is always to help you again.

S
smtwtfsAuthor
February 19, 2019

Thank you for your reply.    When I went to import, it gave me this error 51 message, I attached a file of it.     Is there a work around it? 


K
KhimG
February 19, 2019

Hello, @smtwtfs.

 

Thanks for the prompt response and letting me know the outcome of the steps given by @JenoP. I’m here to help resolve the error on Line 51 so you can import the file successfully.

 

This error typically happens when the account type selected on Line 51 is different from the one existing in the Chart of Accounts. You can fix this by following the steps below:

 

First, check the source of the problem.
1.    Save the IIF file to your computer.
2.    Open the saved IIF file in Microsoft Excel.
3.    Look at Line 51 of the Excel spreadsheet. This provides the account name and type that QuickBooks is expecting.

 

Then, look at your QuickBooks Chart of Accounts to determine the type of account. Once done, make the corrections by doing one of the following:
•    In QuickBooks, update the type of account to match the expected type.
•    In the Export to QuickBooks section, update the account to match the type of account.

 

That should do it. Give this a try and let me know how it goes. Post again in the Community if you need anything else, I’m more than happy to help. Take care and have a great day!
 

A
Anonymous
February 20, 2019

Use our BRC Transaction Copier  to pull transactions from one QuickBooks company file and import them into another company file.

Terms & ConditionsAccessibility statement