When a QuickBooks Desktop to Online migration is actually finished
The import finishing is not the migration finishing. What has to agree between the two files on the conversion date, how to run each figure, and what the Desktop file still has to hold afterward.
A QuickBooks Desktop to Online migration is finished when the accrual Balance Sheet and Profit and Loss for All Dates agree in both files, including Accounts Receivable and Undeposited Funds, and every bank account is marked reconciled through the conversion date.
Intuit's documentation, read in September 2026, gives 60 days from creating a QuickBooks Online account to move Desktop data, so the Online account is best created close to the conversion date rather than months ahead of it.
After a move to QuickBooks Online, reconciliation reports and paycheck-level payroll detail stay in the Desktop file and its saved reports, which remain the support for every return filed from Desktop figures.
A QuickBooks Desktop to Online migration is finished when the two files agree on one date, and not before. That date is the conversion date, the last day your books lived in Desktop. On it, the accrual Balance Sheet and Profit and Loss for All Dates match in both files, down to Accounts Receivable and Undeposited Funds, and every bank account is marked reconciled through that day.
The import tool reaching the end is where that check starts. Below is the tie-out: which figure to compare, how to run it in each file, and what a mismatch usually means. Then the part that outlasts the migration: the history that stays in the Desktop file afterward, and why the old file becomes a record rather than something to delete.
What is the conversion date, and why choose it before you open QuickBooks Online?
The conversion date is the last day of transactions kept in QuickBooks Desktop. Everything dated after it is entered in QuickBooks Online. Choose it first, because two of Intuit's rules run on clocks, and one of them starts before the move does.
Intuit's help article on moving a Desktop company file to QuickBooks Online, read in September 2026, says you have 60 days from the time you create your QuickBooks Online account to move your data, and that the Desktop file's Total Targets count must be below 4,000,000. Open the Online account in October to look around, and a January 1 cut-over is already outside the window. Create it close to the move, not months ahead. Intuit's article on condensing a Desktop file, read in September 2026, adds that a file above 750,000 targets takes longer to move and may produce discrepancies, especially in inventory, which is worth knowing before the window opens rather than after.
The same article says that if you run payroll, you should wait 2 to 3 business days after your last payroll before moving, and finish the move at least 7 business days before your next scheduled payroll. On a two-week payroll cycle, ten business days apart, that leaves a window of one or two business days in each cycle. Year-end is the natural conversion date because it gives both files a clean edge: a full year in Desktop, a full year in Online, one set of year-end figures to tie. It is also when payroll is busiest, so put the window on a calendar rather than estimating it.
Two more instructions change the order of work. If the Online company already holds data, the move asks you to type Agree or select Replace, and the Desktop file replaces what is there. And Intuit's article on reconnecting bank feeds, read in September 2026, says to import the Desktop data before connecting the bank, or the Desktop data will replace any bank transactions already downloaded. Anything already typed into the Online file is replaced by the move.
The Desktop file itself has to be right before any of this. The move copies the books as they are, so an account last reconciled in March arrives in QuickBooks Online still unreconciled since March, with the same unexplained difference, now on a system that has never seen the statements. If you are months behind, scope the catch-up before reconciling anything, finish it in Desktop, and convert afterward.
What has to match between QuickBooks Desktop and Online after the migration?
Intuit's QuickBooks Online documentation, read in September 2026, says to compare the Profit and Loss and Balance Sheet in both files with the report period set to All Dates and the accounting method set to Accrual, and to check Accounts Receivable, Undeposited Funds and the report totals; it also says cash-basis reports may not match and that QuickBooks Online may calculate inventory values and cost of goods sold differently. That guidance is in Intuit's article on switching from Desktop to Online.
Run every report below on Accrual and All Dates in both files, even if you keep your books on the cash basis. Accrual is the basis on which Intuit says the two files will agree, which makes it the only basis on which a difference tells you something.
Figure | Run it in both files as | Should the two files match? | A mismatch usually means |
|---|---|---|---|
Total assets, total liabilities, total equity | Balance Sheet, All Dates, Accrual | Yes, to the cent | Something did not come across, or came across twice. Find which section differs before looking at single accounts |
Each bank and credit card account | Balance Sheet, then against the statement for the conversion date | Yes, and both should equal the statement | If both files agree with each other and not with the statement, the problem was already in Desktop |
Accounts Receivable | Balance Sheet line, then A/R aging by customer | Yes. Intuit names it | An open invoice or a customer payment that did not arrive as it was in Desktop. The aging shows which customer |
Undeposited Funds | Balance Sheet line | Yes. Intuit names it | Customer payments recorded as received but never grouped into a bank deposit. It should hold only payments genuinely waiting for the bank |
Accounts Payable | Balance Sheet line, then A/P aging by vendor | Yes | An open bill or a bill payment that did not arrive as it was. The aging shows which vendor |
Net income | Profit and Loss, All Dates, Accrual | Yes | Income or expense in one file and not the other. The same gap will show in equity on the Balance Sheet |
Inventory asset and cost of goods sold | Balance Sheet and Profit and Loss | Not necessarily. Intuit says Online may calculate them differently | Expected if you track inventory. Record both figures on the conversion date so the difference is explained, not rediscovered |
Any report on the cash basis | The same reports, Cash | Not necessarily. Intuit says cash-basis reports may not match | Expected. Tie on Accrual, then note the cash-basis differences and their size |
Payroll expense and liability accounts | Balance Sheet and Profit and Loss | The account totals, yes. The paycheck detail, no | Intuit's documentation, read September 2026, says paychecks arrive as regular checks. A difference in the totals is a real one; missing paycheck detail is by design |
The table narrows a problem quickly. Say total assets agree and Accounts Receivable is $1,240 higher in QuickBooks Online. Run the A/R aging by customer in both files, and the $1,240 will sit against one or two customers, which turns a whole-file question into two or three transactions to open side by side.
Matching the two files proves the move copied your books. It does not prove the books were right. For that, every line still has to tie to something outside the software: a bank statement, a loan statement, a customer's list of what they owe you.
Two files that agree prove the copy worked. Only a bank statement proves the books did.
How do you run the conversion-date tie-out, step by step?
The tie-out is eight steps, and the order matters more than the speed. The first three happen in Desktop before anything moves.
Reconcile every bank and credit card account in Desktop through the conversion date. The Online file inherits whatever state these are in, including any difference nobody has explained.
Stop entering anything in Desktop dated after the conversion date. A figure that changes in Desktop after you save the reports can no longer be tied.
Save the conversion-date reports from Desktop as PDFs. The Balance Sheet and Profit and Loss on All Dates and Accrual, the A/R and A/P aging reports, the reconciliation report for every account, and the year's payroll summary. These are the Desktop column of the table and part of the permanent record.
Create the QuickBooks Online account and move the file inside Intuit's 60-day window, before connecting any bank account.
Run the same reports in QuickBooks Online with the same settings and fill in the table, one row at a time.
Explain every difference before entering new work. A difference in a row Intuit expects (inventory, cash basis, paycheck detail) gets a dated note with its amount. A difference anywhere else gets found.
Mark bank transactions reconciled up to the conversion date. Intuit's article on what to do after the move, read in September 2026, says QuickBooks Online assumes no bank transactions have been reconciled, and tells you to reconcile each account to the conversion date, selecting every transaction and then unchecking those that have not cleared. Repeat it for every bank account; the difference should reach zero at the statement balance.
Connect the bank feeds last. Intuit's bank-feeds article, read in September 2026, says to note the date of the most recently categorized transaction in Desktop. Bring transactions in from after it, so the feed does not duplicate what the import already brought across.
The migration is finished when every row of the table either matches or carries a dated note explaining the difference, and every account in QuickBooks Online starts its first reconciliation from the statement balance on the conversion date.
A migration is also the one time the books are handed from one system to another anyway, which makes it a natural point to decide who keeps the new file. If that is the question, what bookkeeping costs is part of the answer.
Why don't cash-basis reports and inventory match after the migration?
Because the two programs calculate them differently, and Intuit documents it. Its switching article, read in September 2026, says accrual-basis reports in QuickBooks Online will match your reports in QuickBooks Desktop and cash-basis reports may not. Its post-move article says the two programs don't consider transactions paid the same way, and that inventory comes across on the first-in, first-out method (FIFO, which costs each sale at the price of the oldest stock on hand) and is recalculated from a FIFO start date you choose during the move.
An expected difference is still a number. Write both figures down on the conversion date: the inventory asset in Desktop, the inventory asset in Online, and the same for the cash-basis net income. Next year someone will set a cash-basis Profit and Loss beside the last return filed from Desktop and find a gap. With the note, that is a two-minute answer. Without it, it is an afternoon of re-running reports in a program nobody has opened for a year.
If your inventory was valued on some other method before the move, the change touches your tax return as well as your books. Raise it with whoever files your return before you pick the FIFO start date, not after.
What history stays only in the QuickBooks Desktop file after you convert?
Keep the Desktop file, and the PDFs from the conversion date, as the record of everything dated before the conversion date. Intuit's documentation, read in September 2026, describes two kinds of record that QuickBooks Online does not carry in the form Desktop kept them, and a third follows from how a change log works: it records changes made in the program that keeps it.
Record | What QuickBooks Online has instead | What to keep from Desktop |
|---|---|---|
Reconciliation history | No reconciled transactions until you mark them up to the conversion date, per Intuit's post-move article | The reconciliation report for every account and every statement period, saved as PDFs |
Payroll detail | Paychecks converted to regular checks, current-year paycheck information as lump sums, and prior year-to-date figures entered by hand, per Intuit's article on how data transfers | Payroll summary and detail reports by employee and by pay period |
Change history | An audit log of what happens in the Online file, where Intuit's audit log article says the conversion itself appears as Import Administration events | Any change-history report your Desktop version produces, run for the period up to the conversion date |
A change log in the new file answers who changed what after the move. For what that record has to show from here on, see what a ledger's change history needs to record.
How long the old records matter is set by what they support. The IRS says to keep records that support an item of income or deduction on a return until the period of limitations for that return runs out, which is generally three years from filing, and to keep employment tax records for at least four years after the tax becomes due or is paid, whichever is later (IRS, How long should I keep records?, read September 2026; IRS Publication 583, Rev. December 2024). Every return filed from Desktop figures is supported by Desktop records, and the paycheck detail in the table above is employment tax records. The exceptions to those periods are a question for whoever prepares the returns.
Save the PDFs even though the file itself is kept. A PDF does not depend on a subscription or an installed version staying current, and Intuit's discontinuation policy, read in September 2026, says QuickBooks Desktop 2023 was discontinued after May 31, 2026, losing live support and services including Desktop Payroll and online bank feeds.
Before the move, run the Balance Sheet and Profit and Loss in Desktop with the period set to All Dates and the method set to Accrual, plus the A/R and A/P aging reports, and save all four as PDFs named with the conversion date. Add the reconciliation report for every bank and credit card account. Those files are the Desktop half of the tie-out, and once Desktop is closed they are the only way to check the new file against the old one.
Is QuickBooks Desktop going away?
Not for existing subscribers, as of September 2026. Intuit's help documentation, read in September 2026, says new US subscriptions to QuickBooks Desktop Pro Plus, Premier Plus, Mac Plus and Enhanced Payroll stopped after September 30, 2024, that existing subscribers can keep renewing, and that QuickBooks Desktop Enterprise is not affected. Individual versions do end: Intuit says Desktop 2023 was discontinued after May 31, 2026, losing live support and services such as Desktop Payroll and online bank feeds. Intuit also says Desktop 2024 Pro Plus, Premier Plus and Enterprise Solutions won't be discontinued in May 2027, because it is moving away from its historical three-year software lifecycle. Which version you run decides your date, so check it before treating a migration as urgent.
What doesn't transfer from QuickBooks Desktop to QuickBooks Online?
Bank connections, reconciliation status and payroll detail do not transfer as they were, according to Intuit's documentation read in September 2026. Bank and credit card accounts have to be reconnected in QuickBooks Online. QuickBooks Online assumes no bank transactions are reconciled until you mark them reconciled up to the conversion date. Paychecks arrive as regular checks, current-year paycheck information as lump sums, and prior year-to-date payroll figures are entered by hand. Cash-basis reports and inventory values may differ after the move by design. Transactions, account balances, lists and the chart of accounts do come across, so the accrual Balance Sheet and Profit and Loss for All Dates should agree in both files; where they do not, something did not come across, and it is worth finding before any new work goes in.
Books in the new file that tie every month
A migration is a natural point to decide who keeps the new file: you, someone you hire, or a service. If that is the decision in front of you, we are glad to talk it through, including whether handing the books over makes sense for you at all.
This article explains how the rules generally work. It is not tax advice for your situation.
Operations background across retail, property management, and e-commerce. Writes step-by-step guides for owners who need the answer, not the theory.
