In Quickbooks, each unique customer has an ID that is displayed in the url of the customer record. Behind the scenes, Boatyard stores this specific QuickBooks Customer ID for each contact.
When we send an invoice to QuickBooks, we reference that exact Customer ID. If that ID no longer exists because the record was merged, deleted, or inactivated, QuickBooks cannot find it and the sync will fail.
Best Practice When Cleaning Up Customers in QuickBooks
You can absolutely clean up your customer list in QuickBooks. We just recommend coordinating the final step to keep everything aligned.
Step 1: Complete Your Cleanup in QuickBooks
Go ahead and:
Merge duplicate customers
Make old customers inactive
Consolidate records as needed
Finish all cleanup on the QuickBooks side first.
Step 2: Notify Boatyard
Once cleanup is complete, let us know which customers were changed so we can update the mapping on our side.
To update the connection, we need:
The name of the affected customer
A direct link to the updated customer record in QuickBooks
You can send this through live chat or email and we’ll handle the update quickly.