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.
