Learn how you can export data from QuickBooks Online to QuickBooks Desktop:

Are you in pursuit of exporting your data files from QuickBooks Online to QuickBooks for Mac? This article shall provide a step-by-step and easy-to-follow crosswalk to help you reach your destination.

QB users, the majority of the time, have the proclivity to switch from QuickBooks Online to QuickBooks for Mac, which also requires exporting the data file. In simple words, in order to convert from QuickBooks online to Mac, users are supposed to export the file to QuickBooks desktop Windows and then convert the Windows file to Mac. This situation might seem to be a bit daunting to many users. Considering this, we have come up with this article, where we will be talking in detail about the entire process to export the file.

If you feel that the process of exporting data files from QuickBooks Online to QuickBooks for Mac is too technically tedious for you to handle, then, in that case, feel free to connect with accounting experts directly.

Read Also: How to Resolve QuickBooks Error Code C=47?

Important pointers

  • You need to use a Windows system with internet explorer 11 or higher when exporting the data file.
  • QuickBooks Desktop for Windows should be of the same version or earlier than QuickBooks Desktop for Mac. To understand it better, we will take an example that if you are exporting to QuickBooks for Mac 2016, then you need to make use of QuickBooks for Windows 2016 or earlier versions.
  • Also, ensure that QuickBooks for Mac is updated to the latest release before converting the file to Mac.

Steps to Convert QBO File to QuickBooks Desktop for Mac

You can simply convert QuickBooks online data file to QuickBooks for Mac, by carrying out the below-mentioned steps:

Step 1: At the start, Export the data from online to Desktop.

Export the data from online to desktop - Screenshot Image

Step 2: Subsequently, convert the Windows company file to Mac.

Adhere to the following steps to proceed with the conversion process:

  • Access your company file in the QuickBooks Desktop for Windows software.
  • Afterward, re-sort Lists.
  • Then, you are required to Rebuild and verify the data file.
  • Subsequently, move to the File menu and choose the Utilities option.
  • From the Utilities option, copy the company file for QuickBooks desktop for Mac.
copy company file for QuickBooks desktop for Mac - Screenshot Image
  • Now, you need to save the file at the desired location. This will create a file with the extension MAC.qbb
  • Once you implemented the preceding steps, it is pertinent to restore the file in QuickBooks desktop for Mac.
    • For this, choose to Browse in the No Company open window and locate the file you wish to restore. It should be borne in mind that if the QuickBooks Windows file is on an external drive, save it locally by dragging it to the desired location before restoring it. This process shall avoid any data corruption.
    • Afterward, hit the OK button when a prompt asks if you want to Restore a QuickBooks desktop for a Windows file.
    • Next, enter a name for the restored file and hit on Save.

You may also see: How to Turn on Advanced Inventory in QuickBooks Enterprise?


Well, now that you have arrived at this article’s conclusion, we are hopeful that you must be well versed in the process of exporting data files from QuickBooks Online to QuickBooks for Mac. However, in case you face any impediment or have any related query, you can unhesitatingly contact our QuickBooks support team directly via our U.S based helpline number, i.e., 1-800-761-1787, and they will handle the situation for you.


Can I export my data file directly from QuickBooks Online to QuickBooks for Mac?

No! There is no direct method to export your data file from QuickBooks Online to Mac.

What data can be transferred from QuickBooks Online to MAC?

Users can transfer data such as customer information, vendor information, chart of accounts, transactions (invoices, bills, payments, etc.), and some reports from QuickBooks Online to QuickBooks for Mac.

Can I import my QuickBooks Online backup file (.QBO) into QuickBooks for Mac?

No! The .QBO file format used for QuickBooks Online backup files is incompatible with QuickBooks for Mac.

Will all my customizations and settings in QuickBooks Online be preserved after exporting to QuickBooks for Mac?

Not all customizations and settings may be preserved during the export process. Some features and settings in QuickBooks Online may not have direct equivalents in QuickBooks for Mac.


Suggested Reads:

Upload or Download QuickBooks Desktop Company File to Intuit

Configure firewall and security settings for QuickBooks desktop

How to Resolve QuickBooks Error 1601, 1603 and 1642?

Call Now +1-800-761-1787