Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Hi,
I'm having the strangest issue with importing a simple BILL IIF in QUICKBOOKS DESKTOP 2019. I've stripped the file down to its most basic components and can't find a way around the issue. It looks like the schema for IIF has been change but the documentation hasn't. eg In the Header Help for TRNS & SPL is says "The TRNSTYPE, ACCNT, and AMOUNT columns are required." This is true. However if you omit the NAME field you get "Missing mandatory field NAME in header. [15102]".
I even created a blank company and tried to import the sample IIFs from the import kit (https://support.quickbooks.intuit.com/support/pages/executable/iif/iif_import_kit.zip) and used that without success.
Error 3040 claims to be an invalid character, but no matter how I check it, the result is always the same.
Long story short, does anyone know how to resolve importing this data:
!TRNS | DATE | TRNSTYPE | ACCNT | NAME | AMOUNT |
!SPL | DATE | TRNSTYPE | ACCNT | NAME | AMOUNT |
!ENDTRNS | |||||
; [ERROR] The record at (or starting at) this line could not be imported. There was an error when converting the amount "-100.00" in the field "item amount". QuickBooks error message: This field contains an invalid character. [3040] | |||||
TRNS | 07/16/2017 | BILL | Accounts Payable | Bob | 100 |
SPL | 07/16/2017 | BILL | Accounts Receivable | -100 |
Any help would be greatly appreciated!
Mark
Solved! Go to Solution.
Not sure why you're seeing the error in your post.
One thing that does look wrong is your use of "Accounts Receivable" on the SPL line. You can't use an AR account in QB on a Bill.
Regarding the NAME, it is required for a Bill. And also a NAME is required for any AR row, whether a TRNS or SPL row.
Generally we recommend avoiding the new import code as it's so shabby and Intuit has shown very little interest in fixing it for the last two years.
See our more detailed recommendations here: BRC QuickBooks 2019 & 2020 IIF Import Changes and Recommendations
Thank you for posting your question here in Community, @Mark145.
IIF is used to export or import QuickBooks Desktop data like your bank transactions, general journals, customer, and vendor lists.
However, creating IIF files from scratch or adapting data from another program is technically complex and may be difficult if you don't have experience formatting delimited text files. This makes it faster and easier to enter the information directly into QuickBooks Desktop unless you have very large amounts of data to import.
Let me help you with how to import the IIF file in QuickBooks Desktop. Here’s how.
If the issue persists, I recommend contacting our Phone support. They have the proper tools to pull and check your account regarding this issue.
To reach out to our Phone support, here’s how.
You can refer to this article for additional reading on export, import, and edit IIF files. Export, import, and edit IIF files.
Please fill me in if you have further concerns. Take care!
Hi Pabz_l,
Thank you for your response.
I have successfully imported the chart of account and list of suppliers so I am familiar with the process.
Do you have any information regarding Error 3040?
Cheers
Mark
Not sure why you're seeing the error in your post.
One thing that does look wrong is your use of "Accounts Receivable" on the SPL line. You can't use an AR account in QB on a Bill.
Regarding the NAME, it is required for a Bill. And also a NAME is required for any AR row, whether a TRNS or SPL row.
Generally we recommend avoiding the new import code as it's so shabby and Intuit has shown very little interest in fixing it for the last two years.
See our more detailed recommendations here: BRC QuickBooks 2019 & 2020 IIF Import Changes and Recommendations
Hi BR,
That did the trick. Thank you for the assistance!
There are some very weird inconsistencies in IIF (such as not accepting the date 09/01/17, had to be 2017/09/01) but I've got my first 100 BILL entries tested and working as well as their corresponding CHECK entries.
Cheers
Mark
I am having a similar problem and can't get it fixed. I am hoping you can help me. I tried to follow the messages but not helping. I am getting the 15102 error.
Thanks!
Julie
Hi Julie.
I understand that you're experiencing difficulty resolving the 15102 error in QuickBooks, even after attempting the steps mentioned in the thread you provided. I'll do my best to assist you further.
Since you've already tried the suggestions mentioned in the thread, let's explore some additional troubleshooting steps. You'll want to download the QuickBooks .IIF import kit to use as reference guide for creating and working with .IIF import files. Make sure to follow the correct exactly to ensure your transactions import successfully.
If you're still getting the same error, follow these instructions:
Additionally, ensure that your subscription is currently active and that your software is updated to the latest version. This way, you always have the latest features and fixes. If the issue persists after trying these steps, I recommend reaching out to our Customer Care Support team for further assistance. They have specialized tools to help diagnose and resolve specific error codes.
Don't hesitate to ask if you have any further questions or concerns with importing files. The Community is always here to help.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here