Portfolio Monitoring

Extract KPIs from Excel, PDF, or CSV and analyze variances against plan.

1|Updated May 16, 2026
One-click install
npx skills add https://github.com/executiveusa/Cheggie-trade-V2 --skill portfolio-monitoring-executiveusa
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: Portfolio Monitoring
Source: https://github.com/executiveusa/Cheggie-trade-V2/tree/main/core/financial-skills/plugins/vertical-plugins/private-equity/skills/portfolio-monitoring
Command: npx skills add https://github.com/executiveusa/Cheggie-trade-V2 --skill portfolio-monitoring-executiveusa

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

It solves the problem of reviewing portfolio company performance without manually reconciling monthly or quarterly financials, budgets, and covenant signals into a clear variance story for stakeholders.

Core Features & Use Cases

  • Ingest financial packages and extract KPIs: Pulls reporting period financials (e.g., revenue, EBITDA, cash, debt, capex, working capital) from Excel/PDF/CSV into a comparable KPI set.
  • Analyze variances to budget and flag risk: Compares actuals to plan and prior period, highlights red/yellow performance gaps, and surfaces covenant compliance status when provided.
  • Produce board-ready summaries and trends: Generates an executive summary, an actual vs. budget vs. prior KPI table, management questions, and trend interpretation when multiple periods exist.
  • Use cases: Portfolio reviews, preparation of board materials, covenant monitoring, and ongoing performance updates for investment teams.

Quick Start

Use the skill to review a provided portfolio company financial package by asking: "Analyze this company's monthly financials against the budget/plan and summarize the key KPI variances and covenant status."

Frequently Asked Questions about Portfolio Monitoring

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I analyze portfolio company financials against budget and prepare board-ready reports?

To analyze portfolio company financials against budget, ingest monthly or quarterly reporting packages in Excel, PDF, or CSV format to extract core KPIs like revenue, EBITDA, and cash. The process compares actuals to plan and prior periods, flags red and yellow variance gaps with context, and generates an executive summary with a covenant compliance status for board materials.

What financial KPIs are tracked during portfolio performance variance analysis?

Portfolio performance variance analysis tracks financial KPIs including revenue, EBITDA, cash, debt, capex, and working capital. It compares these actual metrics against budget and prior period figures, flagging red and yellow performance gaps and surfacing covenant compliance status across leverage and profitability metrics.

Can I extract financial KPIs from PDF and Excel packages for covenant monitoring?

Yes, you can extract financial KPIs from PDF, Excel, and CSV financial packages for covenant monitoring. The ingestion process pulls reporting period financials such as revenue, EBITDA, cash, and debt into a comparable KPI set, then surfaces covenant compliance status across leverage and cash metrics for portfolio reviews.

What's the best way to automate board reporting from multiple periods of portfolio financials?

The best way to automate board reporting from multiple periods is to ingest sequential financial packages to build a comparable KPI set. This generates an executive summary, an actual versus budget versus prior KPI table, management questions, and trend interpretation across revenue, profitability, leverage, and cash metrics for board materials.

Does portfolio monitoring work with CSV financial packages or only Excel and PDF?

Portfolio monitoring works with CSV financial packages in addition to Excel and PDF formats. It ingests monthly or quarterly financial reporting packages across all three formats to extract core financial KPIs, compare actuals to budget, and produce board-ready summaries with variance flags and trend interpretation.

Why do I need to flag red and yellow variances in portfolio company reviews?

You need to flag red and yellow variances in portfolio company reviews to highlight performance gaps against the budget or prior period that require stakeholder attention. These flags provide context for actual versus plan deviations in revenue, profitability, leverage, and cash metrics, directly informing management questions and board material preparation.