Are you able to import IIF and QBO files into QuickBooks online?

For *.qbo files, use the following reference

https://quickbooks.intuit.com/learn-support/en-us/help-article/bank-transactions/upload-transactions...

For *.iif files, you have to open the files in Excel and save as *.csv files. Then you will need to use a 3rd party converter or importer tool to proceed.

To import bank statements in csv format, use this importer tool

https://transactionpro.grsm.io/qbo

Otherwise, you have to convert *.csv files into *.qbo files, use a csv2qbo converter tool

https://www.moneythumb.com/?ref=110

Hi there, @gcarhic-h-c-h-co.

I'm here to shed some light on IIF importing in QuickBooks.

We're unable to import IIF into QuickBooks Online; this feature is only available in QuickBooks Desktop.

You can consider Fiat Lux - ASIA's suggestion above or visit the QuickBooks App Center for a third-party application that your company requires. Enter the app name or keyword in the search bar.

I'm always available to assist you if you have any additional concerns about running your business. Stay safe!

I am so disappointed in Quickbooks Online. There are so many features missing that existed in desktop. Forcing me to pay a 3rd party to do something that should be easy. It's disappointing that Intuit is charging me more money for less functionality and causing me to go pay a 3rd party to perform a simple function.

I'm not please with Intuit or Quickbooks online. My recommendation? Don't move online.

I would second kwilkie16 and require a floor vote if this was a board.  QB Online is completely lacking in its functionality and vision.  Was it made for a small business that only has 1 employee... the owner????  Seriously, what small business does not have to pay employees, and yet you take this ability away and charge me more?  I'd like an explanation about why this isn't included, and don't tell me it's coming or I should request the feature.  It should not have been a released version if you aren't capable to deliver a product that is worth purchasing.

I understand why you felt that way, cachance. And, I appreciate you reaching out to us regarding your payroll data.

Let me help you upload the IIF files to QuickBooks Online (QBO). Please know that users using the standalone payroll (Core, Premium, Elite payroll) can export payroll transactions directly to QBO. 

When migrating data from the Desktop payroll account, you'll get a prompt to sign in and select the company you want to export the details to. For more information about the process, please visit this link: Export your payroll data into QuickBooks.

As suggested in this thread, you can also use a third-party app. We can't suggest which one to use use to bring over data. However, you can visit our Intuit Apps section to search for applications that integrate with QuickBooks.

Here's how:

1. Sign in to your QuickBooks account.
2. On left navigation bar, click Apps.
3. Use the search field to find apps (enter a keyword like "IIF").

Also, I've attached an article you can use to learn more about the type of data you can import directly into QuickBooks: Common questions about importing data to QuickBooks Online.

Please don't hesitate to leave a comment below if you have additional questions about importing data or managing payroll. I'm always glad to answer them for you. Enjoy the rest of your weekend!

Agree here, I just got quickbooks online because I got an email saying QB desktop for Mac isn't being supported anymore. Paying $500 a year for something that is going to make my accounting and invoice/PO management impossible ( I use iif import every day! ) is going to be a nightmare. 

It is a shame how Intuit has become a nickeling and diming company.  To me, pricing should be based upon number of transactions, not features.  I searched for all the IIF import apps providers.  All of them want to charge a monthly fee from $8 to $20 a month.  Is this a joke.  Importing IIF into QuickBooks is the most basic right of a QuickBooks customer.

Agree!  This is SO GROSS how Intuit is abusing its loyal customers by saying, "you have to use a third party...but we can't tell you which one...but best of luck to you."  Baloney.  Intuit just doesn't want to provide what it always has for a reasonable price.

What is striking to me is QuickBooks forcing people to migrate to online when the online product is defective. Importing IIF files is critical for my clients using my web application software. They can generate several IIF files each day copying financial data from my program to their desktop copy of QB for printing checks and bank reconciliation. I'm afraid I'm having to agree, it is about greed and laziness. They are full of arrogance and don't feel it important to provide a superior product anymore. It appears that my only solution is to change my web application to do the work of printing checks, reconciliations and occasional reports. Then my clients can say goodbye to QB. Such stupidity to ruin a company that could be good.

this is ridicules, how can you abandon your own file format import capabilities, I use every day iif files to import Bills and payments in single iif file plus journal entries in another iif format from our POS. Unless quick books online enable iif imports I will be off the Quickbooks online ( totally a garbage product compared to Quickbooks desktop ) near future

How do I import my POS data into quickbooks online?  When I had desktop, I   would go to utilities, import IIF file, select  the file and inport.  It was simple and easy.  How do I do it now??  

@patrson1 

For *.iif files, you have to open the files in Excel and save as *.csv files. Then you will need to use a 3rd party importer tool to proceed.

https://get.transactionpro.com/qbo

Hi there, patrson1.

Allow me to add some information to clarify and address your concerns about importing data into QuickBooks Online.

That's correct, importing IIF files is only available in QuickBooks Desktop. We currently don't have the option to import data in IIF file format from the QuickBooks Point of Sale system to QuickBooks Online. You can, however, import data into QuickBooks Online using a CSV (Comma Separated Values) file, Google Sheets, or an XLS/XLSX file. 

Here's some information about the various formats:

• CSV file: A common file format used for text files that contain tabular data. In CSV files, each field of text is separated by a comma, semicolon, or other special character.
• XLS/XLSX file: XLS is the file format of Microsoft Excel 1997-2003. Microsoft Excel 2007 and newer use the XLSX file format.
• Google Sheets: A cloud-based spreadsheet created in Google Drive.

You can also check out this link to learn more: Common questions about importing data to QuickBooks Online. It contains information about the data you can import into QuickBooks Online.

If you want to import products and services, you can use this article as a reference: Import products and services into QuickBooks Online.

Let me know if you still have other questions or concerns about importing data to QuickBooks Online. I'll be here to assist.

So, Archie_B, you're implying that a CSV file can duplicate all the functions of an IIF file? I'm looking for the detailed documentation on how to do that. I haven't found it yet, would you please include a link to the docs?

I understand I can use third-party applications to convert my IIF files, but this simply looks like some sort of scam where Intuit agrees to not develop (do the right thing) the fundamental function to bring QB on the web closer to a real program. Is someone paying Intuit off for this or is there kickback from the third-parties? Why would I want to pay someone else for the right to import data into QB online when the desktop version is closer to a real program? This is no big deal for Intuit to code this functionality, so there has to be some reason, likely greed, for not doing it.

@Archie_B Importing IIF files is as important to a QuickBooks user as food and water to any human being.  Having said that, I was perfectly happy using QuickBooks Desktop; upgrading it every three years, until you guys first forced me to upgrade every year at a whopping $500+ year; then forcing me to switch to QB Online.  Now, you are telling me IIF does not work.

It has been my observation that since Mr. Goodarzi took the helm, this nickel and dime mentality started at Intuit.  Why don't you print my reply and take it to him and ask him to respond, please!