Was this page helpful?
Thank you!

Comments or suggestions?

Enter Email Address (optional)

Import bank transactions into QuickBooks Desktop 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 Desktop.

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 Desktop, 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 select Express Start and create the file on your desktop so you can remove it later.
  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.
  • 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.
KB ID# HOW12346
4/27/2017 1:58:17 AM
QYPPRDQBKSWS07 9138 Pro 2017 0888bd