Import into QuickBooks through the QBO format (all QuickBooks versions are supported until they are three years old) or IIF format (all QuickBooks versions are supported). QBO and IIF format are different: QBO (Web Connect) is to import bank transactions, and IIF is more ‘low level’ import allowing to create various transactions between QuickBooks account. Both formats have limitations – read below to choose the most suitable format for you. Import into QuickBooks by converting to QBO or IIF
Import into QuickBooks through QBO format
Use CSV2QBO to convert CSV, Excel (XLS, XLSX), TXT to QBO and import into QuickBooks 2017, 2016, 2015
Short video (7 min) how to convert a CSV file to QBO format and import into QuickBooks:
Longer video with more details (22 min) about multiple accounts, mapping different amount layouts and more:
Import into QuickBooks through IIF format
Use CSV2IIF to convert CSV, Excel (XLS, XLSX), TXT to QFX and import into Quicken
Use Bank2IIF to convert OFX, QFX, QBO, QIF, QBX, OFX to IIF
What are main differences between QBO and IIF import into QuickBooks?
QBO import requires Internet connection with QuickBooks allowed to access Internet, IIF import is completely offline
QBO import allows to apply renaming rules to assign payee or vendor even if it is different on supplied QBO file from the record in QuickBooks, and assign the expense account during import. IIF must have expense accounts supplied as you have them in QuickBooks. CSV2IIF allows to do that through the category column or provide default expense account.
Imported QBO transactions go first into the Online Banking Center, where you can review, delete, match and finally include into the register. QuickBooks provides two Online Banking Center modes, completely be their user interface and actually how transactions are imported. IIF import is done directly into QuickBooks transaction register.
QBO import requires QuickBooks to be no older than three years. IIF keeps importing without asking you to upgrade.
QuickBooks Online imports QBO files only, QuickBooks Online does not import IIF files