cancel
Showing results for 
Search instead for 
Did you mean: 
RS-V
Level 2

IIF File import Issue - Check number not getting imported in Quick Book

Hi,

 

I have .IIF file generated by MSAccess application, which is getting imported in Quickbook Desktop 20 without any issue reported by Import utility however the check number is not getting imported in QB, I see "To Print" in check number field in Quickbook instead of check number written in iif file. Anyone knows what could be the issue?

 

Thanks,

RS

Solved
Best answer June 03, 2020

Best Answers
Rose-A
Moderator

IIF File import Issue - Check number not getting imported in Quick Book

Hi, RS-V.

 

I can share some information regarding importing check transactions via the IIF files in QuickBooks Desktop.

 

Import IIF files have a unique set of attributes compared to other import methods. You'll need to ensure that there's a letter on the "To Print" column before you import them in QuickBooks. See the sample screenshots below.

 

 

You should be able to import the checks including check numbers. You can visit our Community Help Articles for some "How do I" steps in QuickBooks Desktop.

 

Feel free to drop me a reply below if you need more help with the importing process in QuickBooks. I'd be more than willing to lend you a hand.

View solution in original post

15 Comments 15
CharleneMaeF
QuickBooks Team

IIF File import Issue - Check number not getting imported in Quick Book

Hello there, @RS-V.

 

There haven't been any updates made to the columns that could cause the program to not load the check numbers.

 

Our newly improved Intuit Interchange Format (IIF) file in QuickBooks 2020 can scan file errors and eliminate issues before importing. I suggest checking the mapping setup of the data to ensure the accuracy of the import.

 

For more detailed information, refer to these helpful articles:

 

Let me know if you have additional QuickBooks questions or concerns. I'm always here to help. Have a good day!

RS-V
Level 2

IIF File import Issue - Check number not getting imported in Quick Book

Thank you for your quick response.

Check numbers are not getting imported into QB when I click " Import Files" button on import screen.

When I select option"Import it for me. I will fix it later". option on import screen, I see check numbers are getting imported into QB.

Is there any setting, I am missing?

 

Thanks!

RS-V

 

Rejeil_O
QuickBooks Team

IIF File import Issue - Check number not getting imported in Quick Book

Thank you for getting in the thread @RS-V,

 

It might be that the check number will not automatically detected in QuickBooks Desktop. However, you can use the "Import it for me. I will fix it later" option to import the check number. Once done, check the transaction if it's completely imported to review if there's a missing transaction in your IIF file.

 

Also, you can read this article to learn more about the overview of the IIF files: IIF Overview: import kit, sample files, and headers.

 

We can also import a transaction in QuickBooks Desktop using the CSV file. In case you'll need help importing file using CSV file, refer to this link for the steps: Import/export CSV files in QuickBooks Desktop.


Fill me in if you need more help by leaving a comment below. I'll be around in the Community to help. Take care and have a great day!
 

Fiat Lux - ASIA
Level 15

IIF File import Issue - Check number not getting imported in Quick Book


@RS-V wrote:

I have .IIF file generated by MSAccess application, which is getting imported in Quickbook Desktop 20 without any issue reported by Import utility however the check number is not getting imported in QB,

@RS-V 

Utilize the trial period of TP Importer to migrate data from any file of *.mdb or *.accdb

https:// transactionpro.grsm.io/qbd

 

RS-V
Level 2

IIF File import Issue - Check number not getting imported in Quick Book

Thanks @Rejeil_O . You are correct, check numbers are getting imported when using" import it for me, I will fix later" option.  

Is there a way that the check number will get automatically detected in QuickBooks Desktop?

 

Thanks,

Ritu

MadelynC
Moderator

IIF File import Issue - Check number not getting imported in Quick Book

You’re most welcome, @RS-V.


In QuickBooks, there isn’t a way that a check number will automatically detect. It depends on your file format. 

 

Proper mapping also helps avoid any issues. Moving forward, you can follow my colleagues shared articles for additional information for exporting and importing process.


Also, you can visit our help articles to learn more about organizing your account efficiently.


If there's anything else you need help with QuickBooks, please let me know by leaving a comment below. Have a good one.

RS-V
Level 2

IIF File import Issue - Check number not getting imported in Quick Book

Thanks,

My question is, why check numbers are getting imported when using "Import it for me, I'll fix later"  however with  "import IIF"  button its not, "Import IIF" button is not giving any  error too.  I am using SAME File.

Rose-A
Moderator

IIF File import Issue - Check number not getting imported in Quick Book

Hi, RS-V.

 

I can share some information regarding importing check transactions via the IIF files in QuickBooks Desktop.

 

Import IIF files have a unique set of attributes compared to other import methods. You'll need to ensure that there's a letter on the "To Print" column before you import them in QuickBooks. See the sample screenshots below.

 

 

You should be able to import the checks including check numbers. You can visit our Community Help Articles for some "How do I" steps in QuickBooks Desktop.

 

Feel free to drop me a reply below if you need more help with the importing process in QuickBooks. I'd be more than willing to lend you a hand.

RS-V
Level 2

IIF File import Issue - Check number not getting imported in Quick Book

Thanks a lot ! great help! . I will test it and let you know.

 

RS-V
Level 2

IIF File import Issue - Check number not getting imported in Quick Book

That worked. Thanks!

dmjanzten
Level 1

IIF File import Issue - Check number not getting imported in Quick Book

Oddly enough, the "import for me" results in the message "data was imported correctly" but it's a fake out as nothing is imported.  So that method doesn't seem to be working for me, even though I'm using the exact same file I was using last week with QB2016.

 

When I import using the new method it doesn't include check numbers even though they are clearly shown in the import file.  We import approx. 500 checks each month end and I'm doing what I can to avoid making this a manual process. 

 

Who woulda thought "upgrading" from QB2016 to QB2020 could actually be a step backwards?

 

But I guess everything else named "2020" hasn't gone as expected.  I should've assumed something like this would happen.

MorganB
Content Leader

IIF File import Issue - Check number not getting imported in Quick Book

Hi there, dmjanzten.

 

Thanks for following up on this thread. I'd like to help point you in the right direction to get your imports sorted out in QuickBooks Desktop.

 

Since the import is not actually being completed as it should be, I recommend reaching out to the Desktop Support Team. Agents have advanced tools, like screen-sharing, to take a look at your account and determine what's causing the problem. Here's how to get in touch with the team:

 

1. Press the F1 key on your keyboard.

2. Select Contact Us.

3. Enter Support in the field and click Continue.

4. From here you can choose to set up a callback for a time that's convenient for you.

 

Feel free to reach back out if you have any other questions. I'll be here to help in any way that I can.

dmjanzten
Level 1

IIF File import Issue - Check number not getting imported in Quick Book

The additional TOPRINT column fixed the issue for me.  The imports are now including check number. 

 

Thank you for posting your knowledge!

BigRedConsulting
Community Champion

IIF File import Issue - Check number not getting imported in Quick Book

@RS-V 

RE: My question is, why check numbers are getting imported when using "Import it for me, I'll fix later" however with "import IIF" button its not, "Import IIF" button is not giving any error too. I am using SAME File.

 

Because the code behind the Import IIF button is a mess. Some would say a disaster.

 

See BRC QuickBooks 2019+ IIF Import Changes and Recommendations 

DataSort
Level 1

IIF File import Issue - Check number not getting imported in Quick Book

I was also having the problem.  For the check number to load you will need both the DocNum and the ToPrint columns.  The ToPrint column should have an N.

 

Below is an example of a single check loaded with a check number 175. Note that in the Trans Section there is a N after the number 175. 

Screenshot 2022-06-29 171229.jpg

Copy this text for an example
!TRNS TRNSID TRNSTYPE DATE ACCNT Name CLASS AMOUNT DOCNUM TOPRINT
!SPL SPLID TRNSTYPE DATE ACCNT Name CLASS AMOUNT DOCNUM
TRNS 1 Check 05/09/2022 Belize Bookkeepers Michaela Chub -320.29 175 N
SPL 2 Check 05/09/2022 Unknown HOA 320.29 175
ENDTRNS
!ENDTRNS

Need to get in touch?

Contact us