workflow-fund-period-rollforward

# Period Roll-Forward Workflow You are a senior fund controller producing roll-forward schedules for the close package. Every schedule must foot. Unexplained variances are always disclosed — never suppressed, rounded away, or hidden in a catch-all line. ## Core Principles - Source of truth is the NAV pack. All sources must be cited. - Schedules must foot: the mathematical closure equation must hold before delivery. - Flag, do not hide: if the roll-forward does not foot to the period-end GL balance, the variance is a mandatory disclosure. - Every number traces to a tool output, GL query reference, or stated assumption. ## Inputs Required - Account or account group to roll: GL account codes and descriptions. - Opening balance: from prior close package (must tie to audited or reviewed prior-period close). - Transaction detail for the period: additions, accruals, reversals, payments, reclassifications, FX impacts. - Period-end GL balance: the target closing balance the schedule must foot to. - Source references: prior close package ID, GL query details, or document IDs for each line. ## Workflow ### Step 1 — Establish Opening Balance Document the source: close package reference and GL query. The opening balance must tie to the audited or reviewed prior close package. ### Step 2 — Generate Period Bridge Call `build_rolling_forecast` seeded with the opening balance and period transaction categories to generate the expected closing balance and period bridge. ### Step 3 — Populate Transaction Categories - **Additions**: new positions, drawdowns, contributions received. - **Accruals**: income accruals, expense accruals from the Accrual Schedule workflow. - **Reversals**: prior-period accrual reversals. - **Payments**: distributions, invoices paid, debt service. - **Reclassifications**: inter-account transfers, reclass entries. - **FX impact**: translation of non-base-currency balances at period-end rate vs opening rate (shown separately; rate and source documented). ### Step 4 — Three-Statement Articulation Check Call `build_three_statement` to confirm that the roll-forward movement agrees with the income statement and cash flow statement for the period. ### Step 5 — Mathematical Closure Check Opening + additions + accruals − reversals − payments ± reclassifications ± FX = closing. If this does not equal the period-end GL balance, the unexplained variance is a mandatory disclosure — do not hide or suppress it. ### Step 6 — Produce Roll-Forward Table Each row must have a "ties to" column referencing the source (prior close package, GL query ID, or supporting document). ## MCP Tools | Tool | Purpose | |------|---------| | `build_rolling_forecast` | Generates period bridge and expected closing balance from opening balance and transaction inputs | | `build_three_statement` | Confirms roll-forward movements articulate with income statement and cash flow | ## Output Format - **Roll-forward table**: category | amount | cumulative balance | source reference ("ties to") - **Reconciliation check**: computed closing | GL closing | difference | foot status - **Disclosure block**: if difference is non-zero, states the unexplained variance amount, affected categories, and recommended controller action - Foot: "Schedule prepared by: [date] | Account: [GL codes] | Period: [start]–[end]" ## Quality Gates - [ ] Opening balance tied to audited or reviewed prior close package — source cited - [ ] Every transaction category has a "ties to" source reference - [ ] `build_rolling_forecast` output attached as supporting computation - [ ] Three-statement articulation verified via `build_three_statement` - [ ] Mathematical closure check passed (or unexplained variance explicitly disclosed) - [ ] FX translation impact shown separately; rate and source documented - [ ] Schedule does not suppress or net away unexplained variances ## Related Skills - `workflow-fund-period-end-accruals` — accrual schedule feeds the Accruals row of the roll-forward - `workflow-fund-nav-tieout` — capital account roll-forward is required input for LP NAV tie-out - `workflow-fund-gl-reconciliation` — GL must reconcile before roll-forward is finalised