TJ, Lynn SolutionsPublished Updated
QuickBooks Desktop to Online: what doesn't transfer, and how to check your books after the move
Intuit's export moves your lists and your transactions. It drops your reconciliation history, your bank connections, and your templates, and it can leave the new file looking finished when it isn't. Here's what to check before you trust it.
DIRECT ANSWER
Intuit's migration tool moves your chart of accounts, customers, vendors, items, and transactions from QuickBooks Desktop to QuickBooks Online. It does not move past reconciliation reports, bank connections, custom templates, memorized reports, price levels, or the audit trail, and current-year payroll lands as lump sums. The conversion is done when the balance sheet, trial balance, P&L, AR aging, AP aging, and cash by account in QBO match Desktop as of the last day you entered anything in it. Not before.
QuickBooks gives you a migration tool to move your Desktop file to QuickBooks Online, and they sell it like it's something you just click and it delivers results. It does not. There are a lot of traps that you need to look out for.
I've done two of these since August. The export was the short part both times. The real work was before anyone clicked Export and after the new file opened, and this article is that work.
Why Desktop owners are moving now
Intuit stopped selling Pro Plus, Premier Plus, and Mac Plus to new US customers on September 30, 2024. If you already had a subscription you could keep renewing it, and Enterprise was never part of the announcement. Then on May 31, 2026, Desktop 2023 lost the services that made it worth keeping: payroll tax calculations, bank feeds, payments, live support, and security updates. If you're on 2024, you can keep renewing for now. Intuit's guidance on how long 2024 stays supported shifted this year, so check their current policy before you plan around a date.
If you bought the one-time license years ago and never wanted a monthly bill, none of that feels fair. Many of the Desktop owners I talk to say some version of that, and I don't argue with them. It's also not going to change. The question stopped being whether to move. The question is whether the file you end up with is true.
What transfers from Desktop to Online, and what doesn't
Intuit publishes the list. Here is the part of it you'll feel.
| Moves | Moves with changes | Does not move |
|---|---|---|
| Chart of accounts (QBO adds a Detail type to every account) | Reconciled transactions come over marked R and cleared ones marked C. Past reconciliation reports do not. | Bank connections and any uncategorized feed items |
| Customers, vendors, items, and transactions | Current-year paychecks come over as lump sums. Employee records move. | The audit trail |
| Memorized transactions, as recurring transactions | Some sales tax moves as journal entries, and Intuit's own note says Desktop payments can apply to the wrong filings in QBO | Custom templates and memorized reports |
| P&L budgets | Invoice subtotals land in the description field, and progress invoices lose their link to the estimate | Price levels and units of measure |
| Attachments up to 30MB | Open purchase orders don't show what was received | Bank account numbers and notes |
| Your closing date and password | Active estimates become Closed, inactive ones become Rejected | Users. Everyone has to be invited again. |
Three of those hit owners first. Your reconciliation reports are gone, so the proof that last year's books tied to the bank is now a PDF you hopefully saved. Your bank connections are gone, so every account has to be reconnected, and that is where cash gets doubled (more on that below). Your invoice and statement templates are gone, so the first invoice out of the new file looks like Intuit's default until someone rebuilds yours.
Intuit also puts limits on the move itself. The file has to be under 4,000,000 targets or you condense it first. You get 90 days from the day you sign up for QBO to bring the file over, or 180 if your accountant set up the subscription. And if the QBO company already has data in it, the import replaces it, and Intuit's wording is that you can no longer undo that action.
What actually goes wrong after a conversion
None of this is on Intuit's list. All of it is from doing the work.
You never wrote down what Desktop said
Before you open QBO, print six reports from Desktop: balance sheet, trial balance, P&L, AR aging, AP aging, and cash by account. Date them to the last day anyone entered a transaction in Desktop, which is usually not the day you're printing. That date is your cutoff, and every check in this article uses it. Those six numbers are the only proof you'll have that the conversion worked. If you skip this step, "it looks right" is the best you'll ever be able to say about the new file.
The import summary talked you out of checking
When the export finishes, Intuit gives you an import summary. Read the counts before you read the words. Transactions in Desktop should equal transactions in Online. Vendors will usually be higher in Online, because Desktop's Other Names list becomes vendors, and that is fine. Accounts will usually be one lower, and estimates get skipped, and that is fine too. What is not fine is a transaction count that doesn't match, or a line saying account balances didn't match. If you see either, stop. Don't change anything in the new file to make the warning go away.
Your reconciliation history is gone, but the last one survived
Open Reconcile on any bank account in the new file and the history is empty, even though the register is full of R's. The last reconciliation you finished in Desktop is still there, though. It's sitting in the Beginning balance field. Match that number to a bank statement ending balance before you reconcile a single month forward. Until one full statement month reconciles to zero, treat every transaction that came over marked as reconciled as unproven. If you've ever had a QBO file that looked current and wasn't, this is the same problem with a different cause.
You connected the bank and your cash doubled
When you reconnect a bank feed in QBO, it offers to create a new account named after the bank's nickname for it. Accept that and you now have two checking accounts: the one that came over from Desktop with every transaction in it, and an empty one the feed is about to fill. Cash doubles on the balance sheet and nobody notices until the next report is wrong. Connect every feed to the account that came over. Set the download start date to the day after your cutoff. And when the feed offers you checks that already carry an R in the register, exclude them. Don't add them again.
Payroll came over as lump sums, then got imported again
Intuit brings current-year paychecks over as totals, not as itemized checks. That's workable. The trouble starts when someone downloads a year-to-date report from the payroll company and imports it on top, because now the year is in the file twice. The check is simple and boring: payroll provider report, then the bank withdrawal, then the QBO entry, one pay period at a time. When all three agree, that period is verified. If your payroll provider's export doesn't carry dates on its year-to-date block, don't import it at all.
Notes, lists, and a few accounts didn't make the trip
Customer notes, custom lists, and the occasional account with its notes attached will not always be in the new file, and the import summary won't always tell you. This is why the reports you pulled before the export matter more than the export. If you have the general ledger and the audit log for every account, you can rebuild what dropped. If you didn't pull them and Desktop is already shut down, you're rebuilding from memory.
You paid someone out of a file that wasn't proven yet
Until the six reports match, don't pay a bill, print a check, send an ACH, or run a transfer out of the new file. Every payment you make out of an unproven file is a payment you may have to unwind. There's no shortcut here. Prove it first, then run the business from it.
A conversion I did this August
This August I converted a file for a commercial cleaning company with 17 or 18 recurring accounts, all with their own quirks, like how often the rate went up, and by how much, and the deals each one had made with the owner. Like many business owners who bought the one-time license for QuickBooks Desktop, she was not happy that support had been discontinued, and she was not looking forward to the monthly fee that QBO charges. Especially since that fee seems to go up every year. Her file was from the 2013 version of Desktop. So, very outdated. I went on site and pulled about 50 different reports from her file before we touched anything, because the thing about the Desktop to Online migration tool is that it rarely transfers cleanly. Things go missing, or get duplicated, or land in a new format that throws off the whole system. Having the general ledger and the audit log for every account was what made this migration work.
The import summary always says something is off, and it will deactivate old accounts or void old invoices to get itself through. That isn't always a helpful solution, but it's what the tool wants you to do in order to migrate.
When the cutoff finally happened, she was missing several accounts and their notes, plus a number of lists she had built over the years. Had she used the tool by itself, she would've lost important information about her accounts and how each one paid. Not ideal.
I recreated everything that was missing from the reports I pulled before shutting Desktop down. The first thing I do on any migration is reconcile EVERY account to the bank statements and the history. Her QBO matched her Desktop exactly. And in the process I found a few thousand dollars she was owed that had gotten lost in paperwork. We collected it and brought her accounts receivable down to $0.
How to check the new file before you trust it
Do this the same day the export finishes, before anyone sends an invoice out of the new file. None of it needs an accountant. It needs someone patient, and it helps if that person didn't do the export.
- Print the same six reports from both programs and lay them side by side. Balance sheet, trial balance (every account and its balance on one page), profit and loss, the report that shows who owes you money (AR aging), the one that shows who you owe (AP aging), and the balance in each bank and credit card account. Date every report to the last day anyone entered something in Desktop, not today. QuickBooks can show these reports two ways, cash or accrual, and it will happily give you one of each. Set both programs to accrual so you're comparing like with like. Now go number by number: total assets, total liabilities, net income, each bank balance, the AR total, the AP total. They should match exactly. If one doesn't, that is the first thing to solve, and you don't use the new file for anything until you know why.
- Save the import summary and read the numbers, not the warnings. When the export finishes, QuickBooks shows you a summary and lets you download it. Keep it. It tells you how many transactions were in Desktop and how many landed in Online, and whether your account balances matched. Those two transaction counts should be identical. If they're off, or it says balances didn't match, something didn't come over, and no amount of clicking around in the new file will show you what. Stop there and get help before you fix anything by hand. The summary will also list warnings about vendors, templates, and estimates. Most of those are noise. The vendor count going up, for example, is Desktop's Other Names list turning into vendors. The transaction count is the one that matters.
- Open Reconcile on each bank and credit card account and look at the beginning balance. In QBO, go to reconcile any bank account. The history will be empty, which looks alarming. Ignore that and look at the beginning balance it shows you. That number is the last reconciliation you finished in Desktop. Go find the bank statement that ends at exactly that balance. If you can find it, you're fine, and you reconcile forward from there one month at a time. If you can't find it, don't start reconciling to see what happens. It means Desktop and the bank were already apart before the conversion. Make a list of what's on the statements that never made it into Desktop, get those entered, and then reconcile.
- Connect your bank last, and connect it to the accounts that already exist. Don't link your bank to QBO until step 1 matches. When you do, QBO will offer to create a brand-new account for the feed, named after whatever your bank calls it. Say no. Pick the checking or credit card account that came over from Desktop. Then set the start date for the download to the day after your last Desktop entry, so it doesn't pull in months of transactions you already have. If it still shows you checks and deposits that are already in the file, exclude them. Don't add them a second time.
- Send logins, then lock the past. Nobody who used Desktop automatically has a login to the new file, and that includes your bookkeeper. Send the invites. Then set a closing date on the last day of Desktop and put a password on it, so nobody can go back and change the numbers you just proved.
- If you collect sales tax, check what QBO thinks you owe against your last return. See the Washington section below.
- Keep the Desktop file.Make a backup of the Desktop company file and put it somewhere you'll still find in three years. Once you replace the data in QBO you can't undo it from that side. The original on your computer is untouched until you delete it. Don't delete it.
If the Desktop file was already wrong before the move, the export carried that too. That's a cleanup, and it's a different job from a conversion.
If you're in Washington
Intuit's own transfer notes say some sales tax moves as journal entries, that sales tax won't copy for every transaction, and that payments you made in Desktop can apply to the wrong filings in QBO. For a Washington business that means your sales tax center may not agree with your last combined excise return. Before the next return is due, compare what QBO thinks you've collected and paid against what My DOR shows filed and paid. That's a setup check, and it's bookkeeping. Which classification your revenue belongs in is a tax question for whoever signs your returns.
Should you move at all
Enterprise is still sold, and if you track inventory by bin, lot, or serial number, or you run job costing that QBO's projects can't carry, Enterprise is the honest answer for now. Everyone on Desktop 2023 or older already lost bank feeds and payroll on May 31. If you're on 2024, nobody is forcing you this year. Move when the new file is worth more to you than the monthly fee: bank feeds that work, a bookkeeper who can get in without a remote desktop, reports you can open from your phone. And move when you have the time to check it. Intuit says to convert at least seven business days before your next payroll run, and your 90-day window starts the day you sign up for QBO. Don't do this the week before payday.
We've also moved a Contractor edition file, and those have their own quirks.
Questions owners ask
What doesn't transfer from QuickBooks Desktop to QuickBooks Online?
What happens to my reconciliations when I convert?
Why did my bank balance double after I connected bank feeds?
What happens to payroll history in the conversion?
How long does the conversion take?
Can I go back to Desktop after converting?
Scope: Lynn Solutions is not a CPA firm. We do not provide federal income tax preparation, tax advice, attestation, or audit services. We do prepare and file Washington state and city tax returns — DOR combined excise, city B&O, and L&I — as part of bookkeeping scope.
Still on Desktop and want the check done for you?
If you're still on Desktop and you'd rather not do this alone, we do the conversion and the check afterward for Washington businesses, remote, and we treat it as bookkeeping work, because that's what it is. Bring the last balance sheet Desktop printed. We'll tell you what the move will and won't carry before anyone clicks Export. Conversions are quoted as a project after we see the file.
More guides: Lynn Solutions Resources · Why QuickBooks Can Look Current While the Books Are Not Reconciled · QuickBooks Cleanup Guide · Washington Excise Tax Bookkeeping Rhythm
NEXT STEP
Prove the new file before you run the business from it.
Bring the last balance sheet Desktop printed. We'll tell you what the move will and won't carry before anyone clicks Export.
Or call 253-353-2675