The biggest QuickBooks Desktop to Online migration limitations include: a 4,000,000 target (list item and transaction) file size cap, a 60-day window to import after creating your QuickBooks Online company, no transfer of custom templates, memorized reports, attachments, price levels, or assembly items, limited inventory support (FIFO method only, in QuickBooks Online Plus or Advanced), and uncertain multicurrency compatibility depending on your setup.

Category Limitation File size Max 4,000,000 targets Time window Must import within 60 days of QBO start date Templates Custom templates and logos don't transfer Reports Memorized reports don't carry over Attachments Don't transfer at allInventory FIFO method only, Plus/Advanced plans only Price levels Not converted Assembly items Not supported in QBO Custom fields Limited or no support Multicurrency Conflicting reports; verify with Intuit directly

File Size and Technical Limitations

Your QuickBooks Desktop file can't exceed 4,000,000 targets, a combined count of list items and transactions, for Desktop Enterprise, Pro Plus, and Premier Plus (2022 and newer releases). Check your count using F2 or Ctrl+1 in QuickBooks Desktop. Files exceeding this need condensing or a specialized migration approach, since the standard export tool simply won't process them.

You can only import Desktop data into QuickBooks Online within 60 days of your QuickBooks Online company's start date. Currently, there is no workaround or option to override this limit. If the window closes, even an empty, unused QuickBooks Online company can't accept a late import; you'd need to start over with a fresh company.

Data That Doesn't Transfer At All

None of your custom invoice, estimate, or sales form templates convert to QuickBooks Online, and your logo doesn't transfer either. You'll need to recreate your branded forms directly in QBO.

QuickBooks Online lets you memorize reports going forward, but none of the reports you memorized in Desktop are converted. Every saved custom report needs to be rebuilt from scratch.

Any files or documents attached to transactions in your Desktop company do not convert to the Online version. If you rely on attached receipts, contracts, or supporting documents, you'll need to save and re-upload them manually.

Past bank reconciliation reports don't import. It's recommended you save these from QuickBooks Desktop before migrating, so you still have access to them for reference.

Price levels aren't converted, since QuickBooks Online doesn't have a built-in way to automatically adjust item prices the same way Desktop does.

QuickBooks Online has no equivalent to marking a sale "Pending." Any pending transactions in your Desktop file are not converted.

Features With Partial or Limited Support

Inventory tracking transfers with real constraints:

• Inventory is only available on QuickBooks Online Plus or Advanced plans, not Simple Start or Essentials
• QuickBooks Online recalculates inventory using the First-In-First-Out (FIFO) method only, regardless of what method you used in Desktop
• QuickBooks Online doesn't support units of measure for inventory items
• Only QuickBooks Desktop for Windows can export inventory to Online; QuickBooks for Mac inventory items migrate as non-inventory items instead, so Mac users need to export from a Windows machine first if inventory data matters
• Advanced Inventory features from Desktop Enterprise (like serial/lot tracking or multiple warehouse locations) need manual adjustment or third-party tools afterward

QuickBooks Online doesn't directly support assembly builds the way Desktop does. If your business relies on assemblies, plan for a workaround or alternate inventory process after migrating.

QuickBooks Online has limited support for custom fields on customers, vendors, employees, or items. Some custom field data may not convert cleanly, and ongoing custom field sync is more restricted in Online than in Desktop.

This is genuinely unclear territory, and sources disagree. Some documentation states that companies using the multicurrency feature cannot be migrated to QuickBooks Online at all. Other, more recent sources state that multicurrency transfers but is only available on QuickBooks Online Plus. Given this inconsistency, if your company uses multicurrency, confirm directly with Intuit support before planning your migration around it, rather than relying on either claim alone.

Early payment discounts already given to customers convert as credit memos applied to the customer's balance, rather than staying as discounts in the same format. Existing finance charge invoices convert without data loss, but QuickBooks Online has no automatic way to assess new finance charges for late payments going forward.

Bank feed setups don't move to QuickBooks Online. You'll need to reconnect your bank accounts and set up feeds fresh inside QBO after migrating.

Payroll-Related Limitations

Payroll history is one of the more commonly reported problem areas. Detailed historical payroll data doesn't always transfer with full accuracy, and businesses with Desktop Payroll (Assisted, Basic, or Enhanced) should expect to verify payroll figures carefully and potentially re-enter certain historical details manually rather than trusting the migration completely.

Reports and Interface Differences

QuickBooks Online doesn't have the exact same report set as Desktop. Accrual-basis reports generally match between the two systems, but cash-basis and certain specialized reports may look or calculate differently. Budget-related features and certain preference settings also don't map one-to-one between Desktop and Online.

Platform-Specific Limitation: Mac Users

QuickBooks for Mac has its own specific restriction: it cannot export inventory directly to QuickBooks Online. If inventory data matters to your business, you'd need to open your company file in QuickBooks Desktop for Windows first, or have someone export it from a Windows machine on your behalf.

How to Work Around These Limitations

1. Export what won't transfer manually. Use Excel/CSV exports for inventory details, custom fields, and reports before migrating, so you have a reference to rebuild from.
2. Save reconciliation reports and attachments separately before starting the export, since neither transfers automatically.
3. Rebuild templates and logos directly in QuickBooks Online rather than expecting them to carry over.
4. Verify inventory quantities and valuations against your Desktop reports after migrating, since the FIFO recalculation can shift numbers.
5. Confirm your QuickBooks Online plan level supports the features you need (Plus or Advanced for inventory, for example) before migrating.
6. Get written confirmation from Intuit on multicurrency handling if that applies to your company.

Frequently Asked Questions

What is the biggest limitation when migrating from Desktop to Online?

The 4,000,000 target file size limit and the 60-day import window are the two hard technical limits most businesses run into first.

Do custom templates transfer to QuickBooks Online?

No. Custom templates and logos don't convert and need to be recreated directly in QuickBooks Online.

Does inventory transfer accurately?

Partially. Inventory only transfers on QuickBooks Online Plus or Advanced, using the FIFO method, and units of measure aren't supported, so values often need verification afterward.

Can I migrate a company that uses multicurrency?

Sources conflict on this. Confirm directly with Intuit support before migrating if your company relies on multicurrency.

Will my memorized reports and attachments come over?

No, neither transfers. Both need to be rebuilt or re-uploaded manually in QuickBooks Online.

What if my file is too large to migrate?

You'll need to condense your Desktop company file to reduce targets, or use a specialized migration service built for larger files.

Final Thoughts

QuickBooks Desktop to Online migration limitations fall into three buckets: hard technical limits (file size, the 60-day window), features that simply don't exist in Online (assembly items, price levels, Pending sales status), and things that transfer only partially (inventory, custom fields, payroll history). Knowing these limitations before you start lets you plan around them, exporting what won't transfer and budgeting time to rebuild what's lost, rather than discovering the gaps after your Desktop file is already retired.

Not sure how these limitations apply to your specific company file? Contact the BooksMerge team for an honest assessment before you commit to migrating.