Solved

IIF Transaction Type

6 replies
0 views

Am trying to import credit card transactions via iif and the transaction type seems to be bad. According to the IIF import kit it is BILLCCARD, but gives an error that it's an invalid value for field TRNSTYPE.

I have seen where others do this, but can't find the correct transaction type. Have tried CCARD as well.

Can anyone tell me what the correct transaction type is for importing credit card transactions? Thanks!

QuickBooks Desktop

BigRedConsultingAnswer

The transaction type for a credit card charge is "CREDIT CARD". The type for a credit card credit is "CCARD REFUND".

You might want to use our BRC IIF Transaction Creator to help you figure out the IIF file layout in this and other ways. You can use it in trial mode - no charge - to create example IIF files for review. You might even like it so much you'll decide to use it!

BigRedConsultingAnswer

The transaction type for a credit card charge is "CREDIT CARD". The type for a credit card credit is "CCARD REFUND".

You might want to use our BRC IIF Transaction Creator to help you figure out the IIF file layout in this and other ways. You can use it in trial mode - no charge - to create example IIF files for review. You might even like it so much you'll decide to use it!

S

sbarberAuthor

Beautiful! Will do that. Thank you so much!!

M

michael-su

Does anyone know why this transaction will not import via an .iif file? These are credit card transactions and I get an [ERROR] Invalid line [15114] message for each SPL line. The file is a tab delimited text file saved with an .iif extension.

TRNS CREDIT CARD 1/1/22 American Express RESTAURANT NAME 1 -57.88 1 N

SPL 1762 CREDIT CARD 1/1/22 Travel & Ent:Meals RESTAURANT NAME 1 57.88 N

ENDTRNS CREDIT CARD 1/1/22 American Express RESTAURANT NAME 1 -57.88 1 N

Sign up

Login with SSO

Login to the community

Login with SSO