Insight · Method
The Reconciliation Report Every Migration Owes You
"The migration is done" is not a fact. It's a claim — and claims need receipts.
Ask a vendor how a migration went and you'll hear "complete." Ask them how many records went in, how many came out, and where the difference went, and the room gets quiet. That silence is the most expensive sound in enterprise software.
What "done" should mean
A migration isn't done when the new system opens and things look plausible. It's done when a written reconciliation exists that accounts for every record class, in both directions. Ours always includes, at minimum:
- Count reconciliation — records in versus records out, per object: accounts, contacts, opportunities, tickets, notes, attachments. Exact numbers, not ranges.
- Exclusion ledger — every record deliberately dropped, with the reason and the owner who approved dropping it. "We excluded 1,247 archived records at your ops manager's direction on the 14th" is a sentence, not a shrug.
- Transform log — where values were merged, split, remapped, or normalized, so "Acme Inc." and "ACME incorporated" becoming one account is a documented decision, not an accident.
- Spot-check set — a sample of records traced end-to-end, field by field, signed off by someone on your side.
The thirty-second question
If a vendor tells you the migration went well, ask one question: "Show me the exclusion ledger." Competent teams hand it over — they built it during the migration because it's how they work. Teams that improvised will need to "put something together," and what they eventually produce will be a summary, not a ledger.
The difference matters most after the fact. When finance asks why 2025 revenue history doesn't tie, the exclusion ledger is the difference between a five-minute answer and a six-week forensic archaeology project.
Why we lead with it
Foundry includes a reconciliation report in every migration, at every price point. It's not an upsell and it's not a "premium deliverable." It is the minimum honest output of moving someone's business records — and it's the reason our clients stop asking "is it really done?" because they're holding the proof.