cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Experienced Member
Solved

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

Best answer 03-26-2019 08:39 AM

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.

4 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!

Experienced Member

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.