Liquidity page datasets
curl --request GET \
--url https://coreapi.io/api/analytics/finance/liquidity \
--header 'Authorization: Bearer <token>'import requests
url = "https://coreapi.io/api/analytics/finance/liquidity"
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/liquidity', 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/liquidity",
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;
}{
"tenantName": "<string>",
"currency": "<string>",
"asOf": "2023-11-07T05:31:56Z",
"months": [
"<string>"
],
"overviewWire": {
"months": [
"<string>"
],
"cashflow": {
"collected": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"refunded": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"net": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"totals": {},
"forecastBilled": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"collectedThisMonth": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"collectedOtherMonths": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"collectedUnassigned": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"refundedRefund": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"refundedChargeback": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"refundedPayout": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"collectedRefundReturned": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"corrections": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"correctionsReversed": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"correctionsCounter": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"correctionCount": [
123
],
"refundedReturnFee": [
{
"amount": "1234.56",
"currency": "EUR"
}
]
},
"mrrMovements": {
"new": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"expansion": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"contraction": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"lost": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"resurrecting": [
{
"amount": "1234.56",
"currency": "EUR"
}
]
},
"revenueBreakdown": {
"recurring": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"oneOff": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"variable": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"total": [
{
"amount": "1234.56",
"currency": "EUR"
}
]
},
"receivablesTrend": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"receivablesTrendOverdue": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"ageing": {
"asOf": "2023-11-07T05:31:56Z",
"total": {
"amount": "1234.56",
"currency": "EUR"
},
"overdueTotal": {
"amount": "1234.56",
"currency": "EUR"
},
"buckets": [
{
"key": "not_due",
"amount": {
"amount": "1234.56",
"currency": "EUR"
},
"invoiceCount": 123,
"topCustomers": [
{
"customer": {
"id": "<string>",
"number": "<string>",
"name": "<string>"
},
"amount": {
"amount": "1234.56",
"currency": "EUR"
},
"invoiceCount": 123
}
]
}
],
"over365": {
"amount": "1234.56",
"currency": "EUR"
}
},
"receivablesTable": {
"rows": {},
"totals": {},
"forecastInvoiceCount": [
123
]
},
"totals": {},
"meta": {
"asOf": "2023-11-07T05:31:56Z",
"buildId": "<string>",
"scope": "invoice_address",
"currency": "EUR",
"from": "2025-10",
"to": "2026-09",
"findings": {
"error": 0,
"warning": 3,
"info": 12
},
"filtersNotApplied": [
"<string>"
],
"notSnapshotted": [
"one_off",
"accounted_mrr",
"cash_collected"
],
"projectedFrom": "2026-10",
"forecast": {
"incomplete": false,
"failedSubscriptions": 0
},
"build": {
"status": "failed",
"builtAt": "2023-11-07T05:31:56Z",
"buildId": "<string>",
"failed": {
"invariants": [
"CASH_WITHIN_DOCUMENT"
],
"rowCount": 5,
"invoiceRowCount": 5
}
},
"dataBuildId": "<string>"
}
},
"liquidity": {
"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
}
}
],
"paymentBehaviour": {
"termDays": 123,
"months": [
{
"month": "<string>",
"averageDays": {},
"openOverdueCount": 123
}
],
"summary": [
{
"method": "<string>",
"averageDays": "<string>",
"withinTerm": "<string>",
"invoices": 123
}
]
},
"reconciliation": {
"totalDifference": "<string>",
"rows": [
{
"id": "<string>",
"customer": {
"id": "<string>",
"number": "<string>",
"name": "<string>"
},
"subscription": {
"id": "<string>",
"number": "<string>"
},
"invoice": {
"id": "<string>",
"number": "<string>"
},
"product": "<string>",
"month": "<string>",
"contract": "<string>",
"billed": "<string>",
"difference": "<string>",
"cause": "billed_after_end",
"causeLabel": "Abgerechnet nach Vertragsende",
"parts": [
{
"cause": "not_billed",
"causeLabel": "Nicht abgerechnet",
"amount": "149.00"
}
],
"invoices": [
{
"id": "<string>",
"number": "<string>"
}
],
"findingId": "<string>",
"belowTolerance": false,
"monthComplete": true
}
],
"monthTotals": {}
},
"dso": "<string>"
},
"findings": [
{
"code": "<string>",
"label": "<string>",
"severity": "error",
"count": 123
}
],
"accountingClosed": [
true
],
"meta": {
"asOf": "2023-11-07T05:31:56Z",
"buildId": "<string>",
"scope": "invoice_address",
"currency": "EUR",
"from": "2025-10",
"to": "2026-09",
"findings": {
"error": 0,
"warning": 3,
"info": 12
},
"filtersNotApplied": [
"<string>"
],
"notSnapshotted": [
"one_off",
"accounted_mrr",
"cash_collected"
],
"projectedFrom": "2026-10",
"forecast": {
"incomplete": false,
"failedSubscriptions": 0
},
"build": {
"status": "failed",
"builtAt": "2023-11-07T05:31:56Z",
"buildId": "<string>",
"failed": {
"invariants": [
"CASH_WITHIN_DOCUMENT"
],
"rowCount": 5,
"invoiceRowCount": 5
}
},
"dataBuildId": "<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>"
}Datensätze
Liquidity page datasets
Key figures (net cash of the range, outstanding and overdue today, DSO over three and twelve months), the overview datasets (cash flow, ageing, receivables trend and table), payment behaviour per payment method, contract against billing, the data quality findings per code and whether each month is closed in accounting. Payment behaviour and DSO are organisation-wide and ignore a segment (meta.filtersNotApplied).
Required permission: analytics:read.
GET
/
api
/
analytics
/
finance
/
liquidity
Liquidity page datasets
curl --request GET \
--url https://coreapi.io/api/analytics/finance/liquidity \
--header 'Authorization: Bearer <token>'import requests
url = "https://coreapi.io/api/analytics/finance/liquidity"
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/liquidity', 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/liquidity",
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;
}{
"tenantName": "<string>",
"currency": "<string>",
"asOf": "2023-11-07T05:31:56Z",
"months": [
"<string>"
],
"overviewWire": {
"months": [
"<string>"
],
"cashflow": {
"collected": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"refunded": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"net": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"totals": {},
"forecastBilled": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"collectedThisMonth": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"collectedOtherMonths": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"collectedUnassigned": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"refundedRefund": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"refundedChargeback": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"refundedPayout": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"collectedRefundReturned": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"corrections": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"correctionsReversed": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"correctionsCounter": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"correctionCount": [
123
],
"refundedReturnFee": [
{
"amount": "1234.56",
"currency": "EUR"
}
]
},
"mrrMovements": {
"new": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"expansion": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"contraction": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"lost": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"resurrecting": [
{
"amount": "1234.56",
"currency": "EUR"
}
]
},
"revenueBreakdown": {
"recurring": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"oneOff": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"variable": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"total": [
{
"amount": "1234.56",
"currency": "EUR"
}
]
},
"receivablesTrend": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"receivablesTrendOverdue": [
{
"amount": "1234.56",
"currency": "EUR"
}
],
"ageing": {
"asOf": "2023-11-07T05:31:56Z",
"total": {
"amount": "1234.56",
"currency": "EUR"
},
"overdueTotal": {
"amount": "1234.56",
"currency": "EUR"
},
"buckets": [
{
"key": "not_due",
"amount": {
"amount": "1234.56",
"currency": "EUR"
},
"invoiceCount": 123,
"topCustomers": [
{
"customer": {
"id": "<string>",
"number": "<string>",
"name": "<string>"
},
"amount": {
"amount": "1234.56",
"currency": "EUR"
},
"invoiceCount": 123
}
]
}
],
"over365": {
"amount": "1234.56",
"currency": "EUR"
}
},
"receivablesTable": {
"rows": {},
"totals": {},
"forecastInvoiceCount": [
123
]
},
"totals": {},
"meta": {
"asOf": "2023-11-07T05:31:56Z",
"buildId": "<string>",
"scope": "invoice_address",
"currency": "EUR",
"from": "2025-10",
"to": "2026-09",
"findings": {
"error": 0,
"warning": 3,
"info": 12
},
"filtersNotApplied": [
"<string>"
],
"notSnapshotted": [
"one_off",
"accounted_mrr",
"cash_collected"
],
"projectedFrom": "2026-10",
"forecast": {
"incomplete": false,
"failedSubscriptions": 0
},
"build": {
"status": "failed",
"builtAt": "2023-11-07T05:31:56Z",
"buildId": "<string>",
"failed": {
"invariants": [
"CASH_WITHIN_DOCUMENT"
],
"rowCount": 5,
"invoiceRowCount": 5
}
},
"dataBuildId": "<string>"
}
},
"liquidity": {
"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
}
}
],
"paymentBehaviour": {
"termDays": 123,
"months": [
{
"month": "<string>",
"averageDays": {},
"openOverdueCount": 123
}
],
"summary": [
{
"method": "<string>",
"averageDays": "<string>",
"withinTerm": "<string>",
"invoices": 123
}
]
},
"reconciliation": {
"totalDifference": "<string>",
"rows": [
{
"id": "<string>",
"customer": {
"id": "<string>",
"number": "<string>",
"name": "<string>"
},
"subscription": {
"id": "<string>",
"number": "<string>"
},
"invoice": {
"id": "<string>",
"number": "<string>"
},
"product": "<string>",
"month": "<string>",
"contract": "<string>",
"billed": "<string>",
"difference": "<string>",
"cause": "billed_after_end",
"causeLabel": "Abgerechnet nach Vertragsende",
"parts": [
{
"cause": "not_billed",
"causeLabel": "Nicht abgerechnet",
"amount": "149.00"
}
],
"invoices": [
{
"id": "<string>",
"number": "<string>"
}
],
"findingId": "<string>",
"belowTolerance": false,
"monthComplete": true
}
],
"monthTotals": {}
},
"dso": "<string>"
},
"findings": [
{
"code": "<string>",
"label": "<string>",
"severity": "error",
"count": 123
}
],
"accountingClosed": [
true
],
"meta": {
"asOf": "2023-11-07T05:31:56Z",
"buildId": "<string>",
"scope": "invoice_address",
"currency": "EUR",
"from": "2025-10",
"to": "2026-09",
"findings": {
"error": 0,
"warning": 3,
"info": 12
},
"filtersNotApplied": [
"<string>"
],
"notSnapshotted": [
"one_off",
"accounted_mrr",
"cash_collected"
],
"projectedFrom": "2026-10",
"forecast": {
"incomplete": false,
"failedSubscriptions": 0
},
"build": {
"status": "failed",
"builtAt": "2023-11-07T05:31:56Z",
"buildId": "<string>",
"failed": {
"invariants": [
"CASH_WITHIN_DOCUMENT"
],
"rowCount": 5,
"invoiceRowCount": 5
}
},
"dataBuildId": "<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
API token of the organisation. Send it as Authorization: Bearer api_... The token is bound to exactly one organisation.
Abfrageparameter
First month (YYYY-MM, time zone of the organisation). Default: to minus 11 months.
Last month (YYYY-MM). Default: the current month. At most 36 months.
ISO-4217 code. Default: the default currency.
Movement scope. Default: the organisation setting.
Verfügbare Optionen:
subscription, invoice_address, customer, organisation Analytics segment: only its customers.
Antwort
The datasets.
Liquidity page: key figures, cash flow, ageing and receivables (overview datasets), payment behaviour, reconciliation, findings and the accounting close per month.
Name of the organisation.
Currency of every amount (ISO-4217).
Calculation time; null before the first calculation.
Months of the range (YYYY-MM), ascending.
Cash flow, ageing, receivables trend and table (same shape as GET /api/analytics/finance/overview).
Show child attributes
Show child attributes
Key figures, payment behaviour, reconciliation, DSO.
Show child attributes
Show child attributes
Data quality findings per code.
Show child attributes
Show child attributes
Per month of months: the month's postings are closed in accounting (the ledger of the month is final). The analytics figures follow the source dates (finalization, payment and settlement date, service period) and can still change after the close; a record made after the close is a POST_CLOSE_CHANGE finding.
Calculation time, scope, currency, findings, filters not applied.
Show child attributes
Show child attributes
War diese Seite hilfreich?