Skip to main content
O
office-foreignca
October 9, 2023
Question

How do I import an IIF File?

  • October 9, 2023
  • 3 replies
  • 0 views
Our daily CashOut's need to be imported from our Shop Management software into Quickbooks online. How do I do this? 
(Previously in Quickbooks Desktop it was File-Utilities-Import-IIF Files)

    3 replies

    Fiat Lux - ASIA
    Fiat Lux - ASIA
    October 9, 2023

    QBO doesn't support to import IIF. Can you export your data in *.csv file format from your Shop Management software instead? Another question, did you switch from QB Desktop? 

    B
    Billy C1
    April 9, 2024

    Yes

    JaeAnnC
    JaeAnnC
    October 9, 2023

    It's nice to welcome you into the Community, @office-foreignca. I'll be happy to share the details about importing IIF files into QuickBooks Online (QBO).

     

    In QBO, there are specific file formats you can upload, which include Comma Separated Values (CSV), Google Sheets, or an XLS/XLSX. However, the program is unable to support importing IIF files at this moment.

     

    I understand how this feature is beneficial to your business. For now, I recommend utilizing an importer tool to upload your IIF files to QBO. To do that, you can visit our App Center.

     

    Here's how:

     

    1. Go to Apps and select Find Apps.
    2. Type the keyword "IIF importer" in the search bar and press Enter.
    3. Select an app and click Get app now to integrate.

     

    Moreover, here's an article containing in-depth information about importing data into QBO: Common questions about importing data to QuickBooks Online.

     

    Stay in touch whenever you have additional questions about importing IIF files. The Community is open anytime to address your queries. Keep safe and have a great rest of the day!

    BigRedConsulting
    BigRedConsulting
    October 9, 2023

    @JaeAnnC  RE: However, the program is unable to support IIF files at this moment.

     

    That is incorrect. 

    You can say that it does not support Intuit's standard file format, the "Intuit Interchange Format". That would be accurate. 

    But, you can't say that it is unable to, as if it isn't possible.  Of course it's able to! It's just that Intuit hasn't implemented it, similarly to the other plethora of features that Desktop has that Online is missing.

    Zed Axis
    Zed Axis
    October 25, 2023

    Hi @office-foreignca 

     

    It is possible to import an IIF file into QuickBooks Online but you need to use a third party app like Axis Online that you can find in the QuickBooks Apps Store that is able to open the IIF file.  You can then map the columns to the fields in QuickBooks Online and batch import the IIF data directly into your company file. 

     

    Hope that gives you another option.

     

    Zed

    M
    Magnus Ozigbo-Esere
    January 30, 2024

    Why should i have to pay for a third party tool on top of paying monthly subcription for Quickbooks.

    Clearly, QBO does not want my business for long as i will obviously look for an alternative platform.

    Our care software exports Intuit format iif specifically for quickbooks. it is exploitative of QB to ask small business owners to pay for additional software to import their own native format. At the very least, they should implement import directly. this is ridiculous and i will surely vote with my feet and my money !

    Terms & ConditionsAccessibility statement