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

QuickBooks users, majority of the times 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, the user is supposed to export the file to QuickBooks desktop windows and then convert the windows file to Mac. Such a 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, the entire process to export the file.

Thus, we recommend you to read this article carefully till the end. Moreover, if you feel the process of exporting data file from QuickBooks online to QuickBooks for Mac to be too technical for you to handle, then in that case, feel free to connect with accounting experts directly.

Read Also: Different Windows 10 Versions that work best for QuickBooks Desktop

Important pointers

  • The user needs 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

The user can simply convert QuickBooks online data file to QuickBooks for Mac, by carrying out the steps below:

Step 1: The very first step is to export the data from online to desktop

Export the data from online to desktop - Screenshot Image

Step 2: And then, convert the windows company file to Mac

  • The user needs to open the company file in QuickBooks desktop for Windows
  • After that, re-sort lists
  • And rebuild and verify the data file
  • The next step is to move to the file menu and choose the utilities and then copy company file for QuickBooks desktop for Mac
copy company file for QuickBooks desktop for Mac - Screenshot Image
  • Now, the user needs to save the file in the desired location. This will create a file with the extension MAC.qbb
  • And after that, it is important to restore the file in QuickBooks desktop for Mac
    • For this, the user needs to select browse in the no company open window, and after that locate the file the user wishes to restore. It should be noted that if the QuickBooks windows file is on an external drive, then it is important to save it locally by dragging it to the desired location before restoring it to avoid data corruption.
    • The user will then have to select OK button when a prompt appears asking if the user wants to restore a QuickBooks desktop for windows file
    • And then enter a name for the restored file and hit save

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


Well, now that you have arrived to the bottom of this article, we believe that you might be well versed with the process to export data file from QuickBooks online to QuickBooks for Mac.

However, in case you have any doubt remaining or for any further information, you can simply 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.


Suggested Reads:

How to Install and use QuickBooks database server manager?

Configure firewall and security settings for QuickBooks desktop