Import a Transactions file into Quickbooks Online

Quickbooks Online imports QFX, OFX, QBO, CSV files. Use this guide to find how to import a file with transactions into Quickbooks Online.

If your bank provides transaction download in OFX, 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.

For CSV files, you may need to adjust your CSV file before importing into Quickbooks Online:

Format amounts to be with just decimal separator (comma or dot) and depending on your Quickbooks Online setup, you may need to change it to what it expects
Format dates to be just numbers, not named months. Quickbooks works with dates formatted as MM/DD/YYYY, DD/MM/YYYY
Only description is imported (single column) by Quickbooks with CSV option. Use formats like OFX to import name, description and check number.

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 have a QBO or OFX file instead of QFX file, the tutorial still applies.

Step 1. Open Banking section in Quickbooks Online

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

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

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

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

Select an OFX or QFX or QBO file. You could have this file downloaded from your bank or created with conversion software from different formats, let's say PDF format or QIF format you would use the ProperConvert app to create an OFX file.

Then click 'Open' and 'Next'.

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

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

Then click 'Let's go!'.

Step 3. Review Imported Transactions.

Click 'For Review'.

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

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.

And then select Vendor/Payee.

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

Rollback (delete) imported transactions

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.

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

Go to 'Excluded'.

Select all of them again.

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

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

Import a CSV file into Quickbooks Online

Use the ProperConvert app to convert your transaction files to required by your accounting software file format.

Follow the steps below for the Windows version, followed by the Mac version.

When the CSV file is created, switch to Quickbooks online and import created CSV file. Look for 'Banking' and click on it.

The next step is to select an account and click the 'File Upload' button. In your accounting software, look for 'Import a statement', 'Upload a bank file', or similar links to upload the created CSV file.

Then click 'Browse' and select created CSV file, click 'Next'.

Then select an account in Quickbooks to import and click 'Next'.

The next step is to confirm the Mapping and Date format. Date and Description columns should be preselected and the amount column needs to be set. Click the 'Next' button.

Review transactions in Quickbooks online, before importing and click the 'Next' button.

Finish the import by on the next step. Once the transactions are imported, you can review and categorize them under the account.