.iif import error 15153

nr23 · ‎February 08, 2023

Hi -- I am trying to import a journal entry but I keep getting an error message :
; [ERROR] Expected transaction data or line item header. [15151]

; [ERROR] Expected 'ENDTRNS'. All transactions must end with ENDTRNS. [15153]

This is a sample of the JE I'm trying to import. Can I not import JEs with multiple TRNS lines? Thanks.

!TRNS	TRNSID	TRNSTYPE	DATE	ACCNT	CLASS	AMOUNT	DOCNUM	MEMO
!SPL	SPLID	TRNSTYPE	DATE	ACCNT	CLASS	AMOUNT	DOCNUM	MEMO
!ENDTRNS
TRNS		GENERAL JOURNAL	########	69990	Operations:Climate3	16908.43		Dec PR1
TRNS		GENERAL JOURNAL	########	69990	Operations:Lands3	7447.844		Dec PR1
TRNS		GENERAL JOURNAL	########	69990	Operations:Water3	5187.322		Dec PR1
TRNS		GENERAL JOURNAL	########	69990	Operations:Other3	1205.544		Dec PR1
TRNS		GENERAL JOURNAL	########	69990	Operations:Admin3	3831.191		Dec PR1
TRNS		GENERAL JOURNAL	########	69990	Operations:Ind Pol3	1219.517		Dec PR1
SPL		GENERAL JOURNAL	########	69999	Operations:Admin3	35799.85		Dec PR1
ENDTRNS

BigRedConsulting · ‎February 08, 2023

RE: Can I not import JEs with multiple TRNS lines?

You can't import any transactions with multiple TRNS lines.

In an IIF file, each transaction has one TRNS line, followed by one or more SPL lines, and one ENDTRNS line.

The minimum transactions will be:

TRNS

SPL

ENDTRNS

Yours will be something more like:

TRNS

SPL

ENDTRNS

Also, each transaction must balance, meaning the sum of the amounts must be zero (debits = credits). In your example, all the rows are positive (debits).

View solution in original post

BigRedConsulting · ‎February 08, 2023

RE: Can I not import JEs with multiple TRNS lines?

You can't import any transactions with multiple TRNS lines.

In an IIF file, each transaction has one TRNS line, followed by one or more SPL lines, and one ENDTRNS line.

The minimum transactions will be:

TRNS

SPL

ENDTRNS

Yours will be something more like:

TRNS

SPL

ENDTRNS

Also, each transaction must balance, meaning the sum of the amounts must be zero (debits = credits). In your example, all the rows are positive (debits).

nr23 · ‎February 08, 2023

Ahhh. so i got it backwards -- i can have one TRNS line but multiple SPL lines (because I definitely am importing transaction with multiple SPL lines). And i just forgot to make the last number negative but it was negative in my attempted import. Thanks!

Topics

Training

Community

Resources

.iif import error 15153