Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Connect with and learn from others in the QuickBooks Community.
Join nowHi,
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! Go to Solution.
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 N 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.
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!
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
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!
@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,
Utilize the trial period of TP Importer to migrate data from any file of *.mdb or *.accdb
https:// transactionpro.grsm.io/qbd
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
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.
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.
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 N 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.
Thanks a lot ! great help! . I will test it and let you know.
That worked. Thanks!
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.
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.
The additional TOPRINT column fixed the issue for me. The imports are now including check number.
Thank you for posting your knowledge!
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
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.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.