What we do
Tools
Industries
Department
How we workLet's talk →
Home/QuickBooks/Merge Two Accounts in QuickBooks by Renaming One
QuickBooks chart of accounts

Two Accounts That Should Be One: How to Merge Them in QuickBooks

There's no Merge button. You edit the duplicate so its name, account type and detail type match the account you're keeping, then save, and QuickBooks offers to merge them. Every transaction moves to the account you keep. It can't be undone, so pick the keeper carefully.

Where to do it

QuickBooks Online: edit the duplicate, copy the keeper's name, account type and detail type exactly, select Save, then Yes, merge accounts.

Accounting Chart of accounts Action ▾ Edit

QuickBooks Desktop: edit the duplicate and give it the keeper's exact name. QuickBooks says the name is in use and asks whether to merge.

Lists Chart of Accounts Edit Account

Before you rename the duplicate

These come from Intuit's own rules for merging accounts in Online.

  • Do the two share an account type and detail type?

    All three, name, type and detail type, have to match. If the duplicate is the wrong type, change it first, and only if that type change is allowed for that account.

  • Is either one connected to a bank feed?

    Intuit's help says not to merge accounts connected to online banking, or accounts QuickBooks created itself such as a payroll funding account. Those need Intuit support.

  • Are subaccounts involved?

    Two subaccounts must sit under the same parent. Two parent accounts can't have subaccounts of their own. More in subaccounts.

  • Have you saved the reconciliation reports?

    The merged-away account loses its reconciliation history. Its transactions stay reconciled, but save the reports first if anyone might ask for them. Reconciliation reports shows where they are.

  • Do both accounts have an opening balance?

    Delete the more recent opening balance equity entry before merging. The older one becomes the opening balance of the merged account.

Merging in QuickBooks Online

  1. 1

    Write down the keeper exactly

    Accounting Chart of accounts

    Open the keeper with Action › Edit. Note the name character for character, the account type, the detail type, and its parent if it's a subaccount. Close without saving.

  2. 2

    Edit the duplicate

    Find the account you want gone, open Action › Edit, and change its name, account type and detail type to match the notes. Account numbers, if you use them, are worth matching too.

  3. 3

    Save and confirm

    Select Save, and a merge prompt appears. Choose Yes, merge accounts.

    Watch for: the warning. It's the last point where you can still back out.

  4. 4

    Check a report

    Run a Balance Sheet or Profit and Loss detail report for the keeper over the past year. Both sets of transactions should be there, and the duplicate now shows as inactive.

Merging in QuickBooks Desktop

  1. 1

    Make a backup first

    A Desktop merge can't be undone either, and a backup is the only way back.

  2. 2

    Open the duplicate

    Lists Chart of Accounts

    Select the account you're getting rid of and choose Edit Account from the Account menu at the bottom of the list.

  3. 3

    Type the keeper's name

    Exactly as it reads, and its number too if account numbers are turned on. Both accounts need to be the same type.

  4. 4

    Say Yes to the merge

    Save. QuickBooks tells you the name is already in use and asks whether to merge the two. Yes moves every transaction to the keeper.

Surprises the day after a merge

The wrong one was kept

How you'll know: The surviving account has the old name, or the type you meant to retire.

Fix: You can still rename the keeper or change its detail type, where QuickBooks allows it. What you can't do is split the transactions back apart without moving them one by one.

Two different accounts were merged

How you'll know: Office Supplies and Office Equipment are now one line, and fixed assets are sitting in expenses.

Fix: Create the lost account again and reclassify its transactions to it. It's slow, which is why the keeper check above matters.

The duplicate comes back next month

How you'll know: A new account with the old name appears after an import or an app sync.

Fix: Something outside QuickBooks is mapped to a name that no longer exists, and it created a fresh one. Point that app's mapping at the keeper.

Bank accounts, vendor records and whole company files

Is merging two accounts the same as merging vendors or customers in QuickBooks?

No. Accounts are the categories on your chart of accounts, like Fuel or Checking. Vendors and customers are the people you buy from and sell to, kept in their own lists. The rename-to-match idea is similar, but merging one never touches the other. Merging vendors covers that list.

How do I merge two bank accounts in QuickBooks?

The same rename-to-match steps work for bank accounts that aren't linked to a feed. If either one is connected to online banking, Intuit says not to merge it that way. It only changes QuickBooks records, never anything at the bank.

Can I undo a merge of two accounts in QuickBooks?

No. Intuit's help describes the merge as permanent. The fix for a bad merge is recreating the lost account and moving its transactions back by hand, so check twice before you say yes.

Can I merge two QuickBooks company files together?

Not with this feature, and QuickBooks Online has no built-in way to combine two companies. It usually means importing lists into the file you keep and re-entering or summarizing the rest, which is a different job from cleaning up one chart of accounts.

Our chart has hundreds of accounts and plenty of near-duplicates. Who builds a list of the pairs?

n-frames does, for businesses and bookkeepers whose chart grew through years of imports and different hands. It reads the chart through Intuit's API and leaves every merge decision, and the merge itself, to whoever owns the books.

Let's talk

Tell us the one thing your team does manually that eats up time. We read every message and reply within a day.