If you want to migrate from QBO CA to QBD CA, there are 2 options:
1. Export your data out of QBO and import them into QBD (e.g QBW file) using a 3rd party migration tool
2. Purchase a 3rd party migration service
Welcome to the QuickBooks Online community! Fiat Lux is off to a great start here letting you know about the third-party options that can get your data from QuickBooks Online to QuickBooks Desktop. I know how important it is to make sure you're using the correct product for your business, and I want to shed light on what the options are so far as Intuit's process.
At this time, there isn't a way for QuickBooks Online to be migrated to QuickBooks Desktop for Canada. There are, however, certain lists and other details you can move from your QuickBooks Online to the Desktop platform so you're not starting your company file completely from scratch. Here's more information on that: Move lists and balances from QuickBooks Online to QuickBooks Desktop
Feel free to review that article and let me know if you have further questions about it. I hope you have a great week!
Thanks for the steps you provided to transfer lists and balances from QB online to QB Desktop.
Just want to know when you transfer balances, it will be the balance on the day you export the data to Excel, correct?
Sorry I am asking as our company file as all data entered since the start of business from Nov 2019 to June 2020 some data entered for July 2020 to December 2020. Once I transfer the balances which would be as of today, would I just post all revenue and expenses that were not entered in QB Online?
I hope I explained the situation clearly.
That's correct, the balances will be as of the date of the transfer. Any transactions from July 2020 to December 2020 that weren't entered into QuickBooks Online prior to exporting your data to Excel will need to be entered into QuickBooks Desktop Pro after importing the Excel data.
Let me know if there's anything else I can help with!
Thanks for the follow-up question, and I can confirm how this process works when you move from QuickBooks Online to QuickBooks Desktop so that you know how to get started.
Using the steps in the article I shared previously, it's possible to export and import some list information and then enter opening balances to the profiles. When you add an opening balance to a customer or vendor profile, that creates a transaction that you can enter payments against. This means if you were also to enter the actual transactions, your figures would duplicate.
If you'd like to enter the transactions themselves rather than the opening balances, I recommend considering a third-party app. At this time, there isn't a built-in option to move transactions from QuickBooks Online to QuickBooks Desktop, but a third-party app can fill in the gap. I see Fiat Lux has suggested one to you, or you can also check the Apps tab in QuickBooks Online as well as the Apps for QuickBooks Desktop page to see which options are available in both programs. Here, it'll be important that whatever tool or service you use can connect with both to ensure that you're able to seamlessly move the information.
I hope this helps clarify things, but don't hesitate if you have further questions.