TXT import problem

RatliffCPA · ‎December 04, 2023

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

BigRedConsulting · ‎December 04, 2023

The issue is that you're not terminating the transactions properly.

Change ENDTRANS to ENDTRNS and then it should work.

View solution in original post

BigRedConsulting · ‎December 04, 2023

The issue is that you're not terminating the transactions properly.

Change ENDTRANS to ENDTRNS and then it should work.

RatliffCPA · ‎December 04, 2023

That fixed it. Thank you so much!!

Topics

Training

Community

Resources

TXT import problem