cancel
Showing results for 
Search instead for 
Did you mean: 
Announcements
Everything you need to know about banking in QuickBooks Online - Discover more
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
MJoy_D
Moderator

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

11 REPLIES 11
MJoy_D
Moderator

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!

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.  

ChrisMDC
Level 2

IIF Import - The Credit Card Credit Transaction Type

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

Get r done
Level 2

IIF Import - The Credit Card Credit Transaction Type

Thanks for the thread all, 

 

I'm trying to import Credit Card transactions into QuickBooks Desktop Premier Plus 2022 Nonprofit.

 

Is there a header that allows me to enter a Customer:Job (NAME) and a Vendor in the same row of the entry and preferably adds new vendors where needed?  I tried using two rows for each credit card charge, row one with Customer:Job under the NAME header and row two with the vendor under the NAME heading but the vendor names are all erroring out as shown below.

 

; [ERROR] [Chili's Grill & Bar] There is already another entity in Quickbooks by this Name [10143]

;[Chili's Grill & Bar] Invalid Customer Name on the distribution line [11114]

 

Best,

Jim

Jovychris_A
Moderator

IIF Import - The Credit Card Credit Transaction Type

Let me help you correct the IIF file and share more information about importing this, @Get r done.

 

Yes, there is a way to add the Customer: Job and vendor on the same row, but you'll want to review your IIF file in Excel to make edits and remove the special characters like & and +. This way, it will import the file seamlessly.

 

You can also check some sample IIF files from this article: IIF Overview: import kit, sample files, and headers.

 

Additionally, you'll want to export IIF files later to edit or change them and see more details about import/export limitations, feel free to check this guide: Export, import, and edit IIF files.

 

We're always here in the Community 24/7 if you need more assistance. Anytime we'll be right here to help. Stay safe and well.

Get r done
Level 2

IIF Import - The Credit Card Credit Transaction Type

Thank you Jovychris A  !!

 

This worked in QBDT 2022 Premier Plus Non Profit.  Create an Excel file that pulls the info from your credit card transactions into the correct format, paste into an IIF file and import.

!TRNSTRNSIDTRNSTYPEDATEACCNTNAMECLASSAMOUNTDOCNUMMEMO
!SPLSPLIDTRNSTYPEDATEACCNTNAMECLASSAMOUNTDOCNUMMEMO
!ENDTRNS         
TRNSPTCREDIT CARD6/7/2023CC AccountVendorSupport-1648.28CC Jun 23Yada yada
SPLPTCREDIT CARD6/7/2023GL AccountCustomer:JobSupport1648.28CC Jun 23Yada yada
ENDTRNS         
TRNSPTCREDIT CARD6/13/2023CC AccountVendorSupport-311.76CC Jun 23Yada yada
SPLPTCREDIT CARD6/13/2023GL AccountCustomer:JobSupport311.76CC Jun 23Yada yada
ENDTRNS         
TRNSPTCREDIT CARD6/21/2023CC AccountVendorFamily Support-113.63CC Jun 23Yada yada
SPLPTCREDIT CARD6/21/2023GL AccountCustomer:JobFamily Support113.63CC Jun 23Yada yada
ENDTRNS         
TRNSPTCREDIT CARD6/2/2023CC AccountVendorNonresidential-119.06CC Jun 23Yada yada
SPLPTCREDIT CARD6/2/2023GL AccountCustomer:JobNonresidential119.06CC Jun 23Yada yada
ENDTRNS         
TRNSPTCREDIT CARD6/4/2023CC AccountVendorNonresidential-39.66CC Jun 23Yada yada
SPLPTCREDIT CARD6/4/2023GL AccountCustomer:JobNonresidential39.66CC Jun 23Yada yada
ENDTRNS         

 

 

Chris-MDC
Level 1

IIF Import - The Credit Card Credit Transaction Type

Thank you!  This is exactly what I was looking for.  

JoesemM
Moderator

IIF Import - The Credit Card Credit Transaction Type

On behalf of my colleague,  @Get r done, Chris-MDC. You're most welcome.

 

I’m glad to know that the information provided by my colleague above has helped you to figure this out. Thank you for making business with us in QuickBooks.

 

If you have any other concerns in QuickBooks count me in. I'll surely get back to you. Take care.

Get r done
Level 2

IIF Import - The Credit Card Credit Transaction Type

Hello again, for the credit card transaction IIF import, is there a setting in QBDT 2022 Premier Plus that allows new vendors to be posted with out first setting them up in QBDT? Thank You.

JamaicaA
QuickBooks Team

IIF Import - The Credit Card Credit Transaction Type

Nice to see you here again, @Get r done.

 

Importing credit card transactions through IIF is challenging. Worry no more, I'm here to handle your question about posting new vendors without setting them up in QBDT.

 

Currently, there's no way to allow vendor posting related to your credit card transactions into the program. The system cannot recognize them without their profile. Therefore, we recommend setting vendors first to track entries easily.

 

Please back up your company file before importing IIF files. You can use this to restore data if you run into problems. To learn more about it, refer to this article: Export, import, and edit IIF files.

 

You'll want to check out this guide for the sample formats: IIF Overview: import kit, sample files, and headers.

 

If you have any other questions, please let me know in the comments below. I'll be here to lend a hand.

Need to get in touch?

Contact us