cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 1

IIF Import File - Where are transactions?

I am a new user working with an IIF export file from a third party company.  They advised that all I would have to do is import the file in QB, which I did.  I received a message that the import was successful.  However, where are the transactions after importing them?

 

 

1 Comment
Highlighted
Moderator

IIF Import File - Where are transactions?

Hello BusMgr,

 

Welcome to the QuickBooks Community. It would be my pleasure to answer any questions you may have regarding importing IIF transactions in QuickBooks Desktop.

 

The first thing you can do is open the imported file to determine if the content from the third party company is complete. Here's how:

 

  1. Open the Microsoft Excel program.
  2. Click the File tab at the top menu bar, and click Open.
  3. Search for the .IIF file.
  4. Choose All files to show all file types.
  5. Open the file.
  6. Make the necessary edits.
  7. Save the changes you made to the IIF.

If you're needing to learn more insights on IIF files, such as checking the content, please refer to the article below (scroll down to Edit the exported file):

 

Export or import Intuit Interchange Format (.IIF) files.

 

The information that shows on the IIF file is the data imported into the QuickBooks program. If it doesn't exist at all, I recommend running the Verify and Rebuild Data feature.

 

Here are the steps on how to verify data:

 

  1. Click the File tab at the top menu bar.
  2. Select Utilities.
  3. Click Verify Data.

To rebuild data:

 

  1. Click the File tab at the top menu bar.
  2. Select Utilities.
  3. Click Rebuild Data.

 

In case you'll need to run this process in the future, I'm also adding this article:

 

Verify and Rebuild Data in QuickBooks Desktop.

 

Let me know how the steps above go regarding the IIF file. I'll be on a lookout for your response.

Need to get in touch?

Contact us