cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Community Contributor *

iif file headers missing

I'm trying to import data with an iif file but have noticed that some of the headers I need are missing. How do I find what those headers should be? I've tried exporting an iif file but even in these exports the headers are not included. Nor have the sample iif files been helpful.

 

A specific example: if I want to import employee data there are no headers for Occupation, Gender, and Date of birth. I want to include columns with this information. Where do I find what these headers should be named?

 

I'm using Quickbooks Pro 2016 (not using a payroll service)

 

Thanks for any suggestions which would help.

Solved
Best answer 06-11-2019

Accepted Solutions
QuickBooks Team

Re: iif file headers missing

Hi there, @JayBe.

 

As mentioned, the IIF headers are predefined fields. Currently, you can only enter details on the available headers, and the option to add more is unavailable.

 

For additional details and references, I recommend checking the articles below:

I already sent a feedback statement on your behalf to our engineers. We listen to customers’ suggestions as it contributes significantly for product enhancements. You can always visit the QuickBooks Blog site to check the latest added feature.

 

That should keep you going today, @JayBe. Let me know if you have follow-up questions. I'm still here to provide answers.

7 Comments
QuickBooks Team

Re: iif file headers missing

Hi there, JayBe.

 

The column headers in the IIF file are listed on the label columns and they are assigned to a specific index at the bottom. You can manually modify the information, but it's not an assurance that it will be successfully imported.

 

To test, you can try to create a dummy company file, and do a sample import by following the steps:

  1. Click File located at the top.
  2. Choose New Company.
  3. Click the Express Start button.
  4. Enter a business information
  5. Follow the on-screen instructions until finished.

Once done, try to import the modified IIF file.

 

Should you have additional questions related to this, feel free to let us know. Thanks.

Community Contributor *

Re: iif file headers missing

I'm not sure if I fully understand you. I know I can create custom entries. The names are listed in a CUSTNAMEDICT table while the data is then liked to the column header CUSTFLD1, CUSTFLD2, etc.

 

However, the headers I mentioned are in-built (Gender, Occupation, etc), not customer defined. Just like the headers ADDR1, ADDR2...CITY...FIRSTNAME
....

 

I would therefore assume that Quickbooks as a pre-defined header name such as DOB or OCCUPATION.

 

I can of course try multiple variables of these names but that seems rather hit and miss to me. Surely there's a better way of finding this information!

BRC
Established Community Backer ***

Re: iif file headers missing

Many QB fields cannot be imported.  If the export does not include the fields, they aren't supported.

QuickBooks Team

Re: iif file headers missing

Hi there, @JayBe.

 

As mentioned, the IIF headers are predefined fields. Currently, you can only enter details on the available headers, and the option to add more is unavailable.

 

For additional details and references, I recommend checking the articles below:

I already sent a feedback statement on your behalf to our engineers. We listen to customers’ suggestions as it contributes significantly for product enhancements. You can always visit the QuickBooks Blog site to check the latest added feature.

 

That should keep you going today, @JayBe. Let me know if you have follow-up questions. I'm still here to provide answers.

BRC
Established Community Backer ***

Re: iif file headers missing

@HoneyLynn_G

RE: As mentioned, the IIF headers are predefined fields. Currently, you can only enter details on the available headers, and we don't have the option to add more. 

 

If by "we" you mean "Intuit" the of course you have the option to add more.  Don't patronize us. You control the whole show.  You can add more any time you want.

Community Contributor *

Re: iif file headers missing

Okay, I understand your answer. Though truth be told, it doesn't make much sense. It should be a straight forward thing to like to a field if you know the name. But maybe Quickbooks designed their database structure differently.

 

Not the answer I was hoping for but thanks for the feedback. Although it doesn't really answer the question I'll mark your response as the solution.

Community Contributor *

Re: iif file headers missing

 

Need to get in touch?

Contact us