roll-forward

Generate balance-sheet roll-forward schedules tied to GL queries.

31|4|Updated Jun 13, 2026
One-click install
npx skills add https://github.com/r9412460971-cloud/OPC-skill --skill roll-forward-r9412460971-cloud
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: roll-forward
Source: https://github.com/r9412460971-cloud/OPC-skill/tree/main/skills/roll-forward
Command: npx skills add https://github.com/r9412460971-cloud/OPC-skill --skill roll-forward-r9412460971-cloud

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Manually creating balance sheet roll-forward schedules for month-end close and audit is time-consuming and prone to errors, especially when ensuring every line item ties back to general ledger entries and the schedule foots correctly.

Core Features & Use Cases

  • Structured Roll-forward Generation: Creates a standardized schedule that reconciles beginning balance to ending balance for any balance-sheet account or group, with clear line items for additions, accruals, reversals, payments, reclasses, and FX adjustments.
  • GL Traceability: Ties every activity line to a specific GL query via the internal-gl MCP, providing full audit trail and source documentation for each figure.
  • Variance Flagging: Automatically checks if the schedule foots (beginning + activity = ending GL balance) and surfaces any unexplained gaps without plugging them, ensuring accuracy for audit and reporting.
  • Use Case: For a month-end close package for accounts receivable, use this skill to pull all period activity from the GL, tie each line to corresponding journal entries, and validate the schedule matches the ending GL balance, flagging any discrepancies for follow-up.

Quick Start

Use the roll-forward skill to generate a fully tied roll-forward schedule for the inventory account for Q3 2024, citing all relevant GL queries for each line item and flagging any unexplained variances.

Frequently Asked Questions about roll-forward

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

FAQPage Schema
How do I create a balance sheet roll-forward schedule for month-end close?

To create a balance sheet roll-forward schedule, this Skill reconciles beginning balances to ending period general ledger balances by structuring line items for additions, accruals, reversals, and reclasses. It automatically foots the schedule and ties every line to a verifiable GL query.

How does GL traceability work for account reconciliation schedules?

GL traceability for account reconciliation works by tying every roll-forward activity line to a specific general ledger query. This provides full audit trail support and source documentation, ensuring each figure in the financial reporting workflow is verifiable.

What happens if my roll-forward schedule does not foot to the ending GL balance?

If your roll-forward schedule does not foot to the ending GL balance, the Skill surfaces unexplained variances without plugging gaps. It automatically checks if beginning balance plus activity equals the ending balance, flagging discrepancies for audit follow-up.

Can I use this for audit-ready financial reporting across multiple balance sheet accounts?

Yes, you can use this for audit-ready financial reporting across any balance-sheet account or group. It generates standardized schedules applicable to month-end close packages, ensuring full traceability of account activity to source journal entries.

What is the best way to reconcile beginning balances to ending period general ledger balances?

The best way to reconcile beginning balances to ending general ledger balances is using a structured roll-forward schedule that categorizes all period activity. This approach validates additions, accruals, and payments against source journal entries for accurate reporting.

Why does my manual account reconciliation schedule have unexplained variances?

Manual account reconciliation schedules often have unexplained variances because line items are not tied to specific general ledger queries. Automating the roll-forward process ensures every schedule line matches verifiable GL activity and correctly foots to the ending balance.