IIF Import Checks to Bank Rec

Justin K · ‎March 17, 2020

Upon upgrading to QB 2020, our IIF files that we use to import checks into Bank Rec are throwing errors. I've been able to eliminate the errors, and while I can get the checks to import into Bank Rec using a modified file, the check number is not making it into the bank rec entry. (shows as blank and wants to be 'printed'). Below is an example transactions from the file I'm testing with. Any help getting the check number to show up in QB would be greatly appreciated!

Ashley H · ‎March 17, 2020

Thanks for reaching out to the Community, @Justin K.

At this time, there's not a way to import Check Numbers into QuickBooks Desktop Enterprise. I'm going to submit feedback to our Product Development Team about bringing in a feature that will allow this to happen.

In the meantime, here's a Community Article that provides more information about Exporting, Importing, and how to edit IIF Files for QuickBooks Desktop.

Let me know if you have additional questions or concerns. I'm always here. Have a beautiful day.

BigRedConsulting · ‎March 17, 2020

Yes, you can continue to import check numbers on checks. The key is to avoid the new buggy import interface and opt for the older one that works.

See these recommendations for steps: BRC QuickBooks 2019 & 2020 IIF Import Changes and Recommendations

BigRedConsulting · ‎March 17, 2020

@Ashley H

RE: At this time, there's not a way to import Check Numbers into QuickBooks Desktop Enterprise.

Of course there is, and always has been a way to do this.

Justin K · ‎March 18, 2020

After doing some searching, the below seemed to work in my initial testing:

IIF Import Checks to Bank Rec

Banking

Banking

Banking

Banking