IIF Import problem

veguy · ‎November 30, 2023

Hi!

I created a sample IIF file below to import my daily sales. Everything works great except that the name, "Square Inc." does not show up on import on the Deposit line (for the 513.73 amount). So I have to manually enter that vendor name in the register for the imported transaction. I checked and the vendor name in the IIF file matches with the name in my QB Desktop. Does anybody know why and can you please help me to solve this problem? Many Thanks.

!TRNS TRNSTYPE DATE ACCNT NAME AMOUNT MEMO

!SPL TRNSTYPE DATE ACCNT NAME AMOUNT MEMO

!ENDTRNS

TRNS DEPOSIT 10/1/2023 Chase Total Business Checking Square Inc. 513.73 10/01 sales

SPL DEPOSIT 10/1/2023 Merchant Account Fees 30.78

SPL DEPOSIT 10/1/2023 DD Accounts Receivable DoorDash.com 282.46 10/01 sales

SPL DEPOSIT 10/1/2023 Cash Account 27.56 10/01 sales

SPL DEPOSIT 10/1/2023 Tips Received -25.98

SPL DEPOSIT 10/1/2023 Sales Tax Payable Square Inc. -67.77

SPL DEPOSIT 10/1/2023 Food Sales -760.78 10/01 sales

ENDTRNS

veguy · ‎November 30, 2023

Never mind. Thank you. After posting this question, I found out the solution. The solution is to NOT click on the Import IIF button but to use the option below it. Apparently, the latter option uses a different import code. So the NAME field is NOT ignored. Thank you all.

View solution in original post

veguy · ‎November 30, 2023

Never mind. Thank you. After posting this question, I found out the solution. The solution is to NOT click on the Import IIF button but to use the option below it. Apparently, the latter option uses a different import code. So the NAME field is NOT ignored. Thank you all.

FritzF · ‎December 05, 2023

Hi, veguy.

Thank you for sharing the steps you've done to resolve this here in the Community. This will surely help other users as well in the future.

Stay safe and have a good one.

leodee1 · ‎May 06, 2024

@FritzF - why would the name not be imported on deposits when using the "recommended" approach of clicking the Import IIF button?

CharleneMaeF · ‎May 06, 2024

Hi, leodee1.

I'll shed some light on the missing name from the IIF file and then lay down the details on how we can take care of it.

When adding your deposits in QuickBooks Desktop using the Import IIF Tool, I recommend ensuring the right format is followed. This way, your transactions will be imported successfully. Using an incorrect one can cause missing names or other info in your file.

Aside from that, make sure the spelling and placement of the headers are correct. It'll tell the program how to import the type of data. It begins with !TRNS, !SPL, and !ENDTRNS.

For more guidance to import your IIF data, you can follow these steps:

From the QuickBooks Help menu, choose QuickBooks Help.
Select the Search tab
Type IIF file format, and select the Start Search arrow.
Select Reference guide to import files.

You can also browse this article to learn more about how to use the template: IIF Overview: import kit, sample files, and headers.

Once you're all set, you can start importing your lists and transactions to QuickBooks Desktop.

Finally, you can browse and bookmark to guide you on what to do with your imported data: Tasks you can do with IIF files.

I'm always here to help again if you have more questions about managing and importing your data. Would you like to learn more about other processes in QuickBooks? I'm with you every step of the way.

Topics

Training

Community

Resources

IIF Import problem