Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
Get 50% OFF QuickBooks for 3 months*
Buy nowLet me help you import the data file from IIF format into QuickBooks Online, Aimee.
Currently, the supported file formats that you can use to import information to QuickBooks Online are CSV, XLS/XLSX, and Google Sheets. We're unable to recommend a specific application that you can use if you're referring to a third-party application, However, if these files are from QuickBooks Desktop, make sure to back up your company file first before you import the files. Once done, here's how you can import them:
To give you more details on how you can import and export your lists and transactions to and from QuickBooks Desktop, I've provided this article for more details: Export, Import, And Edit IIF Files.
Additionally, learn how you can check out these articles to familiarize yourself with when working with QuickBooks Online. I've added this article for more information: Getting Started With QuickBooks Online.
Please let me know if you have any questions when importing IIF files. Remember, we're here to make sure we've addressed all your concerns. Have a great day!
The following steps allows an IIF file to be opened in Excel.
Save the IIF file locally
Open Microsoft Excel and in Excel, select FILE > OPEN
In the drop down for file type, change to ALL FILES (*.*)
Browse and select the IIF file
When the Text Import Wizard appears, select DELIMITED and NEXT
Select TAB as the DELIMITER
Select FINISH
Select FILE > SAVE AS and change the SAVE AS type to an Excel workbook
Use TP Importer to proceed
https://get.transactionpro.com/qbo
Hi aimee@bayourealt . If you are looking for an app that imports IIF files into QuickBooks Online then can I suggest you take a look at Axis Online that you can find in the QuickBooks Online apps marketplace. You do not have to reformat the IIF files as Axis reads them directly and converts the data format into a format that QuickBooks Online understands.
You have clicked a link to a site outside of the QuickBooks or ProFile Communities. By clicking "Continue", you will leave the community and be taken to that site instead.
For more information visit our Security Center or to report suspicious websites you can contact us here