Are you in pursuit of exporting from the old Company File into a New data File but don’t know how to initiate it? There is no need to worry as this article divulges all the information you need in this context. Just make sure that you got through this article very keenly till the very end.
Ancillary points to note before we proceed.
You need to bear in mind the following points before you export from Old QuickBooks Company file into a new data file.
- You can import damaged lists to your new company files and damage your files.
- If the lists are imported to an existing file or you can either add information to the new company file, ensure that you have created a backup of your file before implementing the steps provided in this article.
- The steps listed below will be very helpful in importing lists. If you are willing to use transactions, use ‘Batch entry’ or ‘third-party software.’
Walkthrough: Exporting Lists from Old Company File into a New Data File
Follow the steps enumerated below to habituate yourself to a reliable procedure for exporting your lists from the old Company File to a new one. Make sure that you carry out these steps sequentially.
Step 1: Exporting the List
- To begin, select ‘Utilities’ from the QuickBooks File menu, followed by ‘Export Lists to IIF Files.’
- Then, once you’ve decided on the list you want to export, choose it and click ‘OK.’
- Finally, navigate to the spot where you wish to save your file using Browse.
- Finally, select the ‘Save’ option to save the file.
- To export the list from QuickBooks, use Notepad or Excel to open the ‘.IIF’
- To avoid complications caused by exporting very long lists, use only one at a time to export the major lists, including your Items, Customers, and Vendors.
Read Also: What is reverse pull headgear?
Step 2: Clean the lists
- First, you must launch ‘Microsoft Excel.’
- Select the Office Button Open option from the ‘File’ menu (if you’re working with Excel 2007).
- Select the location where you want to save the file (.IIF file).
- Select ‘All Files’ from the ‘Type Field’ drop-down menu.
- Next, choose the IIF file and select ‘Open.’
- Return to the Text Import Wizard and select ‘Finish’ from the ‘Next’ You can open it in Microsoft Excel.
- In MS Excel, you may do any alteration that you want.
- You must save all necessary changes to the IIF at this point.
- Choose ‘Save’ from the ‘File’
- On the prompt that appears, select ‘Yes.’
- On your screen, you will be asked to save the IIF file again.
- Select ‘Don’t Save.’
- Note: If you want a comprehensive understanding of IIF Files in IIF, read the overview that you’ll find by checking out the edit, import, and export IIF Files in QuickBooks Desktop.
Step 3: Importing the list
You should backup all your company files before performing any operation on them and before importing any list. Importing the list is easy if you adhere to the hassle-free walkthrough provided below.
- Access your Company file as an ‘Administrator.’ You also need to ensure that you open the file in ‘single user mode.’
- Then select ‘Utilities’ from the ‘File Menu.’
- Next, select ‘Import’ and select ‘IIF Files’
- Finally, import the ‘Charts of Accounts’
- Import the lists that do not contain information from other lists.
- After successfully importing the ‘Charts of Accounts,’ you must import the other lists in the following order:
- Payment Methods List
- Payment Terms List
- To-Do Notes
- Customer Type List
- Vendor Type List
- Class List
- Job Type List
- Shipping Methods List
- Customer Message List
- You need to Import the below-mentioned lists in the same order as they have been provided:
- Other Names
- Sales Rep
- Price Level
When you are done importing the lists, jump to Step 4 for the creation of Opening Balance.
Step 4: Create Opening Balance
Creating opening balance for bank accounts
- Firstly, sign into the website of your financial institution.
- Access QB Desktop and head to ‘Company.’
- Proceed ahead to ‘Chart of Accounts.’
- Right-click to choose ‘New.’
- In ‘account type,’ choose ‘Bank or Credit Card.’
- Choose ‘Continue.’
- Put some name on your account.
- Provide information prompted by other data fields.
- Choose ‘Enter Opening Balance.’
- If you wish to edit your opening balance, choose the ‘Change Opening Balance’
Other types of accounts like Asset and liability
- Sign into the website of your financial institution.
- Open QuickBooks Desktop.
- Head to ‘Company‘ menu & choose ‘Chart of Accounts.’
- Right-click Chart of Accounts and then select ‘New.’
- Click on ‘Fixed Asset, Loan, or Equity.’
- Subsequently, choose the ‘Other Account Types’ option & select one type.
- Tap on ‘Continue.’
- Provide some name to the account.
- Provide data for other fields.
- Click on ‘Enter Opening Balance.’
- If you want to alter your opening balance, you can choose the ‘Change Opening Balance’
- Choose ‘Save.’
- Click on ‘Close’ to record the opening balance.
We have a firm belief and optimism that this article must have assisted you in exporting your lists from an Old company file to a new file in QuickBooks. We have attempted to encapsulate all the invaluable tips and information relating to the Export process.
If you have any unresolved queries related to this domain, feel free to contact our QuickBooks enterprise technical support Team via our helpline number i.e., 1-800-761-1787. Our team of experts shall make sure that all your queries and dubiety gets sorted out. We work compassionately towards ensuring Client satisfaction most amicably.
Leave a Reply