cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Get your Payroll questions answered by a QuickBooks Product Manager here - https://intuit.me/31Nl3My
John Lambert
Level 1

IIF Import - The Credit Card Credit Transaction Type

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?

Solved
Best answer September 01, 2021

Accepted Solutions
MaryJoyD
QuickBooks Team

IIF Import - The Credit Card Credit Transaction Type

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 TRNSTYPEACCNT, 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!

View solution in original post

3 REPLIES 3
MaryJoyD
QuickBooks Team

IIF Import - The Credit Card Credit Transaction Type

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 TRNSTYPEACCNT, 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!

View solution in original post

Fiat Lux - ASIA
Level 15

IIF Import - The Credit Card Credit Transaction Type

@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

 

John Lambert
Level 1

IIF Import - The Credit Card Credit Transaction Type

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.  

Need to get in touch?

Contact us