
Skill
roll-forward
build roll-forward schedules for balance sheets
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.
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).
More skills from the financial-services repository
View all 62 skills3-statement-model
fill out 3-statement financial models
May 15ExcelFinanceFinancial ModelingFinancial Statementsaccrual-schedule
build period-end accrual schedules
May 6AccountingFinanceJournal EntryMonth-End Closeai-readiness
identify AI opportunities in portfolio companies
May 21AI InfrastructureOperationsPrivate EquityStrategyaudit-xls
audit spreadsheets for formula accuracy
May 15AuditExcelFinanceSpreadsheetsbond-futures-basis
analyze bond futures basis
May 15DerivativesFinanceFixed IncomeTradingbond-relative-value
perform bond relative value analysis
May 15FinanceFixed IncomeTrading
More from Anthropic
View publisheralgorithmic-art
create algorithmic art with p5.js
skills
Apr 6CreativeDesignGenerative ArtJavaScriptbrand-guidelines
apply Anthropic brand colors and typography
skills
Apr 6BrandingDesignTypographycanvas-design
create posters and visual art as PNG or PDF
skills
Apr 6CreativeDesignPDFclaude-api
build apps with the Claude API
skills
Apr 6AgentsAnthropicAnthropic SDKClaude API +1doc-coauthoring
co-author documentation and technical specs
skills
Apr 6DocumentationTechnical Writingdocx
create and edit Word documents
skills
Jul 18DocumentsDOCXOfficeTemplates +1