Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
I keep getting "Found a misplaced SPL line in the import file." When I tried to load myself.
Then I tried QB's way of uploading, for it to review. The entire file failed. When I clicked on Review, I received the attached error.
I've had QB desktop for 6 years and have used the same software to upload my IIF files and have NEVER had any problems, now I'm getting this.
I'm lost as to what to do??
Thank you for posting here in Community @d1csp3r,
I'm here to assist you. Once you receive the error message, QuickBooks Desktop allows you to review the error found in your .IIF file. You can manually open the folder where the .IIF file was saved. Look for the error, and correct the problem with the file. Here's how:
You can visit our QuickBooks Desktop Help Article if you have other questions about importing and exporting your transactions in QuickBooks Desktop.
Stay in touch with us here in the Community if you need further assistance. I'm always here to help. Have a good one!
The misplaced SPL line error means there is a SPL line that does not follow a TRNS line.
For example, you might have
TRNS...
SPL...
SPL...
SPL...
ENDTRNS
and then
SPL...
ENDTRNS
In this case the last SPL line will trigger the error as there is no TRNS line before it.
Hi, there @d1csp3r.
Thank you for getting back here in the thread. As what @BigRedConsulting, you can check if there's an inorder line in your import file in QuickBooks Desktop because it might be the reason you received the error when importing transactions.
I've also provided steps on how to import IIF file in QuickBooks Online. You can follow these steps and check if you still get the error.
Note: We don't recommend the option Import it for me. I'll fix it later. Since this option bypasses data review, some of the info may not be correct or complete for your books. It also requires that you switch to a single user.
In case you'll need help on how to export or edit an IIF file, refer to this link: Export, import, and edit IIF files.
If you need further assistance, feel free to leave a message in the comment section. I'll be happier to help. Have a wonderful day!
I figured it using this workaround, since I cannot open the IFF, as previously stated.
This is the most worthless advice. It doesn't even address the issue - much like QB tech support. I am having the same problem and was told I would have to pay for support which I did sat on hold for 30 mins was hung up on once and then got back on tech support for another 2 hours to be told they couldn't help and would call me back tomorrow. No call back - hands down the worst customer service I have ever received from a company.
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