Deal Pipeline CRM

Clear stages, clean intermediary and relationship records, a weekly partner pipeline pack and a hygiene routine, so the deal system you run in DealCloud, Affinity or a spreadsheet is one the team trusts.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Then open the Marketplace in the app, search for Deal Pipeline CRM, and click Install. It goes into your own files, and works offline from then on.

Before you start: this plan is general information to help your team organise its work. It is not financial, investment, tax, accounting or legal advice, and it does not recommend any product, investment or deal. Rules differ between countries, so check decisions that matter with qualified, licensed advisers in the countries concerned. Investing can lose money, and raising or managing other people's money is regulated in most countries.

What it installs.

1

Pillar

1

Area

50

Projects

200

Starter tasks

💹 Private Equity & Venture Capital

Deal Pipeline CRM

Running a deal pipeline system such as DealCloud or Affinity: stages, intermediary records, relationship history, reports for partner meetings and data hygiene.

  1. Inventory of where deal data lives today
  2. Pipeline stage definitions with entry and exit rules
  3. Minimum required fields for a deal record
  4. Intermediary firm and banker record structure
  5. Contact and relationship history model
  6. Deal naming and codename conventions
  7. Pass reasons and dead deal codes
  8. Deal ownership and coverage assignment rules
  9. Access permissions and confidential deal walls
  10. Naming the CRM owner and admin role
  11. Friday deal record update by each deal lead
  12. Monday pipeline pack for the partner meeting
  13. Monthly stale deal sweep
  14. Duplicate company and contact merge routine
  15. Missing field and data quality report
  16. Email and calendar capture check
  17. Monthly adoption and usage check
  18. Quarterly pipeline funnel and conversion report
  19. Quarterly relationship coverage report
  20. Yearly configuration review of the pipeline system
  21. Writing useful interaction notes after calls
  22. Building saved views and dashboards for your coverage
  23. Pipeline metrics that mean something in private equity
  24. Relationship intelligence and introduction paths
  25. Consistent sector, deal type and size tagging
  26. Exporting and analysing pipeline data in a spreadsheet
  27. Admin basics for fields, picklists and layouts
  28. Choosing a deal pipeline platform
  29. Migrating from spreadsheets into the new system
  30. Email and calendar integration set-up
  31. Linking a company data provider to records
  32. Document and data room link policy
  33. Personal data retention policy for contacts
  34. Retiring unused fields, stages and reports
  35. Quick capture from a phone after meetings
  36. Platform contract renewal and vendor review
  37. Go-live day and team training session
  38. Annual pipeline retrospective for the partners
  39. Deal flow statistics for a fund raise
  40. Rolling out a major platform release
  41. Spreadsheet pipeline for a searcher or independent sponsor
  42. Learning an established CRM as a new associate
  43. Handing over records when a team member leaves
  44. Shared upkeep rota for a team without an admin
  45. Merging two pipelines after teams combine
  46. Add-on targets and platform deals in one system
  47. Lenders, co-investors and advisers on deal records
  48. Stage change alerts and automated tasks
  49. Prior contact and conflicts check from records
  50. Three-year analysis of time to decision

Where it starts.

Each project arrives with its purpose, milestones and first tasks written out. Here is how the first three read.

Inventory of where deal data lives today

Before changing anything, find out where the pipeline really is: a partner's spreadsheet, three inboxes, a shared drive of teasers and half a CRM nobody updates. A one-page inventory of every source, its owner and how current it is shows what the system has to replace and what it must never lose. This is a team plan, best installed into a shared workspace so each role can own its tasks.

First tasks

  • CRM owner lists the spreadsheets, inboxes and drives holding deal data
  • Ask each deal team member to walk the CRM owner through their deals
  • Mark each source as current, partly current or abandoned
  • Note the fields that exist in only one source

Pipeline stage definitions with entry and exit rules

When one partner's "live" is another's "looked at the teaser", every pipeline count is an argument. Writing each stage with a plain entry rule and exit rule, such as NDA signed, management meeting held or IOI submitted, makes the numbers mean the same thing to everyone who reads them.

First tasks

  • Write down the stages the team uses today in their own words
  • Draft an entry rule for each stage tied to a real event
  • Agree how on-hold and paused deals are shown
  • Take the stage list to a partner meeting for sign-off

Minimum required fields for a deal record

Records with forty optional fields end up with four filled in, and never the same four. Choosing the eight to twelve fields every deal must carry, such as source, sector, deal lead, stage, enterprise value band and next step, gives reports something to stand on and keeps entry under two minutes.

First tasks

  • Pull the fields used in the last three partner meeting reports
  • Cut the list to the twelve fields every deal must have
  • Write a one-line definition and picklist for each field
  • Turn on required-field rules in the system

Make it yours.

Install Deal Pipeline CRM, then tell Aurum the date you're aiming for. It checks whether the plan fits the weeks you actually have.

Free · Mac (Apple silicon) and Windows · v1.0.5 · Other platforms

Blueprints are general information to help you organise your own work. They are not medical, financial, legal or other professional advice. See the Terms.