CRM for Private Equity: Portfolio and Deal Tracking

Private equity firms need a CRM that tracks deal origination and due diligence, monitors portfolio company performance, manages advisor and intermediary relationships, and handles LP communications — all with sensitive deal data kept off third-party servers. DenchClaw is a local-first, open-source AI CRM built on DuckDB that runs entirely on your infrastructure. Here's how to configure it for a PE firm.

What PE Firms Need from a CRM#

Private equity relationship management spans several distinct functions that most CRMs handle poorly:

Deal origination: Tracking proprietary deal flow from business owners, bankers, brokers, and referral networks. Hundreds of opportunities at various stages, each requiring follow-up.

Due diligence: Managing the workflow from initial NDA through management meetings, financial analysis, and closing. Tracking open items across dozens of workstreams.

Portfolio management: Ongoing oversight of invested companies — board meeting schedules, financial reporting, management team changes, add-on acquisition opportunities.

LP management: Capital formation, investor reporting, distribution communications, and relationship maintenance across institutional and private LPs.

Advisor network: Investment bankers, operating advisors, industry experts, and consultants who contribute to both deal flow and portfolio value creation.

DenchClaw's flexible schema handles all of these in a single, locally-hosted system.

Setting Up DenchClaw for Private Equity#

1. Install DenchClaw

npx denchclaw

Opens at http://localhost:3000. All data stored locally in DuckDB.

2. Create a Companies object

Covers both pipeline and portfolio:

• Name (text)
• Description (text)
• Industry (select: Manufacturing, Healthcare, Technology, Business Services, Consumer, Financial Services, etc.)
• Sub-Sector (text)
• Geography (text)
• Revenue (number)
• EBITDA (number)
• EV Range (text)
• Status (select: Tracking → First Contact → NDA → CIM Reviewed → Management Meeting → IOI → LOI → Diligence → Closing → Portfolio → Exited → Passed)
• Deal Type (select: Buyout, Growth Equity, Recap, Add-On, Minority)
• Source (linked to Intermediaries)
• Deal Lead (text)
• First Contact Date (date)
• Investment Date (date)
• Entry EV (number)
• Entry EBITDA Multiple (number)
• Current Status Notes (text)

3. Create an Intermediaries object

Investment bankers, business brokers, and deal finders:

• Name (text)
• Firm (text)
• Type (select: Investment Bank, Business Broker, Independent Sponsor, Finder, Other)
• Phone (text)
• Email (text)
• Coverage (text — industries or geographies they cover)
• Deals Introduced (number)
• Deals Closed (number)
• Relationship Owner (text)
• Last Contact Date (date)
• Status (select: Active, Nurturing, Inactive)
• Notes (text)

4. Create an LPs object

• Name (text)
• Type (select: Pension, Endowment, Foundation, Sovereign Wealth, Fund of Funds, Family Office, HNWI, Corporate)
• Primary Contact (text)
• Fund (text)
• Commitment (number)
• Capital Called % (number)
• Total Distributions (number)
• TVPI (number)
• Status (select: Active, Re-Up Prospect, Former)
• Last Meeting Date (date)
• Next Reporting Date (date)
• Notes (text)

5. Create a Portfolio Performance object

Track quarterly KPIs for each portfolio company:

• Company (linked)
• Period (text — e.g., "Q4 2025")
• Revenue (number)
• EBITDA (number)
• Revenue Growth YoY (number)
• EBITDA Margin (number)
• Headcount (number)
• Key Highlights (text)
• Key Risks (text)
• Next Board Meeting (date)

Managing the Deal Pipeline#

PE deal pipelines are longer and more complex than VC. A single buyout might take 6-18 months from first conversation to close, with dozens of touch points.

Deal origination tracking:

"Show all companies in Tracking or First Contact status with last activity over 60 days ago" "Which intermediaries have sent us deals in the past 6 months?" "How many manufacturing buyout opportunities have we reviewed this year?"

Active diligence management:

Use the kanban view for deals in active process:

NDA → CIM Reviewed → Management Meeting → IOI → LOI → Diligence → Closing

Query for deal pace: "Show all deals in LOI or Diligence sorted by deal lead"

Pass tracking:

Log every pass with a reason. Over time, query: "What are the most common reasons we passed on deals in the last 12 months?"

This analysis sharpens your investment thesis and improves your no-go decisions. If 40% of passes are "too small," you might adjust your sourcing criteria. See how DenchClaw's query interface handles pipeline analysis.

Intermediary Relationship Management#

In private equity, your deal flow quality is directly tied to your intermediary relationships. A top-10 M&A boutique that covers your target sector can generate more proprietary access than 100 cold calls.

Track your intermediary relationships systematically:

Relationship health: "Show all active intermediaries with no contact in 90 days"

Coverage analysis: "Which intermediaries cover healthcare and have sent us a deal in the past year?"

Conversion rates: "How many deals from [banker X] have we closed vs. reviewed?"

The best intermediary relationships are built through responsiveness and honesty. When you pass on a deal, give useful feedback quickly. When you're looking for a specific type of deal, tell your key bankers proactively.

Log every conversation and create follow-up tasks. The banker who remembers you gave them thoughtful feedback last month will give you the call on the next deal.

Portfolio Company Oversight#

After investment, the CRM role shifts to portfolio management. DenchClaw tracks the relationship and performance layer alongside your formal reporting systems.

Board meeting cadence: "Show all portfolio companies with next board meeting this month"

Performance monitoring: Use the Portfolio Performance object to log quarterly KPIs. Query: "Show all portfolio companies with EBITDA growth below 10% in the last two quarters"

Management team tracking: Log changes to management teams in the company's Notes field. Track when you need to make a key hire. Create tasks for recruiting follow-ups.

Add-on acquisition tracking: Create add-on opportunities linked to their parent portfolio company. Track the same pipeline stages as platform deals. Query: "Show all add-on opportunities in diligence by portfolio company"

For building custom dashboards to visualize portfolio performance, see how to build apps in DenchClaw.

LP Relationship Management and Fund Raising#

LP relationships require consistent, proactive management — not just when you're raising a new fund.

Ongoing LP management:

"Show all LPs with last meeting date over 90 days ago" "Which LPs have their next reporting deadline this month?" "Show all re-up prospects sorted by commitment size"

Fund raise pipeline:

When raising, switch to a fund raise pipeline view:

Identified → Introductory Meeting → Diligence → Committed → Closed

Track every prospective LP through the process. Log every meeting, call, and follow-up commitment.

LP reporting preparation:

Query portfolio performance data before each LP update: "Show all portfolio companies with Q4 performance data entered" — identify which companies are missing data and collect it before the reporting deadline.

Operating Advisor and Expert Network#

PE firms build value through operational expertise. Track your advisor network in DenchClaw:

Create an Advisors object:

• Name (text)
• Background (text — career summary)
• Expertise (text — industries, functions)
• Current Engagements (text)
• Status (select: Active Board Member, Active Advisor, Available, Inactive)
• Portfolio Company (linked)
• Relationship Owner (text)
• Notes (text)

Query: "Show all available advisors with healthcare operations expertise" — when a portfolio company needs a new board member, your queryable advisor database is the first place to look.

Frequently Asked Questions#

Can DenchClaw replace Salesforce, Dynamo, or Altvia for PE? DenchClaw can replace spreadsheets, Airtable, and basic CRM platforms for firms that want a flexible, local alternative. Enterprise PE CRM platforms offer deeper LP portal integrations, fund administration connections, and automated reporting. DenchClaw is best for firms that want full control and customization without vendor lock-in.

Is deal flow data private in DenchClaw? Yes. All data is stored locally in a DuckDB file. No deal information, founder data, or LP details are sent to any external servers by default.

Can we import our existing deal database? Yes. Export your current database as CSV (from Airtable, Excel, or your current CRM) and import into DenchClaw. Complex schemas may require some SQL work in the DuckDB layer.

How do we handle multiple funds in DenchClaw? Add a Fund field to your Companies and LPs objects. Filter views by fund to see individual fund pipelines while querying across all funds simultaneously.

Can analysts and partners use DenchClaw simultaneously? Yes. Run DenchClaw on a shared server and all team members access it via browser. Set up role-based access controls to limit what analysts can see vs. partners.

Ready to try DenchClaw? Install in one command: npx denchclaw. Full setup guide →