Skip to main content
November 22, 2019
Question

How do I import a .iif file into QB online?

  • November 22, 2019
  • 2 replies
  • 0 views
Can I import an .iif file into QBO?

2 replies

November 22, 2019

Hi @eaglecj,

 

The ability to import an IIF file is exclusive to QuickBooks Desktop. If you wish to import your files to QuickBooks Online (QBO), you can do so via a CSV file.

 

Say, you want to import your products and services. Follow these steps:

  1. From the Gear icon, select Import Data.
    • Note: The next page will show you a list of everything you can import in QBO, which are Bank dataCustomersVendorsChart of Accounts, and Products and Services.
  2. Tap on the Products and Services button.
  3. Hit the Browse button to look for the file you want to upload.
    • Note: You can click on the Download a sample file link to see the correct format of a file you can upload.
  4. Search for your file. Select Open, then Next.
  5. Map your fields, then select Next.
  6. Tick the Overwrite all values for each product or service with the same name.
  7. Hit Import.

Learn more about this topic by viewing this article: Import products and services from Excel.

 

Here's a list of articles of other things you can import in QBO:

Let me know if you have other questions by leaving a comment below. I'll get back to you.

June 15, 2020

So what this tells me is that any company with any kind of history cannot make the change to Quickbooks Online if they have any kind of desire to retain their accounting history since QBO does not support the import of transaction import...even as csv file format.

 

Sounds like we need to find an alternative accounting system as this will not work.

Fiat Lux - ASIA
June 16, 2020

@Apt7855 

Utilize the migration tool

https:// transactionpro.grsm.io/qbo

 

October 27, 2023

YOU CAN'T enough said!