Unbilled Revenue
Unbilled Revenue: Revenue recognized but not yet invoiced.
Formula
Unbilled Revenue = Recognized revenue - Billed revenue (where recognition > billing)Computable definition
The canonical formula in the GASP formula grammar. The MCP server compiles it to SQL over the datasets listed below.
sum(max(field.recognized_revenue - field.billed_amount, 0))Unit: currency
Notes: Evaluated per subscription row, so only subscriptions where recognition exceeds billing contribute.
Data requirements
Grain: Monthly aggregate · Frequency: Monthly · Aggregation: aggregate (month) · Staged: no · Main source: Finance / ERP.
| Field | Dataset | Type |
|---|---|---|
billed_amount | revenue_schedule | decimal |
period_start | revenue_schedule | date |
recognized_revenue | revenue_schedule | decimal |
Example SQL (Postgres)
SELECT (SELECT COALESCE(SUM(GREATEST((recognized_revenue - billed_amount), 0)), 0) FROM revenue_schedule WHERE period_start >= :period_start AND period_start <= :period_end) AS unbilled_revenue From an agent: with the GASP MCP server, call
lookup_metric({ "name": "Unbilled Revenue" }) or generate_query({ "metric": "Unbilled Revenue", "adapter": "<your adapter JSON>" }).
What It Tells You
Service already delivered that billing has to catch up on.