This article provides the instructions to convert your Quicken for Mac file to QuickBooks for Mac.
QuickBooks for Mac can convert a Quicken for Mac file created with, or updated by, Quicken for Mac 2007 and newer. Ensure that Quicken for Mac is up to date.
You may need to make some changes to your Quicken Account list and Memorized Transaction list to make the transition from Quicken to QuickBooks as smooth as possible.
If you plan to continue using Quicken with this data (for example, if you had combined business and personal finances in your Quicken file), make a copy of your Quicken file to convert before you make any of the following changes. Convert only the accounts you want to use in QuickBooks Before you convert to QuickBooks, delete accounts in Quicken that you know you won't want in QuickBooks. In QuickBooks, you cannot delete accounts that contain transactions, but in Quicken you can. So it's easier to delete accounts you know you won't want before you convert.
You might want to delete some accounts from your Quicken file in the following situations:
Review your memorized and scheduled transactions QuickBooks converts the following Quicken transactions:
Make customer names consistent When you convert to QuickBooks, names in your Accounts Receivable register become customers, and transactions become invoices and payments. If you used different names for the same customer in Quicken, QuickBooks won't link the customer's invoices and payments correctly. (For example, perhaps you have your customer Daniel Miller listed as Dan Miller, D. Miller, and Daniel G. Miller.) To avoid this problem, edit your customer names in Quicken so that each customer goes by only one name.
In order to convert your file, you will need a version of QuickBooks for Mac that is of the same or newer year as your Quicken for Mac file. However, QuickBooks for Mac 2015 and newer do not have the ability to convert Quicken for Mac files. If you need it, you can use the trial version of QuickBooks for Mac 2014 to complete the conversion, then open your new QuickBooks file in your current, newer version of QuickBooks to convert it to that year.
Important: QuickBooks does not change your original Quicken files in any way.
You can continue to use those original files with Quicken. You may want to continue using Quicken for personal finance and for investment accounts. There is no connection between your Quicken data and your new QuickBooks company file. Convert your Quicken file into a QuickBooks company file
QuickBooks uses the data from your Quicken A/R account to create a QuickBooks A/R account.
If you track inventory or write purchase orders, turn on the preference for inventory and purchase orders.
If you collect sales tax from customers, turn on the sales tax preference and then set up at least one sales tax item.
For each account in the Quicken file, QuickBooks creates a balance sheet account of the type closest to the Quicken account type.
Editing your Other Names list QuickBooks places the name (or description) from every Quicken transaction (except in your A/R account) in the Other Names list. This list contains not only names of customers, vendors, and employees but also descriptions such as “Deposit,” “Transfer,” and “Interest.” If you have slightly different versions of the same name (for example, Mike Rhymes, Michael Rhymes, and Michael P. Rhymes), QuickBooks puts each version of the name on the Other Names list. You can merge similar names or move the name to other lists like the Customers List, Vendors List, and the Employees List.
Important: Merging names or moving a name from the other names list cannot be undone after you record it so be sure you select the proper names to go to the proper lists.
A name can be on only one list. If you need to have the same person or company on two lists, add a new name that is slightly different from the first name.
The transactions in your Quicken A/R account are converted in the following ways:
QuickBooks marks invoices as paid by assigning each payment it converts to the oldest invoices for that customer first.
The conversion saves you the time of typing in all your accounts receivable transactions, but you'll probably want to make some changes to the converted data.
For example, if the category you used in most A/R transactions was “Sales income,” you'll want to change the name of the converted invoice item from “Sales income” to the product or service you actually sell, such as “Consulting hours.” The converted income account, however, may be just fine as “Sales income.”
Collapse All or Expand All
Quicken Essentials for Mac does not convert directly to QuickBooks for Mac. To do the conversion, you need to: