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, 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, the entire process to export the file.

So, we recommend you to read this article carefully till the end. However, 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

  • 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 steps below:

Step 1: First of all, you have 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.

  • 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 you need 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, select browse in the no company open window, and after that locate the file you 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.
    • You will then have to select OK button when a prompt appears asking if you want to restore a QuickBooks desktop for windows file.
    • Now 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

How to Resolve QuickBooks Error 1601, 1603 and 1642?