Skip to main content
J
John Lambert
September 1, 2021
Solved

IIF Import - The Credit Card Credit Transaction Type

  • September 1, 2021
  • 3 replies
  • 0 views

We successfully import Credit Card Charges using IIF but we remain unable to import the Credit Card Credit Transactions.  The problem is with the Transaction Type.  The import module does not recognize any of the Transaction Type Codes we have tried.  We've searched thoroughly the Import Kit for examples but have had to resort to trying educated guesses.  For example, we have tried CCARD CREDIT which is the code in the filter list for transaction type in Reports.  We have also tried CREDIT CARD CREDIT which is the code that displays in a report within the Transaction Type column of a printed report.  We have tried other variations.  But no success.  What is the code we need to use in our IIF files for Credit Card Credit Transactions?

Best answer by MJoy_D

I can share some information about the code that you can use with your IIF files, @John Lambert. 

 

You can use the CCARD REFUND as the keyword or code for refunds you receive on credit card charges in your IIF files. Also, please take note that TRNSTYPE, ACCNT, and AMOUNT columns are required in the column headings for transactions. 

 

To know more about the codes or keywords that I'm referring to above and all the information needed to import your file successfully, check out this article: IIF Overview: import kit, sample files, and headers. Just click on the Download Kit button under the Download and install the .IIF import kit part.

 

Then, refer to the following article for detailed guidance on how to edit the IIF file: Export, import, and edit IIF files. Also, make sure to create a backup company file before importing the file. This is to make sure that you can still restore your data in case you run into problems or errors: Back up your QuickBooks Desktop company file. 

 

Keep me posted if you still need further assistance with your file. Just let me know by leaving a Reply below. Keep safe and have a great rest of the day!

3 replies

MJoy_D
MJoy_DAnswer
September 1, 2021

I can share some information about the code that you can use with your IIF files, @John Lambert. 

 

You can use the CCARD REFUND as the keyword or code for refunds you receive on credit card charges in your IIF files. Also, please take note that TRNSTYPE, ACCNT, and AMOUNT columns are required in the column headings for transactions. 

 

To know more about the codes or keywords that I'm referring to above and all the information needed to import your file successfully, check out this article: IIF Overview: import kit, sample files, and headers. Just click on the Download Kit button under the Download and install the .IIF import kit part.

 

Then, refer to the following article for detailed guidance on how to edit the IIF file: Export, import, and edit IIF files. Also, make sure to create a backup company file before importing the file. This is to make sure that you can still restore your data in case you run into problems or errors: Back up your QuickBooks Desktop company file. 

 

Keep me posted if you still need further assistance with your file. Just let me know by leaving a Reply below. Keep safe and have a great rest of the day!

    J
    John LambertAuthor
    September 11, 2021

    A+ Mary JoyD.  Thank you.  This solved the problem.  Would just mention this transaction type is not in the import kit so maybe it needs to be updated to include it.  

    Fiat Lux - ASIA
    Fiat Lux - ASIA
    September 2, 2021

    @John Lambert 

    Another option, prepare your CC Credit data with the following template

    Credit Card AccountPayeeTransaction DateRefNumberMemoAddress Line1Address Line2Address Line3Address Line4Address CityAddress StateAddress PostalCodeAddress CountryVendor Acct NoExpenses AccountExpenses AmountExpenses MemoExpenses ClassExpenses CustomerExpenses BillableItems ItemItems QtyItems DescriptionItems CostItems ClassItems CustomerItems BillableCurrencyExchange Rate
    QuickBooks Credit CardBarnes and Noble01/09/20201 1 Main Street   AnytownNY12345USA Misc Supplies50             
    QuickBooks Credit CardMcDonald's03/09/20202 1 Jones Street   AnytownNY12345USA Meals12.5  ABC CompanyY         
    QuickBooks Credit CardJoe's Taxi05/09/20203 1 Felt Ave   AnytownNY12345USA       Item A1Item A20     

     

    then utilize one of these importer tools

    https://transactionpro.grsm.io/qbd

    https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

     

    C
    ChrisMDC
    March 25, 2023

    John,

    I'm struggling to import credit card transactions.  Can you share the header format you use and the transaction type for both the credit card charge and the corresponding cost or expense?

     

    Regards

    Terms & ConditionsAccessibility statement