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:
- Two bank accounts are being generated instead of one.
- 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).
Any insight into the problem would be appreciated. Screen shots associated with this problem can be seen on the attached.
