Portfolio Monitoring and KPIs

A standard monthly pack, a KPI dictionary and dashboard, covenant headroom checks, an early warning watchlist and quarterly valuation workpapers for tracking portfolio companies between board meetings.

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

Then open the Marketplace in the app, search for Portfolio Monitoring and KPIs, 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

203

Starter tasks

💹 Private Equity & Venture Capital

Portfolio Monitoring and KPIs

Tracking portfolio companies between board meetings: monthly reporting templates, KPI dashboards, covenant headroom, early warning signs and valuation updates.

  1. Portfolio company monitoring inventory
  2. Information rights and reporting obligations map
  3. Standard monthly management reporting pack
  4. KPI definitions dictionary
  5. Choosing the KPIs that test each investment thesis
  6. Budget and investment case baselines
  7. Covenant headroom calculator
  8. Portfolio reporting calendar
  9. Portfolio data store and version control
  10. Monthly pack receipt and chase routine
  11. Monthly KPI and variance review
  12. Portfolio KPI dashboard
  13. Quarterly covenant compliance review
  14. Thirteen-week cash flow review for watchlist companies
  15. Early warning watchlist
  16. Monthly CFO check-in calls
  17. Quarterly portfolio company valuation update
  18. Restatement and data quality log
  19. Quarterly portfolio review with the partners
  20. Annual budget intake and re-baselining
  21. Reading a monthly management pack in thirty minutes
  22. Covenant definitions and cure rights explained
  23. Cash conversion and working capital metrics
  24. Recurring revenue metrics for software holdings
  25. Valuation methods for unquoted holdings
  26. Leading indicators by business model
  27. Price, volume and mix variance bridges
  28. Portfolio monitoring software selection
  29. Standard chart of accounts mapping
  30. Automating pack collection from company systems
  31. KPI set review after the first year
  32. Reforecast trigger rules
  33. Watchlist escalation protocol
  34. Risk-based reporting tiers
  35. Year-end audit and management accounts reconciliation
  36. Preparing for a tight covenant test date
  37. Half-year valuation committee submission
  38. Annual monitoring lookback
  39. Deal anniversary review against the investment case
  40. Inheriting a portfolio company from a departing colleague
  41. Monitoring a minority growth stake
  42. Monitoring on a lean fund team
  43. Monitoring cover during leave or a live deal
  44. Monitoring companies that report in other currencies
  45. Monitoring through a covenant breach or waiver
  46. Portfolio concentration and shared exposure map
  47. Debt maturity and hedging tracker
  48. Sustainability data collection across the portfolio
  49. Back-testing early warning signals
  50. Benchmarking portfolio companies against peers

Where it starts.

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

Portfolio company monitoring inventory

Before any dashboard is worth building you need one record per portfolio company listing who owns the relationship, the closing date, the fund's ownership, the lenders and where the governing documents sit. Most teams find gaps here: a facilities agreement nobody saved, or a CFO who left and was never replaced in the contact list.

First tasks

  • List every current portfolio company with its deal lead and closing date
  • Record the CFO and a backup finance contact for each company
  • Save links to the shareholders' agreement, facilities agreement and deal model
  • Ask the deal lead for any governing document that is missing

Information rights and reporting obligations map

Shareholders' agreements and facilities agreements both say what the company must send and by when, and the two rarely match: lenders may want monthly accounts within 30 days while the investor's rights say 20 working days. Mapping every obligation per company tells you what you can insist on, what the lenders will see before you do, and where the company is already late.

First tasks

  • Pull the information rights clause from each shareholders' agreement
  • Extract the reporting deadlines from each facilities agreement
  • Tabulate deliverable, recipient, deadline and source clause per company
  • Flag every case where investor and lender deadlines differ

Standard monthly management reporting pack

Ten companies sending ten different packs means every review starts with hunting for the cash line. A standard pack agreed with each CFO fixes the core pages: P&L against budget and prior year, balance sheet, cash flow, net debt, a KPI page and a page of management commentary. Companies can add their own pages behind it, but the first six should always look the same.

First tasks

  • Collect the latest monthly pack from each portfolio company
  • Draft the six fixed pages using the best existing pack as a base
  • Walk each CFO through the template on a short call
  • Write the agreed submission deadline on the template cover
  • Review the pack template with CFOs after budgets are set @recurring(yearly)

Make it yours.

Install Portfolio Monitoring and KPIs, 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.