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>",
"pendingCustomers": 0
}
},
"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",
"description": "<string>"
}
],
"invoices": [
{
"id": "<string>",
"number": "<string>"
}
],
"findingId": "<string>",
"belowTolerance": false,
"monthComplete": true,
"expected": "579.03",
"causeDescription": "<string>"
}
],
"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>",
"pendingCustomers": 0
}
}{
"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>"
}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.
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>",
"pendingCustomers": 0
}
},
"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",
"description": "<string>"
}
],
"invoices": [
{
"id": "<string>",
"number": "<string>"
}
],
"findingId": "<string>",
"belowTolerance": false,
"monthComplete": true,
"expected": "579.03",
"causeDescription": "<string>"
}
],
"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>",
"pendingCustomers": 0
}
}{
"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
Abfrageparameter
Antwort
The datasets.
Liquidity page: key figures, cash flow, ageing and receivables (overview datasets), payment behaviour, reconciliation, findings and the accounting close per month.
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.
War diese Seite hilfreich?