Coming back to QuickBooks Mac from QuickBooks Online - What to Expect
After three years, QuickBooks for Mac gets an update. This month, QuickBooks for Mac 2019 finally arrives. With such a long gap in-between the releases, many of you moved to QuickBooks Online and may now wish to return. Yet, what about your company data file? Can it come back and how difficult will that be?
The biggest difficulty is getting past the fact that there is no direct route to get from QuickBooks Online to QuickBooks for Mac. You will need to export your data into QuickBooks for Windows and then convert that file into QuickBooks for Mac. Even though the process appears complicated, you can still get your data back into QuickBooks for Mac.
The following step will get you started on the standard conversion process. After reading this overview, you should have enough information to choose if conversion is right for you. Follow this sequence to help guide you.
*Note: Alternatively, you may wish to have QuickBooks Data Services perform the entire conversion for you, however, certain fees may apply. Contact support to have them initiate a Data Services case on your behalf.
Windows and IE
The first part of the conversion ONLY works with Internet Explorer. With that said, in Windows 10 it is easy to mistake the Microsoft Edge browser icon with Internet Explorer.
Should you use the wrong browser, prepare to receive this message:
Internet Explorer does not show on the application listing, but it is a built-in feature and does not need installation. To locate it search for “Internet Explorer,” and you should find it.
Where's the Export?
Select the Company Settings Gear Icon, in the upper right portion of the screen, to access the Export Data Feature.
Answer the QuickQuestion with QuickBooks Desktop in order to begin the wizard:
Important: If you're using a trial version of QuickBooks for Windows to facilitate the conversion, you may need to briefly open the Activate window. Please see this community post
Heads up - most Important information that will not come over
Some information simply cannot export and will need to be re-created. The export wizard should determine which data items you currently use in QBO that do not carry over and notify you before continuing. Please take note prior cancelling your QBO Subscription to be sure to either print or view the following if you want to re-create the data in Desktop. View the complete list, but some of the more common items are:
Recurring templates are called memorized transactions in Desktop and are used to easily enter repeating transactions
Customer Credit Card information does not export for security reasons
Locations is not a feature in QuickBooks Desktop editions and therefore cannot be recreated
Statements cannot be exported, unfortunately, yet can be recreated in QuickBooks Desktop
A note about lists...
Thecharacter limitsdid not appear to an issue for this particular file. All accounts and names came over for Chart of Accounts, Customer, Vendors and Employees
Items: Everything came over except for Bundles, which is a collection of items and services typically sold together. Those had to be recreated as Group Items in QuickBooks for Mac.
Discrepancies (The Big Reports)
Within the QBO test file, the Profit and Loss for the last fiscal year showed most Income Totals Matched. COGS was off by about $5,000 and so was Gross Profit, but that can be explained with how inventory is calculated. QuickBooks Desktop and QuickBooks for Mac both use the Average Cost method to calculate your inventory whereas QuickBooks Online uses the “First-in-first-out (FIFO)“ inventory management method.
Take note, expense totals closely match what shows in QuickBooks Online.
For the Balance Sheet, Accounts Receivable was off by about $5,000 which also skewed total current assets. However, individual asset accounts matched such as Undeposited Funds, Retainage Receivable, Checking, Savings, Petty Cash. In the end, the Total Assets were lower by about $2,000 from QuickBooks Online, but they did balance with Total Liabilities.
QBWin to QBMac
The process and differences migrating from QuickBooks for Windows into QuickBooks for Mac is even easier and less intrusive. You can save your Windows file as a Mac backup, using a special utility built into QuickBooks. Then simply restore the backup into your new QuickBooks for Mac 2019. Follow this guide for more detailed steps.
On average, the entire process may take hours*, including:
Requesting the export file from QBO
Installing a trial version of QuickBooks for Windows 2018
Importing the file into this version
Exporting to a QuickBooks for Macintosh backup file
Installing QuickBooks for Macintosh 2019
Importing the backup file from QuickBooks for Windows
*Times may vary depending on file size.
The entire process is not instantaneous and may seem complicated, but it is easier if you remember the sequence and follow the process: QBO-->QBWin-->QBMac. It certainly appears easier than starting from an old backup or starting completely over for that matter. For an easy to follow guide, please see the Visual Guide for Export.