Occasional Contributor
Posts: 3
Registered: ‎11-11-2021

Procedure To Edit, Export & Import IIF In QuickBooks Desktop

The steps to edit, export, and IIF File Import Quickbooks Desktop are as follows:

What is the Intuit Interchange Format and How Do I Export It File?

  • To begin, log in to your company file using all administrative credentials.
  • After that, go to the File menu and select Switch to Single-user Mode.
  • Go back to the File menu and select Utilities, then Export. Now select Export IIF Files from the drop-down menu.
  • From the Save in the drop-down menu, select the location where you wish to save the IIF, such as Windows desktop, downloads folder, or any other folder.
  • In the File name field, type a name and then click Save.
  • Click the OK button.

Import IIFs Files

  • You must first log in to the company file in order to import the IIFS file.
  • Make sure you're running it in single-user mode instead than multi-user mode.
  • Then, from the 'File' menu, select the 'Utilities' option.
  • Select 'Import' from the drop-down menu, then Import IIF.
  • Click Open after selecting the file.
  • And then click the 'OK' button to confirm the import procedure.

In QuickBooks, how can I edit an IIF file?

  • To edit an IIF file, follow these instructions.
  • To open Microsoft Excel, go to the File menu in the upper left corner and select Open.
  • You must navigate to the location where you saved your IIF file.
  • Under the File type drop-down, select 'All Files.'
  • After that, click on the IIF and then on Open.
  • Now, under the Text Import Wizard, click Next, then Next again, and finally Finish.
  • If it asks for permission to make modifications to your IIF file, say yes. Yes should be selected.
  • Click Save once more in the File menu.
  • Select Yes.
  • Exit the Excel programme. You will now get a popup on your screen to save the IIF again. Don't Save must be selected here.

You can download and install the.IIF Import Kit to save time and improve your results. If you have any questions or concerns, you may either download a sample to practise with IIF files or utilise the templates to import transactions into QuickBooks.