Import QIF into AccountEdge Pro: convert QIF to OFX

AccountEdge Pro imports OFX files. Convert your QIF file to OFX first, then import it. Read the full AccountEdge Pro import guide.

load a QIF file in ProperConvert

What is a QIF file

QIF is plain text with no transaction IDs and no account number, so apps can't use it to detect duplicates. Avoid converting the same period twice. Its dates can be ambiguous, such as 03/04/26, so confirm the date format in the app. QIF can carry categories, which are useful when the output needs expense and income accounts.

What is an OFX file

OFX (Open Financial Exchange) is a standard format for bank data. Many accounting apps import it. It holds the date, amount, payee, memo, check number and a transaction ID, along with the account ID and type. More about OFX.

Why convert QIF to OFX

QIF is an older format with no transaction IDs and no currency, and many current apps don't take it. OFX is the most widely accepted bank format, with named fields and a transaction ID on each row, so an app can skip rows it already has.

Before you import: back up AccountEdge

Back up your AccountEdge company file before you import, so you can restore it if the transactions come in wrong.

Step by step: convert QIF to OFX

  1. Download, install and start ProperConvert. The trial is free.
  2. Open your QIF file.
  3. Review the transactions to see how the app read your file. Check that the dates are correct, and that expenses are negative and deposits (payments to the account) are positive. The "Change +/-" button reverses the signs for the whole file, for bank and credit card accounts alike.
  4. Set the OFX settings below.
  5. Click Convert, then confirm the file name and location.

Set the OFX output settings

In the QBO/QFX/OFX tab on the right sidebar, set the file type to OFX and select OFX All apps as the OFX target, then set:

See all OFX settings.

Import the OFX file into AccountEdge

  1. Click Bank Register, then Bank Statement.
  2. Click Import Statement.
  3. Go to the OFX file and click Open.
  4. AccountEdge reports how many transactions were in the file, how many were imported and how many were skipped. Click OK.
  5. Assign an expense or income account to each transaction.

See the AccountEdge import guide for more.

Transactions imported into AccountEdge

AccountEdge OFX questions

How does AccountEdge treat the amounts?

Negative amounts are imported as withdrawals and positive amounts as deposits. Check numbers and payees are imported too.

Why do I still have to assign accounts?

A bank statement doesn't know your accounting. A Home Depot purchase can be a utility expense for one company and office or building supplies for another, so you assign the expense or income account yourself.

Related AccountEdge Pro conversions