Was this page helpful?
Thank you!

Comments or suggestions?



Enter Email Address (optional)
email

Import bank transactions into QuickBooks from an IIF file

Some financial institutions (FI) provide transaction data in an Intuit Interchange Format (IIF) file. You must download IIF files to your hard drive from your FI Web site and then import them into QuickBooks.

To import banking transactions into QuickBooks
  1. Login to your financial institution's Web site and locate the IIF file containing your banking transactions.
  2. If you have the option to change the name of the bank account in the IIF file to match the name of the bank account in QuickBooks, make sure the account names are identical.
  3. Download the IIF file to the Desktop.
  4. Import the IIF file. 
  5. Open the bank register to view the imported transactions
  6. Re-assign each transaction from the default expense account to the correct expense account.
  7. Check for duplicate entries and for the correct ending balance.
Troubleshooting IIF Import Files

When you import the IIF file, you may notice that transactions aren't flowing where they should, not showing up at all, or other strange behaviors

To Troubleshoot IIF Import Files for Online Banking:

  1. Create a brand new company file by going to File > New Company.
  2. Next, make sure to Skip the Interview and create the file on your desktop so you can remove it later.
    • In QuickBooks 2013 and newer select Express Start.
  3. Create a customer, an invoice to the customer, receive payment from the customer, and record a deposit.
  4. After that, enter and pay a bill (you also will have to create a vendor).
  5. Import the IIF file into your test file.
  6. Check to see if the same behavior is occurring in the new file.

Important: If you see the same results from your original file, then the IIF file is the issue, not the program or company file and you will need to contact the financial institution to resolve the issue as they might not be using a compatible version of IIF for QuickBooks.  It is recommended to use .QBO files (QuickBooks Web Connect) to import transactions from your bank.  Ask your bank if they support this format.

If the problem does not occur in the new file, then the IIF file is good and properly formatted for QuickBooks. You will need additional troubleshooting in your company data file. Possible fixes could be running a rebuild and merging bank accounts that are used in the IIF file, etc.

 

If these steps do not resolve the issue, you can read discussions and post messages and questions relating to your issue on the Intuit QuickBooks Community site for free or you can contact a technical support agent for additional guidance. Fees may apply.

KB ID# HOW12346
10/23/2014 12:12:38 PM
PPRDQSSWS403 9102 Pro 2013 9a54b6