Frozen MRR figures of a snapshot

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

import requests

url = "https://coreapi.io/api/analytics/finance/snapshots/{month}/{version}"

headers = {"Authorization": "Bearer <token>"}

response = requests.get(url, headers=headers)

print(response.text)

const options = {method: 'GET', headers: {Authorization: 'Bearer <token>'}};

fetch('https://coreapi.io/api/analytics/finance/snapshots/{month}/{version}', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

<?php

$curl = curl_init();

curl_setopt_array($curl, [
  CURLOPT_URL => "https://coreapi.io/api/analytics/finance/snapshots/{month}/{version}",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "GET",
  CURLOPT_HTTPHEADER => [
    "Authorization: Bearer <token>"
  ],
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}

{
  "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
    }
  ]
}

{
  "status": 409,
  "type": "ANALYTICS_MRR_FINANCIALS__SNAPSHOT_MONTH_NOT_ENDED",
  "title": "An error occurred",
  "detail": "<string>"
}

{
  "status": 409,
  "type": "ANALYTICS_MRR_FINANCIALS__SNAPSHOT_MONTH_NOT_ENDED",
  "title": "An error occurred",
  "detail": "<string>"
}

{
  "status": 422,
  "type": "https://tools.ietf.org/html/rfc2616#section-10",
  "violations": [
    {
      "propertyPath": "to",
      "message": "Der Zeitraum darf höchstens 36 Monate umfassen.",
      "code": "analytics.mrr_financials.range_too_long"
    }
  ],
  "title": "Validation Failed",
  "detail": "<string>"
}

GET

api

analytics

finance

snapshots

{month}

{version}

Frozen MRR figures of a snapshot

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

import requests

url = "https://coreapi.io/api/analytics/finance/snapshots/{month}/{version}"

headers = {"Authorization": "Bearer <token>"}

response = requests.get(url, headers=headers)

print(response.text)

const options = {method: 'GET', headers: {Authorization: 'Bearer <token>'}};

fetch('https://coreapi.io/api/analytics/finance/snapshots/{month}/{version}', options)
  .then(res => res.json())
  .then(res => console.log(res))
  .catch(err => console.error(err));

<?php

$curl = curl_init();

curl_setopt_array($curl, [
  CURLOPT_URL => "https://coreapi.io/api/analytics/finance/snapshots/{month}/{version}",
  CURLOPT_RETURNTRANSFER => true,
  CURLOPT_ENCODING => "",
  CURLOPT_MAXREDIRS => 10,
  CURLOPT_TIMEOUT => 30,
  CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
  CURLOPT_CUSTOMREQUEST => "GET",
  CURLOPT_HTTPHEADER => [
    "Authorization: Bearer <token>"
  ],
]);

$response = curl_exec($curl);
$err = curl_error($curl);

curl_close($curl);

if ($err) {
  echo "cURL Error #:" . $err;
} else {
  echo $response;
}

{
  "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
    }
  ]
}

{
  "status": 409,
  "type": "ANALYTICS_MRR_FINANCIALS__SNAPSHOT_MONTH_NOT_ENDED",
  "title": "An error occurred",
  "detail": "<string>"
}

{
  "status": 409,
  "type": "ANALYTICS_MRR_FINANCIALS__SNAPSHOT_MONTH_NOT_ENDED",
  "title": "An error occurred",
  "detail": "<string>"
}

{
  "status": 422,
  "type": "https://tools.ietf.org/html/rfc2616#section-10",
  "violations": [
    {
      "propertyPath": "to",
      "message": "Der Zeitraum darf höchstens 36 Monate umfassen.",
      "code": "analytics.mrr_financials.range_too_long"
    }
  ],
  "title": "Validation Failed",
  "detail": "<string>"
}

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

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

Einführung

Grundlagen

Pläne

Angebote

Finanzberichte

Provisionen

Zahlungspläne

Frozen MRR figures of a snapshot

Autorisierungen

Pfadparameter

Abfrageparameter

Antwort