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. !TRNSTRNSIDTRNSTYPEDATEACCNTNAMECLASSAMOUNTDOCNUMMEMOCLEAR!SPLSPLIDTRNSTYPEDATEACCNTNAMECLASSAMOUNTDOCNUMMEMOCLEAR!ENDTRNS TRANS1Check01/29/131098George -449.36BP SPL1Check01/29/137350George 22.39BPGrainger Stretch WrapSPL1Check01/29/135340George 29.97BPPat Mallet reimburse for fire extinguisher rechargingSPL1Check01/29/137500George 397.00BPReliant EnergyENDTRANS TRANS1218General Journal12/28/225310Gusto 587.50ACHRegular Payroll Dec 17 – Dec 23SPL1218General Journal12/28/225310Gusto 37.07ACHRegular Payroll Dec 17 – Dec 23SPL1218General Journal12/28/225310Gusto 36.42ACHRegular Payroll Dec 17 – Dec 23SPL1218General Journal12/28/225310Gusto 8.52ACHRegular Payroll Dec 17 – Dec 23SPL1218General Journal12/28/222110ACC -669.51ACHGusto: Regular Payroll Dec 17 – Dec 23ENDTRANS

Solved

TXT import problem

2 replies
0 views

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