---
title: "List sealed consolidation worksheet versions and periods"
method: GET
path: "/companies/{companyId}/reporting-scopes/{reportingScopeId}/worksheet/periods"
tags: ["Company Settings"]
---

# List sealed consolidation worksheet versions and periods

`GET /companies/{companyId}/reporting-scopes/{reportingScopeId}/worksheet/periods`

## Request

- Base URL: `https://api.medianfi.com/api/v1`
- URL: `https://api.medianfi.com/api/v1/companies/{companyId}/reporting-scopes/{reportingScopeId}/worksheet/periods`
- Auth: HTTP bearer

Enumerates every sealed hierarchy version and period that has a sealed consolidation worksheet, each with per-stage availability flags, so the client can select a versionId and periodEnd for the worksheet read. Requires explicit all-entity access. Returns available:false with an honest reason when no consolidation scope or sealed worksheet exists.

## Response `200`

Sealed worksheet version and period list, or an honest-unavailable envelope

- ReportingScopeWorksheetPeriodsResponse
  - `success` boolean, required
  - `data` ReportingScopeWorksheetPeriods, required
    - `available` boolean, required
    - `reason` 'no_consolidation_scope' | 'no_sealed_version' | 'no_sealed_worksheet' | 'null', nullable, required: Honest-unavailable reason. no_consolidation_scope = the scope does not exist for this company; no_sealed_version = no sealed hierarchy version; no_sealed_worksheet = the version (or requested period) has no sealed rollup authority. Null when available is true.
    - `scope` ReportingScope, required: A read-only consolidated reporting identity within one company. It is not a legal entity and cannot own postings, integrations, schedules, AR/AP items, Forecast state, or any other accounting fact.
      - `id` string, uuid, required
      - `companyId` string, uuid, required
      - `kind` 'consolidated', required
      - `label` string, required
      - `rootEntityId` string, uuid, required: The company's one persisted primary legal entity.
      - `createdByUserId` string, uuid, nullable, required
      - `createdAt` string, date-time, required
      - `retiredAt` string, date-time, nullable, required
    - `periods` ReportingScopeWorksheetPeriodSummary[], required
      - `reportingScopeVersionId` string, uuid, required
      - `periodStart` string, date, required
      - `periodEnd` string, date, required
      - `presentationCurrency` string, required
      - `glPeriodId` string, uuid, nullable, required
      - `stages` ReportingScopeWorksheetStageAvailability, required
        - `trialBalanceRollup` boolean, required
        - `profitAndLoss` boolean, required
        - `balanceSheet` boolean, required
        - `translationAdjustment` boolean, required
        - `eliminations` boolean, required
        - `nci` boolean, required

## Other responses

- `401`: Authentication required
- `403`: Insufficient permissions or not a company member
- `404`: Resource not found

---

[API](https://skmtc.dev/medianfi/apis/median-api.md) · [All operations](https://skmtc.dev/medianfi/apis/median-api/llms.txt) · [OpenAPI document](https://skmtc.dev/medianfi/apis/median-api/revisions/20090ea32b0d?raw)