REVENUE CONTROL / BROWSER-LOCAL

Three CSVs. Explicit columns. No silent guesses.

MeterProof accepts UTF-8, comma-delimited RFC 4180 CSV. Plain decimals are limited to 24 significant digits and 9 decimal places; XLSX, exponent/locale-formatted numbers and semicolon delimiters are refused rather than reinterpreted.

IMPORT-READY STARTER KIT

Begin with one proven synthetic audit.

Download all three files, run them unchanged, then replace the rows with your own exports.

01usage.csv3 synthetic events · 321 bytes 02pricebook.csv3 price rows · 431 bytes 03invoice_lines.csv2 invoice lines · 348 bytes

usage.csv

Column	Required	Meaning
`event_id`	yes	Unique event reference
`customer_id`	yes	Exact customer join key
`meter`	yes	Exact meter join key
`quantity`	yes	Non-negative decimal
`event_at`	yes	ISO-8601 timestamp with offset
`ingested_at`	no	Timestamp used to classify late arrival
`source_ref`	no	Your source-system reference, retained in the local ledger

event_idRequired

Unique event reference

customer_idRequired

Exact customer join key

meterRequired

Exact meter join key

quantityRequired

Non-negative decimal

event_atRequired

ISO-8601 timestamp with offset

ingested_atno

Timestamp used to classify late arrival

source_refno

Your source-system reference, retained in the local ledger

pricebook.csv

Column	Required	Meaning
`price_id`	yes	Stable price rule
`customer_id`	no	Blank default or exact override
`meter`	yes	Exact meter join key
`currency`	yes	Uppercase ISO 4217 code
`effective_from`	yes	Inclusive timestamp
`effective_to`	no	Exclusive timestamp
`pricing_model`	yes	flat, graduated or volume
`tier_start`	yes	Inclusive start of the contiguous tier range
`tier_end`	no	Exclusive tier end; blank for the open final tier
`unit_price_minor`	yes	Decimal minor units per usage unit
`included_quantity`	no	Applied once per effective revision
`minimum_amount_minor`	no	Integer revision minimum

price_idRequired

Stable price rule

customer_idno

Blank default or exact override

meterRequired

Exact meter join key

currencyRequired

Uppercase ISO 4217 code

effective_fromRequired

Inclusive timestamp

effective_tono

Exclusive timestamp

pricing_modelRequired

flat, graduated or volume

tier_startRequired

Inclusive start of the contiguous tier range

tier_endno

Exclusive tier end; blank for the open final tier

unit_price_minorRequired

Decimal minor units per usage unit

included_quantityno

Applied once per effective revision

minimum_amount_minorno

Integer revision minimum

invoice_lines.csv

Column	Required	Meaning
`invoice_id`	yes	Invoice reference
`line_id`	yes	Unique invoice-line reference
`customer_id`	yes	Exact customer join key
`meter`	yes	Exact meter join key
`period_start`	yes	Inclusive UTC billing-period timestamp
`period_end`	yes	Exclusive UTC billing-period timestamp
`quantity`	yes	Invoice quantity
`amount_minor`	yes	Signed integer minor units
`currency`	yes	Uppercase ISO 4217 code
`price_id`	no	Checked against the effective price

invoice_idRequired

Invoice reference

line_idRequired

Unique invoice-line reference

customer_idRequired

Exact customer join key

meterRequired

Exact meter join key

period_startRequired

Inclusive UTC billing-period timestamp

period_endRequired

Exclusive UTC billing-period timestamp

quantityRequired

Invoice quantity

amount_minorRequired

Signed integer minor units

currencyRequired

Uppercase ISO 4217 code

price_idno

Checked against the effective price