Convert to Quickbooks compatible formats (QBO, IIF, QBJ)

QuickBooks accounting software is offered as QuickBooks Desktop (QBD) or QuickBooks Online. Both variants import the QBO format as a common format for bank transactions under Bank Feeds, and each of them imports its own set of formats. The QBO format applies to bank transactions files and credit card transactions files. See below options and Desktop and Online versions.

Use the ProperConvert app to convert your file to a format compatible with Quickbooks.

Import bank transactions and credit card transactions into Intuit QuickBooks 2020-2023 and Quickbooks Online through the QBO format or the IIF format (all QuickBooks Desktop versions are supported). QBO and IIF formats are different: QBO (Web Connect) is to import bank transactions, and IIF is more ‘low level’ import allowing to create of various transactions between QuickBooks accounts. Both formats have limitations – read below to choose the most suitable format for you.

Which formats does Quickbooks import?

For QuickBooks desktop, convert to QBO (Bank Feeds or web connect) format or IIF format if you have Intuit QuickBooks 2020-2023. QBO and IIF files are importable by QuickBooks Enterprise as well.

For older QuickBooks Desktop versions, convert to the IIF format.

Import into QuickBooks through the QBO format

The QBO format is a QuickBooks Web Connect format used to import bank transactions into QuickBooks (under Bank Feeds). ".QBO" does not mean "QuickBooks Online".

the ProperConvert app converts CSV, Excel (XLS, XLSX), TXT, OFX, QFX, QBO, QIF, QBX, OFX, PDF, MT940 to the QBO format.

Import a QBO file into Quickbooks Desktop (Windows or macOS)

quickbooks-import-web-connect-file

quickbooks-successfully-import-complete

Import a QBO into Quickbooks Online

Import into QuickBooks Desktop through the IIF format

IIF format is the format to use for all QuickBooks versions. It allows supplying more details about transactions like expense/income account or class. Unlike the QBO format, which requires "matching" under the Bank Feeds after QBO import, the IIF format requires vendor names, account names to be exact to what you have in Quickbooks otherwise Quickbooks will create new vendor and account records during IIF import.

Quickbooks Online does not import IIF files.

The IIF format is considered a "low level" or "system" format and QuickBooks imports it right into its database, so you have to be precise with the data you provide. Typos and mismatches will result in new vendor records and accounts created. Always do a backup (as with any other import) for the QuickBooks company file before any IIF import. Putting aside the scary part, this is a great format widely used and you can import data quickly. If you just figuring out QuickBooks, start with the QBO format (see above).

CSV files must have exact vendor names and category (expense/income) account names matching account names in QuickBooks. All QuickBooks versions are supported as long as they import IIF files (except QuickBooks Online). For QuickBooks Enterprise the user must have exclusive access to import IIF files.

Use the ProperConvert to convert your transaction files to the IIF format.

What are the main differences between QBO and IIF import into QuickBooks?

What is the QBJ format?

The QBJ format is the latest format supported by Quickbooks to create General Journal Entries. Quickbooks accountant edition allows your accountant to create general journal entries for you, export them as IIF files, send them to you and import them into your Quickbooks.

How is the QBJ format different from QBO and IIF formats?

The QBJ format is for General Journal Entries. QBO and IIF files are for transactions.

The ProperConvert app converts general journal entries from CSV/Excel to QBJ (and to IIF as well) and import them into Quickbooks. Working in Excel with general journal entries is faster than directly in Quickbooks. In addition, importing QBJ files creates the audit record in your Quickbooks, so you can review easily created entries.

Summary

The ProperConvert app is a one-stop solution to convert bank and credit card transactions and general journal files you have to a format comaptible with your Quickbooks version.

Related articles