Established MMXXVRemote-first · Serving clients worldwideConversions both directions
care@ezconvertbooks.com

October 15, 2026

QuickBooks merge vs make inactive: cleaning duplicate lists before a migration

The short answer: merge when two records are the same real account, customer or supplier and you want one history; make a record inactive when it is genuinely separate but finished. The two are not interchangeable. Intuit says a merge in QuickBooks Online is permanent and can’t be undone, and a merged supplier has to be recreated by hand if you change your mind. Making something inactive is reversible, but on a balance sheet account with a balance it quietly posts an adjustment to Opening Balance Equity. Choose wrong before a migration and the new system inherits the mess.

Merge vs make inactive at a glance

MergeMake inactive
Use it whenTwo records describe the same thing (a typo, an import, two staff keying the same supplier)The record is real and separate, just no longer used
What happens to transactionsMoved onto the record you keepStay where they are; reports show them against the inactive name
Reversible?No. Intuit: merging is permanentYes, via “Include inactive” and Make active
Side effects (QuickBooks Online)A merged account loses its reconciliation history, though its transactions stay reconciledA balance sheet account with a balance is zeroed by an automatic entry to Opening Balance Equity, and reactivating doesn’t move it back
Effect on a migrationOne clean record arrives in the new systemThe record still exists and may come across, sometimes as active again

Merging in QuickBooks Online

Accounts. There is no merge button for the chart of accounts. Per Intuit’s article, updated 1 September 2026, you edit the duplicate so its account name, account type and detail type exactly match the account you keep, save, and confirm “Yes, merge accounts”. The conditions matter more:

  • Don’t merge accounts connected to online banking, or accounts QuickBooks creates itself, such as the direct deposit funding account. Those go to Intuit support.
  • Save the reconciliation reports for the account you are merging away first. Its reconciliation history goes; its transactions stay reconciled.
  • If both registers have an opening balance equity transaction, delete the most recent one before merging. The older one becomes the new opening balance.
  • Two subaccounts need the same parent. Two parent accounts can only merge if neither has subaccounts.

Suppliers and customers. For suppliers (vendors in US editions), open the profile you don’t want, choose Edit > Merge contacts, and pick the one to keep from the Into list. QuickBooks moves past transactions across and marks the duplicate as deleted. Intuit says a merged supplier can only be restored by recreating it manually. Intuit publishes a matching article for merging duplicate customers.

Merging in QuickBooks Desktop

Desktop merges by name. On Windows you copy the name of the entry you keep, edit the duplicate, paste that name in, save, and answer Yes to the merge prompt. Intuit’s preconditions, from its article updated 20 August 2026:

  • Back up first (our guide to backup vs portable vs accountant’s copy explains which file).
  • Switch to single-user mode and clear any pending accountant’s changes.
  • On Windows, multicurrency must be off.
  • Suppliers can’t be merged if they are tax authorities, tax exempt, paid through online banking, or direct deposit suppliers.
  • An account with an active bank feed returns “You cannot merge an account that has online information associated with it”. Turn off the feed first.

Accountant and Enterprise editions also have a Merge Vendors tool for several at once.

Duplicates also surface as data damage. Verify Data can log “Duplicate name encountered” for the customer, supplier, account, item and other lists, and Intuit notes this often follows importing lists from other company files. Its fix is to rename one of the pair, re-run Verify, then merge the names if both carry transactions or delete the spare if it has none. If Verify reports more than duplicates, start with Verify and Rebuild.

Making things inactive: the limits

In QuickBooks Online you can’t delete an account. You can only make it inactive or merge it. Intuit lists what blocks inactivation: default accounts, accounts used by products or services, income accounts with pending billable charges, accounts linked to recurring transactions, and accounts with subaccounts. Bank accounts are disconnected rather than inactivated.

The trap is balances. Before you make a balance sheet account inactive, Intuit says to bring it to zero. Otherwise QuickBooks posts an automatic adjustment to Opening Balance Equity, which can affect balances and tax reports, and it won’t reverse that entry if you reactivate the account.

For customers, “delete” in QuickBooks Online is make inactive once a customer has transactions. Making a parent inactive also inactivates its sub-customers. A customer with linked projects can’t be inactivated until the projects are deleted. Old transactions then show the name marked “(deleted)”.

A cleanup order that survives a migration

  1. Back up and verify. Never merge in a file that fails Verify.
  2. Export the lists. Sort by name, tax or VAT/GST number and email; real duplicates usually share one.
  3. Decide record by record. Same entity: merge. Distinct but dormant: make inactive. Different tax registration or currency: keep separate. A supplier billing in two currencies is two records for a reason (see multi-currency cleanup).
  4. Save reconciliation reports for every account you are about to merge away.
  5. Merge first, then zero balances, then inactivate. Clearing open items such as unapplied payments and credits before inactivating keeps Opening Balance Equity clean.
  6. Re-run the trial balance and compare it with the one you started from. A merge moves history between records; it should not change totals.

Why this matters more before a conversion

Most conversions carry lists and history as they are. Two copies of one supplier become two contacts in Xero, Zoho Books or Sage, each with half the history, and the ageing reports split with them. Inactive records are a separate trap: some routes bring them back active or tagged, as our QuickBooks to Xero vs Zoho Books comparison shows. For what can’t move at all, see what doesn’t convert.

Frequently asked questions

Can I undo a merge in QuickBooks?

No. Intuit says merging is permanent and can’t be undone. A merged supplier in QuickBooks Online has to be recreated by hand, and its transactions stay on the record you kept. Back up before merging.

What happens if I make an account with a balance inactive?

In QuickBooks Online, Intuit says an automatic adjustment entry zeroes the balance and posts it to Opening Balance Equity. Reactivating the account does not move the balance back, so bring it to zero first.

Why won’t QuickBooks let me merge two accounts?

The usual causes are a bank feed connection, different account or detail types, mismatched parent accounts, or a parent that still has subaccounts. In Desktop, multi-user mode, pending accountant’s changes or multicurrency being on (Windows) will also block it.

Should I merge or inactivate before migrating?

Merge true duplicates so one record arrives with the full history. Inactivate records that are real but finished, after zeroing their balances. Keep records separate when they differ by tax registration or currency.

If you use class tracking, retire unused classes the same way: see QuickBooks class cleanup before you migrate.

Related service: QuickBooks support

Thinking about a conversion?

Send us your details for a free, fixed-price quote within one business day.