Billings

Billings: Amounts invoiced in a period.

Formula

Billings = Total invoiced amount in period

Computable definition

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

sum(field.invoice_amount where in_period(field.invoice_date))

Unit: currency

Breakdowns

by_payment_status: one row per payment_status value

Notes: by_payment_status returns one row per payment status as of period end, so finance sees how much of the period's billing is paid, unpaid, partly paid or written off.

Data requirements

Grain: Per event · Frequency: Per transaction · Aggregation: event · Staged: no · Main source: Billing.

Field	Dataset	Type
`invoice_amount`	invoice	decimal
`invoice_date`	invoice	date
`snapshot_date`	invoice	date

Example SQL (Postgres)

SELECT (SELECT COALESCE(SUM(invoice_amount), 0) FROM invoice WHERE snapshot_date = :period_end AND (invoice_date >= :period_start AND invoice_date <= :period_end)) AS billings

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

What It Tells You

The cash the period's invoices should bring in. The payment status breakdown shows how much of it has arrived.

← Back to Finance metrics