Skip to main content
S
sbarber
July 24, 2022
Solved

IIF Transaction Type

  • July 24, 2022
  • 1 reply
  • 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!

Best answer by BigRedConsulting

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!

 

 

1 reply

BigRedConsulting
BigRedConsultingAnswer
July 24, 2022

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
July 24, 2022

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

M
michael-su
March 10, 2023

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

 

Terms & ConditionsAccessibility statement