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
Use CSV2QBO to convert CSV, Excel (XLS, XLSX), TXT to QBO and import into QuickBooks 2017, 2016, 2015
Use OFX2QBO to convert OFX to QBO
Use Bank2QBO to convert OFX, QFX, QBO, QIF, QBX, OFX to QBO
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:
Use CSV2IIF to convert CSV, Excel (XLS, XLSX), TXT to QFX and import into Quicken
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.
Related articles for: