- Mark as New
- Bookmark
- Subscribe
- Permalink
- Report Inappropriate Content
Banking
Thanks for joining the Community today, @jimmy17.
Currently, there isn't a setting that will stop the check number to add when importing the iif files since it will depend on the data you imported. However, you can manually edit the check number when importing the iif file. Let me show you how.
- Open Microsoft Excel, go to File, and then select Open.
- Click the drop-down list for File type, then select All Files.
- Select the IIF file you want to edit and select Open.
- In the Text Import Wizard, select Next, and then Next and Finish.
- Make the changes to your IIF file.
- Go back to the File menu, select Save, and then click Yes.
- Exit Excel.
Then, you'll get a prompt to save the IIF again. Select Don't Save. After that, you can import your file once again.
For your reference, check out this article: IIF Overview: import kit, sample files, and headers. This will provide you sample charts of how the IIF looks like.
Also, here are some articles that you can read to learn more about the transactions that you can import and export using Intuit Interchange Format (IIF) files:
Additionally, feel free to read the topics from our QBDT help articles in case you need additional guides while working with QuickBooks in the future.
Let me know if there's anything else you need about QuickBooks. I'm still here to offer my assistance. Have a good one.