Iif File Not Importing
If a timecard is not signed off, it will not be exported. Easily import all your bank and credit card files. You do have the IIF file export/import function (under "File" then "Utilities"), and that should support custom fields. Save it somewhere easy to find like your desktop. IIF is the format that QuickBooks supports for data import and export, which is why this extension uses that format. You can confirm that the file was imported correctly by noting that My Bank USD shows a balance of $100. As a result, not all banks have been linked to Xero with a bank feed. I have tried exporting and importing the iif file on numerous occasions without anyluck. New Feature:. I work for a payroll company and we've used our payroll software to create a file to import General Ledger amounts into QB for years. IIF file, described above, in its entirety, the more simple approach is to email us ( /Blog/5934/The-IIF-Intuit-Information-File-Chart-of-Accounts) and we will email you back a QuickBooks portable file which already contains the subject COA. It is able to import any data allowed by QuickBooks. iif files are data files rather than documents or media, which means they're not meant to be viewed at all. Go to File>Utilities>Import>IIF Files in QuickBooks and Import the txt file. For more information about “Arcler Desk” and its services please contact at our toll free number +1-888-500-1723 or drop us your queries at [email protected]
And, from what I can see from a quick look, custom fields are not supported. You will learn the difference between importing iif files compared to other web connect files. (IIF Method) • Desktop file can be referred to as needed • Create New DESKTOP file from IIF lists • File > Utilities > Export Lists • Use Add/Edit Multiple List Entries to clean up lists • Use Desktop Converter tool to import ‘clean’ file in to QBO • Tip: Use the condense tool to erase inactive list entries. There is also info on the subject and example files on the quickbooks web site. To be able to transfer your QuickBooks information, primarily to other QuickBooks software, Intuit created the Intuit Interchange Format (. An extra set of eyes almost always helps. So as with any other bookkeeping or accounting program other than DONATION or QuickBooks Desktop, you can just manually enter the printed-out summary transaction for Bank Deposits into QuickBooks. There is no “easy” way to import journal entries into QuickBooks, however if you are using QuickBooks Desktop (Pro, Premier, Accountant, and Enterprise only) you could use the IIF Kit from Intuit to open the sample. The use of IIF files for QuickBooks is no longer officially supported. Unfortunately, with QuickBooks Online there is not support for importing IIF files. iif file but keep getting errors because it's not formatted correctly. So it's not a bug, and it's also unlikely to change in any version of VB, or any future version of the IIF. Why not simply export tables using QuickBooks® export feature? You can, but let's examine each method. Steve is nothing short of brilliant. The IIF format is somehow limited and seems to be outdated sooner or later. Now we are finished with Red House and must import the saved file into QuickBooks. Prior to now, the old. It was worth it for me, but it is not a great process to hand off to trust someone else with. I have SQL Server 2012 and I would like to import Excel files data to Database. You'll see a window warning you that the file may not be compatible with text. IIF' on Drive C. Support is available before and after purchase. 0 Need to import transactions, but the format is not supported? Convert CSV to QFX and import into Quicken, (PC/Mac). Steps to Import Chart of Accounts into QuickBooks software. With Kutools for excel, we can not only import txt, PRN or CSV files but also Excel files into an excel worksheet beginning at a specific cell. CSV format; it’s the only acceptable file type. 3) The answer that OP references is to using an SDK used by developer. These IIF files are saved in common data format and utilized by QuickBooks to export varied financial data. Now importing the saved IIF file is even easier than exporting it. Data, Get External Data, Import Data. File to Import - Click the folder icon on the right side of the File to Import field. CSV to IIF Convertor Clone is just like SimplyConvert IIF Converter , which is a powerful and easy to use piece of software that allows you to convert CSV and QIF files downloaded from your online bank account to IIF files you can use for importing into QuickBooks. Files with the file extension. You will find the QuickBooks IIF import and export utilities on the 'File' menu in the QuickBooks program. Import Selected types (i. QuickBooks is a "closed" database. Prior to importing your journal entry for the first time, you will need to set up three new vendors in QuickBooks. importing data converted from IIF files. In the following example, specified Boolean expression return False ( 2>3 is not TRUE). Hi Nick, No, your problem is common for Australia and is why we added the "Date Format" option. Autosoft DMS allows you to create an. If you are using the QuickBooks Intuit Anywhere Connector or the QuickBooks IIF file for the Desktop version, also refer to those sections for special instructions. Download the IIF Transaction Creator for a free trial before you purchase. Save your IIF file in a location and with a name, that will be easy to locate later. I am running a routine that exports a file prepared for importing into QuickBooks as an *. Table of Contents. Review transactions in a readable view before converting. Parameter Query - IIF Or Nz Not Working Sep 24, 2006. Customize invoices app setting to change the account type. Is there a way to generate a. *iif is not one of my "save as" options. Regardless of whether your business is big or small, IIF Transaction Creator can help save you a ton of time by converting all of your worksheet data into IIF files so that you can quickly and easily import that converted information into. XmlDataSourceNodeDescriptor' to type 'System. However, it is not perfect and sometimes can show results which are not really usable because of how certain programs. It should now import correctly!. A backup copy will allow you to restore your data if a problem occurs during the import. IIF files exported from Ascend TMS work best with this option. I have no difficulty generating a flat file with any kind of delimiters from SQL, but I do not know the IIF (INTUIT Import Format) for a QuickBooks transaction. Verify the beginning balances for accounts in the general ledger. While I would not consider this an automated solution, it gets the job done and will be sufficient as we attack the client’s long-term objective: adopt NetSuite eCommerce to get out of the inherit weaknesses in any integration effort. Intuit hasn't been updating this. Here are a few recommendations that will help your import go more smoothly. CompuTime101 can create an. You may also need to rename the file to remove the txt extension. A list of GL entries ready for import. Note: Items purchased with 100% store credit, cash or check will not appear on the IIF file. To solve do the following: Go. OPENROWSET. This video takes you through an overview of the. This can be a lifesaver if you work in Excel,. Transactions or customer names saved in QuickBooks must be archived before new customer names or transactions may be imported. If the employee name does not match, then QuickBooks will create a new employee with. QuickBooks Mac and Quickbooks Online are not supported because they do not allow time activity to be imported. What is CSV2IIF (CSV to IIF Converter)? Finally, the solution to import your transactions in the IIF format. The qbo file provided by your financial institution contains an invalid information or formatting. Intuit QuickBooks is typically used for small business accounting and can also be used for personal finance purposes. To export to Quicken Interchange Format, select "File" then "Export," select "Loose QIF" and then click "OK. However, now we are going to move to Sage Peachtree and it looks like the modification will be much more involved. When importing data in a batch mode, a new batch import program converts CSV file records into World Z file batch update records and thereby enters data from the CVS file into the database as a normal batch transaction. Choose the location where you saved the. Was able to download my credit card QIF file into Quick books. This improvement helps make sure that data you are importing meets the necessary requirements before you are allowed to upload into the QuickBooks Company file of the user. QuickBooks Desktop allows you to upload and import Excel data files as IIF files via the IIF Import Utility. This import did not use the QuickBooks business logic to validate import, requiring user validation to some degree. Get help for QuickBooks Online, QuickBooks CD/Download for Windows, and for QuickBooks for Mac from the official QuickBooks® support website. About the sample files in the IIF Import Kit:. Which leads to another set of problems with combining data later. Back up your QuickBooks Desktop Export Company File. I never know files names or number of files in folder, but I know that structucture of data is same in every single file. Note: Unlike QuickBooks Desktop, QuickBooks Online does not have a facility for importing the sort of export files exported by DONATION, IIF files. Importing Budgets into QuickBooks Desktop from Excel (or Spreadsheets) via IIF 00:09:25 – How to create a budget template to import excel data (file, utilities, import, IIF files. Any ideas? The Item ID I'm testing with is "OCH101-A". I can get through exporting the IIF file, convert it to a CSV file then tell the program to import. About the sample files in the IIF Import Kit:. As for financial formats, there are not so many to transfer data from one place to another (for example, from your bank to your accounting software). Last step is to import the IIF file back into QuickBooks, by going into File, Utilities, Import, List from IIF… Then go back to the Set Up Budgets windows to see your imported budget. If you have not already created your new file select, File, New, and follow the prompts. Rather watch a video about importing a CSV file into Xero?. This import did not use the QuickBooks business logic to validate import, requiring user validation to some degree. So I was excited to hear that Zed Axis, an application that I use in my own business and one that I have reviewed several times before in this blog is able to import IIF files into QuickBooks Online. If you haven't attempted to create a QuickBooks. Then select the IIF file you saved to the computer, and import. First you clear out all the unwanted columns It appears that the GnuCash CSV import routine requires exactly one line per transaction split, and NO HEADERS, NO TRANSACTION SUMMARY line, and a funky DATE FORMAT. iif file you’ve exported from QuickBooks always begins with a header that shows the version and release numbers of the QuickBooks software used to create the file. What is wrong with this import?. Importing and exporting IIF files created by QuickBooks is reasonably smooth due to the fact QuickBooks codecs the record for you. Step 1: Select your file (Excel) containing Journal Entries with Separate Columns for Credit and Debit Amounts. Importing the IIF file into QuickBooks. I need urgent help please!!!. dir c: s -h *. Before you begin Please be aware that Quicken cannot import Excel (. For QuickBooks 2018 and older, click the "Import IIF" button. Web" is included in the file is to ensure that "System. The starting chart of accounts created in Quickbooks when you select the setup option for restaurants is minimal, and does not contain any detail food categories. Importing a transaction with an account that has not been created prior to the import. Choose which method to use to enter transactions. The other times, the JE does not balance because of rounding errors. Essentially, it allows you to export your store's order data to an IIF file – QuickBooks’ proprietary file format – and then import that file into QuickBooks to update account information with your store data. Which leads to another set of problems with combining data later. Contact us by phone, post a question to the community, or browse our expert FAQs. The IIF File Extension, Intuit Interchange Format is a proprietary text file used by Intuit's Quickbooks software for importing and exporting lists and transactions. I verified there were no 'tabs' but I cant get the system to show me what is wrong with the IIF. If you need a more advanced import, please check the articles on importing using the QuickBooks Business Importer. Is there a "delayed" IF (Or any other kind of IF) that justifies the need for Immediate IF?. When I run the sample code you wrote, everything works fine. Bank (Telpay WTHDRWL) Payables Import File; 200 Payroll Deposit. Note: We don't recommend the option Import it for me. I have recently been reminded of a tool I wrote back in 2012 which has not been featured on this blog. If you do not set up this data, the import of transactions will set up some of the data, but. The Import it for me link uses the method we've all been using with IIF files for many years. on the import point file dialog, the second box down are the point file types you have setup in the drawing. One of the more tedious tasks I do as Treasurer for our Habitat affiliate is inputting payment data for our home owners. Transaction Data Stitch IIF exports can include invoices, payments, refunds (negative payments only; returns not supported), and expenses. Why not simply export tables using QuickBooks® export feature? You can, but let's examine each method. QuickBooks Desktop allows you to upload and import Excel data files as IIF files via the IIF Import Utility. then select new point file format, you get this dialog, where you will specify the settings for the format. How To Export Transactions to Quickbooks Step 1: Backup Company files before importing - see article below. Since this option bypasses data review, some of the info may not be correct or complete for your books. (Keep format, answer "Yes") Finally, import budget file into QuickBooks: Go to File - Utilities - Import. If you have not already created your new file select, File, New, and follow the prompts. In QuickBooks, go to File > Utilities> Import > IIF Files. eZ Import products are fully integrated with QuickBooks, allowing the software to simply translate your transaction data to your QuickBooks data. Re-export or move the file into the '\CWU20YY\QB Conversion Files' directory. The file is downloaded from the payroll services as an IIF file. Importing data from other systems (such as Clio, MyCase, TimeSlips, Bill4Time, TimeMatters, Rocket Matter - all trade names of respective owners) into CaseFox® CaseFox can import some of the data automatically when data exported from Clio and MyCase is uploaded to CaseFox. This changed with the Introduction of QuickBooks Desktop Enterprise 19. Parameter Query - IIF Or Nz Not Working Sep 24, 2006. Now we are finished with Red House and must import the saved file into QuickBooks. Returns False for any error, e. Tips for beginners and database developers. PADS has the ability to generate a drill drawing with a hole table (under File-CAM). iif file would parse the data and push it into the database directly. To be able to transfer your QuickBooks information, primarily to other QuickBooks software, Intuit created the Intuit Interchange Format (. How to Import PayPal Transactions into QuickBooks | Enix & Associates Skip to main content. In the example displayed here, there was a Payment Term assigned to vendor records in the vendor import file that was not included with the import data on the IIF formatted worksheet, resulting in the reported errors. It can be imported by QuickBooks and most. An IIF file is a file format that can be uploaded into the venerable desktop version of QuickBooks. It would be great if QB 2019 would at least tell you what it didnt like about the file. This will open the Windows File Explorer window. Although IIF import files are often created using a spreadsheet application like Excel, Import from IIF and Import from Excel are distinctly different utilities. When to Manually Import Transactions Into QuickBooks Online Using a CSV File. Another way to understand the data in a Stitch IIF is to duplicate the file, change the file extension from. Open the IIF file and make sure the amounts in detail area in the form for this transaction equal the amount at the top of the form. This will add the new Tax Agency name into the. I've received a 'template' for an IIF file for Quickbooks transactions, and there's like seventy-bazillion fields in there, lots of which I never even user. mny" (depending on the settings of your computer, file extensions may not be visible, but they are present, and you can still use the steps below to locate those files). The number of transactions and/or customer names saved in QuickBooks exceeds the available storage space. How to import. ) Since older IIF files generated in the same way had been working fine before the QB 2019 update, I simply bypassed the data validation in the Import IIF QB dialog box. Re: VBA code to open an Excel file only if not already open Hi photoman, The code only checks to see if the file is already open on your computer (which is the request from the original poster), not if someone else has the file open. Before importing any file (IIF file, QBO file, QBJ file) into Quickbooks, make sure to backup your Quickbooks company data file. Go back into quickbooks and import the. I have been using PowerBI desktop and going through the usual Get Data -> From Access Database and going to my file to import the data. Our goal is to help you understand what a file with a *. Guru Importer specifically allows users to import an IIF file created in the standard "General Journal" format, into QuickBooks Online as one or more journal entries. When to Manually Import Transactions Into QuickBooks Online Using a CSV File. Do not confuse "Import from Excel" (CSV file import) with IIF import. Is there a "delayed" IF (Or any other kind of IF) that justifies the need for Immediate IF?. QuickBooks Online which is Intuits cloud version of QuickBooks was completely rewritten specifically for the cloud and therefore do. not all of this code is work '_' attrib. How to Import PayPal Transactions into QuickBooks | Enix & Associates Skip to main content. Re: Delete First line of Text file and Import Here's another. 59 free - Top4Download. If your business uses an online payment transaction system, you have the ability to download your transaction register in a comma separated value file, or as a QuickBooks IIF file. You must save the IIF file that IntraVet creates somewhere (such as My Documents) before importing the information into QuickBooks ®. I need Access to import this field as "text". iif Intuit QuickBooks Import File (Intuit Import File). iif file would parse the data and push it into the database directly. QuickBooks Mac and Quickbooks Online are not supported because they do not allow time activity to be imported. What I am having problems with is selecting the correct import category and mapping the fields. KairosDonor can create a file that the State or Area Quickbooks can import directly into Quickbooks. Review transactions in a readable view before converting. The audit trail is the file that contains information about the changes made to the company file and the use responsible for the changes. iif is the file for April 17, 2012), while monthly GL files are simply named with the month and year (such as February2012. (Note: These steps are for QuickBooks 2012 - the exact steps may differ for other versions). I completely agree with Karl about properly prepared IIF files not corrupting QB. eZ Import products are fully integrated with QuickBooks, allowing the software to simply translate your transaction data to your QuickBooks data. Find the answer to fix error on line x cannot change account type when importing quickbooks IIF file. user452051 wrote: Here is my question is there any tool that can help me to import data to oracle database from CSV file format. Luckily, we have a nice solution to augment modules. importing data converted from IIF files. Many third party payroll providers supply a file formatted in an IIF format to be imported into either QuickBooks Pro, Premier or Enterprise. Additional information on working with IIF Files. You can use Transaction Pro Importer on the Intuit App Center to easily import these files. If a different extension is used, Drake Accounting will not be able to successfully perform the import. It's recommended that you first try to export a QuickBooks report for one day to make sure the names match and correct any differences. Click “Start. To import your files open your QuickBooks company file. Autosoft DMS allows you to create an. Open the company in QuickBooks whose payroll data you created an IIF file for. PADS has the ability to generate a drill drawing with a hole table (under File-CAM). Select company you're going to import Journal Entries into. You will have to export the files for each account one at a time, and Microsoft's recommendation is to make a list of all accounts and check them off as you export. Can anyone help me with how to correctly format an. Import GitHub Project do not use Iif function, which returns one of two objects, depending on the evaluation of an expression. iif file for this deal in the past, the Status will read, "Not Sent. If you're using an earlier version of Excel on the Data tab, in the Get External Data group, click From. You may also need to rename the file to remove the txt extension. This file contains the employees worked hours. An extra set of eyes almost always helps. IIF file exists in the \CWU20YY\QB Conversion Files directory, but the file is not named "export. So it's not a bug, and it's also unlikely to change in any version of VB, or any future version of the IIF. Customize invoices app setting to change the account type. I paid yesterday an My taxes were not filed with the IRS. Select Import IIF. Description. In the fields that I am having issues with, it is choosing "Long Integer," which will not convert correctly. Click “Save. Note: Unlike QuickBooks Desktop, QuickBooks Online does not have a facility for importing the sort of export files exported by DONATION, IIF files. qbo suffix is and how to open it. PC applications can access files in IFS folders through network drives you map on your Windows PC. Importing Business Data from Other Finance Systems Customizing Business Central Using Extensions. Once the file is selected click the Open button. Included With: QuickBooks Pro, Premier, Accountant 2019 and Enterprise 19. You will receive a message that your file has been imported. I don't have QuickBooks in front of me now, but you can find the download link by searching for IIF in the QuickBooks online help. QuickBooks Online which is Intuits cloud version of QuickBooks was completely rewritten specifically for the cloud and therefore do. Review it to make sure accounts receivable, QuickBooks accounts and sub-accounts are accurate. The IIF file format, Intuit Interchange Format is a proprietary text file used by Intuit's Quickbooks software for importing and exporting lists and transactions. Change the file type field in the bottom of the window to All Files. Importing a transaction with an account that has not been created prior to the import. To solve do the following: Go. QuickBooks Mac and Quickbooks Online are not supported because they do not allow time activity to be imported. Excel: Import Your CSV file into a Spreadsheet. The Import it for me link uses the method we’ve all been using with IIF files for many years. When I download my. QuickBooks Online. CompuTime101 can create an. Importing the IIF file into QuickBooks. Now, IIF Transaction Creator is a dedicated Microsoft Excel add-in that will facilitate exporting MS Excel data and creating an IIF file, hence providing you a solution to easily import transactions into QuickBooks. The QuickBooks iiF file format has been around a long time. Another use of this tool is to convert the QIF files available from many financial institutions into a format that can be imported into QuickBooks. The IIF (Intuit Interchange Format) is a legacy format for importing transactions and list into QuickBooks desktop. It will also include instructions on how to import that file into your QuickBooks Desktop account. If I import everything I have duplicate checks and other information such as "Imported Income" that I have to change within quickbooks. How to Import PayPal Transactions into QuickBooks | Enix & Associates Skip to main content. IIF won't work with transaction types, or fields in records, that have been added to QuickBooks since around 2002 or so. eZ Import products are fully integrated with QuickBooks, allowing the software to simply translate your transaction data to your QuickBooks data. Knowledge base with the solutions for similar conversions. Files with the file extension. But the output is a gerber file. Ensure that while importing IIF file to utilities, it does not consists of lists, transactions or a combination of both. In the Import dialog box that appears, simply select the export file you just created and click Open. It's recommended that you first try to export a QuickBooks report for one day to make sure the names match and correct any differences. Description: QBY file is an Intuit QuickBooks Accountant's Import file. From the QuickBooks main menu select File – Import – Import iif files. Select Import IIF. With the export file, which will be a. In QuickBooks, go to File > Utilities> Import > IIF Files. This import did not use the QuickBooks business logic to validate import, requiring user validation to some degree. We suggest you copy and paste the names listed here to ensure accuracy. Steps to Import Chart of Accounts into QuickBooks software. This function returns True if there is a file with the name you pass in, even if it is a hidden or system file. I got an email recently from someone who was trying to import QuickBooks IIF transactions. But the output is a gerber file. On this screen, under Group and Watchlist, select the group (usually zero) and the watchlist or list name you want the stocks to go into. Select File type: Text CSV (. Importing IIF Files into QuickBooks Premier 2019 – Bypass Validation Step 1. Select Import IIF, browse to your file and select OK. Re-export or move the file into the '\CWU20YY\QB Conversion Files' directory. Sample iif files. Option 1: Import Journal Entries with Separate Columns for Credit and Debit Amounts. Find the answer to fix error on line x cannot change account type when importing quickbooks IIF file. save each sheet as a separate text file and then import the files. All tips and tricks presented assume that you are using QuickBooks 2011 or higher. Import Wizard should appear. A dialog box will pop up. They do not go in to the bank feeds center. The first time you import a. iif and save the file in a location you will remember, such as the desktop, as you will need to access the file at a later time. Importing Purchase Requisitions. This is only required the first time you import your payroll into the Telpay for Business software. Import QIF Files in Quicken 2005, 2006, 2007. Further, these enhancements permit you to see the transactions in your IIF file that fail to meet the data requirements; allowing you the opportunity to fix the errors and re-import the data once corrected. Save your IIF file in a location and with a name, that will be easy to locate later. I got an email recently from someone who was trying to import QuickBooks IIF transactions. Once you have the Quickbooks details set up, you can navigate to "Invoices", click an Invoice, and then click the "Quickbooks IIF File" link on the top right. To export the list of accounts from QuickBooks®: Select Utilities from File menu; Select Export from the Utilities fly-out; Select Lists to IIF files from the Export fly-out. It has come as a surprise to many that Intuit does not support the IIF file format for QuickBooks Online and has no plans to add that either. The Upload File page appears. 5 had been working, but I usually end up going months between importing and getting caught up on accounting and at this point I can’t even remember where I was getting the QIF files required for SimplyConvert to work. In the fields that I am having issues with, it is choosing "Long Integer," which will not convert correctly. IIF file extension or it won't. Save Budget file. Open the IIF file and make sure the amounts in detail area in the form for this transaction equal the amount at the top of the form. However, I seem to be getting quite a few errors. QuickBooks Desktop supports only one method of importing time data - an Intuit Interchange Format or IIF file. If you have downloaded the IIF Import Kit, you will find there the IIF Header Help folder that lists the column headings that you can use for each list type (i. IIF file for import. Here's an example of an IIF import file formatted to import sales tax items. Hi, I'm trying to import a QuickBooks. Importing Data through the Import Data Functionality. Do not confuse importing from Excel and CSV with IIF import. This window will show if one or more issues are detected with the IIF file to be imported. Work around: Change the format to "Custom" and put a non-numeric character in front of the number. Note Intuit doesn't offer assisted technical support for creating or importing. 1) Quickbooks Desktop allows an import of an IIF file. I'll fix it later" link at the bottom of the Window: Locate the "ShoWorks QuickBooks. Importing and exporting IIF files created by QuickBooks is fairly easy because QuickBooks formats the file for you. Note: Items purchased with 100% store credit, cash or check will not appear on the IIF file. You need to map your exported txt data to the format in the sample file. Learn which PayPal transactions can be imported into QuickBooks. In this QuickBooks training tutorial, you will learn how to import iif files. Saasant import. There are a few configuration settings required in QuickBooks and CompuTime101, as detailed in this guide. Enter relevant account names in the provided fields, ensuring that you match them exactly to how they are. iif download for your convenience only and it is only meant as a way to add transactions to your check register. If the revenue code on an item is not setup in the Chart of Accounts in TCR for the branch associated to the job, then the item will be missing from the export file, causing an imbalance. (You may get a message asking you to close out of all windows, Select OK). Go to File>Utilities>Import>IIF Files in QuickBooks and Import the txt file. Quickbooks import preparation - payroll example Takes information from a sheet, formats the data, removes unnecessary lines then saves the result as an. Please note that some steps outlined below may not apply to your system depending on the services you purchased. IIF file again. Importing and exporting IIF files created by QuickBooks is fairly easy because QuickBooks formats the file for you. If you were not able to locate your bank or if you need to download more than 90 days of banking transactions, then it is important for you to understand how to import your banking transactions using an Excel format called. A backup copy will allow you to restore your data if a problem occurs during the import. With Kutools for excel, we can not only import txt, PRN or CSV files but also Excel files into an excel worksheet beginning at a specific cell. From Quickbooks, go to "File > Utilities > Import > IIF Files". For more information on how to import the IIF file, refer to QuickBooks' documentation.