Preserve the source and history behind each relationship before mapping records into your team's workspace. The worksheet supports preparation; it is not a direct-import contract.
1. Inventory the source records
- Keep an untouched copy of each lender list and historical debt matrix.
- Give each source a filename, as-of date, and stable row identifier.
- Record who owns the source and who may access its private relationship notes.
2. Map the relationship and its evidence
- Separate institution, operating team, responsible originator, and your internal relationship owner.
- Retain the original contact value alongside the proposed normalized value.
- Link historical financing, quotes, passes, and outcomes to their source and date.
- Mark uncertain affiliations or outdated contacts for human review.
3. Resolve duplicates deliberately
- Compare institution, team, contact route, and source evidence before merging records.
- Preserve distinct teams at the same institution and private notes belonging to different owners.
- Record the duplicate decision and intended destination field or record.
4. Review before migration
- The CSV contains one clearly labeled sample row. Remove it before entering your own records.
- Use one row per source relationship record; retain additional financing history in a linked source file.
- Review a small sample with your team and confirm access permissions.
- Agree on the destination mapping and import process with CapLens before loading records.