Merging Duplicate Customer Records

Duplicate customer records — where you have two (or more) Biller Genie customer records for the same real-world business or person — usually appear after a one-time customer import, a manual entry that didn't match an existing record, or a sync hiccup with your accounting software. This article covers how Biller Genie handles merging and the practical workflow for getting your customer list back to one record per customer.

Biller Genie does not have a native customer merge

The Biller Genie merchant portal does not have a "Merge Customers" button. The reason is that your accounting software (QuickBooks Online, QuickBooks Desktop, or Xero) is the system of record for customer identity. Merging customers inside Biller Genie without merging them in your accounting software would create a worse mismatch — Biller Genie would have one record but the accounting software would still have two, and the next sync would re-create the duplicate on the Biller Genie side.

The correct workflow is to merge in your accounting software first, then let Biller Genie sync the merged state.

Merging in QuickBooks Online

1. Decide which record you want to keep (the "winner"). Note its exact display name.
2. In QuickBooks Online, open the "loser" duplicate. Click Edit.
3. Change the loser's display name to exactly match the winner's display name. Save.
4. QuickBooks asks if you want to merge. Click Yes. All invoices and transactions on the loser are reassigned to the winner.
5. Wait for the next Biller Genie sync (or trigger a manual sync from Add-Ons > QuickBooks Online). The loser record will be marked Hidden in Biller Genie and the winner will pick up the consolidated invoices.

QuickBooks Online merges are irreversible — make sure you have the winner picked correctly before saving.

Merging in QuickBooks Desktop

The QuickBooks Desktop workflow is the same idea — rename the loser to exactly match the winner. From the Customer Center, right-click the loser, choose Edit Customer:Job, change the Customer Name to match the winner exactly, click OK, and confirm the merge. After your next Biller Genie sync, the merged state propagates.

QuickBooks Desktop limitation: if the loser has sub-customers (Jobs) underneath it, you'll need to move those Jobs to the winner first or delete them. QuickBooks Desktop won't merge a customer that has Jobs attached.

Merging in Xero

Xero supports contact merging from the contact list. Select the duplicate contacts using the checkboxes, click Merge, choose the master contact (the one to keep), and confirm. Xero moves all invoices and transactions to the master. After your next Biller Genie sync, the merged state propagates to Biller Genie.

Before you merge: a five-minute checklist

A few things to confirm before merging in your accounting software, because the result of the merge is the same on the Biller Genie side regardless of which one you pick as the winner:

• Pick the winner deliberately. If one of the duplicates has stored payment methods set up in Biller Genie, more accurate contact info, or active Customer Portal access, that's the one to keep. The loser's stored payment methods, portal access, and Biller-Genie-side customization (autopay thresholds, per-customer reminder overrides, etc.) will be lost in the merge.
• Note the loser's CC Emails. If the loser had additional CC email recipients on file (different from the winner), copy them down so you can add them to the winner after the merge. See Adding CC Email Recipients on Invoices.
• Disable autopay temporarily. If both customers have autopay on with open invoices, turn autopay off on the loser BEFORE merging to avoid an accidental charge during the merge window.
• Verify the duplicates are actually duplicates. A customer with the same name at two different locations is two real customers, not a duplicate.

After the merge syncs into Biller Genie

1. Open the winner's customer record in Biller Genie and confirm all the previously-spread-across-two-records invoices now appear on one record.
2. Add any CC Emails from the old loser that you noted before merging.
3. Re-enable autopay on the winner if you'd disabled it during the merge.
4. If the customer had a Biller Genie Customer Portal login on the loser's email but not the winner's, contact support@billergenie.com — we can help re-link portal access to the surviving record.

Preventing future duplicates

• Search before adding. Before manually creating a new customer in QuickBooks or Xero, search by name, email, and phone to make sure they aren't already there.
• Standardize display names. Pick one convention (e.g. "Last Name, First Name" or "Business Name") and stick to it. Most duplicates come from one person being entered as "Smith, John" and again as "John Smith."
• Use the customer import tool carefully. If you're importing a CSV of customers, run a dedupe pass against your existing customer list first. See Customer Import Tool Quick Reference Guide.

Still having trouble?

If the merge in your accounting software went through but the duplicates still appear in Biller Genie after a few syncs — or if your accounting software is refusing to merge for some reason — contact support@billergenie.com with both customer IDs from Biller Genie. We can audit the sync state and help reconcile.

Related articles

• Parent and Sub Customers
• Deactivating a Customer
• Customer Import Tool Quick Reference Guide