Skip to content
cccskills
FreePublished on GitHub

roll-forward

Build a balance-sheet account schedule showing how the opening balance changes into the closing balance. Link each movement to general ledger records or supporting documents, check the arithmetic, and report any unexplained difference for close or audit work.

OriginalShow the original 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.

See how to install

Good for

  • Preparing balance movement schedules for month-end close
  • Linking account movements to evidence for an audit
  • Checking opening-to-closing balance reconciliation
  • Identifying unexplained differences in an account

Files included (1)

  • SKILL.md1.4 KB

SKILL.md (original)

Review the instructions the agent will receive before you install.

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).

Reviews

No reviews yet. Tell others what you thought.

Comments

No login needed. Share how it worked for you, ask a question, or note where it did not run.

No comments yet. Be the first to write one.

Comments are published right away. Do not include personal information such as email addresses or phone numbers. Up to 2 URLs.

0 / 1,000 characters

This form is protected by reCAPTCHA, and the Google Privacy Policy and Terms of Service apply.

More skills from this repository

Complete an existing financial model template by entering historical data and forecast assumptions, then linking the income statement, balance sheet, and cash flow statement with formulas. Check statement balances, cash consistency, and scenario behavior as each section is completed.

  • Complete a partially filled financial model
  • Link forecasts across three financial statements
  • Check balance sheet and cash flow consistency
anthropics/financial-services40.3KUpdated Sep 22, 2026

accrual-schedule

FreeSummary

Prepare a period-end accrual schedule for expenses incurred but not yet fully recorded. Apply company policy, subtract amounts already booked, cite supporting records, and draft journal entries for controller approval, including reversal notes where required.

  • Preparing an accrual schedule for month-end close
  • Calculating audit fee, bonus, or utilities accruals
  • Drafting journal entries with supporting references
anthropics/financial-services40.3KUpdated Sep 22, 2026

ai-readiness

FreeSummary

Review quarterly updates and financials across portfolio companies to identify practical AI opportunities. Rank them by estimated profit impact, speed, and feasibility, then outline first steps and approaches that other companies can reuse.

  • Quarterly reviews of AI opportunities across portfolio companies
  • Prioritizing companies for AI investment and operational support
  • Finding ways to reuse successful AI projects across companies
anthropics/financial-services40.3KUpdated Sep 22, 2026

audit-xls

FreeSummary

Check spreadsheet formulas for errors, broken references, inconsistent calculations, and unit mismatches. Review a selected range, one sheet, or an entire financial model, then receive findings ranked by severity with suggested fixes.

  • Checking formulas in a selected range
  • Investigating a balance sheet that does not balance
  • Reviewing a financial model before client delivery
anthropics/financial-services40.3KUpdated Sep 22, 2026

Analyze price differences between bond futures and cash bonds, identify the cheapest bond to deliver, and compare implied financing rates with market rates. Present valuation tables and historical context to assess potential basis trades.

  • Comparing bond futures with cash bond prices
  • Identifying the cheapest bond to deliver
  • Comparing implied financing rates with market rates
anthropics/financial-services40.3KUpdated Sep 22, 2026

Assess whether bonds are expensive, cheap, or fairly priced by comparing yields with government rates and credit risk benchmarks. Combine spread breakdowns, historical context, and interest rate scenarios into tables and a recommendation.

  • Comparing the relative value of candidate bonds
  • Separating credit risk from other yield differences
  • Estimating gains and losses under interest rate shifts
anthropics/financial-services40.3KUpdated Sep 22, 2026

See all skills by anthropics

Report a problem with this skill