What QIF export file format does this tool accept?

This tool accepts QIF Text File (Quicken) files. Export from QIF and upload the (Quicken) file directly.

Can I convert QIF CSV to QuickBooks Online?

Yes, this tool converts QIF Text File (Quicken) exports directly to QuickBooks Online CSV format compatible with QuickBooks Online.

How do I import QIF text file to QuickBooks Online?

Export your text file from QIF, upload the CSV file to this converter, then import the converted file to QuickBooks Online.

Convert QIF to QuickBooks Online CSV | QIF to QBO

🥦

QuickBooks Online CSV Format

valid rows

Transform QIF (Quicken Interchange Format) transaction files into QuickBooks Online's 3-column CSV format. Your data never leaves your browser.

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 QIF

Valid QIF file with sample transactions

Sample QIF File

How to Convert QIF to QBO

Export from Banking

My Account → Account Activity → Select .QIF

Upload and Configure

Upload QIF Bank Transactions CSV and choose Bank Transaction CSV (3-Column) format

Preview and Download

Review converted data, download Quickbooks Online-ready file

Import to QuickBooks Online

Banking → Select Account → Upload from Computer → Import CSV

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

QIF to QBO Conversion Questions

Is the QIF to QBO converter free to use?

First transactions are free to preview. Full conversions use credits based on transaction count (0.5 credits per 1,000 rows, minimum 5 credits).

Is my QIF data safe?

Absolutely. All conversion happens in your browser. Your QIF file is never uploaded to servers. Your financial data never leaves your computer.

Do I need to convert QIF before importing to QB Online?

Yes. QuickBooks Online doesn't support QIF format directly. You must convert QIF to QBO or CSV format first using a converter tool.

Common Bank Transaction CSV (3-Column) Import Errors

Issues you might encounter when importing QIF Bank Transactions data to Bank Transaction CSV (3-Column) - and how we solve them

Invalid QIF File

File is not a valid QIF format

CSV file or corrupted QIF

Valid QIF file from Quicken or bank

Ensure you're uploading a QIF file with proper format

QIF files are text files with lines starting with D, T, P, etc.

Missing Transaction Date

QIF transaction missing required 'D' (date) field

Transaction without D line

D01/18/2025 at start of transaction

Every QIF transaction must have a date (D field)

Check QIF file format - each transaction needs D and T fields

Missing Transaction Amount

QIF transaction missing required 'T' (amount) field

Transaction without T line

T-150.50 in transaction block

Every QIF transaction must have an amount (T field)

Check QIF file format - each transaction needs D and T fields

Split Transaction Detected

QIF contains split transactions (S, E, $ fields)

Single transaction with multiple categories

Splits converted to total amount only

Split transactions are combined into single CSV row with total amount

Category information is lost in QBO CSV import (use bank rules after import)

Why Convert QIF to CSV for QuickBooks Online?

QIF: The Legacy Format Still in Use

QIF (Quicken Interchange Format) is a text-based format from the 1990s, still widely used: - Microsoft Money, old Quicken, GnuCash all export QIF - Many financial tools support QIF as a fallback format - Easy to create/edit in text editors - Old financial records often stored as QIF QuickBooks Online doesn't import QIF - you must convert to CSV first.

What This Tool Does

We convert your QIF text file to QuickBooks Online's required CSV format: Input (QIF - plain text with single-character codes): !Type:Bank D01/18/2025 T-150.50 PAMAZON.COM MOrder #12345 ^ Output (QBO CSV): Date,Description,Amount 01/18/2025,AMAZON.COM - Order #12345,-150.50 The tool parses QIF's tag-based format (D=date, T=amount, P=payee, M=memo) and converts to QBO's simple CSV columns.

How People Use QIF to QBO

Many of my clients still have historical data locked in Quicken QIF files from when they used Microsoft Money or older Quicken versions. I convert QIF to QBO CSV format and import the transactions so their QuickBooks Online records go back to the beginning of their business.

Our church used GnuCash for years and exported everything as QIF before switching to QuickBooks Online. The QIF to QuickBooks converter handled our legacy date formats and combined payee and memo fields into clean descriptions for the CSV import.

A few clients have banks that only provide QIF downloads instead of CSV or OFX. I use this tool weekly to convert QIF to QuickBooks Online format. The smart description builder merges payee, memo, and check number fields so nothing gets lost in the conversion.

Field Mapping

How Banking Qif fields map to Quickbooks Online Bank Transaction

Banking Qif	Source Value		Quickbooks Online Bank Transaction	Target Value	Note
`D`	`01/15/2025`	→	`Date`	`01/15/2025`	QIF date (flexible formats) → MM/DD/YYYY
`T`	`-50.00`	→	`Amount`	`-50.00`	Signed amount (negative for payments, positive for deposits)

Why Use the QIF to QBO Converter?

Legacy Format Support

Works with QIF files from Quicken, Microsoft Money, GnuCash, and more

Flexible Date Parsing

Handles multiple QIF date formats (MM/DD/YY, M/D'YY, MM/DD/YYYY)

Smart Description Builder

Combines payee (P), memo (M), and check number (N) into description

Split Transaction Handling

Converts split transactions (S, E, $) to single CSV rows with total amount

Browser-Based Security

All processing in your browser - your QIF data stays private

Category Preservation

Includes category info in description (note: QBO CSV doesn't import categories)

Data Transformation

Each QIF transaction becomes one CSV row (splits are combined)

Text-based transaction with single-character codes

Key columns: D (Date), T (Amount), P (Payee), M (Memo)

1:1 — One input row creates one output row

Simple CSV format with 3 columns

Transaction Convert QIF date to MM/DD/YYYY

Description Combine payee, memo, and check number

Amount Keep signed amount as-is

Amounts must be numeric; dates must be valid

Your QIF to QBO Conversion is Secure

Local Processing Engine

Your QIF to QBO files stay on your device. Processing happens client-side, nothing leaves your machine.

Zero Server Storage

Your QIF to QBO 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 QIF to QBO files.

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.

QIF (Quicken Interchange Format) is a text-based format from the 1990s. Each transaction is a block of lines starting with single-character codes: D for date, T for amount, P for payee, M for memo, ending with ^. It's human-readable and easy to edit in a text editor.

QIF is a legacy format that Intuit (QuickBooks maker) created for Quicken. QuickBooks Online moved to modern CSV imports for simplicity. QBO's manual upload feature only accepts 3 or 4-column CSV files, not the multi-line tag-based QIF format.

Yes! QIF is a universal format. Any software that exports QIF (Microsoft Money, GnuCash, Moneydance, old Quicken versions) will work with this tool. The QIF specification is the same across all platforms.

QIF supports split transactions using S (split category), E (split memo), and $ (split amount) tags. This tool combines splits into a single CSV row with the total transaction amount. Category details are included in the description field for your reference.

QIF categories are preserved in the description field (e.g., 'Payee - Memo [Office Supplies]'). However, QuickBooks Online's CSV import doesn't support categories - you'll need to set up bank rules in QBO to auto-categorize after import.

Yes! QIF is plain text. You can open it in Notepad/TextEdit and manually add, remove, or edit transactions. Just maintain the format: each transaction starts with D and T lines, ends with ^. Be careful with date formats.

QIF is flexible with dates: MM/DD/YYYY (01/18/2025), M/D/YY (1/18/25), MM/DD/YY (01/18/25), and variations with apostrophes (M/D'YY). This tool handles all common QIF date formats automatically.

First transactions are free to preview. Full conversions use credits based on transaction count (0.5 credits per 1,000 rows, minimum 5 credits).

Absolutely. All conversion happens in your browser. Your QIF file is never uploaded to servers. Your financial data never leaves your computer.

Yes. QuickBooks Online doesn't support QIF format directly. You must convert QIF to QBO or CSV format first using a converter tool.