cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Importing from IIF file getting an error, The Account Name on a distribution does not exist in Quickbooks [11110]

The Account Name on a distribution does not exist in Quickbooks [11110]

 

We were importing IIF files into QB 2015 and moved to 2019.  Now we are getting an error message as seen above.  It used to work fine in 2015.  The IIF file has has the following columns.

 

!TRNS TRNSID TRNSTYPE DATE ACCNT NAME AMOUNT DOCNUM CLEAR TOPRINT MEMO
!SPL SPLID TRNSTYPE DATE ACCNT NAME AMOUNT DOCNUM CLEAR QNTY MEMO CLASS

!ENDTRNS

 

What does the error message mean and how can I solve it?

 

thanks in advance

Solved
Best answer 03-26-2019

Accepted Solutions
BRC
Established Community Backer ***

Re: Importing from IIF file getting an error, The Account Name on a distribution does not exist in Quickbooks [11110]

Yes, QB 2019 has many new unneeded restrictions added in an effort to save you from yourself. But IMO they get in the way more than they help.

 

See BRC QuickBooks 2019 IIF Import Changes and Recommendations  for steps to import the old way that worked for you.

6 Comments
BRC
Established Community Backer ***

Re: Importing from IIF file getting an error, The Account Name on a distribution does not exist in Quickbooks [11110]

Yes, QB 2019 has many new unneeded restrictions added in an effort to save you from yourself. But IMO they get in the way more than they help.

 

See BRC QuickBooks 2019 IIF Import Changes and Recommendations  for steps to import the old way that worked for you.

QuickBooks Team

Re: Importing from IIF file getting an error, The Account Name on a distribution does not exist i...

Hi there, @MikeStrider.

 

The Account Name on a  distribution does not exist in Quickbooks [11110] error happens when there are errors or typographical errors in your IIF imported file most specifically on the account name. I'd be happy to help you import the file successfully to QuickBooks Desktop (QBDT).

 

To import the IIF file successfully, you must check the file first. Double-check the account names used, the spelling and any other typographical error. You must ensure that the names used exists and are acceptable in QuickBooks.

 

Once done, checking the file, try importing it again.

 

You can read this article to know more about importing/exporting IIF files in QBDT: Export or import Intuit Interchange Format (.IIF) files.

 

Please know that I'll be right here to help you have any other QuickBooks or importing questions. I'll be glad to help you!

Not applicable

Re: Importing from IIF file getting an error, The Account Name on a distribution does not exist in Quickbooks [11110]

Thank you for this link.  We will try it.

QuickBooks Team

Re: Importing from IIF file getting an error, The Account Name on a distribution does not exist i...

Hello again, MikeStrider.

 

Thank you for getting back to the Community.

 

In behalf of my colleague @Angelyn_T, I would like to say you're welcome. In addition to the information above, I'm adding the detailed steps I recommend on this:

 

  1. If you encounter an error, you'll have an option to select Review now.
  2. Search for the error.
  3. Make corrections to the error.
  4. Click Save.
  5. Close the File not imported window.
  6. Import the IIF file again.

For additional reference, you can visit the article about the improved IIF import in QuickBooks 2019:

 

Improved IIF Import in QuickBooks 2019.

 

Please don't hesitate to come here with all of your concerns about importing the IIF file. The Community is here to ensure your success.

Not applicable

Re: Importing from IIF file getting an error, The Account Name on a distribution does not exist in Quickbooks [11110]

We have been importing iif files into quickbooks for years.  Just upgraded from 2018 to 2019 and the iif import worked fine except for the information in the "docnum" is blank in quickbooks after the import even though there were values (check numbers) in the iif file.

Anonymous
Not applicable

Re: Importing from IIF file getting an error, The Account Name on a distribution does not exist i...

Thank you for letting us know, @tfoster171.

 

I'm here to help share some insights and get this import process working for you.

 

Generally, if the information is missing when importing the data, it's possible that data was formatted incorrectly. Also, we don't recommend the option Import it for me. I'll fix it later. Since this option bypasses data review, some of the info may not be correct or complete for your books. You can refer to this article for more details about unsuccessful import: File not imported.

 

If the issue persists after reviewing the format, I'd suggest reaching out to our Desktop Specialist to look into this further. I'm sure they can help you with this using their extra tools.

 

Please stay in touch with me if you have other questions about importing your IIF. I'm here to help however I can.

Need to get in touch?

Contact us