Import a QFX, QBO, OFX file into Quickbooks Online

If your bank provides transaction download in QFX or QBO formats, you can import these files directly into Quickbooks Online. OFX, QFX, QBO files share the same OFX specification with QFX and QBO files having additional details related to Quicken and Quickbooks accounting software. Quickbooks Online supports the OFX import in general, and therefore supports QFX and QBO file import similar to OFX import.

How to import a OFX/QFX/QBO file into Quickbooks Online

This tutorial shows how to import a QFX file into Quickbooks Online. If you a QBO or OFX file instead of QFX file, the tutorial still applies.

Step 1. Open Banking section in Quickbooks Online

Login into Quickbooks Online to import a QFX file and click on 'Banking'.

IMPORTQFXQUICKBOOKSONLINE Step 1: Banking Quickbooks Online

Step 2. Select a Quickbooks Account and the file to import

Then select an account you want to import your data into.

IMPORTQFXQUICKBOOKSONLINE Step 2: select an account Quickbooks Online

Look for the 'File Upload' button and click on it.

IMPORTQFXQUICKBOOKSONLINE Step 3: file upload Quickbooks Online

Look for the 'Browse' button and click on it.

IMPORTQFXQUICKBOOKSONLINE Step 4: Browse Quickbooks Online

Select an OFX or QFX or QBO file. You could have this QFX file, downloaded from your Bank or created with conversion software from different formats, let's say PDF format or QIF format you would use Bank2QFX converter from Propersoft and create a QFX file. IMPORTANT: Bank2QFX is now replaced with the ProperConvert app, which converts from more formats and converts to more formats.

Then click 'Open' and 'Next'.

IMPORTQFXQUICKBOOKSONLINE Step 5: Browse a QFX Quickbooks Online

Review that QFX file you are going to import: filename, Account ID, Account Type, and Date range.

IMPORTQFXQUICKBOOKSONLINE Step 6: review QFX file Quickbooks Online

If everything matches as you expected, select Quickbooks account you want to import your data into. Then click 'Next'.

IMPORTQFXQUICKBOOKSONLINE Step 7: Select an account Quickbooks Online

Then click 'Let's go!'.

IMPORTQFXQUICKBOOKSONLINE Step 8: click Let's go Quickbooks Online

Step 3. Review Imported Transactions.

Click 'For Review'.

IMPORTQFXQUICKBOOKSONLINE Step 9: for review Quickbooks Online

You can see four transactions are imported. The Description column is actually the Payee column from the QFX file.

IMPORTQFXQUICKBOOKSONLINE Step 10: description column Quickbooks Online

The Payee column is Vendor records or Payee in Quickbooks to match. We don't have any Vendors yet, so this column is empty. Click on the Payee column.

IMPORTQFXQUICKBOOKSONLINE Step 11: payee column Quickbooks Online

And then select Vendor/Payee.

IMPORTQFXQUICKBOOKSONLINE Step 12: select vendor Quickbooks Online

Confirm the Category, which is expense or income account. Click 'Add' to add the transaction to the register. Continue for all transactions.

IMPORTQFXQUICKBOOKSONLINE Step 13: select category Quickbooks Online

Let's say you realized, that it is an incorrect imported QFX file or something wrong with a file, and you don't want those transactions to be here. So, select all transactions.

IMPORTQFXQUICKBOOKSONLINE Step 14: select all Quickbooks Online

Then select 'Batch actions' and click 'Exclude Selected'.

IMPORTQFXQUICKBOOKSONLINE Step 15: click exclude selected Quickbooks Online

Go to 'Excluded'.

IMPORTQFXQUICKBOOKSONLINE Step 16: excluded Quickbooks Online

Select all of them again.

IMPORTQFXQUICKBOOKSONLINE Step 17: select again Quickbooks Online

Then select 'Batch actions' and click 'Delete'.

IMPORTQFXQUICKBOOKSONLINE Step 18: del transactions Quickbooks Online

So, this way, you completely delete those transactions from Quickbooks Online.

IMPORTQFXQUICKBOOKSONLINE Step 19: four transactions deleted Quickbooks Online

See this tutorial as a video:

Related articles