Skip to main content
N
nr23
February 8, 2023
Solved

.iif import error 15153

  • February 8, 2023
  • 1 reply
  • 0 views

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.

 

!TRNSTRNSIDTRNSTYPEDATEACCNTCLASSAMOUNTDOCNUMMEMO
!SPLSPLIDTRNSTYPEDATEACCNTCLASSAMOUNTDOCNUMMEMO
!ENDTRNS       
TRNS GENERAL JOURNAL########69990Operations:Climate316908.43 Dec PR1
TRNS GENERAL JOURNAL########69990Operations:Lands37447.844 Dec PR1
TRNS GENERAL JOURNAL########69990Operations:Water35187.322 Dec PR1
TRNS GENERAL JOURNAL########69990Operations:Other31205.544 Dec PR1
TRNS GENERAL JOURNAL########69990Operations:Admin33831.191 Dec PR1
TRNS GENERAL JOURNAL########69990Operations:Ind Pol31219.517 Dec PR1
SPL GENERAL JOURNAL########69999Operations:Admin335799.85 Dec PR1
ENDTRNS        
Best answer by BigRedConsulting

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

SPL

SPL

SPL

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).

 

1 reply

BigRedConsulting
BigRedConsultingAnswer
February 8, 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

SPL

SPL

SPL

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).

 

N
nr23Author
February 8, 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!

Terms & ConditionsAccessibility statement