cancel
Showing results for 
Search instead for 
Did you mean: 
Adrianhd
Level 2

Importing an IIF file with multiple different dates

I am using Quickbooks desktop 2019 and I am trying to import an IIF file that has multiple different dates and keep getting the error message: 

 

"The date in the distribution line must be the same as the transaction header [11081]"

 

I would like to be able to import this iif file because I do not want to have to import per day and like the convenience of the date range. 

Solved
Best answer January 28, 2021

Best Answers
ReyJohn_D
QuickBooks Team

Importing an IIF file with multiple different dates

Thanks for the screenshot and for following the steps given by my peers above, @Adrianhd.

 

I've got your back in handling IIF import in QuickBooks Desktop.

 

Yes, you're correct. You'll need to add both TRNS and ENDTRNS for each date range before importing your IIF files. This way, you can prevent errors like this.

 

When you're all set, you can now import your IIF file again.

 

If you get the same outcome, I recommend getting in touch with our live support. One of our agents can review your account in a secure space and determine what's preventing you from importing the file.

 

Before diving in, please check our support hours so they can assist you promptly.

 

Here's how to contact our support:

 

  1. Open your QuickBooks Desktop, and then go to the Help menu.
  2. Select QuickBooks Desktop Help.
  3. On the pop-up screen, choose Contact us.
  4. Enter your concern on the Tell us more about your question box, like "IIF files import error."
  5. Click the Search button.
    q120.PNG
  6. Select either the Call us or Message Us option.

 

By the way, you can perform other tasks with your IIF files, such as bulk editing them, etc. Please head to this link for more details: Tasks you can do with IIF files.

 

Feel at ease to comment back below if you have more file management concerns or any QuickBooks-related. I'm still up and running to answer them for you.

View solution in original post

9 Comments
MadelynC
QuickBooks Team

Importing an IIF file with multiple different dates

Here's everything you'll need to know about importing IIF file in QuickBooks, @Adrianhd.


I’m glad that you’ve visited us here in the Community. 


Correct formats, spelling, and placement of the file are required to prevent errors during import. You’ll want to make sure everything is set to ensure your transactions are transferred successfully. 


You can download the sample IIF file found in this article IIF Overview to ensure every component is properly setup. 


You can also visit this link about importing, exporting, and editing IIF files in QBDT. This reference contains complete details to learn more about its limitations.


If you have further questions concerning the IIF import, please don't hesitate to let me know. I'll be here to help.

Adrianhd
Level 2

Importing an IIF file with multiple different dates


@MadelynC wrote:

Here's everything you'll need to know about importing IIF file in QuickBooks, @Adrianhd.


I’m glad that you’ve visited us here in the Community. 


Correct formats, spelling, and placement of the file are required to prevent errors during import. You’ll want to make sure everything is set to ensure your transactions are transferred successfully. 


You can download the sample IIF file found in this article IIF Overview to ensure every component is properly setup. 


You can also visit this link about importing, exporting, and editing IIF files in QBDT. This reference contains complete details to learn more about its limitations.


If you have further questions concerning the IIF import, please don't hesitate to let me know. I'll be here to help.


 

Thank you for your prompt response. I have looked at those but unfortunately, I am still confused as to if what I want to accomplish, can be done. In the attachment, it shows the IIF file that I am trying to import and the errors of that import. It seems as though the QB is capturing just the first date and everything else, if it is not that same date it errors out. I don't know if there is something that I can add to that file to separate each date so that way I do not encounter this issue again. Something like an end series command so that way QB will realize to move to the next date in the series.

Rose-A
Moderator

Importing an IIF file with multiple different dates

Thanks for getting back to us, Adrianhd.

 

I appreciate the screenshot you've provided. You should be able to import the files with any dates on them. To avoid getting errors, you might want to double-check the format and ensure the date is the same as QuickBooks.

 

Please be reminded that QuickBooks Desktop takes the date layout from your computer. I'd suggest setting your PC's date the same as the file format.

 

For your reference, check out this article: IIF Overview: import kit, sample files, and headers. This will provide you sample charts on how the IIF looks like as well as a link on what other tasks you can do with this type of file.

 

Kindly update me on how things go by adding another comment below. I want to make sure you're able to import your file, and I'm here if you need further guidance. Have a great day! All the best.

Adrianhd
Level 2

Importing an IIF file with multiple different dates


@Rose-A wrote:

Thanks for getting back to us, Adrianhd.

 

I appreciate the screenshot you've provided. You should be able to import the files with any dates on them. To avoid getting errors, you might want to double-check the format and ensure the date is the same as QuickBooks.

 

Please be reminded that QuickBooks Desktop takes the date layout from your computer. I'd suggest setting your PC's date the same as the file format.

 

For your reference, check out this article: IIF Overview: import kit, sample files, and headers. This will provide you sample charts on how the IIF looks like as well as a link on what other tasks you can do with this type of file.

 

Kindly update me on how things go by adding another comment below. I want to make sure you're able to import your file, and I'm here if you need further guidance. Have a great day! All the best.


Hello Rose, 

So if I have a date range starting at 11/30/2020 and all the dates are following the same format, on the error file I am noticing that there is a TRNS at the start of the 11/30/2020 date. Does the TRNS tell QB that it is a new transaction header? Is there a setting in Quickbooks that I need to enable? I am just trying to think of any and all scenarios. 

jamespaul
QuickBooks Team

Importing an IIF file with multiple different dates

Hello, Adrianhd. 

 

Thanks for getting back to us! I appreciate the screenshot. I'll take it from here and provide details on the header and steps on how we can fix the error message. 

 

You don't need to enable a setting in QuickBooks for the import process. As for the header, the transaction starts at TRNS and ends with ENDTRNS

 

Going back to the issue from the original post, I have another recommendation to help you fix the error message. 

 

I recommend using the IIF Import Kit if you haven't already done so. Then, compare the header and the data fields with the ones on your file. This can help spot any formatting issues that contributes to the error message. 

 

I see that my colleagues have provided the IIF Overview article. Have you checked the guide on using the IIF headers in it? If not, I recommend following the Understand .IIF headers section for important pointers. 

 

You can also open one of the sample files under Individual sample IIF files and compare the fields with your data.

 

After fixing the error message and successfully importing the file, you're welcome to browse other articles for guides. They can help you record transactions, run a variety of reports, manage your lists and other data. 

 

I'm happy to offer a helping hand again if you have more questions on handling your data or your tasks in QuickBooks Desktop.

Adrianhd
Level 2

Importing an IIF file with multiple different dates

Hello James, 

I apologize if I am a nuisance, however, after looking at the formatting I am seeing that everything looks formatted correctly. The only difference between the IIF file that I have and the template is that the IIF that I have does not contain everything from line 1-11

!ACCNT
ACCNT
ACCNT
!CLASS
CLASS
!CUST
CUST
!VEND
VEND
!OTHERNAME
OTHERNAME

If I import individual days, the format and everything works properly. The only time that I encounter an issue is if there are multiple days selected. I have attached the testing file that had been causing me a headache for quite some time. If QB is able to import an IIF with multiple dates and I know the formatting is correct when individual dates (example: everything from 11/30/2020) imports properly, then the only thing that I can think of that may cause my issue is that I may need to add TRNS to the start of each new date. Or possibly a combination of TRNS and ENDTRNS for each date range. If I am incorrect in that theory, please let me know. 

ReyJohn_D
QuickBooks Team

Importing an IIF file with multiple different dates

Thanks for the screenshot and for following the steps given by my peers above, @Adrianhd.

 

I've got your back in handling IIF import in QuickBooks Desktop.

 

Yes, you're correct. You'll need to add both TRNS and ENDTRNS for each date range before importing your IIF files. This way, you can prevent errors like this.

 

When you're all set, you can now import your IIF file again.

 

If you get the same outcome, I recommend getting in touch with our live support. One of our agents can review your account in a secure space and determine what's preventing you from importing the file.

 

Before diving in, please check our support hours so they can assist you promptly.

 

Here's how to contact our support:

 

  1. Open your QuickBooks Desktop, and then go to the Help menu.
  2. Select QuickBooks Desktop Help.
  3. On the pop-up screen, choose Contact us.
  4. Enter your concern on the Tell us more about your question box, like "IIF files import error."
  5. Click the Search button.
    q120.PNG
  6. Select either the Call us or Message Us option.

 

By the way, you can perform other tasks with your IIF files, such as bulk editing them, etc. Please head to this link for more details: Tasks you can do with IIF files.

 

Feel at ease to comment back below if you have more file management concerns or any QuickBooks-related. I'm still up and running to answer them for you.

View solution in original post

Fiat Lux - ASIA
Level 15

Importing an IIF file with multiple different dates

@Adrianhd 

There are some unresolved issues in IIF feature since QBD 2019. If you are still hit the wall, consider to import it as XLS/CSV instead.

Adrianhd
Level 2

Importing an IIF file with multiple different dates

Hello Rey and team, 

 

That worked! Thank you, everyone, for your assistance with this. I apologize that I was sounding like a broken record and annoying but I just could not figure out this issue. 

Need to get in touch?

Contact us
Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up