Skip to main content
July 17, 2024
Question

Importing an IIF file

  • July 17, 2024
  • 2 replies
  • 0 views

I am trying to import an IIF file and it continually fails. Is there someone who can help me get this started? Quickbooks Desktop support has been unhelpful.   I'm willing to pay for the help!  [email address removed].

2 replies

July 17, 2024

Hello there, GVNina. It's my top priority to bring your Intuit Interchange Format (IIF) files to QuickBooks Desktop.

 

Before doing so, I'd like to know if you've encountered any error messages while importing IIF files. This way, I'll be able to check for any open investigation that relates to your concern.

 

On the other hand, when importing IIF files to QuickBooks Desktop, import failure may occur due to errors in the file. Let's ensure we use the correct IIF file format and then import again.

 

You can download the toolkit to know the proper formatting. Refer to this article: IIF Overview: import kit, sample files, and headers.

 

In addition, you can check out this article to learn about IIF import and export limitations: Export, import, and edit IIF files.

 

Let me know if you have any further questions about importing your data into QuickBooks Desktop, and I'll be happy to assist you.

GVNinaAuthor
July 20, 2024

I'm so frustrated, I hope that you can help me!

I DO get an error message that the import failed.  When I click on either the Review or Open file button, I get nothing.  

I have the IIF Toolkit, but it doesn't help me.  I read the manual, but it doesn't actually say what to do if the file doesn't import.  I sent the file to QB Tech Support, and they said they can import it, so it must be a problem with the file.  However, I have no control over the file and can only work with what they send.  The file is from Stripe credit card processing, and I know that QB can import their downloads.  I really don't understand why I am having so much difficulty.

Some other person at QB support said that the problem is I have to map the accounts; however, when I called back to ask for help in mapping the accounts, I was told that isn't necessary.

I have attached a pdf of the file.

 

 

July 18, 2024

@GVNina 

Which QB Desktop year version do you run?

What transaction type do you need to import?

GVNinaAuthor
July 20, 2024

It is QB Desktop Pro Plus 2024.  I'm trying to import an IIF file from Stripe, our credit card processor.

July 21, 2024

I appreciate the effort taken to ensure you can successfully import your files into QuickBooks Desktop (QBDT), @GVNina.

 

Importing IIF files in QBDT is possible. However, if your file came from a third-party app, consider checking the file format and the maximum number of lists entered, as this can be a reason for unsuccessful importing.

 

You can refer to the IIF Import Kit to compare the header and other data fields with the ones on your file. This can help spot any formatting issues that lead to the error message. 

 

Since you encountered the error message File not imported, click the Review Now button to view and resolve any errors detected in your IIF file.

 

Here's how:

 

  1. Click the Review Now button.
  2. Find the ERROR to see the problem(s) with the file.
  3. Correct the errors as needed, and then click Save
  4. Select Yes if you want to keep the file type, and then close the File not imported window.
  5. Import the new corrected file.

 

Check this helpful link for more details: Resolve IIF Import in QBDT 2019 and later.

 

QuickBooks doesn't offer technical support for IIF file import. I suggest contacting Stripe's support for further assistance. On the other hand, you can also seek further help from an IT expert to help successfully import the file.

 

Alternatively, you might consider utilizing a third-party importer tool that can directly import IIF files from Stripe to QBDT. You can explore the Marketplace to find this tool.

 

Additionally, there are other tasks you can carry out with your IIF files, such as bulk editing. Refer to this article for more detailed information: Tasks you can do with IIF files.

 

Don't hesitate to reach out if you have further questions about managing files. I'll be around to help. Stay safe.