Merging eliminates duplicates, reduces confusion, and ensures accurate reporting and transaction history.
When you merge records, the system:
- Moves all history and transactions from the duplicate (secondary) record into the primary (master) record.
- Combines linked data such as invoices, bills, payments, and open balances.
- Deletes the duplicate (secondary) record after merging.
- Ensures that the primary record retains all information needed for reporting and future use.
Supported Record Types
The following records/data may be merged in CustomBooks™:
Tracking Merged Records in the Audit Log (New!)
We have updated the Audit Log to make it easier to track merged records. Previously, when you merged duplicate records (like Companies or Items), the system only logged it as "Deleted." Now, the system logs this action as Merged.
This update helps you see exactly what happened to your data and where it went.
Viewing Merged Records
When you merge a record, the Audit Log will now show the following details:
- User Action Column: Displays the new Merged action classification.
- Comment Column: Provides a detailed trace note explaining exactly where the records went.

Benefits of This Update
- Easily find missing data: Verify if a record was permanently deleted or simply consolidated into another file.
- Clear audit trails: Keep an accurate, stable history for your administration and auditing teams to confirm data authenticity.
Important Considerations Before Merging
✔ Review Transactions First
Before merging, verify that both the primary and secondary records have valid, accurate data. Once merged, the secondary record is deleted and cannot be undone.
✔ Choose the Correct Primary Record
The primary record should be the one you want to retain permanently. The secondary record will be removed.
✔ Verify Active vs Inactive Status
If one record is active and the other is inactive, consider whether you want the final merged record to remain active.
✔ Backup Your Data
It’s a best practice to back up your CustomBooks™ data before performing any major merge activities.
What Happens to Linked Transactions
During a merge, the system:
- Transfers invoices, bills, journal entries, and open transactions from the secondary to the primary.
- Updates payment history and balance information.
- Ensures that reporting reflects only the primary record.
All historical activity appears under the primary record after the merge is complete.
How to Identify Duplicates
🔍 Manual Review
Use filtering and search tools in your customer, vendor, or item lists to look for records with similar names or codes.
📤 Import Tools
When using the Data Import Tool, handle duplicate entries during staging so the Merge Tool is not needed afterward.
📊 Reporting Tools
Run lists and reports sorted by name to identify potential duplicates manually.