Solved
TXT import problem
I am trying to import into QB Enterprise a list of checks and journal entries (which I have done for years) and keep getting this error: "found a misplaced spl line in the import file". I have double-checked my file and the lines are all just as they have always been. Below is a sample that won't import. Can someone help me figure out why this won't import? I have almost 5000 lines of entries that I need to get into QB and do not want to enter them manually.
| !TRNS | TRNSID | TRNSTYPE | DATE | ACCNT | NAME | CLASS | AMOUNT | DOCNUM | MEMO | CLEAR |
| !SPL | SPLID | TRNSTYPE | DATE | ACCNT | NAME | CLASS | AMOUNT | DOCNUM | MEMO | CLEAR |
| !ENDTRNS | ||||||||||
| TRANS | 1 | Check | 01/29/13 | 1098 | George | -449.36 | BP | |||
| SPL | 1 | Check | 01/29/13 | 7350 | George | 22.39 | BP | Grainger Stretch Wrap | ||
| SPL | 1 | Check | 01/29/13 | 5340 | George | 29.97 | BP | Pat Mallet reimburse for fire extinguisher recharging | ||
| SPL | 1 | Check | 01/29/13 | 7500 | George | 397.00 | BP | Reliant Energy | ||
| ENDTRANS | ||||||||||
| TRANS | 1218 | General Journal | 12/28/22 | 5310 | Gusto | 587.50 | ACH | Regular Payroll Dec 17 – Dec 23 | ||
| SPL | 1218 | General Journal | 12/28/22 | 5310 | Gusto | 37.07 | ACH | Regular Payroll Dec 17 – Dec 23 | ||
| SPL | 1218 | General Journal | 12/28/22 | 5310 | Gusto | 36.42 | ACH | Regular Payroll Dec 17 – Dec 23 | ||
| SPL | 1218 | General Journal | 12/28/22 | 5310 | Gusto | 8.52 | ACH | Regular Payroll Dec 17 – Dec 23 | ||
| SPL | 1218 | General Journal | 12/28/22 | 2110 | ACC | -669.51 | ACH | Gusto: Regular Payroll Dec 17 – Dec 23 | ||
| ENDTRANS |