What Bank export file format does this tool accept?

This tool accepts Bank OFX/QFX/QBO File files. Export from Bank and upload the File file directly.

Can I convert Bank CSV to QuickBooks Desktop?

Yes, this tool converts Bank OFX/QFX/QBO File exports directly to QuickBooks Desktop IIF format compatible with QuickBooks Desktop.

How do I import Bank ofx/qfx/qbo to QuickBooks Desktop?

Export your ofx/qfx/qbo from Bank, upload the CSV file to this converter, then import the converted file to QuickBooks Desktop.

OFX to QuickBooks Desktop — IIF Converter

🥦

QuickBooks Desktop IIF Format

valid rows

Import bank transactions from OFX, QFX, or QBO files directly into QuickBooks Pro, Premier, or Enterprise.

Free preview — then from $5. Save with bundles.

Free preview before you pay

Files never leave your browser

No account needed to start

Download Sample OFX File

Sample bank OFX file to test the converter

Download Sample

Tool Rating

4.7 / 5 (45 votes)

How to Convert OFX → QB Desktop

Export from Banking

Accounts → Transaction History → Export

Upload and Configure

Upload OFX/QFX/QBO Bank Transactions CSV and choose IIF File format

Preview and Download

Review converted data, download Quickbooks Desktop-ready file

Import to QuickBooks Desktop

File → Utilities → Import → IIF Files → Select File

Output is in QuickBooks Desktop IIF format — ready to import directly, no manual reformatting needed.

Why Use the OFX → QB Desktop Converter?

OFX/QFX/QBO Support

Works with all major bank download formats.

Balanced Transactions

Every transaction has proper double-entry (debit = credit).

Account Mapping

Configure bank, income, and expense account names.

Desktop Compatible

Works with QuickBooks Pro, Premier, and Enterprise.

Check Number Preservation

Check numbers from OFX are preserved in IIF output.

Browser-Based Privacy

Files process locally. Your bank data never leaves your computer.

OFX → QB Desktop Conversion Questions

Do my accounts need to exist first?

Yes. The bank account, income account, and expense account names must exist in your QuickBooks Chart of Accounts before importing.

How do I import the IIF file?

In QuickBooks Desktop: File → Utilities → Import → IIF Files. Select your downloaded file and click Import.

Can I import OFX files directly into QuickBooks Desktop?

No, QuickBooks Desktop doesn't directly support OFX format. You must convert OFX files to QBO or IIF format first before importing.

How People Use OFX → QB Desktop

Two of my clients' banks don't support direct QuickBooks Desktop bank feeds. I download their OFX files monthly and convert them to IIF for import. The balanced transactions with proper double-entry save me from manually entering every deposit and check.

Our company uses QuickBooks Premier and the bank feed kept disconnecting. Now I just download the OFX file from Chase and convert it to IIF. The account mapping lets me assign the right income and expense accounts before import, which cuts my reconciliation time in half.

We run QuickBooks Enterprise with separate checking accounts for operations, payroll, and a trust account. I convert each bank's OFX download to IIF with the correct account names mapped. The check number preservation is critical for our payment tracking.

Field Mapping

How Banking Ofx fields map to Quickbooks Desktop Iif

Banking Ofx	Source Value		Quickbooks Desktop Iif	Target Value	Note
`FITID`	`202501150001`	→	`DOCNUM`	`202501150001`	Bank transaction ID as document number
`DTPOSTED`	`2025-01-15 12:00:00`	→	`DATE`	`01/15 12:00:00/2025`	Transaction date
`TRNAMT`	`-50.00`	→	`AMOUNT`	`-50.00`	Transaction amount
`NAME`	`AMAZON PURCHASE`	→	`NAME`	`AMAZON PURCHASE`	Payee name
`MEMO`	`Online order #12345`	→	`MEMO`	`Online order #12345`	Transaction memo
`CHECKNUM`	`1001`	→	`CHECKNUM`		Check number (if check transaction)

Why Convert OFX to IIF?

The Bank Feed Alternative

QuickBooks Desktop's Bank Feeds can be unreliable or unavailable for some banks. OFX files downloaded directly from your bank give you complete control over which transactions you import and when. QuickBooks Desktop can't import OFX files directly for all transaction types—it requires IIF (Intuit Interchange Format) for full transaction import with proper account assignments.

What This Tool Does

We convert your bank's OFX/QFX/QBO download to IIF format: - Deposits become balanced DEPOSIT transactions - Payments become balanced CHECK transactions - Transfers are handled as GENERAL JOURNAL entries - All transactions balance (debits = credits) Import via File → Utilities → Import → IIF Files.

Your OFX → QB Desktop Conversion is Secure

Local Processing Engine

Your OFX → QB Desktop files stay on your device. Processing happens client-side, nothing leaves your machine.

Zero Server Storage

Your OFX → QB Desktop files are never cached, logged, or stored anywhere. Every session is ephemeral.

Privacy-First Architecture

Designed for data sovereignty. No third-party trackers or analytics touch your OFX → QB Desktop files.

Data Transformation

Each bank transaction becomes a TRNS/SPL/ENDTRNS block

One row per bank transaction

Key columns: FITID, DTPOSTED, TRNAMT, NAME

1:N — One input row creates multiple output rows

Hierarchical structure for QuickBooks Desktop import

Common IIF File Import Errors

Issues you might encounter when importing OFX/QFX/QBO Bank Transactions data to IIF File - and how we solve them

Account Not Found

QuickBooks can't find the specified account name

Account 'Bank Account' not in Chart of Accounts

Create the account first or use exact name

Verify account names match your Chart of Accounts exactly

Edit account names in the tool options before converting

Transaction Doesn't Balance

IIF requires AMOUNT sum to equal zero per transaction

TRNS: 100, SPL: -90 (doesn't balance)

TRNS: 100, SPL: -100 (balances to zero)

We ensure each transaction balances correctly

All amounts are validated before export

More credits - more savings

Buy bundles and get up to 60% off. Perfect for recurring monthly conversions.

Frequently Asked Questions

You can, but free scripts and AI often miss edge cases that break real-world data: missing SKUs, currency formatting quirks, tax calculation errors, or date format mismatches. We have battle-tested validators specifically designed for accounting software imports that catch these issues before they corrupt your books. Plus, you get instant browser-based conversion without installing Python or managing dependencies.

They're all variants of the Open Financial Exchange format. OFX is the standard, QFX is Quicken's version, and QBO is QuickBooks' version. This tool handles all three identically.

IIF import works with QuickBooks Pro, Premier, and Enterprise versions 2000-2025.

Yes. The bank account, income account, and expense account names must exist in your QuickBooks Chart of Accounts before importing.

Positive amounts become DEPOSIT transactions crediting your income account. Negative amounts become CHECK transactions debiting your expense account.

Transfers (XFER type in OFX) are converted to GENERAL JOURNAL entries between accounts.

In QuickBooks Desktop: File → Utilities → Import → IIF Files. Select your downloaded file and click Import.

No, QuickBooks Desktop doesn't directly support OFX format. You must convert OFX files to QBO or IIF format first before importing.

When banks provide downloads through Web Connect, they sometimes convert QBO files to OFX format during download. You'll need to convert it back or use IIF as an alternative.

IIF (Interchange File Format) is a text-based format that QuickBooks won't discontinue support for, making it ideal for long-term bank import compatibility.

Check that accounts exist in your company file, verify the IIF file structure in a text editor, and ensure data matches your chart of accounts exactly.