Missing Checks After a QuickBooks Online to Desktop Conversion: How to Decide Between
A converted QuickBooks Desktop file with missing checks and broken quarterly reports can be fixed three ways. Here is how our engineers choose between them.
A QuickBooks Online to Desktop conversion is not a clean copy. It rebuilds your company file from an export, and the export skips things: some check types, audit history, and links that reports depend on. The usual symptoms arrive together. Checks are missing from the register, quarterly reports refuse to run or come out wrong, and reconciliations no longer tie.
There are three ways forward, and picking the wrong one wastes days. Our engineers work through the decision in a fixed order.
What to check before deciding anything
First, quantify the damage. Do not trust a single report.
- Open the file in single-user mode as the admin.
- Run a balance sheet and a profit and loss for the full converted period, on both accrual and cash basis. Compare each against the same reports in QuickBooks Online.
- Run a check register detail report for each quarter and count the checks against the Online register.
- Run Verify (File, then Utilities) and note any errors it reports.
Write the differences down. A file with three missing months needs a different fix than one with a handful of stray checks.
Make a full backup (.QBB) before touching anything, and keep the QuickBooks Online subscription active until the Desktop file is proven correct. Once you cancel, the source data is gone.
Option one: redo the conversion
Redoing makes sense when the gaps are broad and systematic. If whole quarters of checks are absent, the export itself likely failed partway or the trial balance import truncated.
The export from QuickBooks Online has known limits. It carries a date range you choose, and anything outside that range is simply not in the Desktop file. Inventory assemblies, multicurrency, and automated sales tax do not convert cleanly. Our engineers cover what the built-in export misses in detail on the QuickBooks Online to Desktop conversion page.
To redo it:
- Export a fresh trial balance and lists from QuickBooks Online, this time in smaller date chunks, one year or less per pass.
- Import each chunk into a new, empty Desktop company file. Never import into the damaged one.
- Reconcile each imported year against the Online reports before moving to the next.
- Re-enter anything the export flags as unsupported, then run Verify.
Redoing is the right call when the file is young and the transaction volume is modest. It is the wrong call when you have already entered months of new work in the converted file, because redoing throws that work away.
Option two: downgrade from Enterprise and continue in Desktop
The built-in export from QuickBooks Online lands in QuickBooks Enterprise. Many people converting back want Pro or Premier instead, often because they hold a perpetual licence for it. You cannot open an Enterprise file in Pro or Premier; the format does not step down on its own.
A downgrade service rewrites the file so it opens in the older edition, with the full transaction history carried over. It suits the file that converted correctly except for edition, or the file that was repaired first and now needs to land on a perpetual licence. See downgrading QuickBooks Enterprise to Pro or Premier for how that works and what to send.
Downgrading does not, by itself, restore missing checks. It is a step after the data is sound, not a repair.
Option three: repair the file in place
When the file has target chaining errors, an out-of-balance balance sheet, or damaged transaction links, redoing the conversion reproduces the same faults, because the damage sits in the conversion's link structure rather than in the source data. That is the moment for a repair rather than a redo.
Repair suits the file with months of new work already entered, or with damage too deep for a re-import to fix. You provide a backup and the admin password, and an engineer opens the file, locates the broken links, and rebuilds them. The QuickBooks data repair service covers this path.
How to choose
Use this order. If the converted file is nearly empty of new work and the gaps are broad, redo the conversion in chunks. If the data is sound but the edition is wrong, downgrade. If the file fails Verify, the balance sheet is out of balance, or a redo already failed once, repair in place.
One caution, stated plainly: a repair can only recover what exists in the file. Checks the export never wrote cannot be restored from the Desktop file itself; they must come from the QuickBooks Online source or be re-entered by hand. That is why we tell every client to keep the Online subscription live until the Desktop file passes a full comparison, quarter by quarter.