Skip to main content

Get 50% OFF QuickBooks for 3 months*

Buy now
Switch to QuickBooks and 70% off for 3 Months
Talk to Sales: 877-683-3280
Hours
Mon - Fri, 5am - 6pm PST
Sat - Sun, 7am - 4pm PST
Product support & help
Need help signing in?
E
ErikD
December 18, 2018
Solved

Error importing IIF File

  • December 18, 2018
  • 1 reply
  • 5 views

Getting this error on the End Trans line. The IIF file has been used for years and now we're getting this error after upgrading to 2019.

[ERROR] Expected '!ENDTRANS'. [15152]

 

Here's a larger look at the file and errors.

!CUST    NAME    BADDR1    BADDR2    BADDR3    BADDR4    PHONE1    EMAIL    CONT1    CTYPE    TAXABLE    NOTEPAD    COMPANYNAME    NOTE
CUST    St George Test Gallery LLC (2776371)    635 Test. George Blvd    Saint George    UT    84770    [removed] [email address removed]                    St George Test Gallery LLC
CUST    St. George Test Gallery LLC (2776410)    1081 E. Test     Saint George    UT    84790    [removed] [email address removed]                    St. George Test Gallery LLC
!TRNS    TRNSTYPE    DATE    ACCNT    NAME    CLASS    AMOUNT    DOCNUM    MEMO    CLEAR    TOPRINT    NAMEISTAXABLE    PAID
; [ERROR] Expected '!ENDTRANS'. [15152]
TRNS    INVOICE    09/04/2018    Accounts Receivable    St. George Test Gallery LLC (2776410)    St. George Test Gallery    97.15    1-40001    Invoice 40001    N    N    Y
!SPL    TRNSTYPE    DATE    ACCNT    NAME    CLASS    AMOUNT    DOCNUM    MEMO    CLEAR    QNTY    PRICE    INVITEM    TAXABLE    EXTRA
SPL    INVOICE    09/04/2018    Labor    St. George Test Gallery LLC (2776410)    St. George Test Gallery    -89.95    1-40001    Labor    N    -1    89.95    Labor    N
SPL    INVOICE    09/04/2018    Shop Supplies Sales    St. George Test Gallery LLC (2776410)    St. George Test Gallery    -7.20    1-40001    Shop Supplies Sales    N    -1    7.20    Shop Supplies Sales    N
SPL    INVOICE    09/04/2018    Sales Tax Payable    Sales Tax Vendor    St. George Test Gallery    0.00    1-40001    Sales Tax Payable    N            Sales Tax Payable    N    AUTOSTAX
ENDTRNS
!TRNS    TRNSTYPE    DATE    ACCNT    NAME    CLASS    AMOUNT    DOCNUM    MEMO    CLEAR    TOPRINT    NAMEISTAXABLE    PAID
; [ERROR] Expected '!ENDTRANS'. [15152]
TRNS    INVOICE    09/06/2018    Accounts Receivable    St. George Test Gallery LLC (2776410)    St. George Test Gallery    352.51    1-40002    Invoice 40002    N    N    Y
!SPL    TRNSTYPE    DATE    ACCNT    NAME    CLASS    AMOUNT    DOCNUM    MEMO    CLEAR    QNTY    PRICE    INVITEM    TAXABLE    EXTRA
SPL    INVOICE    09/06/2018    Labor    St. George Test Gallery LLC (2776410)    St. George Test Gallery    -299.90    1-40002    Labor    N    -1    299.90    Labor    N
SPL    INVOICE    09/06/2018    Parts Sales    St. George Test Gallery LLC (2776410)    St. George Test Gallery    -26.49    1-40002    Parts Sales    N    -1    26.49    Parts Sales    N
SPL    INVOICE    09/06/2018    Shop Supplies Sales    St. George Test Gallery LLC (2776410)    St. George Test Gallery    -26.12    1-40002    Shop Supplies Sales    N    -1    26.12    Shop Supplies Sales    N
SPL    INVOICE    09/06/2018    Sales Tax Payable    Sales Tax Vendor    St. George Test Gallery    0.00    1-40002    Sales Tax Payable    N            Sales Tax Payable    N    AUTOSTAX
ENDTRNS
!TRNS    TRNSTYPE    DATE    ACCNT    NAME    CLASS    AMOUNT    DOCNUM    MEMO    CLEAR    TOPRINT    NAMEISTAXABLE    PAID
; [ERROR] Expected '!ENDTRANS'. [15152]

Best answer by

There are two issues here:

First, the error is incorrect:

"; [ERROR] Expected '!ENDTRANS'. [15152]"  should state:

"; [ERROR] Expected '!ENDTRNS'. [15152]"

 

Second, you're getting the error because you have not defined the ENDTRNS row. You need an ENDTRNS definition line that starts with !ENDTRNS just as you have !TRNS and !SPL defined.

 

Also, note that there is no need to repeatedly redefine the rows.  One set of

!TRNS ...

!SPL ...

!ENDTRNS

definition rows at the top of the file is all that is needed.

 

While this needs to be fixed (would never have worked with any QB version), save yourself a lot of pain by following our recommendations: BRC - QuickBooks 2019 IIF Import Changes and Recommendations 

1 reply

A
Anonymous
Answer
December 19, 2018

There are two issues here:

First, the error is incorrect:

"; [ERROR] Expected '!ENDTRANS'. [15152]"  should state:

"; [ERROR] Expected '!ENDTRNS'. [15152]"

 

Second, you're getting the error because you have not defined the ENDTRNS row. You need an ENDTRNS definition line that starts with !ENDTRNS just as you have !TRNS and !SPL defined.

 

Also, note that there is no need to repeatedly redefine the rows.  One set of

!TRNS ...

!SPL ...

!ENDTRNS

definition rows at the top of the file is all that is needed.

 

While this needs to be fixed (would never have worked with any QB version), save yourself a lot of pain by following our recommendations: BRC - QuickBooks 2019 IIF Import Changes and Recommendations 

    C
    chonres
    February 24, 2019

    Thanks for this post.  I discovered the hard way that the QB 2019 IIF import doesn't work with PayPal generated IIF files because PayPal doesn't include a TRNSTYPE field which QB thinks ought to be mandatory.  PayPal has NEVER included this field and their IIF files have always worked just fine with older versions of QB.  I'm glad to know the old import is still available.

    M
    MDivers
    March 15, 2019

    Upgraded 2 days ago - and nothing else has changed and now my imported POS iif files have errors. When I examine the results - I get the Sales transaction by account but no payment accounts such as visa, amex, etc.  Looks like QB is creating an error file and when I try to review the file I cannot open it with the QB Launcher that is suggested.

     

    Mind you - nothing, nothing changed on the POS system.

     

    Anyone help?

    Need QuickBooks guidance?
    Log in to access expert advice and community support instantly.
    Terms & ConditionsAccessibility statement