QuickBooks HelpQuickBooksHelpIntuit

Move your QuickBooks Desktop accounting info to QuickBooks Online Payroll

by Intuit1 Updated 3 days ago

Learn how to import your accounting info from QuickBooks Desktop to QuickBooks Online Payroll.

You can now move your QuickBooks Desktop accounting info to your existing QuickBooks Online Payroll subscription. This lets you manage your business online with a single company file. No need to start over or maintain 2 different company files.

Notes:

If you’re on wholesale billing:

  • Contact your accountant to purchase QuickBooks Online for you. This way you can continue to manage your wholesale billing after the migration.

If you’re not on wholesale billing:

  • Set up QuickBooks Online through your account management settings to access all its standard features.

You can also migrate without making any changes. Upon migration, QuickBooks Online sets up a 30-day trial of QuickBooks Online Advanced. This trial includes access to advanced features, including wholesale billing.

You can change plans if you find that the advanced features aren't necessary. After the trial ends, you can’t change the plan to QuickBooks Online Ledger. You can change to a standard QuickBooks Online plan any time.

To move your payroll information such as payroll expenses, liabilities, tax payments, and 1099-vendor checks, use Intuit Interchange Format (IIF) transfer. This links all your paychecks to the correct reconciled accounting transactions.

Notes:

  • IIF Transfer is the preferred method as the chances of manual errors are less.
  • You can also manually create transactions for payroll expenses, tax payments, and 1099-vendor checks in QuickBooks Desktop.

Make sure to update your QuickBooks Desktop to the latest release. If you have payroll data such as paychecks and tax info in QuickBooks Desktop Payroll, it won’t be migrated to QuickBooks Online.
Note: You’ll have greater success if you have the QuickBooks Desktop 2022 version or higher.

  1. Sign in as an admin in QuickBooks Desktop.
  2. Go to Company, then select Export Your Company File to QuickBooks Online.
  3. Select Get started.
  4. Select Bring all your company data, then select Continue.
  5. Sign in to a QuickBooks Online account.
    1. If you have a QuickBooks Online account, select Yes, sign me in. Then, select Continue. Sign in to your QuickBooks Online subscription.
    2. If you don’t have a QuickBooks Online account yet, select No, I need to create one. Then, create a QuickBooks Online Advanced trial company.
  6. Select the QuickBooks Online Payroll company file you want to move your QuickBooks Desktop accounting data to. Then, select Continue.
    Note: You can import QuickBooks Desktop data only within 180 days of your QuickBooks Online purchase.
  7. Select Migrate only accounting data, then select Continue. Here, you can review what moves and what doesn’t, then select Continue.
image

     8. Review what you’re exporting and where it’s going, then select Export.

     9. Once the migration completes, you’ll receive an email. You can then sign in to QuickBooks Online.

After signing in, you’ll see a welcome page. This shows the info about the matched QuickBooks Online Payroll paycheck and checks brought in from QuickBooks Desktop.
Note: The system maps paychecks and checks based on the exact match of date, amount, and name. You can download the exception report to see details about the matched and unmatched payroll checks.

  1. To delete duplicate transactions in QuickBooks Online, select Delete duplicate transactions.
    Note: If you select Skip for now, then the accounts and balances in QuickBooks Online won't match those in QuickBooks Desktop.
  2. On the page where you can review migrated data, select Download exception report if you deleted the duplicate checks. You can still delete them if you skipped it on the welcome page.

Delete unmatched data

You can delete unmatched checks from QuickBooks Desktop using the exception report. Once all unmatched checks are deleted, the accounts and balances in QuickBooks Online will match those in QuickBooks Desktop.

Notes:

  • A paycheck is considered matched if all three criteria—date, amount, and payee name—are an exact match. If none or any one variable doesn’t match, the paychecks are considered unmatched.
  • The exception report provides suggestions for matching checks that need to be reviewed and deleted manually in QuickBooks Online from the transaction search screen.
  • These suggestions are based on the most probable match (date and amount match or date and payee name match).
  • If there’s no probable match, then the matching check section will be empty for that paycheck.
  1. Check the matched and unmatched data in the exception report.
    1. Open the downloaded exception report.
    2. Switch between the Matched paychecks sheet and the Paychecks not matched sheet to review the data.
  2. If a payroll check is balanced against a check via manual entry:
    1. Select the Search 🔍 icon.
    2. Enter the transaction details such as the customer name, date, or amount to locate the specific transaction you want to delete.
    3. Select the transaction.
    4. Double-check the customer name, date, and amount to make sure you’ll delete the correct transaction.
    5. Delete the transaction.
      1. Select More.
      2. Select either Delete or Void.
      3. To confirm, select Void transaction or Delete transaction.
  3. If you balance a payroll check against a journal entry, then find the respective journal entry and delete it.

Learn about the business checking account

image
  • After data migration, you'll see the bank accounts you moved from QuickBooks Desktop. You’ll also see the business checking bank account in your list.
  • QuickBooks Online Payroll automatically created this bank account to track all payroll transactions, tax transactions, and contractor payments.
  • When you delete both matched and unmatched data, QuickBooks updates the balance in your business checking account. This balances your books.
  • Your business can continue operating with your business checking account.

You must sign in to vote.

QuickBooks Desktop Mac PlusQuickBooks Desktop Premier PlusQuickBooks Desktop Pro PlusQuickBooks LedgerQuickBooks Online AdvancedQuickBooks Online EssentialsQuickBooks Online PlusQuickBooks Online Simple StartQuickBooks Solopreneur

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.