Skip to main content
J
jjgfromnj
August 20, 2023
Solved

Importing IIF - creates new accounts vs not creating new accounts

  • August 20, 2023
  • 1 reply
  • 0 views

I have 2 different installations of QBD 2019. In one, when importing an IIF, it creates any account that is named in the IIF that doesn't already exist. In the other, if the account doesn't exist the import fails. Where is the setting that controls this?

Best answer by BigRedConsulting

You may have different releases of QuickBooks 2019.  If you review the release in the title area of the F2 dialog window, are the releases different?

 

In any case, to avoid the error, import using the alternate (older reliable) method, which will create any missing account as you import. See BRC QuickBooks 2019+ IIF Import Changes and Recommendations 

1 reply

C
CharleneMaeF
August 20, 2023

Importing the correct data ensures your books are accurate, jjgfromnj.

 

When you import your IIF file in QuickBooks Desktop, there are no settings we can utilize to modify how you want to add your data. The program formats the file for you.

 

Once the transactions are added, they will be automatically posted to their designated account if it already exists. However, a new account will be created if the program doesn't recognize it.

 

In the meantime, I suggest reviewing your IIF file by opening it in Excel to check if the accounts and format are correct. If you find any incorrect details, make sure to update them. This way, we can ensure that QuickBooks will recognize the file. If everything is correct, I recommend checking with your third-party service provider to ensure the data are properly mapped.

 

For more details bout reviewing your IIF file, please see these resources:

 

 

 Additionally, I've added an article that'll help you make changes to the existing accounts or create new ones so you can better track how much money your company has and owes and how much money comes in and out: Add, Edit, or Delete Accounts in QuickBooks Desktop.

 

Please keep us posted if you need additional assistance adding and managing your file in the program. We're always here to ensure the process is seamless.

J
jjgfromnjAuthor
August 20, 2023

My question is, why on one installation of QB 2019 it creates new accounts, and on another installation of QB 2019 (both Windows), the import fails if the accounts don't already exist?

    BigRedConsulting
    BigRedConsultingAnswer
    August 20, 2023

    You may have different releases of QuickBooks 2019.  If you review the release in the title area of the F2 dialog window, are the releases different?

     

    In any case, to avoid the error, import using the alternate (older reliable) method, which will create any missing account as you import. See BRC QuickBooks 2019+ IIF Import Changes and Recommendations 

    Terms & ConditionsAccessibility statement