CapLens
CapLens
Debt AdvisoryInvestorsLendersResources
Log in
Resources

CapLens guide

Migrate lender relationships

Download worksheet · CSV Download text version

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.

Migration help →

Need help applying this to your team?

Contact support →
CapLens

Opportunity, capital, and the intelligence to move forward.

Get started

Find lenders for a deal
Why CapLens
Pricing
Lending programs
Create your free lender profile

For your team

Debt Advisory
Investors
Lenders

Help & resources

Resources
Contact support
Log in

© 2026 CapLens. All rights reserved.