Convert QIF to OFX and import into Xero, QB Online, Sage One, YNAB, AccountEdge

Need to import transactions from a QIF file into Xero, Sage One, or other OFX-compatible software but cannot make it work? The problem is that your bank provides transactions in a format those apps cannot read.

The Solution: try ProperConvert app. It can convert your transactions from QIF to OFX format.

Convert transaction files to the OFX format

ProperConvert extracts transactions from QIF files. It creates OFX files ready to import into Xero, Sage One, or other OFX-compatible software.
No data entry: convert data you already have to OFX format.
Smart: ProperConvert understands many layouts. It finds columns like date, amount, and description.
Easy to use: a few clicks converts all your transactions to importable OFX format.
Free trial and support: try before you buy and get full support before and after your order.
Safe: ProperConvert converts all transactions on your computer.

How can I use ProperConvert to convert transactions from QIF format?

Download, install and run the software
Select a QIF file with transactions and review transactions
Backup your accounting software file before importing any file
Click Convert to convert QIF to an OFX file
Import created file to Xero, Sage One or other OFX importing software or online service

Example: Convert QIF to OFX and import into Quickbooks Online

This tutorial shows how to convert a QIF file from your bank or credit card statement to OFX format. Then import it into QuickBooks Online or another app that supports OFX.

Use the ProperConvert app to convert QIF to OFX. Other formats are supported as well.

Step 1: Download the ProperConvert app and install it

Start the app and open a QIF file to convert.

Step 2: Review transactions before converting

Check that dates are correct, including the year. Confirm deposits and withdrawals are assigned correctly.

Set the OFX Target to match your software, or use 'Regular OFX' as the default.

Set the Account ID and Account Type. Use a different Account ID for each account.

Check 'Open after conversion' to launch the import right after the file is created.

Step 3: Create an OFX file

Click the 'Convert' button to create an OFX file.

Confirm the file name and location.

Step 4: Import created OFX file into Quickbooks Online

Switch to QuickBooks Online and import the OFX file. Click 'Banking.' Select the account to import into.

Click 'File Upload.' Look for 'Import a statement' or 'Upload a bank file.'

Click 'Browse' to find your OFX file and click 'Next.'

Select a QuickBooks account and click 'Next.'

After import, review and categorize the transactions. Add them to the register. Select the Payee (Vendor Record) and Category (expense/income account) for each transaction.

See this as a video:

Learn More

OFX - What Is OFX File Format and How to Open it?
QIF - What is QIF file/format and how to open it?
QuickBooks - How to import transactions into Quickbooks