I want to convert Quicken 2015 for Mac to Quicken 2015 for Windows.

tetrumantetruman Member
edited August 2018 in

QXF files do not support investment accounts, but Quicken 2015 for Mac does not provide the option of exporting QIF.

How can I do this conversion?

Comments

  • smayer97smayer97 SuperUser ✭✭✭✭✭
    edited August 2018

    Unfortunately, at this time there is no easy way to do this.

    If you find this reply helpful, please be sure to click "Like", so others will know, thanks.

    (Canadian  user since '92, STILL using QM2007)

    Have Questions? Check out these FAQs:
  • SilverthunderSilverthunder Member ✭✭
    edited August 2018

    If the goal is to convert the file over as best as possible, what are the steps? I found some instructions but they seem outdated as these instructions don't apply to current version of Mac.


    The first thing that I am stumped on is the part about switching the system preferences over to "international" (underlined 3 paragraphs below)


    Before beginning the conversion process, you must verify your date and time settings, and then restart your Macintosh computer if you make any changes.



    For Mac OS 9:
    1. From the Apple menu, choose Control Panels.
    2. Open the Date & Time Control Panel.
    3. Click the Date Format button.
    4. Verify that the Region option is set to U.S.
    5. Under the Short Date section, select the Show Century option unless you are converting to Quicken 98 for Windows. When you choose Show Century, the Region will change from US to Custom.
    6. Click OK in the Date Format window, and then close the Date & Time Control Panel.
    7. Restart your Macintosh.
    For Mac OS X or higher:
    1. From the Apple menu, choose System Preferences.
    2. Double-click the International icon.
    3. Click the Date tab, and then select the Show century checkbox. When you select Show Century, the Regionwill change from US to Custom.
    4. Close the International window, and then restart your Macintosh.
    Prepare your Quicken for Mac data for conversion:
    1. From the Quicken for Mac Lists menu, select Accounts. Verify that the Show Hidden Accounts box is selected.
    2. Rename any account names, security names, categories, classes, and account description fields to comply with these guidelines:

      • Names cannot contain special characters such as *, &, <, />, %, #, @, :, $, ~, ^, or }.
      • Categories and Accounts cannot have the same name. For example, if you have a category and an account both named Petty Cash, you must rename one of them.
      • An account cannot be named Cash. If an account is named Cash, rename it to Cash Account or something else.
    1. Edit any transactions in your register affected by the following:
      • Category and Class fields cannot contain more than 29 characters.
      • Transactions cannot contain more than 30 split lines. If your transactions have more than 30 split lines, create new transactions to accommodate the excess split lines.
      • Make sure that all online transactions have been accepted into the register, and that the Download Transactions window contains no outstanding transactions.
      • Delete all pending online payments.
    2. From the List menu, select Securities. All securities should have an uppercase ticker symbol associated with them. If a security does not have a symbol associated with it, its price history will not be exported.
    3. Reindex the data file by pressing Command+Option+B on the keyboard at the same time.
    4. Save a copy of your file, and then open the copy:
      1. From the File menu, choose Save a Copy.
      2. In the Save a Copy window, you can specify a specific date range to be included in the file. To include uncleared transactions dated prior to the specified date range, select Include prior uncleared transactions.
      3. Click OK.
      4. In the Save window, specify Desktop as the location, enter a unique name for this file (such as Conversion Copy), and then click Save.
      5. From the File menu, choose Open, and then open the new copy (Conversion Copy) from the Desktop.
    5. Print your account list for use in comparing balances after the data is imported into Quicken for Windows:
      1. From the Lists menu, select Accounts to open the Account list.
      2. Select Print Accounts from the File menu, and then click the Print button.
    Create a QIF (Quicken Interchange Format) file for import into Quicken for Windows:
    1. In the copy that was created of your file (Conversion Copy), choose Export from the File menu.
    2. Full Export will be selected in the Export Window. This option will convert all accounts, categories, and transactions to Quicken for Windows. If you want to export only part of your file, select the Custom Exportoption, and then specify what to include in the export.

      Note: In some versions of Quicken for Mac, the option to export online payees is available, but should not be selected because they cannot be imported into Quicken for Windows.
    3. Click the Export button.
    4. In the Save window, name the file Export.qif and save it. For the file to be properly recognized when importing it into Quicken for Windows, it must contain the extension .qif after the filename.
    5. Insert a PC-formatted floppy disk in the Macintosh's disk drive and copy the Export.qif file to it.
    On your computer running Microsoft Windows, before opening Quicken for Windows, check your date and time settings:
    1. Click the Microsoft Windows Start menu, choose Settings, and then choose Control Panel.
    2. Double-click the Date/Time control panel.
    3. Verify that the correct Time Zone is selected, and then click OK.
    4. Double-click the Regional Settings control panel.
    5. On the Date tab, verify that the Short date style and Long date style are set to four digit years (yyyy), and then click OK.
    Create a Quicken for Windows file (if you have not already):
    1. In Quicken for Windows, choose New from the File menu.
    2. Click OK to create a new file instead of a new account.
    3. Name the file using eight characters or less, and containing no blank spaces, and then click OK. This will be your new Quicken data file, so name it accordingly.
    4. Complete the Create New Account Wizard, using all the default settings. In Quicken 2003, click Exit Setupin the Guided Setup window.

      Note: If you are prompted to choose a financial institution, type None in the Financial Institution field, and then click Next.
    Import the Macintosh QIF file:
    1. Click the File menu, point to Import, and then select QIF file. (In Quicken 98 for Windows, click File, point toFile Operations, and then select Import.)
    2. Click Browse and locate the Export.qif file on your floppy disk. (In Quicken 98 for Windows, click Find File to locate the file on your floppy disk.)
    3. In the QIF Import window, select Transactions, Account List, Security list, Category list, and Special Handling for Transfers.
    After your file imports:
    1. For each banking account in Quicken for Windows 2001 and later, it will be necessary to Accept Alltransactions in the Compare to Register screen. The Compare to Register screen will be in each banking account register. After accepting the transactions, click Done.
    2. Compare the account balances in your Quicken for Windows file to the balances on the list you printed from Quicken for Mac. If the account balances in your Quicken for Windows differ from those in your Quicken for Mac file, you must find the discrepancy and manually enter or edit the transactions.
      1. The most common causes of a discrepancy between account balances are transfers to other accounts within split transactions that have become duplicated. The original split transaction appears with the correct amount, but the transfer component of the transaction is reflected in a completely separate, new transaction.

        This new transaction generates a duplicate of the transfer amount contained in the original transaction, thus causing your account balance to be incorrect. To correct this, isolate and delete the duplicate transfer transactions and reenter the transfer category into the original split transaction.
      2. If your file seems as though it is missing data that should have been included, create a new Quicken file and import items individually.
    3. Rebuild the Memorized Transaction list by holding down the Shift key on your keyboard and selectingMemorized Transactions from the Cash Flow menu. (In Quicken for Windows 2002, 2001, or 2000, hold down Shift and select Memorized Transactions from the Banking menu. In Quicken for Windows 98 or 99, hold down Shift and select Memorized Transactions from the Lists menu.)
    4. Re-enable your accounts for online services, if applicable:
      1. Open the account register, select Enable your Quicken account from the top, and then follow the onscreen instructions.
      2. After your accounts are enabled, complete an online session. Because of the change of platform (Macintosh to Windows), every transaction available online from your financial institution will be downloaded in your first online session.

        The number of transactions downloaded varies. Some financial institutions have 60 to 90 days of transaction history available, while others may have up to one year of transaction history. The downloaded transactions should match those already in your register, and in Quicken for Windows 2001 and later, will need to be processed in the Compare to Register screen.
      3. Your Online Payee list may be populated by the downloaded transactions. Any missing payees will need to be manually entered.
    1. Recreate any loans and budgets.
    If this solution does not resolve the issue, please review other available QuickBooks support options for additional guidance. You can also read and post messages relating to your issue on the QuickBooks Community forums.


    Your opinion counts! Please use the voting and feedback buttons to help us build a better knowledge base
  • smayer97smayer97 SuperUser ✭✭✭✭✭
    edited December 2016


    If the goal is to convert the file over as best as possible, what are the steps? I found some instructions but they seem outdated as these instructions don't apply to current version of Mac.


    The first thing that I am stumped on is the part about switching the system preferences over to "international" (underlined 3 paragraphs below)


    Before beginning the conversion process, you must verify your date and time settings, and then restart your Macintosh computer if you make any changes.



    For Mac OS 9:


    1. From the Apple menu, choose Control Panels.
    2. Open the Date & Time Control Panel.
    3. Click the Date Format button.
    4. Verify that the Region option is set to U.S.
    5. Under the Short Date section, select the Show Century option unless you are converting to Quicken 98 for Windows. When you choose Show Century, the Region will change from US to Custom.
    6. Click OK in the Date Format window, and then close the Date & Time Control Panel.
    7. Restart your Macintosh.
    For Mac OS X or higher:
    1. From the Apple menu, choose System Preferences.
    2. Double-click the International icon.
    3. Click the Date tab, and then select the Show century checkbox. When you select Show Century, the Regionwill change from US to Custom.
    4. Close the International window, and then restart your Macintosh.
    Prepare your Quicken for Mac data for conversion:
    1. From the Quicken for Mac Lists menu, select Accounts. Verify that the Show Hidden Accounts box is selected.
    2. Rename any account names, security names, categories, classes, and account description fields to comply with these guidelines:

      • Names cannot contain special characters such as *, &, <, />, %, #, @, :, $, ~, ^, or }.
      • Categories and Accounts cannot have the same name. For example, if you have a category and an account both named Petty Cash, you must rename one of them.
      • An account cannot be named Cash. If an account is named Cash, rename it to Cash Account or something else.
    1. Edit any transactions in your register affected by the following:
      • Category and Class fields cannot contain more than 29 characters.
      • Transactions cannot contain more than 30 split lines. If your transactions have more than 30 split lines, create new transactions to accommodate the excess split lines.
      • Make sure that all online transactions have been accepted into the register, and that the Download Transactions window contains no outstanding transactions.
      • Delete all pending online payments.
    2. From the List menu, select Securities. All securities should have an uppercase ticker symbol associated with them. If a security does not have a symbol associated with it, its price history will not be exported.
    3. Reindex the data file by pressing Command+Option+B on the keyboard at the same time.
    4. Save a copy of your file, and then open the copy:
      1. From the File menu, choose Save a Copy.
      2. In the Save a Copy window, you can specify a specific date range to be included in the file. To include uncleared transactions dated prior to the specified date range, select Include prior uncleared transactions.
      3. Click OK.
      4. In the Save window, specify Desktop as the location, enter a unique name for this file (such as Conversion Copy), and then click Save.
      5. From the File menu, choose Open, and then open the new copy (Conversion Copy) from the Desktop.
    5. Print your account list for use in comparing balances after the data is imported into Quicken for Windows:
      1. From the Lists menu, select Accounts to open the Account list.
      2. Select Print Accounts from the File menu, and then click the Print button.
    Create a QIF (Quicken Interchange Format) file for import into Quicken for Windows:
    1. In the copy that was created of your file (Conversion Copy), choose Export from the File menu.
    2. Full Export will be selected in the Export Window. This option will convert all accounts, categories, and transactions to Quicken for Windows. If you want to export only part of your file, select the Custom Exportoption, and then specify what to include in the export.

      Note: In some versions of Quicken for Mac, the option to export online payees is available, but should not be selected because they cannot be imported into Quicken for Windows.
    3. Click the Export button.
    4. In the Save window, name the file Export.qif and save it. For the file to be properly recognized when importing it into Quicken for Windows, it must contain the extension .qif after the filename.
    5. Insert a PC-formatted floppy disk in the Macintosh's disk drive and copy the Export.qif file to it.
    On your computer running Microsoft Windows, before opening Quicken for Windows, check your date and time settings:
    1. Click the Microsoft Windows Start menu, choose Settings, and then choose Control Panel.
    2. Double-click the Date/Time control panel.
    3. Verify that the correct Time Zone is selected, and then click OK.
    4. Double-click the Regional Settings control panel.
    5. On the Date tab, verify that the Short date style and Long date style are set to four digit years (yyyy), and then click OK.
    Create a Quicken for Windows file (if you have not already):
    1. In Quicken for Windows, choose New from the File menu.
    2. Click OK to create a new file instead of a new account.
    3. Name the file using eight characters or less, and containing no blank spaces, and then click OK. This will be your new Quicken data file, so name it accordingly.
    4. Complete the Create New Account Wizard, using all the default settings. In Quicken 2003, click Exit Setupin the Guided Setup window.

      Note: If you are prompted to choose a financial institution, type None in the Financial Institution field, and then click Next.
    Import the Macintosh QIF file:
    1. Click the File menu, point to Import, and then select QIF file. (In Quicken 98 for Windows, click File, point toFile Operations, and then select Import.)
    2. Click Browse and locate the Export.qif file on your floppy disk. (In Quicken 98 for Windows, click Find File to locate the file on your floppy disk.)
    3. In the QIF Import window, select Transactions, Account List, Security list, Category list, and Special Handling for Transfers.
    After your file imports:
    1. For each banking account in Quicken for Windows 2001 and later, it will be necessary to Accept Alltransactions in the Compare to Register screen. The Compare to Register screen will be in each banking account register. After accepting the transactions, click Done.
    2. Compare the account balances in your Quicken for Windows file to the balances on the list you printed from Quicken for Mac. If the account balances in your Quicken for Windows differ from those in your Quicken for Mac file, you must find the discrepancy and manually enter or edit the transactions.
      1. The most common causes of a discrepancy between account balances are transfers to other accounts within split transactions that have become duplicated. The original split transaction appears with the correct amount, but the transfer component of the transaction is reflected in a completely separate, new transaction.

        This new transaction generates a duplicate of the transfer amount contained in the original transaction, thus causing your account balance to be incorrect. To correct this, isolate and delete the duplicate transfer transactions and reenter the transfer category into the original split transaction.
      2. If your file seems as though it is missing data that should have been included, create a new Quicken file and import items individually.
    3. Rebuild the Memorized Transaction list by holding down the Shift key on your keyboard and selectingMemorized Transactions from the Cash Flow menu. (In Quicken for Windows 2002, 2001, or 2000, hold down Shift and select Memorized Transactions from the Banking menu. In Quicken for Windows 98 or 99, hold down Shift and select Memorized Transactions from the Lists menu.)
    4. Re-enable your accounts for online services, if applicable:
      1. Open the account register, select Enable your Quicken account from the top, and then follow the onscreen instructions.
      2. After your accounts are enabled, complete an online session. Because of the change of platform (Macintosh to Windows), every transaction available online from your financial institution will be downloaded in your first online session.

        The number of transactions downloaded varies. Some financial institutions have 60 to 90 days of transaction history available, while others may have up to one year of transaction history. The downloaded transactions should match those already in your register, and in Quicken for Windows 2001 and later, will need to be processed in the Compare to Register screen.
      3. Your Online Payee list may be populated by the downloaded transactions. Any missing payees will need to be manually entered.
    1. Recreate any loans and budgets.
    If this solution does not resolve the issue, please review other available QuickBooks support options for additional guidance. You can also read and post messages relating to your issue on the QuickBooks Community forums.


    Your opinion counts! Please use the voting and feedback buttons to help us build a better knowledge base
    As the OP pointed out, QM2015 does not allow exporting data in QIF format, so none of these instructions are of any benefit.

    If you find this reply helpful, please be sure to click "Like", so others will know, thanks.

    (Canadian  user since '92, STILL using QM2007)

    Have Questions? Check out these FAQs:
Sign In or Register to comment.