Quickbooks iif file import error – Solved – in this post we provide you the solutions how to fix iif files.

Quickbooks iif file import error – Solved

We recently changed banks.  Our .iif file downloads worked fine from the old bank but we have been having problems with the downloads from the new bank.  I have spent quite a bit of time trying to identify the problem and think that I may have a clue at this point.

Our .iif file has three heading lines:

!TRNS  TRNSID  TRNSTYPE  DATE  ACCNT  NAME  AMOUNT  MEMO  DOCNUM  CLASS
!SPL  SPLID  TRNSTYPE  DATE  ACCNT  NAME  AMOUNT  MEMO  DOCNUM CLASS
!ENDTRNS

When downloading the .iif file we get messages like
    Error on Line 6: Can’t record invalid transaction      and
   Error on Line 73: You can’t change the type of a name or add duplicate name.

At the end of the upload, we end up with ‘two’ new bank accounts:

    Unknown
    9_____835-Demand Deposit

The two bank accounts show the same totals but one is a negative number and the other a positive.

Based on my own review, it seems that there are two problems:

1. Two bank accounts are being generated instead of one.
2. In the .iif file it looks like any transaction that has an TRNSTYPE of “PAYMENT” results in an error (Can’t record invalid transaction)

(I think that I can address the ‘You can’t change the type of a name or add duplicate name’ error message).

We first encountered this problem with a company file that he was working with so decided to try it with a QuickBooks sample company account and ran into the same problem…so I don’t think that it’s a problem with the software (QB Premier Ed. 2016).

• importing iif files into quickbooks 2019
• import iif file into quickbooks desktop
• quickbooks we weren’t able to import right now
• ; [error] it’s a list or transaction that is not supported by the iif import process.
• unable to import iif files into quickbooks
• iif file not importing
• quickbooks 2019 errors
• quickbooks 2019 iif import error

Continue reading →