cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Level 2

IIF Format error : Transaction not supported

This is the IIF file that we are trying to import.

 

!TRNS TRNSTYPE DATE ACCNT NAME AMOUNT MEMO
!SPL TRNSTYPE DATE ACCNT NAME AMOUNT MEMO
!ENDTRNS
TRNS BILLCCARD 6/9/2018 TD Credit Card Account - CV SAMSCLUB #8155 -121.67
SPL BILLCCARD 6/9/2018 Accounts Payable SAMSCLUB #8155 121.67
ENDTRNS

 

TD Credit Card Account - CV is setup as a Credit Card in the Chart of Accounts.

 

The error we are getting is as below

*** YOUR IIF FILE COULDN'T BE IMPORTED ***
[ERROR] It's a list or transaction that is not supported by the IIF import process.
 

We compared this to the credit_card_bill.iif template and its total match. Not sure what we are missing!!

4 Comments
Highlighted
Anonymous
Not applicable

IIF Format error : Transaction not supported

The kit is wrong and has been for over a decade.

Once upon a time QB supported this transaction type, but then it mysteriously stopped working.

 

The best type to use now for a bill payment by credit card is "CREDIT CARD".

 

Also, for QB 2019 see BRC - QuickBooks 2019 IIF Import Changes and Recommendations 

 

Highlighted
Level 15

IIF Format error : Transaction not supported

Remember that the CC already is a Liability Type. Mixing that with AP is a typical accounting error; you just hid one liability in different liability.

 

You make the credit card charge entries Individually, because each date you bought something with that card, you already Paid for it. There is no Bill. You took a micro-loan from the card provider, so the individual spending to all those names will show the debt balance on the credit card Type of account increasing.

 

Then, you got a Statement, not a Bill. You use it to reconcile the card account. At the end of the reconciliation, do not let QB enter a bill for you. That is not Helpful; it's Wrong. You either make the check entry now, or later, that reflects the Payment amount and date against the CC account as the "expense" entry detail.

Highlighted
Anonymous
Not applicable

IIF Format error : Transaction not supported

RE: Remember that the CC already is a Liability Type. Mixing that with AP is a typical accounting error; you just hid one liability in different liability.

 

The OP appears to be paying an AP bill with a credit card.  That seems a correct thing to do.  Anyway, is a thing supported by QB.

Highlighted
Level 15

IIF Format error : Transaction not supported

"The OP appears to be paying an AP bill with a credit card.  That seems a correct thing to do"

 

Let me try this again.

 

If you Bought on a credit card, there is no also a Bill. If you enter a bill and later find out that supplier allows you to give them a credit card number, which you do later, then of course you have a Bill Payment as Credit Card Charge. Sam's Club doesn't not allow you unpaid purchases; Sam's Club does not provide inhouse Charge accounts. When you shop at Sam's Club, you pay at Sam's Club. You pay with Check, Cash or a credit card at the time of the purchase. Sam's Club is not a AP activity where you Pay Later.

 

That tells me something is being used incorrectly.

Need to get in touch?

Contact us