cancel
Showing results for 
Search instead for 
Did you mean: 
CYS
Level 1

IIF Import

I am trying to import a customer list as an IIF file from our company's old QB file. Problem is, every time I try, I get this message: "We weren't able to import right now. Try again later."Screenshot 2021-01-07 172313.jpg

It doesn't matter how long I wait, it still won't work!

 

If anyone has any insight on this matter, please share. Thanks.

5 Comments
IamjuViel
QuickBooks Team

IIF Import

I'm here to help you get rid of this error, @CYS.

 

Let's perform some troubleshooting steps to ensure that this error is not caused by possible data damage.   

 

The verify and rebuild tool is a built-in tool that auto-detect and self-resolves any minor company file data issues. By running this, it'll return to its default order and automatically fixes minor company file data issues. Here's how:

  1. Go to the File menu.
  2. Choose Utilities.
  3. Select Verify Data.
    • If QuickBooks doesn't find any problems, select OK. You can keep using your company file. You don't have any data damage. 

However, if it detects an error, the tool will help you repair your file. You can select Rebuild Now.undefined

 

You can repeat the same process two or three more times. Once completed, restart your device to ensure that all components are updated. Once completed, you can re-import your IIF files again. Here's how:

  1. Create a backup of your company file.  
  2. Go to the File menu and select Utilities.
  3. Click Import.
  4. Choose Import IIF Files.
  5. Browse to your IIF file and select it to Open.
  6. Select OK to confirm your data was imported.

However,  if the issue persists, you'd want to repair QuickBooks. You can read through this article for more detailed instructions in resolving data damage on your QuickBooks Desktop company file: Repair your QuickBooks Desktop for Windows.

 

Let me know how everything goes by leaving a comment below or if there's anything else I can help you with. I'm always around to help you out.  

CYS
Level 1

IIF Import

Thanks for your reply. I followed all the steps, yet, the issue has not been resolved.

Fiat Lux - ASIA
Level 15

IIF Import

@CYS 

There are some unresolved issues in IIF feature since QBD 2019 released. Consider to utilize one of these 3rd party migration tools.

https://transactionpro.grsm.io/qbd

https://partners.saasant.com/affiliate/idevaffiliate.php?id=5051_2

 

Candice C
QuickBooks Team

IIF Import

Hey there, @CYS

 

Thanks for reaching back out to the Community. I can provide you with some information about importing your customer's list. 

 

Since you've tried the steps my colleague provided above, I recommend contacting our Customer Support Team. They'll be able to use a screen share to help walk you through some additional instructions. 

 

Here's how: 

 

  1. Go to the Help menu. 
  2. Pick the QuickBooks Desktop Help option. 
  3. Click the Contact Us hyperlink. 
  4. Give a brief description of the issue and hit Let's Talk
  5. Scroll down and choose to Get a callback

 

Here's a guide that can become helpful in the future for your business: IIF Overview: import kit, sample files, and headers

 

Let me know how it goes. If you have any other questions, feel free to ask. I'm always here to lend a helping hand. Have a wonderful day! 

JohnWerth
Level 1

IIF Import

Issue is most likely NOT rebuilding your database!!!!!!

1) Open problem child iif file in Excel.  It is TAB delimited 

2) My issue had LARGE Invoice import from Printer's Plan Estimating - Work Order - Invoice solution, so I cut file in half, in half... 10x to get it down to one entry that causes the error.  This is where I am currently stuck.  Every which way I analyze it, I cannot figure out what is wrong as I search through successful invoice imports with the item, sales rep, taxable, terms, ... and find success so logically not that.

 

FYI:  To cut in iif in half, in Excel to File New, and in new "half", copy first three rows on date (at least in Invoice iif import - all 3 rows in Column A start with !).  The cadence of entry (for invoices) is first line, column A = TRANS, then each line (item) Column A = SPL including Sales Tax or Exempt, then ends with Empty row with Column A = ENDTRNS.  Repeats.  Last row of import =  Empty row with Column A = ENDTRNS.   Once done, save file as Tab Delimited.  Then you need to turn on Windows Explorer to show file extensions so your can rename file from .txt (Excel's Tab Delimited default) to .iif.

 

I understand Intuit end user support for.iif is too difficult, but the documents and example files are WEAK -- with a little effort they could be far more robust, e.g., journal entry - why not show large journal entry example, why not include Name field (AP and AR require it!!!).

Sign in for the best experience
Ask questions, get answers, and join our large community of QuickBooks users.
Sign In / Sign Up

Need to get in touch?

Contact us