There are several reasons why migrating from QuickBooks Desktop 2019 to QuickBooks Online may lead to missing transactions or blank account balances. Below is a clear explanation of possible causes and the steps you can take to resolve the issue.
Possible Causes
1. Partial data migration or incorrect selection during migration
During the migration process, QuickBooks allows you to choose whether to bring all company data or only lists and balances. If only lists and balances were selected, detailed transaction history will not transfer. If the migration was interrupted or the Desktop file had errors, large data size, or unsupported items, some data may be missing in QuickBooks Online.
2. File size or complexity exceeded migration limits
Large Desktop company files containing many transactions, links, or inventory activity may exceed the migration limits. When this happens, QuickBooks may skip or fail to transfer parts of the data. Certain data types, such as complex inventory or custom fields, may also require manual adjustments after migration.
3. Mismatched setup or differences in company file settings
If the migration was imported into the wrong QuickBooks Online company file or if the region, currency, fiscal year, or accounting settings do not match between Desktop and Online, balances may appear blank or incorrect. Opening balances may also fail to transfer properly if the setup is mismatched.
4. Post-migration setup not completed
After migration, QuickBooks recommends reviewing reports such as the Balance Sheet and Profit and Loss. If the Chart of Accounts did not transfer correctly or accounts were recreated with missing data, the balances may appear blank. Incomplete setup steps can also cause accounts to show zero when they should display balances.
5. Date ranges or filters hiding data
If the migration applied a cutoff date or if QuickBooks Online is filtered to show only recent activity, older transactions may not appear. Viewing a restricted date range can make it look like the data did not migrate even when it is present but hidden by filters.
Steps to Fix the Issue
1. Review what data was migrated
Check the migration log or the Imported Data section in QuickBooks Online to confirm what was transferred and whether any errors occurred. Compare reports in QuickBooks Desktop, such as the Balance Sheet and Profit and Loss, up to the migration date. Verify whether you selected the option to bring all data or only lists and balances.
2. Compare key reports between Desktop and Online
Run the same date range in both QuickBooks Desktop and QuickBooks Online and compare totals. If the Desktop reports show balances that do not appear in Online, this indicates missing data during migration.
3. Review the Chart of Accounts in QuickBooks Online
Confirm that all accounts from Desktop exist in QuickBooks Online. Missing accounts will naturally display blank balances. Check whether opening balances transferred correctly and whether account types match between Desktop and Online.
4. Identify unsupported or partially migrated items
Certain data does not migrate automatically, such as custom templates, memorized transactions, and some inventory data. If your Desktop file included complex inventory features, multi currency, or assemblies, some balances may need to be entered manually in QuickBooks Online.
5. Re run the migration or bring missing data manually
If large portions of data were not transferred, you may need to migrate again into a new QuickBooks Online company file. Make sure to choose the option to bring all transaction data and confirm the Desktop file is valid, backed up, and within size limits. You can also import missing transactions or balances manually using QuickBooks import tools or a third party migration service.
6. Contact support or work with an accountant
If the migration log shows errors or significant gaps in data, contact QuickBooks support for assistance. For complex or large files, it may be helpful to work with an accountant or a QuickBooks ProAdvisor experienced in Desktop to Online migrations within the United States.