Import QIF into FreeAgent: convert QIF to OFX

FreeAgent imports OFX files. Convert your QIF file to OFX first, then import it. Read the full FreeAgent 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: check the account in FreeAgent

FreeAgent keeps your data online, so there is no company file to back up. Check that the bank account exists and look at what is already uploaded for this period.

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 FreeAgent

  1. Log in to FreeAgent and click Banking.
  2. Click Upload a bank statement.
  3. Click Select a file and select the OFX file.
  4. Select the account to upload to.
  5. Optionally check "Guess explanations for my bank transactions". It works better once you have imported and categorized a few statements.
  6. Click Upload Statement, then Review your transactions.

See the FreeAgent import guide for more.

FreeAgent OFX questions

Why convert to OFX when FreeAgent lists CSV?

FreeAgent has a fixed CSV layout and doesn't let you map columns. In our test, a file trimmed to that layout was still refused, and the same transactions converted to OFX uploaded at once.

How do I categorize the imported transactions?

FreeAgent calls this explaining. For each transaction, select a category, change the description if you like, and click Explain Transaction. Once you have explained some, FreeAgent can guess categories on the next OFX import.

How do I undo an upload?

Click Undo Last Upload, then Delete these transactions. FreeAgent removes everything from the last upload, and you can convert the file again and upload it.

Related FreeAgent conversions