Finance Revenue Metrics Operational

Prepaid Credit Balance

Prepaid Credit Balance: The prepaid commitment customers have paid for and not yet consumed or forfeited, as of period end. Also called Remaining Commitment.

Formula

Prepaid Credit Balance = Purchases + granting adjustments − committed consumption − expiries − reducing adjustments, cumulative to period end

Computable definition

The canonical formula in the GASP formula grammar. The MCP server compiles it to SQL over the datasets listed below.

sum(field.credit_amount where field.credit_event_type in ('purchase', 'expiry', 'adjustment') or field.consumption_basis = 'committed') to_date

Unit: currency

Notes: Also called Remaining Commitment. Purchases and granting adjustments less committed consumption, expiries and reducing adjustments, cumulative to period end. On-demand and overage consumption draw no balance and are left out. The part of the deferred revenue balance that is prepaid consumption.

Data requirements

Grain: Cumulative balance at period end · Frequency: Monthly · Aggregation: to_date (month) · Staged: no · Main source: Billing.

Field	Dataset	Type
`consumption_basis`	credit_event	string
`credit_amount`	credit_event	decimal
`credit_event_type`	credit_event	string
`event_date`	credit_event	date

Example SQL (Postgres)

SELECT (SELECT COALESCE(SUM(credit_amount), 0) FROM credit_event WHERE event_date <= :period_end AND (credit_event_type IN ('purchase', 'expiry', 'adjustment') OR consumption_basis = 'committed')) AS prepaid_credit_balance

Access: recommended sensitivity tier confidential, access scope unscoped. Guidance your policy engine enforces.

From an agent: with the GASP MCP server, call lookup_metric({ "name": "Prepaid Credit Balance" }) or generate_query({ "metric": "Prepaid Credit Balance", "adapter": "<your adapter JSON>" }).

What It Tells You

How much consumption customers have paid for in advance and not yet used: revenue still to be earned through use, or forfeited at expiry.

Common Mistakes

Drawing on-demand or overage consumption against the balance
Reading the balance as a revenue forecast: rollover and consumption timing move it, and Snowflake states its deferred revenue "is not a meaningful indicator of future revenue"
Letting the balance go negative: consumption beyond the balance is overage

Connected in the GASP relationship graph.

Downstream: what this drives

Prepaid Credit Balance measures Customer (Entity)
Prepaid Credit Balance measures Subscription (Entity)

Sources

← Back to Finance metrics