Frozen MRR figures of a snapshot

The MRR figures of the snapshot month and of the eleven months before it, each month as its snapshot stood when this version was taken: key figures, bridge, cohorts, account movements, retention, concentration, churn by reason and committed MRR. The restatements the latest calculation found against this version are listed with their causes.

Required permission: analytics:read.

GET /api/analytics/finance/snapshots/{month}/{version}

Frozen MRR figures of a snapshot

cURL

curl --request GET \
  --url https://coreapi.io/api/analytics/finance/snapshots/{month}/{version} \
  --header 'Authorization: Bearer <token>'

200

{
  "snapshot": {
    "id": "<string>",
    "month": "2026-08",
    "version": 1,
    "takenAt": "2023-11-07T05:31:56Z",
    "takenBy": "<string>",
    "reason": "<string>",
    "checksum": "<string>",
    "builtAt": "2023-11-07T05:31:56Z",
    "alertedAt": "2023-11-07T05:31:56Z",
    "latest": true,
    "definitionsVersion": "v2"
  },
  "tenantName": "<string>",
  "currency": "<string>",
  "scope": "subscription",
  "months": [
    "<string>"
  ],
  "versions": [
    123
  ],
  "kpis": [
    {
      "id": "mrr",
      "title": "MRR",
      "valueKind": "money",
      "value": "12500.00",
      "delta": "250.00",
      "better": "up",
      "sparkline": [
        "<string>"
      ],
      "caption": "<string>",
      "asOfMonth": "2026-08",
      "monthComplete": true,
      "current": {
        "asOfMonth": "2026-09",
        "value": "5279.33",
        "delta": "1916.00",
        "monthComplete": false
      }
    }
  ],
  "movementMonths": [
    {
      "month": "2026-08",
      "bop": "12000.00",
      "eop": "12500.00",
      "steps": [
        {
          "key": "new",
          "value": "-120.00",
          "accounts": 3
        }
      ],
      "reasons": [
        {
          "movement": "new",
          "reason": "price_change",
          "amount": "45.00",
          "accounts": 2,
          "label": "Preisänderung"
        }
      ],
      "snapshotBop": "12100.00",
      "corrections": [
        {
          "key": "voided",
          "label": "Annulliert",
          "value": "-100.00"
        }
      ]
    }
  ],
  "cohorts": [
    {
      "cohort": "<string>",
      "accounts": 123,
      "startMrr": "<string>",
      "cells": [
        {
          "age": 123,
          "month": "<string>",
          "mrr": "<string>",
          "retention": "<string>"
        }
      ]
    }
  ],
  "logos": [
    {
      "month": "<string>",
      "new": 123,
      "resurrecting": 123,
      "lost": 123,
      "net": 123,
      "activeEop": 123
    }
  ],
  "retention": [
    {
      "month": "<string>",
      "nrr": "<string>",
      "grr": "<string>",
      "cohortAccounts": 123,
      "cohortMrr": "<string>"
    }
  ],
  "concentration": {
    "month": "<string>",
    "total": "<string>",
    "segments": [
      {
        "key": "top1",
        "label": "<string>",
        "amount": "<string>",
        "share": "<string>",
        "accounts": 123
      }
    ],
    "top1Share": "<string>",
    "top5Share": "<string>",
    "top10Share": "<string>",
    "above5Count": 123,
    "top": [
      {
        "rank": 123,
        "customer": {
          "id": "<string>",
          "number": "<string>",
          "name": "<string>"
        },
        "mrr": "<string>",
        "share": "<string>",
        "change": "<string>"
      }
    ]
  },
  "churnReasons": {
    "total": "<string>",
    "accounts": 123,
    "entries": [
      {
        "code": "<string>",
        "label": "<string>",
        "amount": "<string>",
        "accounts": 123,
        "share": "<string>"
      }
    ]
  },
  "backlog": {
    "asOfMonth": "2026-09",
    "committed": "54000.00",
    "averageRemainingMonths": "4.3",
    "accounts": 42,
    "buckets": [
      {
        "key": "lt3",
        "amount": "4500.00"
      }
    ],
    "forward": [
      {
        "month": "2026-10",
        "mrr": "12400.00"
      }
    ],
    "events": [
      {
        "id": "end:2026-11:0199c0de-0000-7000-8000-000000000001",
        "month": "2026-11",
        "kind": "end",
        "customer": {
          "id": "<string>",
          "number": "<string>",
          "name": "<string>"
        },
        "accounts": 1,
        "product": "<string>",
        "amount": "-99.00",
        "cancellationReason": "<string>"
      }
    ]
  },
  "restatements": [
    {
      "month": "<string>",
      "level": "cell",
      "subject": "<string>",
      "customer": {
        "id": "<string>",
        "number": "<string>",
        "name": "<string>"
      },
      "snapshotValue": "<string>",
      "currentValue": "<string>",
      "delta": "<string>",
      "cause": "<string>",
      "causeLabel": "Vertragsende geändert",
      "changedAt": "2023-11-07T05:31:56Z"
    }
  ],
  "mrrRows": {},
  "notSnapshotted": [
    "<string>"
  ],
  "frozen": [
    true
  ],
  "moneyFrozen": [
    true
  ],
  "money": [
    {
      "month": "2026-08",
      "collected": "1250.00",
      "refunded": "0.00",
      "net": "1250.00",
      "receivables": "4042.61",
      "dso3m": "29.8",
      "dso12m": "31.2"
    }
  ],
  "accountingClosed": [
    true
  ],
  "findings": [
    {
      "code": "<string>",
      "label": "<string>",
      "severity": "error",
      "count": 123
    }
  ]
}

Autorisierungen

Authorization · string · header · erforderlich

API token of the organisation. Send it as Authorization: Bearer api_... The token is bound to exactly one organisation.

Pfadparameter

month · string · erforderlich

Month (YYYY-MM).

Pattern: (19|20)\d{2}-(0[1-9]|1[0-2])

Beispiel:

"2026-08"

version · integer · erforderlich

Snapshot version.

Erforderlicher Bereich: x >= 1

Abfrageparameter

currency · string

ISO-4217 code. Default: the default currency.

scope · enum<string>

Movement scope. Default: the organisation setting.

Verfügbare Optionen: subscription, invoice_address, customer, organisation

Antwort

200

application/json

The frozen figures.

The MRR figures of a month-end snapshot and of the snapshots of the eleven months before it, in the shapes of the live datasets. A month without any snapshot shows the current calculation and is marked in frozen; besides those months only restatements are read from the live calculation.

snapshot · object

The snapshot.

Show child attributes

tenantName · string

Name of the organisation.

currency · string

Currency (ISO-4217).

scope · enum<string>

Movement scope.

Verfügbare Optionen: subscription, invoice_address, customer, organisation

months · string[]

The twelve months ending with the snapshot month (YYYY-MM).

versions · (integer | null)[]

Snapshot version used per month (the latest one taken until the snapshot); null when the month has none.

kpis · object[]

MRR, ARR, net new MRR, quick ratio, NRR, GRR, active accounts, ARPA.

Show child attributes

movementMonths · object[]

Bridge per month (every month with figures; see frozen).

Show child attributes

cohorts · object[]

Cohort triangle of the twelve months.

Show child attributes

logos · object[]

Account movements per month (every month with figures; see frozen).

Show child attributes

retention · object[]

NRR and GRR per month (every month with figures; see frozen).

Show child attributes

concentration · object

Concentration at the snapshot month end.

Show child attributes

churnReasons · object

Lost MRR of the snapshot month by cancellation reason.

Show child attributes

backlog · object

Committed MRR at the snapshot month end. forward holds that month only and events is empty: forward events are not snapshotted.

Show child attributes

restatements · object[]

Changes found since the snapshot (latest calculation against the latest version of the month).

Show child attributes

mrrRows · object

MRR table rows of the snapshot, aligned with months (null: the month has no snapshot): mrr_bop, mrr_eop, new, expansion, contraction, lost, resurrecting as money, arr_eop (MRR × 12) as money, revenue_churn_rate and mom_growth as exact rates at scale 6, derived from the snapshot with the formulas of the live table.

Show child attributes

notSnapshotted · string[]

MRR table rows a snapshot does not hold (invoice, cash and forecast figures); a snapshot view shows their current values.

frozen · boolean[]

Per month of months: true when the month's MRR figures come from a snapshot, false when the month has no snapshot at all and shows the current calculation ("nicht eingefroren").

moneyFrozen · boolean[]

Per month of months: true when the month's money figures (cash in and out, receivables, DSO) are frozen with its snapshot (snapshots taken since 28.09.2026); false: the month shows the current calculation for these figures.

money · (object | null)[]

Per month of months: the money figures frozen with the month's snapshot; null where moneyFrozen is false.

The money figures of one month as frozen with its snapshot: cash in and out, net cash, receivables at the month end (decimal amounts in the dataset currency) and DSO (days).

Show child attributes

accountingClosed · (boolean | null)[]

Per month of months: whether the month was closed in accounting when its snapshot was taken; null where the month has no snapshot or its snapshot predates 28.09.2026.

findings · object[] | null

Finding counts of the calculation the snapshot was taken from; null for a snapshot taken before 28.09.2026.

Show child attributes