Recognized vs Billed
Recognized vs Billed: Ratio of recognized revenue to billed revenue.
Formula
Recognized/Billed = Recognized revenue / Billed revenueComputable definition
The canonical formula in the GASP formula grammar. The MCP server compiles it to SQL over the datasets listed below.
sum(field.recognized_revenue) / sum(field.billed_amount)Unit: ratio
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 (CAST((SELECT COALESCE(SUM(recognized_revenue), 0) FROM revenue_schedule WHERE period_start >= :period_start AND period_start <= :period_end) AS DOUBLE PRECISION) / NULLIF((SELECT COALESCE(SUM(billed_amount), 0) FROM revenue_schedule WHERE period_start >= :period_start AND period_start <= :period_end), 0)) AS recognized_vs_billed From an agent: with the GASP MCP server, call
lookup_metric({ "name": "Recognized vs Billed" }) or generate_query({ "metric": "Recognized vs Billed", "adapter": "<your adapter JSON>" }).
What It Tells You
Revenue recognition timing vs cash collection.