Space for pervasive banner when authenticated

Learn what moves from QuickBooks Online to QuickBooks Desktop
Learn what moves, what changes, and what to set up again when you move from QuickBooks Online to QuickBooks Desktop.
When you move from QuickBooks Online to QuickBooks Desktop, most of your lists and transactions come with you. Some features have different names in QuickBooks Desktop. A few work differently or start fresh. This article lists it all so you know what to expect. To complete the move, go to Use the migration tool to move QuickBooks Online data to QuickBooks Desktop.
What you need to know first
Your accrual-basis reports will match. Run your profit and loss and trial balance on an accrual basis in both products and the totals line up. Cash basis reports may differ.
QuickBooks Desktop has list limits. There's no target limit for this move, but each QuickBooks Desktop version caps how many names (customers, vendors, and employees) a file can display. To check the limits for your version, go to Maximum number of list entries.
Foreign currency converts to US dollars with no exchange rate. A bill for 100 CAD in QuickBooks Online becomes 100 USD in QuickBooks Desktop.
Your reconciliations start over. Every bank and credit card account has a $0 reconciled balance in QuickBooks Desktop.
Inventory switches from FIFO to average cost. Your quantities and values will need adjusting after the move.
Update QuickBooks Desktop first. Install, activate, and update to the latest release before you open the converted file. If you don't own a license, you can use a QuickBooks Desktop trial.
Find your features by their new names
| QuickBooks Online | QuickBooks Desktop |
| Expenses | Checks |
| Projects | Customer:jobs |
| Categories | Parent items |
| Bundles | Group items (rebuild them; bundles don't move) |
| Transfers | Journal entries |
| Paychecks | Checks |
| Time tracking | Time activities |
| Automated sales tax | Service items |
What transfers, area by area
Each section tells you what moves as-is, what moves with changes, and what you'll set up again in QuickBooks Desktop.
Banking and reconciliation
Moves: Checks, deposits, and transfers. QuickBooks Desktop adds check numbers to any unnumbered checks.
Moves with changes: Transfers become two-line journal entries. Billable status on deposit lines doesn't move.
Set up again: Reconciliations. All bank and credit card accounts have a $0 reconciled balance in QuickBooks Desktop. Do a batch reconciliation for each account after the move.
Chart of accounts
Moves: Your accounts. Deleted accounts move as inactive accounts, and their transaction history stays with them.
Moves with changes: Account numbers only appear if you turn on that preference in QuickBooks Desktop.
Set up again: Account detail types that only exist in QuickBooks Online, and the inventory shrinkage account.
Customers, vendors, and employees
Moves with changes: Deleted customers, vendors, and employees move as inactive names, so your balances stay correct. QuickBooks Desktop has set limits on field lengths. Anything over a limit is cut.
Set up again: Contact notes, preferred delivery method, secondary phone fields, tax-exempt checkmarks, and employee notes. Customer credit card numbers and saved payment profiles don't move, which keeps QuickBooks PCI compliant.
Before you move, review your vendors' 1099 settings in QuickBooks Online so your 1099 reports stay accurate.
Items and inventory
Moves: Categories become parent items with the same item type as the products under them.
Moves with changes:
QuickBooks Online uses first in, first out (FIFO). QuickBooks Desktop uses average cost. QuickBooks Desktop rebuilds each item's cost using average cost going forward, so your past inventory values and cost of goods sold (COGS) can differ.
The move creates one Inventory Adjustment dated the day you move, using your current quantity on hand (QOH) from QuickBooks Online.
Items sold on sales transactions move to the Items tab, but with no asset value attached.
Your total QOH will be wrong in QuickBooks Desktop. Purchases entered as expenses aren't linked to inventory items, and sales count twice. After the move, compare each item's QOH to QuickBooks Online and adjust it by hand.
Set up again: Bundles. Rebuild them as group items
Sales and expense transactions
Moves: Invoices, bills, checks, deposits, and time activities.
Moves with changes:
A transaction with more than one accounts receivable (A/R) or accounts payable (A/P) line splits into separate journal entries.
Timesheet attachments and location data don't move. QuickBooks Desktop doesn't support locations on individual lines.
Set up again: Estimates, purchase orders, sales orders, Inventory Starting Value transactions, Inventory Adjustments, liability adjustments, inventory cost adjustments, and recurring transaction templates. Before you move, run the open estimates and open purchase orders reports in QuickBooks Online and export them to Excel so you can re-enter the open items.
Payroll
Moves with changes: Paychecks move as regular checks for the net pay. Tax line details don't move.
Set up again: Payroll history and employee tax setup don't move. To run payroll in QuickBooks Desktop, subscribe to QuickBooks Desktop Payroll or turn on manual payroll.
Sales tax
Moves with changes: Automated sales tax settings move as service items, not tax codes.
Set up again: Past sales tax payments and manual adjustments. Enter them by hand.
Multi-currency
Moves with changes: Foreign currency amounts convert to US dollars with no exchange rate applied. Review and adjust these transactions after the move.
Reports and audit log
Moves with changes: Accrual basis reports match. Cash basis can differ because of how payments link to invoices.
Set up again: The QuickBooks Online audit log doesn't move. Keep read-only access to QuickBooks Online, or export your history, if you need it for your records.
QuickBooks Desktop fields QuickBooks Online doesn't have
These arrive blank or as general items you can fill in later: customer, vendor, and job types; memorized reports; custom templates; price levels, sales rep initials, and Ship Via options; and the to-do list.
Next steps
Move lists and balances from QuickBooks Online to QuickBooks Desktop if you want your lists without transactions.
Sign in now for personalized help
See articles customized for your product and join our large community of QuickBooks users.