How to Export or Import IIF Files in QuickBooks
- Last Updated on: 30-Mar, 2018 |
- Posted by: QB
This article describes how to Export or Import .IIF files and what transactions can do it
Limitations described for Export & Import IIF Files In QuickBooks Accounting Software
- A user can easily import transactions, but not export any other transactions from their QB software app.
- A large number of entries as maximum through which QB software can do in process in a nice way.
- Imported IIF files do not create links between transactions.
- When a user will import an invoice or any bill along with its payment, thus, it will not link after importing. You must link them, and all other pairs, into the receive payments or Pay Bills window. Thus, if a user require to import then linked it with your transactions as located under the .IIF file.
- A user can easily now import assembly items but this will not able to import the database into the item’s custom fields.
- Thus, end user will unable to import or export payroll data from a QB desktop accounting files related to any other products. However, this can be used by exporting payroll data through Online Payroll & their Intuit Payroll Full Services.
- Therefore, a user can’t able to export from its U.S. version of a QB accounting software. It imports into your Canadian variant of a QuickBooks or as Vice Versa.
- This will not required to type numbers with leading zeros in MS Excel spreadsheet, when ready to create & IIF import files.
- For this importing or exporting IIF files, an Intuit will not responsible or not rendering any technical assistance to our QB clients. There are other resources which provide an instant help.
How to Export .IIF files in QuickBooks Applications?
Method to export the .IIF file
- First of all, sign in your company file as an Admin.
- Ensures that the user is in single user mode.
- In the main file menu, choose Utilities > Then export > give a list to IIF files.
- Check the box just next to each of the list that you export and click it as Ok button.
- Into the Export
- In the drop down menu, save in: and then select the location which you want to save your .IIF file on your desktop.
- Under the file applications of a name field, first of all, remove or delete as asterisk (*). After this type a name of a file.
- Choose IIF files (*.IIF) for a type of the file you used.
- Click on as save this option.
- Give a click on OK to the message through which the file you have saved as successfully.
✔ To view the Exported Files
- First go to the file location.
- Give a right click to the exported file & then choose it Open with.
- Select MS Office Excel sheet.
- If it allows to get the wizard and converted into a text file, then click to the Next > the Next > at last click to Finish option.
✔ Process for editing an Exported file
- First of all, open the .IIF file.
- Open MS office Excel.
- Under the main file menu, click to open it.
- Select the location from where the user has been saved the .IIF file.
- Under the file, type it as field, select all files.
- Now also select .IIF file then click it as to open.
- Click to Next > Next > finish into the text Import Wizard. The .IIF is opened into the MS Excel.
✔ Make an essential edits.
- From a file main menu, apply to save all changes you have been made.
- Click on the option yes as promptly which appears.
- Pres the Alt+F4 keys to close your Excel sheet.
- This will already save your .IIF file as again. Click on don’t save.
List from which you can Import .IIF files
|Chart of Accounts||Customer :Job||Vendor|
|Employee||Other Names List||Customer Type|
|Vendor Type||Class||Job Type|
|Item||Payment Terms||Payment Method|
|Shipping Method||Customer Message||Budgets|
|To Do Notes||Sales Rep||Price Level|
|Sales Tax Codes|
Other Transactions that can be import successfully.
|Account beginning Balances||Vendor Bills||Vendor Bill Refunds |
|Cash Sales to customers||Cash refunds to clients||Credit card refunds to customers|
|Checks||Credit Card transactions||Credit Memos to Customers|
|Deposits||Estimates||General Journal Entries|
|Invoices||Payments from Customer||Purchase Orders|
|Account Transfer of funds|
We support our clients and provide abrupt support along with methods for how to export or import files abruptly.
Method for how to Import the File
- First of all, sign into your company file that as admin.
- Then ensures that you are work as on a single user mode.
- From the main file menu, choose Utilities option > Import heading > then select .IIF File option.
- Go to the location of your .IIF file and highlight it in as bold letters.
- Click on the open option.
- A message appears to confirm your data that you want to imported it instantly.
- Click to the Ok button.
Hopefully, above information will help you to import and export IIF files in QuickBooks Desktop rapidly without any delays. If needed expert help, reach us at QuickBooks Technical Support Number 1-800-880-6389. Feel free to connect with us for any type of Integration Support for QuickBooks.
More Article to Read: