QuickBooks Learn & Support Home
  • QuickBooks, United States

Import an IIF file into your QuickBooks data file

This article will discuss how to import IIF Files to your QuickBooks company file.

Detailed instructions

Before you import transactions:

  1. Since you cannot undo an import, you must backup your company file before proceeding.
     
  2. Before importing transactions, you need to set up Accounts, Items, Names and Sales Tax Items and Names. You can do this on one of two ways.
    • You can enter the data directly into QuickBooks OR
    • You can add code to your IIF file to import this data for you.
       
  3. If you do not set up this data, the import of transactions will set up some of the data, but it might be wrong or unusable like the situations bellow:
    • The A/R account is set up as a type bank account and you cannot change it to a Type A/R account.
    • The customer name is set up as an other name and cannot be used on an Invoice.
    • Sales items and Sales Tax items are set up as Type Service items and they cannot be changed to any other type.

Import transactions:

  • Log in to your data file as the Administrator.
  • Switch to single user (SU) mode.
  • From the File menu, choose Utilities , select Import and click IIF Files.
  • Browse to the location of your IIF file and highlight the file.
  • Click Open.
  • QuickBooks pops a message confirming your data has been imported.
  • Click OK on the message.

     

 Note: Intuit does not offer assisted technical support for creating or importing IIF files. If the IIF file was created by a third-party application, contact the application's technical support department.

Quick Tip: QuickBooks will not require for the closing date password even if the transaction is for a closed accounting period because only the administrator can import transactions.


Was this article helpful? Yes No
Do you still have a question?

Ask your question to the community. Most questions get a response in about a day.

Post your question to the community