What we do
Tools
Industries
Department
How we workLet's talk →
Home/QuickBooks/How to Convert a Quicken File to QuickBooks
Moving off Quicken

How Do I Convert a Quicken File to QuickBooks, and What Has to Be Rebuilt After?

The conversion happens in QuickBooks Desktop. Choose File › Utilities › Convert › From Quicken, pick your Quicken data file (the .QDF), and QuickBooks builds a new company file from it. Quicken's file isn't touched. QuickBooks Online has no converter of its own, and Intuit's tools can't convert a Quicken for Mac file at all.

Short answer

Quicken and QuickBooks Desktop from matching years: run the converter built into QuickBooks and select the .QDF.

File Utilities Convert From Quicken

Quicken from a different year: first download Intuit's Quicken Converter for your QuickBooks Desktop year. It saves a converted copy of the .QDF, which you then feed to the step above.

Heading for QuickBooks Online: convert into Desktop first, then move that company file to Online, or start a fresh Online company and bring in only recent bank activity. Moving from Desktop to Online covers the second hop.

Questions to settle before the conversion runs

  • Is this a Quicken for Windows file?

    Intuit says neither the Quicken Converter nor the conversion utility can move a Quicken for Mac file. On a Mac, plan on a new QuickBooks company with opening balances instead.

  • Is there a backup of the .QDF somewhere safe?

    Quicken's own support says the move only goes one way: QuickBooks data can't be turned back into Quicken. Convert a copy and keep the original.

  • Does your Quicken year match your QuickBooks Desktop year?

    If it doesn't, you need the Quicken Converter download for your QuickBooks year, and Intuit says to uninstall any other converter version first.

  • Which accounts hold investments?

    Brokerage and retirement accounts are the part most likely to need rebuilding by hand. Write down each one's holdings and cost before you start.

  • Is it all business, or mixed with household money?

    Personal categories come across as accounts too. Decide now whether the business gets a clean start or carries the full history.

Running Intuit's conversion, start to finish

  1. 1

    Back up the Quicken file

    Make a backup in Quicken and keep it separate from the copy you convert.

  2. 2

    Run the Quicken Converter, if your years differ

    Install the converter that matches your QuickBooks Desktop year and launch it. Choose I am transferring data from Quicken for Windows, then Get Started, Open a data file located on this computer and Select File. Pick your .QDF, select Convert it!, and Save the new file.

    Watch for: the two files it creates. Use the .QDF, not the .QFX. It sits in a folder named QXXFiles (XX is the version) next to your original file.

  3. 3

    Convert in QuickBooks Desktop

    File Utilities Convert From Quicken

    Select the .QDF and follow the prompts in the Conversion Utility. QuickBooks creates a new company file with your accounts, payees and transaction history.

  4. 4

    Tie the numbers out before you add anything

    Compare each account's balance with Quicken's on the same date, and run a trial balance to see where things landed. Leftover differences often park in Opening Balance Equity.

    Watch for: the urge to start entering this month's work first. Fixing a conversion under a month of new entries is much harder.

What comes through wrong, or not at all

Investment accounts are missing or empty

How you'll know: Your brokerage account isn't in the new file, or it's there with no holdings.

Fix: Intuit's conversion article doesn't promise investment accounts carry over. Set each one up again as an asset account at cost. Recording stock investments shows the entries.

Household categories are now business accounts

How you'll know: The chart of accounts has Groceries, Gifts and Auto:Fuel next to Cost of Goods Sold.

Fix: Merge or rename them into accounts a business would use, and make anything personal inactive. Merging two accounts covers it.

Personal spending sits in the business books

How you'll know: Mortgage payments and family transfers show up as expenses on the profit and loss.

Fix: Recode them to an owner's draw or equity account rather than an expense. How far back to clean up is generally a question for your accountant.

The conversion stops partway or brings in only some accounts

How you'll know: An error, or a company file with fewer accounts than Quicken had.

Fix: Check that missing accounts weren't hidden or inactive in Quicken, then press F1 in QuickBooks Desktop and search "convert from Quicken" for Intuit's troubleshooting. Quicken's support notes that starting a new file can be easier than forcing a stubborn conversion.

Quicken, QuickBooks and the Online question

What is the difference between Quicken and QuickBooks?

Quicken tracks money from the household side: spending, budgets, bills and investments, with some small-business features in Home & Business. QuickBooks keeps a business's books: invoicing customers, paying vendors, payroll, sales tax, and the reports an accountant or lender expects.

Can you convert a QuickBooks file back to Quicken?

No. Intuit's tools only move data from Quicken into QuickBooks, and Quicken's own support says QuickBooks data can't be converted back. That's why the backup of your .QDF matters.

Does the Quicken to QuickBooks conversion work from QuickBooks Online?

Not directly. The converter is part of QuickBooks Desktop. Intuit's community answers suggest converting in a copy of QuickBooks Desktop, then moving that company file to Online. The other route is a new Online company with opening balances and the bank feed, leaving older history in Quicken for reference.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.