Skip to main content
skill Claude Code CX Codex Cursor GitHub Copilot official · Anthropic

portfolio-monitoring — Claude Code skill: install and overview

Analyzes portfolio company financial reports in Excel or PDF, tracks variances against budget, and flags covenant breach risks.

Install into Claude Code · Skills CLI (Vercel) All methods and platforms ↓
npx skills add anthropics/financial-services --skill portfolio-monitoring -a claude-code
Open on GitHub

What portfolio-monitoring does

The skill processes portfolio company financial packages provided as Excel workbooks, PDF files, or CSV exports. It extracts financial metrics including revenue, EBITDA, cash balance, debt, and capex. It then contrasts actual figures against the operating plan and prior reporting periods.

Variances follow three thresholds. Figures within 5% of plan show green, gaps between 5% and 15% trigger yellow warning flags, and drops beyond 15% or covenant issues turn red. The output delivers an executive summary, a KPI comparison table, and questions for management. Before verifying covenants, the agent prompts the user directly for credit agreement terms.

What it helps with

  • Extract revenue and EBITDA figures from quarterly Excel or PDF reports
  • Calculate financial variances against the annual budget and prior periods
  • Identify potential debt covenant breaches and solvency risks early
  • Draft board-ready executive summaries with questions for management

Example prompts for the agent

  • Review portfolio company performance using Q3_financials.xlsx
  • Check covenant compliance and flag budget variances for Acme Corp
  • Generate a monthly financials summary from financials.pdf

How to install portfolio-monitoring

1Skills CLI (Vercel)

npx skills add anthropics/financial-services --skill portfolio-monitoring -a claude-code

2Manually: put the files in place

~/.claude/skills/portfolio-monitoring/SKILL.md

Copy the whole skill folder; for one project use .claude/skills/portfolio-monitoring/

From the same set51

The whole set →
earnings-analysis official anthropics Builds quarterly earnings update reports with beat/miss analysis, revised estimates, key metrics, charts, and the effect on the investment thesis. Claude Code CX Codex Cursor +1 3,300installs equity-research official anthropics Builds a stock snapshot from analyst consensus, financials, price history and macro data. Useful when you need to size up a company fast. Claude Code CX Codex Cursor +1 3,200installs competitive-analysis official anthropics A framework for building competitor analysis decks in PowerPoint or chat. It clarifies project scope, then builds verified slides once the outline is approved. Claude Code CX Codex Cursor +1 2,400installs pitch-deck official anthropics Fills an existing investment banking deck template with data from source files. Use it to move figures into established slide layouts, not to build a deck from scratch. Claude Code CX Codex Cursor +1 2,400installs dcf-model official anthropics Builds an institutional-grade DCF valuation model: pulls data from SEC filings and analyst reports, computes WACC and cash flows, and outputs an Excel model with sensitivity analysis. Claude Code CX Codex Cursor +1 2,400installs ppt-template-creator official anthropics A skill that converts PowerPoint templates into self-contained, reusable skills. Analyze your .pptx, extract all layouts and placeholders with exact coordinates, and package everything as a ready-to-use skill. Claude Code CX Codex Cursor +1 2,300installs macro-rates-monitor official anthropics Builds macro and rates dashboards by combining inflation breakevens, yield curves, and swap spreads into a single analysis. Claude Code CX Codex Cursor +1 2,300installs audit-xls official anthropics Audits Excel sheets for formula errors, hardcoded values, and logic breaks. It checks financial model integrity before sharing work with clients or review committees. Claude Code CX Codex Cursor +1 2,200installs

Similar

cmux-billing manaflow-ai Runbook for cmux billing architecture covering Stripe Checkout, subscription tiers, webhooks, and entitlement overrides during backend development. Claude Code CX Codex Cursor +1 3,700installs invoice-chase official anthropics Finds overdue invoices, checks recent payment activity and drafts customer-specific reminders. The owner reviews each message before anything is sent. Claude Code CX Codex Cursor +1 2,000installs cash-flow-snapshot official anthropics Pulls AR, AP, fixed costs and payment history from accounting software, payment processors, or CSV. Produces a 30/60/90-day cash forecast with confidence bands and flags specific liquidity risks. Claude Code CX Codex Cursor +1 1,900installs business-pulse official anthropics Builds a compact business snapshot from connected finance, sales, and work tools. Use it for a daily brief or to find what needs attention today. Claude Code CX Codex Cursor +1 1,800installs close-month official anthropics Closes the books, reconciles transactions against payment processors, refreshes the 30/60/90-day cash forecast, and publishes the close packet. Claude Code CX Codex Cursor +1 1,800installs churn-prevention coreyhaines31 A Claude Code skill for subscription churn: an exit survey at cancellation, an offer matched to the stated reason, and recovery of failed payments. Claude Code CX Codex Cursor +1 120,600installs revops coreyhaines31 This skill helps design RevOps workflows for lead stages, scoring, routing, and marketing-to-sales handoffs. Use it when CRM processes need clear rules. Claude Code CX Codex Cursor +1 113,000installs community-marketing coreyhaines31 Builds and grows branded communities on Discord or Slack to drive product retention and turn users into advocates. Claude Code CX Codex Cursor +1 89,100installs

Questions about portfolio-monitoring

How to install portfolio-monitoring in Claude Code?

Run npx skills add anthropics/financial-services --skill portfolio-monitoring -a claude-code. Claude Code saves the skill definition to ~/.claude/skills/portfolio-monitoring/SKILL.md.

What file formats can portfolio-monitoring process?

It accepts financial reports in Excel, PDF, and CSV formats. From those documents, it extracts core metrics like revenue, EBITDA, cash balance, capex, and net debt.

How does the skill categorize budget variances?

Variances within 5% of budget receive a green status. Differences between 5% and 15% are marked yellow for discussion, while deficits greater than 15% or covenant risks trigger red alerts.

Source text

SKILL.md · Apache-2.0
---
name: portfolio-monitoring
description: Track and analyze portfolio company performance against plan. Ingests monthly/quarterly financial packages (Excel, PDF), extracts KPIs, flags variances to budget, and produces summary dashboards. Use when reviewing portfolio company financials, preparing board materials, or monitoring covenant compliance. Triggers on "review portfolio company", "monthly financials", "how is [company] performing", "covenant check", or "portfolio update".
---

# Portfolio Monitoring

## Workflow

### Step 1: Ingest Financial Package

- Accept the user's portfolio company financial package (Excel workbook, PDF, or CSV)
- Extract key financials: Revenue, EBITDA, cash balance, debt outstanding, capex, working capital
- Identify the reporting period and compare to prior period and budget/plan

### Step 2: KPI Extraction & Variance Analysis

Key metrics to track (adapt to the company's sector):

**Financial KPIs:**
- Revenue vs. budget ($ and %)
- EBITDA and EBITDA margin vs. budget
- Cash balance and net debt
- Leverage ratio (Net Debt / LTM EBITDA)
- Interest coverage ratio
- Capex vs. budget
- Free cash flow

**Operational KPIs** (ask user or infer from data):
- Customer count / revenue per customer
- Employee headcount / revenue per employee
- Backlog / pipeline
- Churn / retention rates

### Step 3: Flag & Summarize

- **Green**: Within 5% of plan
- **Yellow**: 5-15% below plan — flag for discussion
- **Red**: >15% below plan or covenant breach risk — immediate attention

Output a concise summary:
1. One-paragraph executive summary ("Company X is tracking [ahead/behind/on] plan...")
2. KPI table with actual vs. budget vs. prior period
3. Red/yellow flags with context
4. Covenant compliance status (if applicable)
5. Questions for management

### Step 4: Trend Analysis

If multiple periods are provided:
- Chart key metrics over time (revenue, EBITDA, cash)
- Identify trends — accelerating, decelerating, or stable
- Compare vs. underwriting case

## Important Notes

- Always ask for the budget/plan to compare against if not provided
- Don't assume sector-specific KPIs — ask what matters for this company
- If covenant levels aren't known, ask the user for the credit agreement terms
- Output should be board-ready — concise, factual, no fluff

© anthropics · Apache-2.0 · anthropics/financial-services

See also

Project sponsors

Companies that keep this analytics open
Gold sponsor

Impressions, clicks and code copies — open statistics. We keep the numbers public for the same reason NeBlask itself is public. Become a sponsor