portfolio-monitoring

Extract KPIs and flag variances from portfolio company financial packages.

Updated Aug 23, 2026
One-click install
npx skills add https://github.com/brianping7/volc-financial-services-skill-sets --skill portfolio-monitoring-brianping7
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: portfolio-monitoring
Source: https://github.com/brianping7/volc-financial-services-skill-sets/tree/main/private-equity/portfolio-monitoring
Command: npx skills add https://github.com/brianping7/volc-financial-services-skill-sets --skill portfolio-monitoring-brianping7

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Track and summarize portfolio company financial performance versus plan and prior periods to eliminate manual spreadsheet reviews and speed board- and lender-ready reporting. The Skill ingests monthly or quarterly financial packages, extracts key KPIs, highlights material variances, and surfaces covenant or liquidity risks so decision-makers see issues immediately.

Core Features & Use Cases

  • Document ingestion: Accept Excel workbooks, PDFs, or CSVs and locate period, budget, and actuals information.
  • KPI extraction: Pull revenue, EBITDA, cash balance, net debt, capex, working capital and other agreed KPIs and normalize across periods.
  • Variance analysis & traffic lights: Compare actuals to budget and prior periods, apply color-coded flags (green/yellow/red) based on configurable thresholds, and call out covenant breaches.
  • Trend analysis & summary: Produce concise executive summaries, trend charts across multiple periods, and a table of issues/questions for management or the board.
  • Use case: Ingest a monthly financial pack for PortfolioCo and output a one-page board-ready summary that highlights cash trends, EBITDA variance, and any covenant concerns.

Quick Start

Upload the company's monthly financial package and ask the assistant to "Review PortfolioCo performance vs plan, extract KPIs, flag variances, and summarize covenant status for the latest period".

Frequently Asked Questions about portfolio-monitoring

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

FAQPage Schema
How do I extract financial KPIs from a PDF and Excel portfolio package?

To extract financial KPIs from a PDF and Excel portfolio package, upload the monthly or quarterly financial documents and the tool will locate period, budget, and actuals information to pull revenue, EBITDA, and cash balance metrics.

Can I automate variance analysis and flag covenant breaches in financial reporting?

You can automate variance analysis by comparing actuals to budget and prior periods, applying configurable color-coded threshold flags, and calling out covenant or liquidity risks to surface issues immediately.

What is the best way to generate a board-ready summary from monthly financial statements?

The best way to generate a board-ready summary from monthly financial statements is to ingest the financial pack, extract KPIs, flag material variances, and produce a concise executive summary highlighting cash trends and EBITDA variance.

Does portfolio monitoring work with CSV files for multi-period trend analysis?

Portfolio monitoring works with CSV files, Excel workbooks, and PDFs, normalizing extracted financial metrics across periods to perform optional multi-period trend analysis and generate visual trend charts.

How do I compare actuals to budget and prior periods automatically?

To compare actuals to budget and prior periods automatically, the tool applies configurable variance thresholds with green, yellow, or red traffic light tags to highlight material deviations and required management questions.