Outstanding unpaid
The /reports/cashflow-outstanding-unpaid endpoint returns the current outstanding unpaid invoice amount and how it has changed over time (30, 60, 180, 365 days).
GET /reports/cashflow-outstanding-unpaid
Query parameters
| Parameter | Type | Description |
|---|
baseCurrency | string | Target currency for conversion. Defaults to account base currency. |
region | string | Filter by region or country codes (space-separated). |
currency | string | Filter by currency codes (space-separated). |
plan | string | Filter by plan group IDs (space-separated). |
data_source | string | Filter by data source ID (space-separated). |
Example response
200 OK
{
"currency": "usd",
"outstanding": {
"today": 25000,
"d30": 22000,
"d60": 20000,
"d180": 15000,
"d365": 10000,
"invoice_count": 15,
"change_d30": 3000,
"change_d60": 5000,
"change_d180": 10000,
"change_d365": 15000,
"change_pct_d30": 13.6,
"change_pct_d60": 25.0,
"change_pct_d180": 66.7,
"change_pct_d365": 150.0
}
}
Response fields
| Field | Type | Description |
|---|
today | number | Current outstanding unpaid amount (cents) |
d30 | number | Outstanding amount 30 days ago (cents) |
d60 | number | Outstanding amount 60 days ago (cents) |
d180 | number | Outstanding amount 180 days ago (cents) |
d365 | number | Outstanding amount 365 days ago (cents) |
invoice_count | integer | Number of outstanding invoices |
change_d30 | number | Absolute change vs 30 days ago (cents) |
change_d60 | number | Absolute change vs 60 days ago (cents) |
change_d180 | number | Absolute change vs 180 days ago (cents) |
change_d365 | number | Absolute change vs 365 days ago (cents) |
change_pct_d30 | float | Percentage change vs 30 days ago |
change_pct_d60 | float | Percentage change vs 60 days ago |
change_pct_d180 | float | Percentage change vs 180 days ago |
change_pct_d365 | float | Percentage change vs 365 days ago |
