QIF2OFX: Convert QIF to OFX

Need to import transactions, but the format is not supported? Convert QIF to OFX and import into Xero, QB Online, Xero, QB Online, Sage One, YNAB, AccountEdge, Banktivity, Ace Money. Select compatible OFX variant for your accounting software



What can I do with QIF2OFX (QIF to OFX Converter)?

Why should I trust QIF2OFX?

If I need any help with conversion, can you help me?

Can I try before purchasing?

Convert QIF bank or credit card statement files to OFX format and import into Quickbooks Online, Xero, Sage, MS Money and other accounting software.

This tutorial shows how to convert a QIF file from your bank or credit card statement to OFX format and import into Quickbooks Online. We will use QIF2OFX utility.

Step by step instructions for Windows

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

Make sure you are using the latest version of QIF2OFX. Download it from the QIF2OFX download page. Start QIF2OFX and select a QIF file.

QIF2OFX Windows Step 1: select a QIF file

Review transactions before converting, check that dates are correct, have correct year, deposits and withdrawals are in correct places.

QIF2OFX Windows Step 2: review transactions before converting

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

QIF2OFX Windows Step 3: Target

Set the Account ID (number) and the Account Type. For multiple accounts, use a different account ID for each account.

QIF2OFX Windows Step 4: Account ID, Account Type

Currency should be USD even for non-USD accounts for Quickbooks US edition. For Canadian edition, you can use USD and CAD. And for the UK edition, GBP currency must be set. Also check End balance, Bank ID and Branch ID.

QIF2OFX Windows Step 5: currency

Set 'Open after conversion' to open application handling converted files to start import right after the conversion.

QIF2OFX Windows Step 6: Open after conversion

Click 'Convert' button to create an OFX file.

QIF2OFX Windows Step 7: click Convert

Confirm the file name and location.

QIF2OFX Windows Step 8: file name and location, save

Import created OFX file into Quickbooks Online

Now the OFX file is created, let's switch to Quickbooks Online and import created OFX file. Look for the 'Banking' and click on it.

QIF2OFX Windows Step 9: Banking in Quickbooks

And then select the account you want to import your data into.

QIF2OFX Windows Step 10: select account in Quickbooks

Click the 'File Upload' button. In your accounting software, look for 'Import a statement', 'Upload a bank file' or similar links to upload created OFX file.

QIF2OFX Windows Step 11: File Upload in Quickbooks

Then click 'Browse' to locate your OFX file. And click 'Next'.

QIF2OFX Windows Step 12: click Browse to locate OFX file in Quickbooks

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

QIF2OFX Windows Step 13: select an account in Quickbooks

Once the transactions are imported, you can review, categorize them under the account and add to the register.

QIF2OFX Windows Step 14:  transactions are imported in Quickbooks

Select Payee (Vendor Records) and Category (expense/income accounts).

QIF2OFX Windows Step 15:  Select Payee in Quickbooks

Step by step instructions for macOS

Make sure you are using the latest version of QIF2OFX. Download it from the QIF2OFX download page. Start QIF2OFX and select a QIF file.

QIF2OFX Mac Step 1: select a QIF file

Review transactions before converting, check that dates are correct, have correct year, deposits and withdrawals are in correct places.

QIF2OFX Mac Step 2: review transactions before converting

Set the Account ID (number) and the Account Type. For multiple accounts, use a different account ID for each account.

QIF2OFX Mac Step 3: Account ID and Account Type

Currency should be USD even for non-USD accounts for Quickbooks US edition. For Canadian edition, you can use USD and CAD. And for the UK edition, GBP currency must be set. Also check End balance, Bank ID and Branch ID.

QIF2OFX Mac Step 4: currency

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

QIF2OFX Mac Step 5: OFX Target

Set 'Open after save' to open application handling converted files to start import right after the conversion.

QIF2OFX Mac Step 6: Open after save

Click 'Convert' button to create an OFX file.

QIF2OFX Mac Step 7: click Convert

Confirm the file name and location.

QIF2OFX Mac Step 8: confirm file name and location

Import created OFX file into Quickbooks Online

Now the OFX file is created, let's switch to Quickbooks Online and import created OFX file. Look for the 'Banking' and click on it.

QIF2OFX Mac Step 9: Banking in Quickbooks

And then select the account you want to import your data into.

QIF2OFX Mac Step 10: select an account in Quickbooks

Click the 'File Upload' button. In your accounting software, look for 'Import a statement', 'Upload a bank file' or similar links to upload created OFX file.

QIF2OFX Mac Step 11: File Upload in Quickbooks

Then click 'Browse' button and select created OFX file. And click 'Next'.

QIF2OFX Mac Step 12: click Browse in Quickbooks

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

QIF2OFX Mac Step 13: select an account in Quickbooks

Once the transactions are imported, you can review, categorize them under the account and add to the register.

QIF2OFX Mac Step 14: transactions are imported in Quickbooks

Select Payee (Vendor Records) and Category (expense/income accounts).

QIF2OFX Mac Step 15: Select Payee in Quickbooks