IIF Import Issue

Hello tracey29,

Could you please send a screenshot of what happens when you select the review now button, and when you click on the IIF file?

Thanks,

Talia

Hi Talial

Thanks for your reply.

This shows what happens when I select the option of reviewing the failed entries after I've carried out the import.

Tracey

Hi there, @tracey29, 

I appreciate you providing a screenshot to get a better picture about importing IIF files.

I'll share the correct way to review the failed items so you'll be able to successfully import the Chart of Accounts (COA) list. 

It's possible the format is incorrect when importing your COA.IIF file. This maybe the reason you're unable to import it. 

To help fix this, let's open the file using the Microsoft Office Excel. This way, you can edit failed entries in the list. Here's how: 

1. Right-click the export file. 
2. Choose Open with, then select Microsoft Office Excel. 
3. If a warning about incompatible features, click Yes. 
4. Go to File, then choose Save. Edit the data in the file. 
5. Close Excel. 
6. Click No if you're prompted to save again. 

After that, let's create a backup of your company file because imports are irreversible. Then, you can import again the edited IIF file to QuickBooks 2019. Here's how: 

1. Go to the File menu at the top. 
2. Select Utilities, then choose Import. 
3. Hit .IIF Files. 
4. Find the edited IIF file, then click Open. 

For more details, you can check out this helpful article: Tasks You Can Do With IIF Files. To learn more about importing these files, you can visit these useful articles: 

• IIF Overview
• Export or Import IIF Files
• Export Lists from Old Company File Into A New Data File

The steps above will help you successfully import your COA list, @tracey29. 

I'm here anytime you have other concerns. Take care always!

Hi @RaymondJayO 

Thank you for your detailed instructions.

I've imported the COA and found the errors but I don't know what I need to do to fix them! The Excel file tells me what the error is but I don't know what the solution is and what it should say.

There are just 2 lines on the COA - one says:

The record at (or starting at) this line could not be imported. The specified special account already exists. [580]

And the other says:

; [ERROR] The record at (or starting at) this line could not be imported. The enumerated value "NonPosting" may not be used in the element "Account Type" in this request. [3152]

I haven't gone any further than the COA as I want to get this right before I move onto the Customer list.

One option is to enter it manually because I know what the accounts are and there are only 2....

Can you help please?

Hello Tracey,

Could you also please send a screenshot of those error messages, including as much of the information you are attempting to upload as possible?

Thank you,

Talia

Hi @TaliaI 

This is the file I have for the error on the COA

Tracey

Hello Tracey,

It may be worth adding these manually as you suggested earlier - otherwise we may need you to contact our Desktop support line, as they will be able to look at your account in more detail. You can reach them through 0808 168 9535.

Thanks,

Talia

Hi @TaliaI 

I added that account manually.  I've just tried to import the customer list and they've all failed, I really don't understand why.

Would you be able to help with that please?

Thanks

Tracey

Hello Tracey,

What error are you getting?

Thanks,

Talia

Hi @TaliaI 

I'm just getting the message that they've all failed.  I've attached a screenshot.

Hello Tracey,

Does it allow you to click the review button?

Thanks,

Talia

Hi @TaliaI 

When I click the review button I just get the same options as I did with the COA - it asks me whether I want to open it with QB or find another app.

I haven't tried the supplier or stock list yet but I imagine I'm going to end up with similar issues.

Tracey

Hi @TaliaI 

I'll give them a call, thank you very much for your help.

Tracey

Great,I will p ass on your thanks to Talia

Regards

Emma

When importing the IIF 

File > utilities > Import > IIF files.

Instead of clicking the IMPORT button, click the link below. 

Import it for me. Ill fix it later.