Space for pervasive banner when authenticated
How data transfers from QuickBooks Online to QuickBooks Desktop
Learn how your financial data, transaction histories, and operational lists transfer from QuickBooks Online to QuickBooks Desktop.
When you transfer your accounting workflows from the cloud to a local desktop, some data structures change due to differences in database design. See what moves, what changes, and what needs manual entry.
Important: Before you move your data:
Update your software: Make sure you install, activate and update your QuickBooks Desktop to the latest release before you open the converted file. If you don’t own a license, you can use a QuickBooks Desktop trial file.
Target data ceilings: Complex files with large target sizes may experience errors during conversion. 4,000,000 targets is the ceiling when you move from QuickBooks Online to QuickBooks Desktop. Make sure to check your data before migration.
How features transfer
Find out which QuickBooks Online feature transfers automatically to QuickBooks Desktop. Know how the data adjusts when transferred and if they transfer at all.
| Feature | Transfer quality | Adjustments and parameters |
| Multi-currency | Partially automatic | Multi-currency transactions don’t transfer smoothly. Non-USD transactions may lose original valuation metrics. Note: Multi-currency isn’t supported in QuickBooks Payments. Review your foreign currency accounts immediately after the move. |
| Sales tax tracking | Automatic | Automated sales tax agency settings move over as service items rather than tax codes. Note: Historical sales tax payments and manual adjustments don’t transfer. You must record them manually. |
| Projects | Automatic | Cloud projects transfer to customer: jobs in QuickBooks Desktop. |
| Payroll Processing | Not automatic | Active cloud payroll histories and employee tax setups don’t transfer. Subscribe to QuickBooks Desktop Payroll or turn on manual payroll formatting locally to transfer. |
| Account Reconciliation | Automatic | Reconciled cloud transactions show a bold checkmark in the Cleared column. Historically cleared transactions show a light checkmark. |
How lists and contact info transfer
QuickBooks Desktop has exact character and field counts. If your list goes over these, they’re reduced upon import.
Chart of accounts
Account detail types unique to the cloud don’t transfer.
Account numbers only show if you turn on the preference in QuickBooks Desktop.
Deleted QuickBooks Online accounts transfer to QuickBooks Desktop as inactive accounts with preserved historical transaction ledgers.
The inventory shrinkage account doesn’t convert.
Customers, vendors, and employees
Deleted customers, vendors, and employees transfer seamlessly as inactive list elements to maintain accurate double-entry ledger balance histories.
QuickBooks maintains security and Payment Card Industry(PCI) compliance. To maintain strict data security standards, customer credit card numbers and stored payment profiles don’t transfer.
Stored contact notes, preferred delivery selections, secondary mobile/pager fields, tax-exempt checkmarks, and employee notes don’t transfer.
Note: Edit and confirm your vendor 1099 tracking parameters in QuickBooks Online before you use the export tool for accurate reports.
Legacy fields
Operational fields on QuickBooks Desktop that don’t show in QuickBooks Online, show as blank or general items which you can classify later. Here are the fields:
Customer/vendor/job types
Memorized reports
Custom templates
Price levels, sales rep initials, and Ship Via delivery rules
To-do action log
How products, services, and inventory calculations transfer
Moving inventory between platforms changes how your historical profitability reports show because of calculation logic.
Valuation shift (First In, First Out(FIFO) to Average Costing): When you export from QuickBooks Online to QuickBooks Desktop, the FIFO layers don’t carry over. Desktop rebuilds item costs using its average cost going forward, so historical inventory valuations and Cost of Goods Sold(COGS) can differ after conversion. Review entries and make adjustments to align reports.
Bundles: Product and service bundles don’t transfer and must be rebuilt as group items in QuickBooks Desktop.
Categories: Product categories convert into parent Items, matching the item designation type of the product related to them.
Transaction mapping framework
The migration engine converts transaction lines to match local file behavior.
| QuickBooks Online Transaction | QuickBooks Desktop Transaction | How it converts |
| Cash Purchases | Checks | Converts as localized cash disbursement transactions. |
| Checks | Checks | QuickBooks Desktop assigns chronological numbers to unnumbered QuickBooks Online checks. |
| Transfer Funds | Journal Entries | Converted into localized double-entry ledger lines. |
| Paychecks | Checks | Net wages convert as standard payment entries. Line-item tax details don’t transfer. |
| Deposits | Deposits | Stored billable status markings on deposit entries don’t transfer. |
| Invoices / Bills | Invoices / Bills | Note: Transactions containing multiple Accounts Receivable (A/R) or Accounts Payable (A/P) split rows automatically break out into distinct, multiple journal entries to protect database formatting. |
| Time Tracking | Time Activities | Physical timesheet attachments don’t transfer. Stored tracking location data doesn’t transfer because QuickBooks Desktop doesn’t support line-level locations. |
Important: The following transaction types don’t transfer:
Estimates and purchase orders
Note: Don’t move these as linked, active workflows. Recreate links or re-key open items.Liability adjustments and inventory cost adjustments
Recurring transaction templates
Stored credit card payment confirmations
Note: Run an Open Estimates and Open Purchase Orders report in QuickBooks Online before converting. Export these reports to Excel so you can easily re-key your open project pipelining once your desktop file is active.
Post-migration verification checklist
Note: To confirm that your books match between the two platforms, run your financial statements on an accrual basis. Accrual ledger reporting reconciles between QuickBooks Online and QuickBooks Desktop platforms. Cash basis may show discrepancies because of invoice payment application link timestamps.
Check your balances: Run a Trial Balance and a Profit & Loss report on both platforms to make sure your net income aligns.
Review asset accounts: Verify your ending inventory values against the original QuickBooks Online FIFO values.
Audit log limitations: The historical cloud audit log doesn’t transfer to QuickBooks Desktop. Retain read-only cloud access or export your cloud data history for historical corporate compliance.
Sign in now for personalized help
See articles customized for your product and join our large community of QuickBooks users.
Call Sales: 1-800-365-9606
