Moving from QuickBooks® Online to Desktop

Who This Guide Is For

This guide is designed for business owners, bookkeepers, and accountants who fall into one or more of the following categories:

• Advanced inventory needs — You require barcode scanning, lot/serial number tracking, bin-location management, FIFO costing, or assembly-item builds that QBO does not support.
• Advanced job costing — You need work-in-progress (WIP) reports, committed-cost tracking, estimates-vs-actuals breakdowns, or project percent-complete calculations.
• Industry-specific editions — Your business operates in construction, manufacturing, wholesale distribution, nonprofit, or professional services, and you need the specialized chart-of-accounts templates, reports, and workflows that only Desktop Enterprise editions provide.
• Local data control — Regulatory, security, or connectivity constraints require that your financial data reside on servers you physically control, with no dependency on cloud availability.
• Multi-company management — You manage multiple entities and want to open separate company files without paying per-company subscription fees.

Desktop’s Future: What You Need to Know

Critical Timeline of Desktop Changes

What “End of Support” Actually Means

When Intuit ends support for a Desktop version, the software does not stop functioning. You can still open company files, create transactions, and run reports. However, the following critical features cease to work:

• No security patches or bug fixes — your installation becomes increasingly vulnerable
• Online banking / bank feeds stop connecting
• Payroll updates and tax-table downloads cease
• Live technical support is no longer available
• Third-party integrations may drop support for the version
• Credit card processing through Intuit Payments is discontinued

Valid Reasons to Move to Desktop

Feature Comparison: Desktop vs Online

Desktop-Only Features

QuickBooks® Online-Only Features

What You’ll Lose

Pre-Migration Checklist

1. 1
   Reconcile ALL Bank and Credit Card Accounts in QBO

   Unreconciled transactions will carry over as unreconciled, making your first Desktop reconciliation a nightmare

   Open each bank and credit card account in QBO, complete the reconciliation process, and ensure the difference is $0.00. Print or save each reconciliation report as a PDF.

2. 2
   Run and Save Key Financial Reports

   These become your validation benchmarks after migration

   • Profit & Loss (accrual and cash basis) for current and prior year
   • Balance Sheet as of migration date
   • Trial Balance
   • A/R Aging Summary and Detail
   • A/P Aging Summary and Detail
   • General Ledger for current year

   Export each to PDF and Excel for easy comparison later.

3. 3
   Export ALL Attachments Manually

   Attachments do NOT transfer during migration — this is non-negotiable

   Navigate to Settings → Attachments in QBO. Download every attached file. Organize them by year or transaction type. These must be manually re-attached in Desktop or stored in a separate document management system.

   Critical

   If you skip this step, every receipt, contract, and supporting document attached to transactions in QBO will be permanently inaccessible after you cancel your QBO subscription.
4. 4
   Document All Recurring Transactions

   Recurring transactions must be re-created manually in Desktop

   Go to Settings → Recurring Transactions in QBO. Screenshot or export the list. For each recurring transaction, note: type, customer/vendor, amount, frequency, next date, and any line-item details. You will re-create each one as a Memorized Transaction in Desktop.

5. 5
   List All Third-Party App Integrations

   Many QBO integrations have no Desktop equivalent

   Go to Settings → Manage Apps in QBO. Document every connected app. Research whether each app supports QuickBooks® Desktop. If not, identify alternatives or plan for manual workarounds.

   Common QBO-Only Apps:

   Gusto Payroll, TSheets/QuickBooks Time, Shopify (native connector), Bill.com (QBO connector), HubSpot, Squarespace, and many e-commerce platforms have QBO-only integrations.
6. 6
   Export Employee Payroll Data and YTD Balances

   Payroll data is heavily degraded during migration — you need source data to rebuild

   Run the Payroll Summary report for the current year. For each employee, record: gross wages YTD, federal/state tax withheld YTD, Social Security/Medicare YTD, 401(k) contributions YTD, and any other deductions. You will enter these as opening balances in Desktop payroll.

7. 7
   Notify Your Payroll Provider About the Transition

   Prevent payroll processing gaps during the switchover

   Contact your payroll provider (Intuit Payroll, Gusto, ADP, etc.) and inform them of the platform change. Coordinate timing so there is no gap in payroll processing or tax filing.

8. 8
   Install QuickBooks\u00AE Desktop (2021 or Later)

   The migration tool requires Desktop to be installed before you begin

   Download from your Intuit account at accounts.intuit.com. Run the installer as administrator. Activate with your license key. Run all available updates (Help → Update QuickBooks® Desktop).

   Version Requirement

   The Intuit migration tool requires QuickBooks® Desktop 2021 or later. If you are installing Enterprise, version 21.0 or later is required. Older versions cannot import QBXML files from the migration tool.
9. 9
   Create a Backup of Your QBO Data

   Safety net in case you need to restore your QBO state

   In QBO, go to Settings → Back Up Data. Create a manual backup. This ensures you have a restore point if anything goes wrong during the export process.

10. 10
    Schedule the Migration During a Quiet Period

    Minimize transaction volume during the transition window

    The ideal time is at the end of a month or quarter, after reconciliation is complete and before new transactions begin. Avoid payroll weeks, sales tax filing deadlines, or busy seasons. Communicate a “books freeze” period to your team.

Step-by-Step Migration (QBXML Method)

1. 1
   Initiate the Export in QBO

   Start the data export process from your QBO account

   1. 1. Log in to QuickBooks® Online as the company administrator
   2. 2. Click the Gear icon (Settings) in the top right
   3. 3. Under “Tools,” click Export Data
   4. 4. Enter the reason for your export (required field)
   5. 5. Click Continue

   Admin Access Required

   Only the primary admin or company admin can initiate the export. Regular users and accountant users do not have access to the Export Data feature.
2. 2
   Review the Export Overview

   Understand what will and will not be exported

   The Export Overview screen summarizes what data is included. Review it carefully. Click Get Started to proceed.

3. 3
   Download and Install the Intuit Migration Tool

   The free utility that converts exported data to QBXML format

   1. 1. Click the download link provided on the export page
   2. 2. Save the installer to your Downloads folder
   3. 3. Run the installer as administrator
   4. 4. Follow the installation wizard to completion

   Note:

   The migration tool must be installed on the same computer where QuickBooks® Desktop is installed. It acts as a bridge between the exported QBXML file and Desktop.
4. 4
   Select Your Export Scope

   Choose between full data export or lists-only export

   Option A: All Data with Transactions

   Exports your complete chart of accounts, customer/vendor/employee lists, and all transaction history (invoices, bills, payments, journal entries, etc.). This is the recommended option for most migrations.

   Option B: Lists and Balances Only

   Exports only your lists (accounts, customers, vendors, items) and their current balances. Individual transactions are not included. Choose this if you want a “fresh start” on Desktop with only opening balances.

5. 5
   Enter Confirmation Details and Wait for Email

   Intuit sends a verification email before generating the export file

   1. 1. Enter your name and email address
   2. 2. Click Confirm
   3. 3. Check your email for the confirmation message from Intuit
   4. 4. Click the link in the email to authorize the export
   5. 5. Wait for the export to process (may take minutes to hours depending on data volume)

   Processing Time

   Large company files with years of transaction history can take several hours to export. Do not close your browser or log out of QBO during this process. You will receive a second email when the export is ready to download.
6. 6
   Download the QBXML File

   Save the exported file to a known location on your computer

   1. 1. Click the download link in the completion email or in QBO
   2. 2. Save the .QBXML file to a folder on your local drive (not OneDrive — see Pitfalls section)
   3. 3. Note the exact file path; you will need it in the next step
7. 7
   Prepare QuickBooks\u00AE Desktop for Import

   Close any open company files before importing

   1. 1. Open QuickBooks® Desktop
   2. 2. If a company file is open, go to File → Close Company
   3. 3. You should see the “No Company Open” screen
   4. 4. Keep Desktop open — the migration tool will communicate with it
8. 8
   Run the Migration Tool and Import the QBXML File

   The actual data transfer from QBO export into Desktop

   1. 1. Launch the Intuit Migration Tool
   2. 2. Click Browse and navigate to your downloaded .QBXML file
   3. 3. Select the file and click Open
   4. 4. Click Import to begin the transfer
   5. 5. The tool will create a new company file in QuickBooks® Desktop
   6. 6. Wait for the import to complete (progress bar will show status)

   Import Duration:

   Import time depends on data volume. A small company (1–2 years of data) may take 15–30 minutes. Large companies with 5+ years of transactions can take 1–3 hours. Do not interrupt the process.
9. 9
   Grant Application Certificate Access

   Allow the migration tool to write data into Desktop

   1. 1. QuickBooks® Desktop will display an “Application Certificate” prompt
   2. 2. Select: “Yes, always allow access even if QuickBooks is not running”
   3. 3. Click Continue
   4. 4. The import will finalize and the new company file will open

   Migration Complete

   Once the company file opens in Desktop, the QBXML import is complete. However, your work is far from finished — proceed to the validation and manual setup sections below.

Need to convert data from other accounting platforms into QuickBooks® Desktop format? Our free accounting tools can convert data from Xero, Sage, FreshBooks, and more into QuickBooks-compatible formats.

What Data Transfers Successfully

What Data Does NOT Transfer

Transaction-Level Data That Does Not Convert

• Recurring / scheduled transactions — must be re-created as Memorized Transactions in Desktop
• Unaccepted bank feed transactions — pending bank feed entries in QBO are dropped
• Voided transfers — may not carry void status correctly
• “To Be Sent” status on invoices — send queue state is not preserved
• Billable status on deposits — billable expense flags on deposit line items are lost
• Markup amounts on billable expenses — markup percentages do not transfer

Payroll Data Degradation

Lists and Categories That Do Not Convert

Feature-Level Data Losses

• Location tracking — QBO location/class data may not map correctly to Desktop classes
• Custom field data — custom fields created in QBO are not preserved^[7]
• Budgets — QBO budgets do not transfer; must be re-created in Desktop
• Company preferences — all QBO settings (invoice preferences, email settings, etc.) are not included
• User permissions — QBO user roles do not translate to Desktop permission sets
• Mobile/pager phone numbers — only primary phone numbers transfer for contacts
• Taxable status on products/services — tax-exempt or taxable flags are not preserved^[7]

Post-Migration: Manual Setup Required

1. 1
   Re-Create All Recurring Transactions

   Rebuild your automated transaction schedule in Desktop

   Using the list you documented in pre-migration Step 4, create each recurring transaction as a Memorized Transaction in Desktop. Go to Lists → Memorized Transaction List → right-click → New Memorized Transaction. Set the frequency, next date, and template.

2. 2
   Set Up Payroll from Scratch

   Enter employee details and YTD balances manually

   1. 1. Subscribe to QuickBooks® Desktop Payroll (Enhanced or Full Service)
   2. 2. Set up each employee with full details (address, SSN, filing status, deductions)
   3. 3. Enter YTD payroll balances for each employee using the payroll data you exported
   4. 4. Download current tax tables (Employees → Get Payroll Updates)
   5. 5. Run a test paycheck (void it afterward) to verify calculations

   Mid-Year Migration

   If migrating mid-year, entering accurate YTD balances is essential for correct W-2 generation. Double-check every employee’s federal, state, Social Security, and Medicare YTD totals against your QBO payroll reports.
3. 3
   Re-Create Invoice, Estimate, and Statement Templates

   Your QBO templates do not carry over to Desktop

   Go to Lists → Templates to create or customize invoice, estimate, sales receipt, purchase order, and statement templates. Add your logo, company information, payment terms, and any custom fields.

4. 4
   Set Up User Accounts and Permissions

   QBO user roles do not transfer — configure from scratch

   Go to Company → Users → Set Up Users and Roles. Create each user account and assign appropriate permission levels (Full Access, Partial Access, or External Accountant). Desktop uses a different permission model than QBO.

5. 5
   Configure Bank Feeds and Connect Bank Accounts

   Re-establish online banking connections in Desktop

   1. 1. Go to Banking → Bank Feeds → Set Up Bank Feeds
   2. 2. Search for each bank by name
   3. 3. Enter your online banking credentials
   4. 4. Map each bank feed to the corresponding QuickBooks® account
   5. 5. Download and review initial transactions
6. 6
   Reconnect Third-Party Integrations

   Set up Desktop-compatible versions of your business apps

   Using the integration list from pre-migration Step 5, install and configure each Desktop-compatible integration. Some apps may require a different connector or version for Desktop. Contact each vendor for Desktop-specific setup instructions.

7. 7
   Enter Company Information and Preferences

   Configure company-wide settings in Desktop

   Go to Company → Company Information. Enter your legal name, address, EIN, phone, email, and fiscal year. Then go to Edit → Preferences to configure each preference category (accounting, checking, invoices, payroll, reports, sales tax, etc.).

8. 8
   Set Up Sales Tax Rates and Items

   Sales tax configuration does not transfer from QBO

   Go to Edit → Preferences → Sales Tax. Enable sales tax, create tax items for each jurisdiction, and set up tax groups if you collect taxes for multiple agencies. Assign default tax codes to taxable items.

9. 9
   Configure Email Settings for Sending Invoices

   Set up Desktop's email integration for customer communications

   Go to Edit → Preferences → Send Forms. Configure either Outlook integration, QuickBooks® email, or webmail. Test by sending a sample invoice to yourself.

10. 10
    Set Up a Backup Schedule

    You are now responsible for your own data protection

    Go to File → Create Backup → Options. Configure automatic backup to run daily or at each close. Save backups to an external drive or network location. Consider also setting up a cloud backup solution (Carbonite, Backblaze, etc.) for off-site protection.

    Backup Best Practice

    Maintain at least 3 backup copies: one on local storage, one on an external drive, and one in the cloud. Test your backups quarterly by restoring them on a separate machine.

Post-Migration Validation

Validation Checklist

Cost Analysis: QBO vs Desktop

QuickBooks® Online Pricing (2026)

QuickBooks® Desktop Annual Pricing (2026)

Break-Even Analysis

Third-Party Migration Tools

Common Pitfalls & How to Avoid Them

Timeline & Planning

When NOT to Do This + FAQ

When You Should Stay on QuickBooks® Online

Frequently Asked Questions