QIF to QBO Converter — Free Online, No Signup

What Is a QIF File and Why Convert It to QBO?

QIF stands for Quicken Interchange Format — a plain-text format developed by Intuit in the 1980s for exporting transaction data from personal finance software. For decades, banks provided QIF downloads and software like Quicken, Microsoft Money, Moneydance, and GnuCash used QIF as their primary import format.

QBO (QuickBooks Web Connect) is the modern successor — based on OFX (Open Financial Exchange) and specifically designed for QuickBooks bank feed imports. Unlike QIF, QBO includes bank identifiers, account type metadata, and unique transaction IDs that allow QuickBooks to import cleanly without duplicates.

The core reasons people need to convert QIF to QBO:

• QuickBooks Online doesn't import QIF — it only accepts QBO/OFX for bank feeds
• QuickBooks Desktop bank feeds require QBO — the IIF import path is for list data, not transactions
• Migrating from Quicken to QuickBooks — Quicken exports QIF; QuickBooks needs QBO
• Old bank downloads in QIF format — many banks switched from QIF to OFX/QBO after 2016
• Legacy financial data recovery — Microsoft Money exported QIF; converting to QBO brings it into modern software

How to Convert QIF to QBO — Step by Step

QIF vs QBO vs OFX — What's the Difference?

Understanding the QIF File Format

A QIF file is a plain-text file where each transaction occupies multiple lines, each line beginning with a single-letter field code:

Each field code means:

• D — Date of transaction
• T — Amount (negative = debit, positive = credit)
• P — Payee / description
• M — Memo / additional details
• N — Reference number or cheque number
• ^ — End of transaction record

Our converter reads all these fields and maps them to the corresponding QBO structure — date to OFX DTPOSTED, amount to TRNAMT, payee to NAME and MEMO fields, and reference to CHECKNUM.

How to Import a QBO File into QuickBooks

QuickBooks Online

1. Go to Transactions → Banking (or Bank transactions in newer UI)
2. Click Upload from file (top right)
3. Select your downloaded QBO file
4. Choose the QuickBooks bank account to import into
5. Click Next → review transactions → Import
6. Transactions appear in the For Review tab for categorisation and matching

QuickBooks Desktop

1. Go to File → Utilities → Import → Web Connect Files
2. Browse to your downloaded QBO file and open it
3. Choose whether to create a new account or add to an existing account
4. Click OK — transactions load into the Banking Centre
5. Review and match transactions in the Banking Centre

Why Use Bank Statement Engine for QIF to QBO Conversion?

There are several QIF-to-QBO tools online, but most have significant limitations. Here's why Bank Statement Engine is different:

• Handles all QIF date formats — MM/DD/YY, DD/MM/YY, DD/MM/YYYY, MM/DD/YYYY, and YYYY/MM/DD are all parsed correctly. Many tools fail on non-US date formats.
• Unique FITID per transaction — each transaction in the QBO output gets a unique ID based on date and amount hash, preventing QuickBooks from importing duplicates if you convert and import twice.
• Supports multi-account QIF files — QIF files can contain transactions from multiple accounts (checking, savings, credit card). Our converter separates them correctly.
• Also outputs Excel and CSV — from the same upload, you can download QBO, Excel (.xlsx), and CSV simultaneously from the results page.
• Handles large files — years of transaction history in a single QIF file processes without timeout or truncation.
• Privacy-first — your QIF file is deleted automatically after 24 hours. No transaction data is stored or analysed.

Common QIF to QBO Conversion Issues and Fixes

QuickBooks says "No new transactions to import"

This means all transactions in the QBO file already exist in QuickBooks (duplicate detection by FITID). If you are sure the transactions are new, try adjusting the date range in your QIF export — QuickBooks tracks imported date ranges per account.

Transactions import with wrong sign (debits showing as credits)

In QIF, negative amounts are debits and positive are credits. If your QIF file uses the opposite convention (some accounting software does), the signs will be flipped. After importing, you can select affected transactions in QuickBooks and use Exclude, then re-import with corrected signs.

Date format issues after import

QuickBooks uses your company's date format setting. If dates appear wrong (e.g., January 6 shows as June 1), your QIF file uses a different date format than what the converter detected. Contact us with your QIF file and we will diagnose the date format issue.

QIF file is from Microsoft Money or an old bank

Microsoft Money's QIF export and legacy bank QIF downloads sometimes use non-standard field codes or encoding. Our converter handles the most common variations. If your file fails, try saving it as plain UTF-8 text and re-uploading.

Frequently Asked Questions