All articles

Transfer From Quicken to QuickBooks and Keep Every Transaction

• 6 min read • QIFQBO Team

How to transfer from Quicken to QuickBooks Online or Desktop by converting QIF to balanced QBO files, with a worked time comparison against retyping.

.qif → .qbo
No file handy?

No account needed for your first 3 conversions. We never store your bank login.

To transfer from Quicken to QuickBooks, export each Quicken account as a QIF file, convert the QIF to a balanced .qbo file, and import it through QuickBooks Web Connect. QuickBooks cannot read QIF or Quicken data files directly, so the conversion in the middle is the step that makes it work. Expect about a minute per account for the conversion and an hour or two for categorizing, however many years of history you carry over.

Intuit sells QuickBooks Online and Desktop as a replacement for Quicken Home and Business, and it advertises that you can bring your data across. In practice the supported route covers a narrow case, and most people who search for how to transfer from Quicken to QuickBooks end up holding a Quicken file that QuickBooks will not open. This article sets out the three routes that exist, what each costs in time and risk, and which one fits a given file. The one most people should use is the QBO route, and it is covered step by step below.

The three ways to move Quicken data into QuickBooks

RouteWhat you doMain riskBest when
Retype or pasteRe-enter each register by hand or paste from a spreadsheetTypos, hours of work, no audit trailUnder 100 transactions
IIF importConvert QIF to a tab delimited IIF file and import into QuickBooks DesktopPosts straight to the ledger, fails on one bad account name, not available in QuickBooks OnlineDesktop users who need lists and opening balances
QBO Web ConnectConvert QIF to .qbo and import as a bank fileCategories need mapping after importAlmost every file, both Online and Desktop

The IIF route is the old advice and it still circulates on forums. We went through its failure modes in QIF to IIF for QuickBooks Desktop and why QBO is the safer import. The short version is that IIF has no review step, so a mistake lands in your books and you find it later at reconciliation.

Step 1. Export QIF from Quicken

Open the data file in Quicken Classic for Windows. Go to File, File Export, QIF File, choose one account, set the date range to cover the whole history and keep Transactions ticked. Repeat for every checking, savings, credit card and loan account you want in QuickBooks. If you are on Quicken for Mac, note that current Mac versions no longer export QIF, so open the file once in Quicken for Windows. The QIF export guide shows the dialog and the settings that matter.

Step 2. Convert each QIF to a balanced QBO file

Upload the QIF files to the converter on the convert Quicken to QuickBooks page. Each file becomes a .qbo file with every transaction balanced, including transfers and splits, which is where simple converters produce files that QuickBooks rejects with a Web Connect error. If you have many accounts, the bulk converter takes them in one batch.

Step 3. Import into QuickBooks

In QuickBooks Online go to Transactions, Bank transactions, Upload from file and choose the .qbo file, then pick the matching account. In QuickBooks Desktop use File, Utilities, Import, Web Connect Files. Both versions put the transactions in a review queue rather than posting them, which is the control you want when moving years of history. The Quicken to QuickBooks Online and QIF to QuickBooks Desktop pages give the version specific details.

A worked example with real arithmetic

Take a sole proprietor with four Quicken accounts and 2,400 transactions across 2021 to 2025. Retyping at about 25 seconds a line is 60,000 seconds, or 16.7 hours. The QIF route is four exports, four conversions and four imports, perhaps 20 minutes in total, followed by categorizing. Categorizing is the same work under any method, but QuickBooks rules reduce it fast: once you have mapped the top 30 payees, the large majority of the remaining lines categorize themselves on the next pass. The figures here are an illustration from typical file sizes, so replace them with your own transaction count to see the gap.

What does not transfer, and how to plan for it

  • Investment lots and cost basis. QuickBooks has no securities module. Keep the Quicken file read only or move holdings to a portfolio tool.
  • Quicken category names as accounts. They travel as text on each line. Create or map the matching QuickBooks accounts, then add bank rules.
  • Opening balances. Enter the balance at the start of the imported period from your first statement so the register ties to the bank.
  • Memorized payees and reports. These are Quicken settings and do not move. Rebuild the few you use in QuickBooks.

Before you commit to the move, make sure QuickBooks is the right fit for your situation. Our Quicken vs QuickBooks page compares the two for a business owner, and Intuit lists current plan prices on its QuickBooks support site. If your books grow complicated enough that you start commissioning custom integrations, a hiring platform such as developerhiring.com is where small firms find a developer for that work.

How do I transfer data from Quicken to QuickBooks Online?

Export each Quicken account as a QIF file, convert the QIF to a QBO file, then upload it in QuickBooks Online under Transactions, Bank transactions, Upload from file. The transactions appear in the review queue, where you categorize and accept them. There is no direct Quicken to QuickBooks Online import for older files.

Can QuickBooks import a Quicken QDF file?

No. A QDF is Quicken's own closed data file and QuickBooks has no import for it. Open it in Quicken, export QIF, convert to QBO and import that. Our QDF to QuickBooks page walks through the full route.

Will my Quicken categories appear in QuickBooks?

Category names come across as text on each transaction, but QuickBooks does not create accounts from them. You map them once to your chart of accounts and add bank rules so future imports categorize themselves. Expect this to take the longest of any step.

Is it better to start fresh in QuickBooks or import the history?

Import at least the current and prior year. You need the comparison for tax filing, and a lender or accountant will ask for it. Older years are optional and cost little to add once the converter is set up. If the file is large, the Web Connect import error guide covers what to do if an upload is rejected.

Move the history today

Export the QIF files, upload them to the converter, and import the QBO files into QuickBooks. If you hit a snag on a particular file, the converter page lists the checks it runs, and you can be reconciling in QuickBooks within the hour.

Convert your QIF to QBO now

Upload your Quicken QIF file and download a QuickBooks ready QBO file in seconds.

Start converting