Ignition facilitates a 2-way sync of client information to QuickBooks - it connects your Ignition clients to QuickBooks clients through mapping. When client databases are connected, there is a potential for client data duplication.

This guide will provide with troubleshooting tips to help you prevent client duplications between QuickBooks and Ignition.

To better understand how data flows between Ignition and QuickBooks generally, please read this article.

Ignition automatically links your clients in Ignition to your clients in QuickBooks based on the selected name during the proposal creation process.

The most common way duplicate clients are created is when names do not match therefore creating a new client in Ignition and QuickBooks.

To make the correct QuickBooks client mapped in Ignition, we advise that you edit the client mapping in Ignition and then make the duplicate client in QuickBooks inactive.

To edit the QuickBooks mapping on a client in Ignition, navigate into a specific client → Edit Client → Apps tab → Select the entity you want to link to.

Remember to click Save Client in the top right-hand corner to save your changes!

Now, you can make the duplicate client in QuickBooks inactive. See this QuickBooks Support article for more details.

If 'Client Name' is selected, then each time new invoices are created in QuickBooks by Ignition, the company name in QuickBooks will be updated to match Ignition.

Alternatively, you can use the Merge Duplicate Client tool available only in QuickBooks Accountant. See this QuickBooks Accountant Support article for more details.

If the duplicate client also exists in Ignition, you can merge the two Ignition records into one. In the Clients tab, select exactly two clients, then click More actions → Merge clients. Choose which client to keep, review the preview, and confirm. Ignition archives the duplicate after the merge.

App links transfer to the kept client only when it isn't already linked to that app. Conflicting app links prevent a merge, and the preview lists any blockers before anything changes.