Skip to main content
February 2, 2024
Question

Migrating from QuickBooks Online to QuickBooks Enterprise

  • February 2, 2024
  • 2 replies
  • 0 views

I recently switched from QuickBooks Enterprise to QB Online. It was not working out for us at all. I have followed the instructions to switch back to QuickBooks Enterprise but now the Balance sheet from QB Enterprise does not match the Balance sheet from QBO. How do I figure out what is wrong. I used the exportqbodatatoqbdt to migrate the data. It took several hours. The Profit and Loss Report matches but not the balance sheet. Please help me. I am stumped.

2 replies

BigRedConsulting
February 3, 2024

RE: I recently switched from QuickBooks Enterprise to QB Online. It was not working out for us at all.

 

That's not surprising as you went from the most full-featured version of QuickBooks to the least.

 

I don't think you'll be able to fully get back to what you had in Enterprise. Much is lost when you "round trip" like this. It might be better to go back to your original Enterprise file and then reenter data.

February 3, 2024

Hello there, @tcberry22.

 

Let me share information about migrating from QuickBooks Online (QBO) to QuickBooks Desktop (QBDT).

 

There are instances that reports don't match when migrating from QBO to QBDT due to export limitations and the use of unsupported versions of Internet Explorer.

 

Here's what you can do to fix this:

 

  1. On QuickBooks Desktop, go to File, and select Close company.
  2. Go back and try to convert your file again. Sometimes converting a second time can fix this problem.
  3. After it finishes, check the Profit and Loss reports again. If they still don’t match, enter manual adjustments to fix the issue.

 

You can read more information in this article: Move your QuickBooks Online data to QuickBooks Desktop.

 

For additional reference, you can use the following articles to learn what steps to perform if reports mismatch, as well as how to save a copy of my QuickBooks Online data:

 

 

Let me know if you have questions about migrating QuickBooks Online to QuickBooks Desktop. I'm always here to help. Have a great day.

tcberry22Author
February 3, 2024

When you say to try converting the file again, do you mean using the migrate tool? The profit and loss reports are correct. It's the balance sheet that is incorrect. The checking account balance is the main one that I'm concerned about.

February 3, 2024

Thank you for coming back to the Community, tcberry22.

 

It's concerning that the Balance Sheet report from the desktop program doesn't match with the one in QuickBooks Online (QBO). I'm here to assist you in ensuring the data on the financial statement is correct.

 

If you switch from QBO to QuickBooks Desktop (QBDT), you might see changes in the appearance of your books. This happens because of export limitations and unsupported versions of Internet Explorer.

 

After exporting your company, compare the Balance Sheet reports from QBDT and QBO. Make sure to set the accounting method to the accrual basis. 

 

If there's a discrepancy in the report, convert your file again using the migration tool. Keep in mind that the process may take some time to complete.

 

You can find more information about how the migration tool works in this article: QuickBooks Desktop Migration Tool FAQ. It provides answers to commonly asked questions about the utility.

 

Once completed review the Balance Sheet reports again. If you continue to get the same result, enter a manual adjustment to rectify the issue. 

 

Moreover, these resources provide a comprehensive list of tasks that you'll have to complete after converting from both programs. Make sure to check out each link below for detailed instructions:

 

If you require more information about the migration process or have any additional queries regarding how to rectify the data in your financial reports, feel free to let me know in the comments below. I'm here to help and offer the necessary guidance. Have a good one, @tcberry22