Import a QFX file into Quickbooks Online - ProperSoft

Import a QFX file into Quickbooks Online

How to import a QFX file into Quickbooks Online

This tutorial shows how to import a QFX file into Quickbooks Online.

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

IMPORTQFXQUICKBOOKSONLINE Step 1: Banking Quickbooks Online

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 a QFX 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. Then click 'Open' and 'Next'.

IMPORTQFXQUICKBOOKSONLINE Step 5: Browse a QFX Quickbooks Online

Review that QFX file you are going to import: file name, 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

Click 'For Review'.

IMPORTQFXQUICKBOOKSONLINE Step 9: for review Quickbooks Online

You can see four transactions are imported. The Description column is actually 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 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

Related articles