IIF Transaction Type

Beautiful!  Will do that.  Thank you so much!!

Does anyone know why this transaction will not import via an .iif file?  These are credit card transactions and I get an [ERROR] Invalid line [15114] message for each SPL line.  The file is a tab delimited text file saved with an .iif extension.

We appreciate you for joining the thread, michael. I'd like to share some insights about importing an IIF file into QuickBooks Desktop.

The Invalid line [15114] error you get while importing is likely due to incorrect formatting of the downloaded file. Make sure the mapping is correct then re-import the file.

See the following articles to find out some basic information regarding IIF files and the proper formats. Additionally, you can check the import limitations in the first article.

• Export, import, and edit IIF files
• IIF Overview: import kit, sample files, and headers
• Improved IIF Import in QuickBooks 2019 and later

Feel free to also browse the QuickBooks Support page for additional help and video tutorials about QBDT.

Keep in touch if you need any more guidance about data management or QuickBooks. We're available 24/7 to back you up. Stay safe.

@michael-su 

It's not possible to tell exactly why you're seeing that error without your ! definition rows, and the Tabs are removed as well between fields.

However, repeating the NAME on the SPL row can be an issue if it's not a Customer.  Something like the example below should work, with the fields separated by tabs. Note the date format should match your computer's month and day order and use either YY or YYYY - also depending on your computer's settings (so typically either MM/DD/YYYY or MM/DD/YY in the US, and not M/D/...) And also that it's a good practice to include the TRNSID and SPLID columns in the second position as shown, with no values, because - for some reason - omitting them seems to cause intermittent issues:

You might try our BRC IIF Transaction Creator Pro , if only in free trial mode, and use it to create example IIF files you can then emulate.

Thanks for your response.  I tried to remove the NAME and add SPLID (which I have never used before in many years of doing this) and still got this error.  I'll try your free tool to see if that helps, but if you have any other suggestions, I'd appreciate them.