IIF Import - The Credit Card Credit Transaction Type

John Lambert · ‎September 01, 2021

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?

MJoy_D · ‎September 01, 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!

View solution in original post

MJoy_D · ‎September 01, 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!

Fiat Lux - ASIA · ‎September 02, 2021

@John Lambert

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

Credit Card Account

Payee

Transaction Date

RefNumber

Memo

Address Line1

Address Line2

Address Line3

Address Line4

Address City

Address State

Address PostalCode

Address Country

Vendor Acct No

Expenses Account

Expenses Amount

Expenses Memo

Expenses Class

Expenses Customer

Expenses Billable

Items Item

Items Qty

Items Description

Items Cost

Items Class

Items Customer

Items Billable

Currency

Exchange Rate

QuickBooks Credit Card

Barnes and Noble

01/09/2020

1

1 Main Street

Anytown

NY

12345

USA

Misc Supplies

50

QuickBooks Credit Card

McDonald's

03/09/2020

2

1 Jones Street

Anytown

NY

12345

USA

Meals

12.5

ABC Company

Y

QuickBooks Credit Card

Joe's Taxi

05/09/2020

3

1 Felt Ave

Anytown

NY

12345

USA

Item A

1

Item A

20

then utilize one of these importer tools

https://transactionpro.grsm.io/qbd

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

John Lambert · ‎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.

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

Get r done · ‎July 11, 2023

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 · ‎July 11, 2023

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 · ‎July 11, 2023

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.

!TRNS	TRNSID	TRNSTYPE	DATE	ACCNT	NAME	CLASS	AMOUNT	DOCNUM	MEMO
!SPL	SPLID	TRNSTYPE	DATE	ACCNT	NAME	CLASS	AMOUNT	DOCNUM	MEMO
!ENDTRNS
TRNS	PT	CREDIT CARD	6/7/2023	CC Account	Vendor	Support	-1648.28	CC Jun 23	Yada yada
SPL	PT	CREDIT CARD	6/7/2023	GL Account	Customer:Job	Support	1648.28	CC Jun 23	Yada yada
ENDTRNS
TRNS	PT	CREDIT CARD	6/13/2023	CC Account	Vendor	Support	-311.76	CC Jun 23	Yada yada
SPL	PT	CREDIT CARD	6/13/2023	GL Account	Customer:Job	Support	311.76	CC Jun 23	Yada yada
ENDTRNS
TRNS	PT	CREDIT CARD	6/21/2023	CC Account	Vendor	Family Support	-113.63	CC Jun 23	Yada yada
SPL	PT	CREDIT CARD	6/21/2023	GL Account	Customer:Job	Family Support	113.63	CC Jun 23	Yada yada
ENDTRNS
TRNS	PT	CREDIT CARD	6/2/2023	CC Account	Vendor	Nonresidential	-119.06	CC Jun 23	Yada yada
SPL	PT	CREDIT CARD	6/2/2023	GL Account	Customer:Job	Nonresidential	119.06	CC Jun 23	Yada yada
ENDTRNS
TRNS	PT	CREDIT CARD	6/4/2023	CC Account	Vendor	Nonresidential	-39.66	CC Jun 23	Yada yada
SPL	PT	CREDIT CARD	6/4/2023	GL Account	Customer:Job	Nonresidential	39.66	CC Jun 23	Yada yada
ENDTRNS

Chris-MDC · ‎July 11, 2023

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

JoesemM · ‎July 11, 2023

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 · ‎July 12, 2023

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 · ‎July 12, 2023

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.

Topics

Training

Community

Resources

IIF Import - The Credit Card Credit Transaction Type