roll-forward
Build a roll-forward schedule for a balance-sheet account — beginning balance plus activity less reversals equals ending balance, with each component tied to GL. Use for month-end close packages and audit support.
- License 许可
- Apache-2.0
- 最近更新
- 2026-10-29
- Stars
- ★ 4.1w
- Forks
- 5.7k
01 前言 Front Matter
- name
- roll-forward
- description
- Build a roll-forward schedule for a balance-sheet account — beginning balance plus activity less reversals equals ending balance, with each component tied to GL. Use for month-end close packages and audit support.
03 SKILL.md 正文
Roll-forward
Given an account (or account group), entity, and period, produce a roll-forward that ties beginning to ending.
Structure
Beginning balance (per prior-period close) X
+ Additions / new activity A
+ Accruals booked this period B
− Reversals of prior accruals (C)
− Payments / settlements (D)
± Reclasses / adjustments E
± FX translation F
Ending balance (per GL at period end) Y
Tie each line
- Beginning — prior-period close package, or GL balance at prior-period end date.
- Each activity line — a GL query (account + date range + journal-source filter) via the internal-gl MCP. Cite the query.
- Ending — GL balance at period-end date.
The schedule must foot: X + A + B − C − D + E + F = Y. If it doesn't, the gap is an unexplained item — surface it, don't plug it.
Output
The roll-forward table with a "ties to" column citing the GL query or document for every line, plus a foot check (pass/fail and the unexplained delta if any).
04 同仓库更多 Skills
value-creation-plan
Structure post-acquisition value creation plans with revenue, cost, and operational levers mapped to an EBITDA bridge. Includes 100-day priorities, KPI targets, and accountability frameworks. Use when planning post-close execution, preparing operating partner materials, or building a board-ready value creation roadmap. Triggers on "value creation plan", "100-day plan", "post-close plan", "EBITDA bridge", "operating plan", or "value creation levers".
unit-economics
Analyze unit economics for PE targets — ARR cohorts, LTV/CAC, net retention, payback periods, revenue quality, and margin waterfall. Essential for software/SaaS, recurring revenue, and subscription businesses. Use when evaluating revenue quality, building a cohort analysis, or assessing customer economics. Triggers on "unit economics", "cohort analysis", "ARR analysis", "LTV CAC", "net retention", "revenue quality", or "customer economics".
returns-analysis
Build quick IRR/MOIC sensitivity tables for PE deal evaluation. Models returns across entry multiple, leverage, exit multiple, growth, and hold period scenarios. Use when sizing up a deal, stress-testing assumptions, or preparing IC returns exhibits. Triggers on "returns analysis", "IRR sensitivity", "MOIC table", "what's the return at", "model the returns", or "back of the envelope".
portfolio-monitoring
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".
ic-memo
Draft a structured investment committee memo for PE deal approval. Synthesizes due diligence findings, financial analysis, and deal terms into a professional IC-ready document. Use when preparing for investment committee, writing up a deal, or creating a formal recommendation. Triggers on "write IC memo", "investment committee memo", "deal write-up", "prepare IC materials", or "recommendation memo".
deal-sourcing
PE deal sourcing workflow — discover target companies, check CRM for existing relationships, and draft personalized founder outreach emails. Use when sourcing new deals, prospecting companies in a sector, or reaching out to founders. Triggers on "find companies", "source deals", "draft founder email", "check if we've seen this company", or "outreach to founder".