Skip to main content

SUMMER SAVINGS 90% OFF QuickBooks for 3 months* Ends 8/27

Buy now
Switch to QuickBooks and 70% off for 3 Months
March 17, 2020
Question

IIF Import Checks to Bank Rec

  • March 17, 2020
  • 4 replies
  • 24 views

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!

 

 

4 replies

Ashley H
Level 4
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
Level 15
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 KAuthor
March 18, 2020

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

 

BigRedConsulting
Level 15
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