How to convert QuickBooks Desktop to Online for an e-commerce brand
Short answer: Converting QuickBooks Desktop to Online is more than a file export for an e-commerce brand. Confirm who owns the file, decide whether you are moving from cash to accrual, plan how Shopify and marketplace data will flow in, and reconcile the opening balances before you trust the new books.
Why e-commerce brands move off Desktop
Most e-commerce accounting tools, from sales-channel connectors to inventory and reporting apps, are built for cloud ledgers. Desktop files often live on one computer or a hosted server, which limits who can get in and makes integrations harder.
“Most accounting tools are built for QuickBooks Online or Xero. You have direct integrations, you have API work that you could plug around with.”
— Saman Izadiyar
“I look at QuickBooks Desktop is a very limited, dormant legacy static software. It’s just, it’s past its prime.”
— Saman Izadiyar
Step 1: Confirm what you actually have
Saman described an owner who believed he was on QuickBooks Online and on an accrual basis. He was on QuickBooks Desktop, on a cash basis, and did not control the file. Before planning a migration, confirm:
- Which product and version the file is, and where it is hosted
- Who has admin access, and whether you own the license
- Whether the books are kept on a cash or accrual basis
- When the bank, card, and clearing accounts were last reconciled
Step 2: Decide on cash or accrual
A migration is a natural point to move to accrual, which matches revenue to fulfillment and inventory to cost of goods sold. It also changes tax and reporting, so agree on the switch and its timing with whoever prepares your returns.
Step 3: Rebuild the sales feed, then backfill
Connect Shopify and other channels through a connector that posts summarized sales, fees, refunds, and tax to clearing accounts. Then backfill year to date so the new file has a full year on one method.
“So we completely migrated him over. We moved his brand over to Accrual.”
— Saman Izadiyar
Step 4: Prove the opening balances
- Bank and card balances tie to statements on the conversion date
- Accounts payable and receivable agings match
- Inventory and loan balances match supporting schedules
- Sales tax payable matches filings
Related: QuickBooks Desktop discontinued: what to do, bookkeepers who handle software migrations, and Shopify accounting.
Take the quiz, or request quotes. Get a quote does not show matched firm names to visitors.
Frequently asked questions
Can I convert QuickBooks Desktop to Online myself?
Intuit provides a conversion tool, and simple files may move cleanly. E-commerce files with inventory, many sales channels, or a cash-to-accrual change usually need cleanup before and after.
Will my sales channel history come over?
Transactions in the Desktop file come over, but integrations do not. Plan to reconnect Shopify, Amazon, and other channels and decide how far back to backfill.
Should I switch to accrual during the migration?
It is a common time to switch because you are rebuilding the feeds anyway. The change affects tax reporting, so coordinate with your tax preparer.
How do I know the migration worked?
Opening bank, card, payables, receivables, inventory, loan, and sales tax balances should tie to statements and schedules on the conversion date.
The full suite bookkeeping firm supporting fast-growth E-Commerce, SaaS and SMB companies with fast, accurate, and clean financials.
See Ottit’s profileRelated reading: QuickBooks Desktop migration case study, QuickBooks Desktop to cloud changes.
Some professionals on Sam’s List pay for visibility or leads. Inclusion and order do not rank professionals. This page is educational and is not tax, legal, or investment advice. Firm names are never shown on Get a quote matches.
Quotes and client examples are what Saman Izadiyar described; they are not a guarantee of results.