CRM migration

Migrate from Insight Legal Case Management to Freshsales

Field-level mapping, validation, and rollback between Insight Legal Case Management and Freshsales. We move data and schema; workflows are rebuilt natively in Freshsales.

Insight Legal Case Management logo

Insight Legal Case Management

Source

Freshsales

Destination

Freshsales logo

Compatibility

100%

12 of 12

objects map 1:1 between Insight Legal Case Management and Freshsales.

Complexity

BStandard

Timeline

48–72 hours

Rollback included Accuracy guarantee Field-level validation

Overview

What this migration involves

Insight Legal Case Management is a UK-based legal practice platform built on Microsoft SQL Server that stores clients, matters, fee earner assignments, time recordings, and financial ledger data in a unified schema designed for law firms. Freshsales is a Freshworks SMB CRM with standard Lead, Contact, Account, and Deal objects, custom fields, and a REST API rated at 100 calls per minute per account. The migration challenge is translating Insight Legal's client-matter structure into Freshsales' lead-account-deal model — a fundamentally different data shape that requires custom field creation for legal-specific properties, value mapping for matter status, and owner resolution by fee-earner email. We extract data directly from the Insight Legal SQL Server database, transform records against Freshsales' API constraints, and load via the Freshsales REST API. Workflows, document templates, and legal accounting logic do not transfer; FlitStack surfaces them as export-for-rebuild deliverables so your team can recreate automation logic in Freshsales after go-live. A delta-pickup window captures any new or modified matters created during the cutover window, and one-click rollback is available if reconciliation identifies data integrity issues.

Field-level fidelity

Every standard and custom field arrives verified.

Schema-aware mapping

AI proposes the map; you confirm before any record moves.

Relationships preserved

Parent–child, lookups, and ownership stay linked.

Full activity history

Calls, emails, meetings — with original timestamps.

Attachments & notes

Documents, uploads, and inline notes move with the record.

Why teams make this switch

Two sides of the same decision

Leaving

Insight Legal Case Management logo

Insight Legal Case Management

What's pushing teams away

  • Pricing lacks transparency on the vendor site — firms report needing to request a quote rather than self-serve pricing information
  • No publicly documented API means all data exports must go through Insight Legal's own migration service, limiting flexibility
  • Smaller firm users report that the feature depth designed for mid-to-enterprise practices can introduce unnecessary complexity
  • Switching to alternatives like Clio or Smokeball often cited for better mobile experience and lower entry cost for small practices
  • Some users find the UK-specific compliance features add administrative overhead that smaller practices do not require

Choosing

Freshsales logo

Freshsales

What's pulling them in

  • Lowest barrier to entry among major CRMs — the free tier supports up to 3 users and includes core CRM functionality before committing to per-seat pricing.
  • Built-in chat, email, and phone reduce reliance on third-party integrations for basic sales communication and contact management.
  • Freddy AI contact scoring and deal insights are included on Pro plans at a lower price than comparable HubSpot tiers.
  • Kanban pipeline views across Contacts, Accounts, and Deals provide visual deal management without requiring custom configuration.
  • Integration with the broader Freshworks ecosystem (Freshdesk, Freshchat, Freshservice) reduces tool sprawl for teams already using Freshworks.

Object mapping

How Insight Legal Case Management objects map to Freshsales

Each row shows how a Insight Legal Case Management object lands in Freshsales, including any object-level transformations, lookup resolution, or schema-design dependencies.

Typical mapping — final map is confirmed during the sample migration step.

Insight Legal Case Management

Client

maps to

Freshsales

Account

1:1
Fully supported

Insight Legal clients map directly to Freshsales Accounts. Client name, address, contact email, and telephone transfer as Account.Name, billing address fields, and Account Phone. Clients without a matter association migrate as standalone Accounts with a source_system_id for audit traceability. This ensures every client record maintains its original identifier for reference matching and reconciliation during the migration process.

Insight Legal Case Management

Contact

maps to

Freshsales

Contact

1:1
Fully supported

Insight Legal contacts (parties on a matter: opposing counsel, witnesses, referrers) map to Freshsales Contacts. Email, phone, job title, and address fields transfer directly. Contacts without a linked Client in Insight Legal attach to a default 'No Account' placeholder Account in Freshsales.

Insight Legal Case Management

Matter

maps to

Freshsales

Deal

1:1
Fully supported

Insight Legal matters translate into Freshsales Deals. Matter title becomes Deal Name, and matter reference numbers are preserved in a custom field (matter_reference__c). Insight Legal's matter status (Open, Closed, Archived) maps to Freshsales Deal stage via a value-mapping table, with Open routing to the first pipeline stage and Closed routing to a Won or Lost stage based on billing outcome.

Insight Legal Case Management

Matter Type / Case Category

maps to

Freshsales

Deal Custom Field: Case_Type__c

1:1
Fully supported

Insight Legal stores matter type as a database column (e.g., Family, Conveyancing, Employment). Freshsales has no native case-type field on Deals. We create a custom picklist field Case_Type__c on the Deal object and populate it via value mapping from the source matter type string. Firms must define the picklist values in Freshsales Settings before migration.

Insight Legal Case Management

Fee Earner

maps to

Freshsales

User / Deal Owner

1:1
Fully supported

Insight Legal fee earners (solicitors, paralegals) map to Freshsales Users by email match. The primary fee earner on a matter becomes the Deal Owner in Freshsales. Secondary fee earners are preserved as a custom multi-select text field (Secondary_Fee_Earners__c) on the Deal. Unmatched fee earners require Freshsales user provisioning before migration or fallback assignment to a designated admin user.

Insight Legal Case Management

Time Record

maps to

Freshsales

Task

1:1
Fully supported

Insight Legal time records (date, duration, narrative, billing rate) map to Freshsales Tasks linked to the parent Deal. Task Subject carries the time-record narrative, Task Due Date carries the record date, and duration in minutes transfers as a custom number field (Time_Minutes__c). Billable vs. non-billable flag from Insight Legal maps to Task Type in Freshsales.

Insight Legal Case Management

Document / Attachment

maps to

Freshsales

Freshsales Files

1:1
Fully supported

Documents and files attached to Insight Legal matters are downloaded from the document management path, re-uploaded to Freshsales Files, and linked to the corresponding Deal record by Deal ID. Original filenames and create dates are preserved in Freshsales File metadata. Files over 25MB require chunked upload via the Freshsales file API.

Insight Legal Case Management

Client Account / Ledger Entry

maps to

Freshsales

Custom Object: Client_Trust__c

1:1
Fully supported

Insight Legal's client account ledger (monies held, disbursements) has no direct Freshsales equivalent. We create a custom object Client_Trust__c with fields for transaction_type, amount, date, and matter_reference. Trust account data is migrated for audit continuity but Freshsales does not process financial transactions — billing must be handled in an accounting system post-migration.

Insight Legal Case Management

Billing / Invoice

maps to

Freshsales

Custom Field on Deal: Last_Bill_Date__c, Total_Billed__c

1:1
Fully supported

Insight Legal bills and invoice records carry total billed amount and last bill date. These values migrate as custom fields on the Deal (Last_Bill_Date__c as date, Total_Billed__c as currency). Freshsales does not have native billing or invoicing — invoice history is preserved as reference data, not as actionable billing records.

Insight Legal Case Management

Key Date / Deadline

maps to

Freshsales

Task

1:1
Fully supported

Insight Legal stores key dates and deadlines against matters. These transfer as Freshsales Tasks with Task Type = 'Deadline' and the original deadline date as the Task Due Date, linked to the parent Deal. Overdue deadlines flagged in Insight Legal carry a custom 'Overdue_at_Migration__c' checkbox set to true for admin review.

Insight Legal Case Management

Custom Field (any)

maps to

Freshsales

Custom Field on corresponding object

1:1
Fully supported

Insight Legal supports user-defined custom fields per firm. Each custom field requires a corresponding Freshsales custom field to be created before migration. Field type parity is enforced: if Insight Legal stores a date, the Freshsales custom field must be Date type. We deliver a custom-field creation checklist as part of the migration plan.

Insight Legal Case Management

User / Staff Record

maps to

Freshsales

Freshsales User

1:1
Fully supported

Insight Legal staff records (name, email, role, department) map to Freshsales Users. Email is the primary match key. Role and department transfer as User custom fields (Role__c, Department__c). Insight Legal's access-control permissions have no Freshsales equivalent — access rules must be rebuilt in Freshsales Profile and Role settings post-migration.

Gotchas + challenges

What specifically takes care here

Platform-specific issues from each side, plus the pair-specific challenges that don't show up on either platform's page on its own.

Insight Legal Case Management logo

Insight Legal Case Management gotchas

High

No public API forces all migrations through vendor services

High

Hybrid hosting creates two distinct extraction paths

Medium

Thousands of fields per matter require explicit scoping

Medium

Trust account compliance data has regulatory retention requirements

Low

Out-of-the-box workflows may not transfer to non-Insight systems

Freshsales logo

Freshsales gotchas

Medium

Freddy AI is Pro-tier only despite heavy marketing

High

Post-migration emails and sequences are disabled

Medium

Bot session credits are a one-time 500-session allocation

Medium

Phone credits charged per minute with no cap

Low

File storage limits scale with plan tier

Pair-specific challenges

  • Matter-type to Deal-stage value mapping requires pre-migration picklist configuration

    Insight Legal stores matter type (Family Law, Conveyancing, Employment) as a flat string in the matters table. Freshsales has no native case-type field on Deals — it uses pipeline stages as the primary deal-progress indicator. We create a custom picklist field Case_Type__c on the Deal object, but Freshsales enforces picklist value pre-configuration before data import. If your Insight Legal matter types include values not yet defined in Freshsales, the import will reject those records. We deliver a picklist-value checklist as part of the migration plan so your Freshsales admin can pre-create every needed value before data lands.

  • Trust account and client ledger data has no native Freshsales equivalent

    Insight Legal maintains client account ledger entries for money held on client account, disbursements, and trust transactions — a core legal accounting construct. Freshsales has no native trust-account, ledger-entry, or client-money object. We migrate ledger data as a custom object (Client_Trust__c) with transaction type, amount, date, and matter reference, but Freshsales will not process trust transactions or produce accounting reports. Your firm must confirm whether legal accounting functionality is needed in Freshsales or whether billing records are migrated purely for historical reference and a separate accounting tool manages active trust accounting post-migration.

  • Insight Legal SQL Server extraction requires database credentials and IT coordination

    Unlike cloud SaaS platforms with OAuth API access, Insight Legal runs on Microsoft SQL Server and requires direct database read access to export data. Your firm's IT administrator or Insight Legal support team must provide read-only SQL credentials, and the migration engine must run from a machine with network access to the database (or a restored backup). Firms using Insight Legal's cloud-hosted option may have a different database access path than those running the desktop version on a local server. We assess the access model during the discovery call and adjust extraction methodology accordingly.

  • Fee earner to Freshsales User resolution depends on email match

    Insight Legal fee earners do not have a native email-to-record link on every matter in the same way a CRM links contacts to owners. During migration, we match fee earner records by email to Freshsales Users and set the matched user as the Deal owner. Any fee earner without a Freshsales User account at migration time is flagged in a pre-flight report and must either be provisioned in Freshsales or assigned to a fallback user. Matters owned by inactive fee earners will not automatically reassign — this requires a mapping decision from your project team before migration runs.

  • Documents and file attachments re-upload without native Insight Legal metadata

    Insight Legal stores documents in a file path or SQL filestream with original create dates, author, and version history. When we re-upload files to Freshsales Files and link them to Deals by ID, Freshsales stores its own file upload timestamp and uploader identity. The original Insight Legal document metadata (author, version number) does not carry over unless your firm has exported those fields to a CSV alongside the files. We include a document metadata export step in the migration plan so that historical file context is preserved in a companion spreadsheet.

Migration approach

Six steps for a successful Insight Legal Case Management to Freshsales data migration

  1. Audit Insight Legal database and design Freshsales custom field schema

    FlitStack connects to the Insight Legal SQL Server database using read-only credentials and inventories all tables: clients, contacts, matters, time_records, key_dates, documents, and staff. We cross-reference with Freshsales' available standard fields and identify every custom field required (Case_Type__c, fee_earner_reference__c, matter_reference__c, Time_Minutes__c, Total_Billed__c, Last_Bill_Date__c, Original_Create_Date__c, Source_System_ID__c). We deliver a Freshsales pre-configuration checklist specifying field names, types, and picklist values your admin creates before migration runs.

  2. Provision Freshsales users and resolve fee earner ownership

    We export Insight Legal staff records and match them to Freshsales Users by email. Any fee earner without a Freshsales account is flagged in a User Mapping Report. Your team provisions those users or designates a fallback owner before the migration run. Unresolved fee earner references do not block the migration — unmatched records assign to the designated fallback owner with a custom field flag (Original_Fee_Earner__c) preserving the original name for post-migration audit.

  3. Extract and transform data, then run sample migration with field-level diff

    FlitStack runs SQL queries against the Insight Legal database to extract all clients, contacts, matters, time records, and key dates in a single coordinated export. We apply field mapping transformations (status-to-stage value mapping, fee earner-to-owner resolution, date format normalization) and write to Freshsales via the REST API. A representative sample — typically 200–500 records spanning multiple matter types and time periods — migrates first. We generate a field-level diff showing every mapped value side-by-side so you verify matter-type mapping, fee earner ownership, and time-record linkage before the full run commits.

  4. Migrate documents and re-link attachments to parent Deal records

    After core data lands in Freshsales, FlitStack downloads documents from the Insight Legal file path, re-uploads them to Freshsales Files, and links each file to the corresponding Deal record by matching matter reference. A document migration manifest records original filename, file path, upload date in Freshsales, and parent Deal ID. Any files exceeding Freshsales' 25MB limit are flagged and chunked upload is used. The document metadata export step runs concurrently, preserving author and version data in a companion CSV.

  5. Run full migration with delta pickup and post-migration validation

    The full dataset migrates to Freshsales in batched API writes respecting Freshsales' rate limit of 100 calls per minute. After the primary migration window closes, a delta-pickup run captures any clients, matters, or time records created or modified in Insight Legal during the cutover period. We run a post-migration validation comparing record counts, field-level totals (total billed, time record minutes), and owner resolution rates against the Insight Legal source. A reconciliation report flags any discrepancies for manual review. One-click rollback reverts all migrated records if critical issues are found before go-live.

Platform deep dives

Context on both ends of the pair

Insight Legal Case Management logo

Insight Legal Case Management

Source

Strengths

  • Combines case management, legal accounting, practice management, and compliance in a single integrated platform
  • Offers both cloud-hosted and on-premise deployment options for UK law firms
  • Built-in workflows for common practice areas reduce initial configuration overhead
  • SRA-compliant trust accounting with dedicated client money handling
  • Mobile apps for iOS and Android support fee-earners working outside the office

Weaknesses

  • No publicly documented API — all data extraction requires vendor-provided migration tooling or manual export
  • Pricing is opaque; firms cannot self-serve tier information and must request a quote
  • Feature depth optimized for mid-to-enterprise practices can create complexity for smaller firms
  • Alternatives like Clio and Smokeball are rated higher on G2 for ease of use in small practice contexts
  • Limited published documentation on custom field limits and schema details
Freshsales logo

Freshsales

Destination

Strengths

  • Generous free tier for small teams with core CRM functionality without per-seat costs.
  • All-in-one sales CRM with built-in telephony, chat, and email reducing third-party tool dependency.
  • Freddy AI contact scoring and deal predictions available on Pro tier.
  • Multiple pipeline views with Kanban and list options across all plans.

Weaknesses

  • Reports lack depth compared to competitors like HubSpot, with limited customization options.
  • Integration setup is poorly documented with no clear guides for connecting third-party tools.
  • AI features gated behind $39/user/month Pro tier despite marketing emphasis on Freddy AI.
  • Bot sessions limited to 500 one-time allocation with no monthly refresh.

Complexity grading

How hard is this migration?

Standard CRM migration. 2 of 8 objects need a mapping; the rest are 1:1.

B

Overall complexity

Standard migration

Derived from compatibility, mapping clarity, API constraints, and data volume across Insight Legal Case Management and Freshsales.

  • Object compatibility

    B

    2 of 8 objects need a mapping; the rest are 1:1.

  • Field mapping clarity

    C

    Field mapping is derived from defaults — final spec confirmed during the sample migration.

  • Timeline complexity

    B

    8-object category — typical timelines run 2–7 days end-to-end.

  • API constraints

    B

    Insight Legal Case Management: Not publicly documented.

  • Data volume sensitivity

    B

    Insight Legal Case Management doesn't expose a bulk API — REST + parallelization used for high-volume runs.

Estimator

Estimate your Insight Legal Case Management to Freshsales migration cost

Rule-based pricing — no per-record fees, no manual quotes. Migrations over 2M records are scoped individually.

Step 1

What are you migrating?

Pick a category, then your source and destination platforms.

Category

FAQ

Frequently asked questions about Insight Legal Case Management to Freshsales data migrations

Answers to the questions buyers ask most during Insight Legal Case Management to Freshsales migration scoping. Not seeing yours? Book a call.

Can't find your answer?

Walk through your Insight Legal Case Management to Freshsales migration with a real engineer — 30 minutes, free, written quote within 24 hours.

Book a free 30 minute consultation

Most Insight Legal to Freshsales migrations complete in 3–5 days of clock time for firms with under 25,000 matters. The longest single phase is Freshsales pre-configuration — creating custom fields for case type, fee earner, billing totals, and matter reference requires manual setup in Freshsales Settings. Firms with 100,000+ matter records or complex multi-fee-earner structures extend to 10–14 days, primarily due to time-record-to-task conversion and document re-upload volume. We sequence the work so your team can begin Freshsales configuration while we build the migration engine.

Adjacent paths

Related migrations to explore

Ready when you are

Move from Insight Legal Case Management.
Land in Freshsales, intact.

Tell us record counts and timeline. We'll come back with a written quote inside 1 business day — no commitment, no sales pitch.

Accuracy guarantee Rollback included Quote in 1 business day