How to clean duplicate accounts in Salesforce without breaking pipeline reports

Duplicate accounts in Salesforce look like a data problem, but sales will feel it as a reporting problem first. Pipeline splits across two accounts, activities sit on the wrong record, marketing attribution gets weird, and the rep stops trusting the system. I have learned not to start by clicking merge just because two company names look the same. My first pass is a duplicate report with a few fi…