cancel
Showing results for 
Search instead for 
Did you mean: 
d1csp3r
Level 2

misplaced spl line

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??

 

6 Comments 6
Rejeil_O
QuickBooks Team

misplaced spl line

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:

 

  1. Instead of clicking the Review now button, you can select the Open in folder option to route you where the .IIF file is located.
  2. Look for the error to check the problem of the file.
  3. Correct the errors and Save it.
  4. Close the File not imported window.
  5. Import the corrected .IIF file.

 

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!

BigRedConsulting
Community Champion

misplaced spl line

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.

d1csp3r
Level 2

misplaced spl line

I still keep getting the attached error, when  I try to open the file.  

Rejeil_O
QuickBooks Team

misplaced spl line

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.

 

  1. Go to the File menu.
  2. Select Utilities, choose the Import tab, and then IIF Files.
  3. Select Import IIF.
  4. Locate the file, then select OK
  5. Once the import is successful, you'll see the numbers of lists and transactions imported. Press Done

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!

d1csp3r
Level 2

misplaced spl line

I figured it using this workaround, since I cannot open the IFF, as previously stated.

 

https://quickbooks.intuit.com/learn-support/en-us/other-questions/2019-iff-review-not-opening/00/243...

jfackler
Level 1

misplaced spl line

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.  

Need to get in touch?

Contact us