Established MMXXVRemote-first · Serving clients worldwideConversions both directions
care@ezconvertbooks.com

October 30, 2026

The report test after a QuickBooks Desktop to Online migration: five checks before you trust the new file

The short answer: run the same five reports in Desktop and in QuickBooks Online, with the same dates and the same accounting method, before anyone enters a new transaction. Intuit tells you to compare the Profit and Loss and the Balance Sheet on All Dates and Accrual, and to check the A/R and Undeposited Funds balances. It does not say what to do when they differ, so the second half of this post does.

What Intuit actually asks you to compare

We read two Intuit help articles on 30 October 2026. The post-move article (“Learn what to do after you move from QuickBooks Desktop to QuickBooks Online”, updated 8/5/2026) says to run the Profit and Loss and the Balance Sheet in both products using the report period All Dates and the Accrual method, and to check the balances of A/R, Undeposited Funds and the overall report totals. The file-move article (updated 9/1/2026) adds, in its video transcript, a year-to-date Profit and Loss with the same date range in both products, then the Balance Sheet, A/R and A/P reports “and others”.

The same article warns that your books may look different after the switch and links to a community list of what does not carry over. It gives no numeric tolerance. Both are US-edition pages; read your own region’s.

Before you start: freeze the comparison

  1. Pick one cutoff date and use it in both products. A report run “today” in Desktop after you kept working will never match an import taken last week.
  2. Save the Desktop reports as PDF or Excel now; they are easier to hand to an accountant than a file you have to reopen.
  3. Use Accrual in both. A Cash-basis Desktop report against an Accrual Online report is the most common false alarm we see.

The five checks

1. Balance Sheet, All Dates

Run it as of the cutoff date in both products and compare account by account, not just the totals. Equal totals can hide two accounts that offset each other. Check the cash and bank accounts first, then A/R, A/P, equity, and anything that looks like a clearing account.

2. Profit and Loss, All Dates and by year

Run All Dates as Intuit says, then run each fiscal year separately. A match on All Dates but a mismatch in one year usually means a transaction landed in the wrong year.

3. A/R aging

Compare total, then customer by customer. Unapplied payments and credits are the usual cause: a Desktop credit that was applied sits against the right invoice, but one left unapplied can show up as a separate line. Our post on unapplied payments and credits covers the cleanup that avoids this.

4. A/P aging

Same method, vendor by vendor. Intuit lists the link between a bill and its purchase order among things that do not move in at least one edition of its migration article, so an open bill can arrive without the order it came from.

5. Undeposited Funds

Intuit names this balance specifically. It should be what you expect from your own bank-deposit habits: payments received but not yet deposited. A large leftover balance usually means old payments that were deposited in Desktop but not linked to a deposit, which is a Desktop cleanup issue rather than a migration error. See Undeposited Funds cleanup.

Where a mismatch is expected

Three things Intuit flags in these articles can legitimately move numbers.

  • Inventory and cost of goods sold. Intuit says these may be calculated differently, so reports may not match exactly. The migration asks for a FIFO start date, and Intuit recommends the first day after your last tax filing period; Intuit says the start date can’t be changed once set and transactions dated before it can’t be edited. Intuit also says you may need to notify the IRS (Form 3115) and to consult your CPA. If you carry inventory, agree the plan with your accountant before you migrate; average cost vs FIFO shows why the values move.
  • Account detail types. The migration assigns them, and some accounts get a generic type such as Other Miscellaneous Income. That changes grouping, not totals.
  • Payroll timing. Intuit says to wait 2 to 3 business days after your last Desktop payroll run before migrating, and to finish the migration at least 7 business days before your next scheduled payroll.

When the numbers differ: a three-step trace

This is our method, not Intuit’s.

  1. Find the first date of divergence. Run the Balance Sheet at each year-end in both products. The earliest year-end that disagrees is where to look. Everything before it is clean.
  2. Find the account. In that period, compare the account lists side by side and note every account whose balance differs, and by how much. Two accounts with equal and opposite differences point to a mapping or detail-type issue; a single account points to a missing or duplicated transaction.
  3. Find the transactions. Export the account’s transaction detail from both products for that period, sort by amount, and look for the one that appears once. Check the date against any closing date, and check whether the transaction is voided or deleted in Desktop.

Log what you find as a short list: account, difference, cause, action. An accountant can review a one-page list in minutes, which is much faster than being handed two sets of reports.

Do the test inside the window

Intuit’s file-move article gives a migration window of 90 calendar days if you signed up for QuickBooks Online yourself and 180 if your accountant did; it does not say when the count starts. Importing into a company that already has data requires you to confirm replacement, which Intuit says cannot be undone, so test in a company you can afford to overwrite.

This is general information; confirm details for your own company file with your accountant.

Frequently asked questions

Which reports does Intuit say to compare after moving from Desktop to Online?

Intuit’s post-move article, updated 8/5/2026, names the Profit and Loss and the Balance Sheet, run in both products with All Dates and the Accrual method, and says to check the A/R and Undeposited Funds balances. Its file-move article, updated 9/1/2026, also mentions year-to-date Profit and Loss, Balance Sheet, A/R and A/P reports.

Should the Online reports match Desktop to the cent?

Intuit gives no tolerance. Its article says books may look different after the switch and points to a list of what does not carry over, and it says inventory and cost of goods sold may be calculated differently so reports may not match exactly. Explain every difference you find rather than accepting or rejecting a number.

How long do I have to run these checks?

The check itself has no deadline in Intuit’s text, but Intuit’s file-move article gives a migration window of 90 calendar days if you signed up for QuickBooks Online yourself and 180 if your accountant did. Run the tests while you can still redo the import.

What if the numbers differ?

Intuit’s article does not give a procedure for a mismatch beyond checking the listed balances and consulting your accountant. Our method is below: find the first date where the two reports diverge, then the account, then the transactions.

Related service: QuickBooks support

Thinking about a conversion?

Send us your details for a free, fixed-price quote within one business day.