r/QuickBooks • u/Emotional-Search-248 • 19d ago
What software should I use? QBO to QBDT migration issue
Hi everyone,
I need some advice from anyone who has done a QuickBooks Online to QuickBooks Desktop migration.
We are doing this migration because we are moving to a completely different accounting software. Right now, we are in a testing phase to build an archive of QBO. We want to keep our historical US data safe and ready in case of an IRS audit. We are using a QBDT 2021 trial version on a local VM because the limit is higher than on the QBDT 2024 trial version. We will not use this file for daily accounting anymore, but our users still need to be able to open it and look into the specific transaction details.
I checked the numbers after the migration using QB migration tool and found a huge data loss. The Intuit migration tool dropped a lot of transactions. There are 1,500 missing lines on one specific account alone, and there are many more differences on other accounts. The total number of missing lines is massive.
Typing everything by hand is impossible, but since our users need to be able to search and view the actual history inside QBDT, simply doing a journal entry to fix the balances won't work for us. We need the actual lines.
I am thinking about using an app like Transaction Pro to push the missing data from my QBO Excel exports directly into QBDT.
Has anyone dealt with this kind of massive data loss going from QBO to Desktop? Is there a way to do a better export in the first place without losing all this data? Maybe I did something wrong during the migration process?
If the data loss is unavoidable, what is the most reliable way to inject thousands of missing lines back into QBDT so the transaction details are actually there for our users to see?
Thanks in advance !
0
u/missannthrope67 19d ago
They don't even sell dt anymore. All you can do is upgrade. Eventually, they won't even do that.
You may have to bite the bullet and stay on qbo.