How to Convert QuickBooks Desktop to Online (and What Doesn’t Carry Over)
Chris Barrett
A lot of the business owners I talk with are still on QuickBooks Desktop, and most of them know they’ll end up in QuickBooks Online at some point. What holds them back usually isn’t the software. It’s worry about the move itself: losing history, breaking reports, or spending a month fixing things afterward.
That worry is fair. I’ve seen conversions go smoothly, and I’ve seen them create a mess that takes months to sort out. The difference almost always comes down to what happens before you click the button.
Here’s how I’d approach it if I were in your shoes, and what we look for when we convert QuickBooks Desktop to Online for a client.
What a QuickBooks Online Conversion Actually Is
When you convert, Intuit’s migration tool copies your Desktop company file into a new QuickBooks Online company. Your lists, transactions, and balances come over, and from that point on you do your bookkeeping in QuickBooks Online.
A few things to know up front:
- The two don’t sync. Once you move, QuickBooks Online is a separate system. You don’t keep both up to date.
- Your Desktop file stays put. The tool copies your data. It doesn’t delete or change the original file. Intuit says that if you’re on Desktop 2023 R3 or newer, you can open the old file in view-only mode for a year after you migrate.
- There’s a window to import. If you set up QuickBooks Online yourself, you have 90 days from the date the company was created to bring your Desktop data in. If your accountant set it up, the window is 180 days. Importing replaces whatever data is already in that QuickBooks Online company.
Do You Have to Switch Right Now?
Not necessarily. Intuit stopped selling new subscriptions to QuickBooks Desktop Pro Plus, Premier Plus, and Mac Plus after September 30, 2024. If you already had one, you can keep renewing it. Enterprise is still sold.
Older versions are a different story. Desktop 2023 lost support after May 31, 2026, which means no live support, no security updates, and no bank feeds, Desktop Payroll, or Payments. If you’re still on 2023 or older, that’s a real reason to act.
For Desktop 2024, Intuit has moved away from its old three-year retirement schedule and says it will keep updating the product. So if you’re current, you’re not being forced out tomorrow. But if you’re paying for a subscription anyway, want remote access, or are tired of hosting a file on a server, it’s a good time to plan the move on your terms instead of in a rush.
Convert Your File or Start Fresh?
Before you touch the migration tool, decide how much history you want to bring. You have two basic paths.
Convert everything
The migration tool can bring all your company data: lists, transactions, and balances. This works well when your file is in good shape and you want your history in one place.
Start fresh with opening balances
You can also bring only lists and balances (customers, vendors, chart of accounts, employees, and items), or set up a new company and enter opening balances as of a clean cutover date. Your old detail stays in the Desktop file for reference.
I lean toward starting fresh when:
- The file has years of unreconciled accounts or known errors
- The chart of accounts has grown into a mess nobody wants to keep
- The file is very large (more on that below)
- You’d rather fix the setup now than carry old problems forward
If the books are clean and reconciled, converting everything is usually fine. If they aren’t, a clean start with good opening balances is often less work than trying to fix bad history in a new system.
Before You Convert: Your Cleanup Checklist
This is the part that makes or breaks a conversion. Whatever is wrong in Desktop will be wrong in Online, just in a place you’re less familiar with.
- Pick a cutover date. The end of a month or quarter works best. Year end is the cleanest, because it lines up with your tax return and keeps the year in one system. Avoid switching in the middle of a month.
- Reconcile every bank and credit card account through the cutover date. Your past reconciliation reports won’t come over, so save them as PDFs first.
- Clean up open invoices and bills. Old receivables you’ll never collect and bills that were already paid should be dealt with now, not after the move.
- Clear out Undeposited Funds. A big balance sitting there usually means payments were recorded but never matched to a deposit. Fix it before you move.
- Review the chart of accounts. Merge duplicates, make unused accounts inactive, and look at the total count. QuickBooks Online Simple Start, Essentials, and Plus allow up to 250 accounts. Advanced has no limit.
- Check classes and locations. If you track them, you’ll need Plus (40 combined) or Advanced (unlimited). Simple Start and Essentials don’t have them.
- Run Verify Data in Desktop (File, then Utilities, then Verify Data). If it finds problems, run Rebuild Data and verify again.
- Check your file size. Press F2 in Desktop to see your total targets. The tool handles files with fewer than 4,000,000 targets, but Intuit notes that files over 750,000 may take longer and very large files have a higher risk of inventory errors.
- Save the reports you’ll want later. At a minimum: Balance Sheet, Profit and Loss, Trial Balance, A/R and A/P aging, sales tax liability, and payroll summaries. Also make a full backup of the company file.
- Plan around payroll. If you run Desktop Payroll, Intuit recommends waiting 2 to 3 business days after your last payroll and finishing the move before the next one.
On the day of the move, the file needs to be on your local computer (not a server or network drive), open in single-user mode, and you need admin access to both the Desktop file and the QuickBooks Online company.
What Doesn't Carry Over From QuickBooks Desktop to Online
Most of your core data moves. But some things don’t, and these are the ones that cause surprises. Based on Intuit’s current list, plan on rebuilding or replacing:
- Bank connections. Bank feeds have to be reconnected in QuickBooks Online, and uncategorized bank feed transactions from Desktop don’t come over.
- Reconciliation reports. Reconciled transactions come over marked as reconciled, but the old reconciliation reports don’t.
- Audit trail and memorized reports. Save anything you rely on before you switch.
- Custom invoice templates. Your logo comes over. Your custom layouts don’t.
- Users and permissions. Everyone has to be invited again in QuickBooks Online.
- Price levels, units of measure, and some custom fields. Customer and vendor custom fields come over. Custom fields on items and employees don’t.
- Progress invoicing details, open purchase order links, and pending sales.
- Mileage, QuickBooks Time data, and letters.
A few areas need extra attention:
Payroll. The current year’s paycheck information comes over as lump sums, along with employees and year-to-date balances. Detailed payroll history from prior years stays in Desktop. Treat payroll as its own project and check that year-to-date totals tie out before your first payroll in the new system.
Sales tax. Some sales tax comes over as journal entries, and Intuit notes that migrated sales tax payments can apply to the wrong filings. Their fix is to delete those payments and recreate them in the QuickBooks Online sales tax center. Intuit’s help center also says QuickBooks Online now calculates what you owe, but you file the return yourself with your state.
Inventory. Inventory is included in QuickBooks Online Plus and Advanced. Quantities and values are recalculated during the move, so check quantities on hand and starting values right away.
Budgets. Intuit’s documentation is mixed on budgets. Plan on checking them, and rebuilding any that didn’t come over correctly.
After You Convert: Check Your Numbers Before Anything Else
Don’t enter a single new transaction until you’ve compared the two systems.
- Run a Balance Sheet and Profit and Loss in both Desktop and Online for the same dates, using the accrual method.
- Compare the Trial Balance, A/R aging, A/P aging, and sales tax liability.
- Fix any differences now. They only get harder to trace later.
- Reconnect bank and credit card feeds, and be careful not to pull in transactions from before your cutover date, or you’ll end up with duplicates.
- Invite your users and set their permissions.
- Rebuild invoice templates, recurring transactions that didn’t come over, and bank rules if you came from a Mac file.
One note on reports: Intuit says accrual-basis reports should match between Desktop and Online, but cash-basis reports may not. If you normally look at cash-basis numbers, don’t panic if they’re off at first. Start with accrual, get that to tie out, and then look at cash. If you’re not sure which method your business uses, our post on cash vs. accrual accounting covers the difference.
Common Mistakes I See
- Converting a file that was never reconciled. You just move the problem to a new system.
- Switching mid-month. It splits a month across two systems and makes the first close in QuickBooks Online harder than it needs to be.
- Assuming everything moves. Bank feeds, templates, users, and reconciliation history all need attention.
- Skipping the report comparison. If the Balance Sheet doesn’t tie on day one, every report after that is suspect.
- Letting the import window run out. If you create a QuickBooks Online company and wait too long, you may have to start over with a new one.
- Picking the wrong plan. If you need classes, locations, inventory, or more than 250 accounts, make sure the plan supports it before you migrate.
How Midwest CPA Helps With QuickBooks Online Conversions
For clients on our monthly accounting services, the conversion and cleanup are part of getting started. We review the Desktop file, clean up what needs it, help you choose a cutover date, and decide with you whether to convert everything or start fresh. Then we run the conversion, compare the reports, connect bank feeds, set up users and templates, and check payroll and sales tax.
After that, we keep the books clean each month so you don’t end up back where you started. If you’d like us to run payroll too, that’s available as an add-on to monthly accounting.
If you only need help moving or setting up a system, take a look at our accounting system setup page. We scope those projects based on what your file needs.
Frequently Asked Questions
How long does it take to convert QuickBooks Desktop to Online?
The migration itself can run anywhere from minutes to hours depending on the size of the file. The real time is in the cleanup before and the review after. A clean, reconciled file can be done fairly quickly. A file with months of unreconciled accounts can take a few weeks to get ready.
Will I lose my historical data?
No. The migration copies your data and leaves the Desktop file alone. Keep a backup and save your key reports as PDFs before you switch. If you’re on Desktop 2023 R3 or newer, Intuit says you can open the file in view-only mode for a year after you migrate.
Can I switch in the middle of the year?
Yes. Just pick the end of a month or quarter as your cutover date so the reporting lines up. Year end is the cleanest, but you don’t have to wait for it.
Will my reports look the same in QuickBooks Online?
Not exactly. QuickBooks Online doesn’t have all the same reports as Desktop, and memorized reports don’t move. Your accrual-basis numbers should match. Cash-basis reports may not, so compare accrual reports first.
Can I keep using QuickBooks Desktop after I convert?
You can keep the old file for reference, but the two don’t sync. Once you move, do all new bookkeeping in QuickBooks Online.
Thinking About Making the Switch?
If you’re still on QuickBooks Desktop and want the move done right the first time, we can help. We’ll look at your file, tell you what needs to be cleaned up, and handle the conversion as part of getting you set up on monthly accounting.
Related Resources
Disclaimer
The content contained in this blog post is intended for general informational purposes only and is not meant to constitute legal, tax, accounting, or investment advice. You should consult a qualified legal or tax professional regarding your specific situation.