The most common task when using Quickbooks is to enter transactions. Often banks provide transactions through online banking. Instead of entering transactions by hand from the printed paper statement, check first which format your online banking provides.
File formats from online banking
OFX, QFX, QBO - transactions have the date, amount, payee name, optional description, an optional check number for checks, and unique transaction ID
QIF - transactions have the date, amount, payee/description, check number
CSV - transactions have the date, amount, payee/description, check number
PDF - transactions are presented inside to printed bank or credit card statement
Importing into Intuit Quickbooks 2019-2021
Intuit Quickbooks 2019-2021 imports QBO (Web Connect) files as the easiest option to import transactions. Quickbooks provides the Bank Feeds interface to "match" transactions to vendor records after import and assign expense/income accounts and add transactions into the register.
Transactions in the QBO format
If your bank provides transactions in QBO format, this is the easiest option to import into Quickbooks as Quickbooks imports QBO (Web Connect) format, simply import this file into Quickbooks or Quickbooks Online
If your bank provides QBO files, but does not provide direct online download, Quickbooks may not import the QBO file from your bank, use the Transactions app, Bank2QBO to make your QBO file importable by Quickbooks
Transactions in the OFX format
QBO format is essentially OFX format with added details related to Quickbooks
Use the Transactions app, Bank2QBO to convert OFX files to QBO format and import into Quickbooks
Transactions in the QFX format
QFX format is OFX format with added details for Quicken and may be importable by Quickbooks by simply renaming .QFX file extension to .QBO
If renaming does not help, use the Transactions app, Bank2QBO to make your QFX file into an importable QBO file
Transactions in the QIF format
QIF format is Quicken Interchange Format and many accounting systems and online bankings sites can provide transactions in the QIF format (for example, Quicken can export transactions as QIF)
Use the Transactions app, Bank2QBO to convert QIF files to QBO format and import into Quickbooks
Transactions in the CSV format
CSV format can be edited in Excel or other spreadsheet software
Excel or Google Sheets is an excellent tool to enter transactions quickly line by line
Once you have transactions, use the Transactions app, Bank2QBO to convert CSV/Excel to importable QBO format
Transactions in PDF bank statement
PDF files are often the only option to download old transactions (past 90 days)
Bank2QBO provides an easy option to extract transactions from PDF files and create an importable QBO file
Import as IIF format
Quickbooks Desktop imports the IIF format, which allows to specify vendor name and expense/income account (category) and import transactions directly into the register.
You have to be precise with vendor names and expense/income account names, so it is a good idea to get your transactions into CSV/Excel format first, edit them and then convert to the IIF format
Use the Transactions app, Bank2IIF to convert transactions to CSV format
After CSV/Excel file is edited, use the Transactions app, Bank2IIF to convert to IIF
Importing into older Quickbooks
For older Quickbooks, IIF format is the only option to import. Use the instructions above to get your data into IIF format
If your QIF file has categories as your expense/income transactions in Quickbooks, use Bank2IIF for quick conversion from QIF to IIF.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article