Reconcile energy settlement
Settlement starts with interval energy and the relevant price, then applies applicable loss treatment, charges and adjustments. Dispatch targets are not a substitute for settlement metering. Credit support manages exposure between delivery, settlement and payment.
The lesson
6 chaptersBrowse the chapters
01Trace the quantity before calculating the money
A settlement analysis starts with the market, participant role, connection point, time basis and quantity definition. A meter's interval energy is different from an instantaneous power reading, an end-of-interval target and a cumulative register. Use the correct unit and determine whether import/export is positive or negative in each source.
For an introductory energy-only calculation, multiply matching MWh by the applicable interval A$/MWh. An average 60 MW load over five minutes consumes 5 MWh; at A$120/MWh its energy-only cost is A$600. The full statement can include other components and adjustments, so this subtotal is not automatically the final invoice.
02Weight prices by actual energy
Suppose two intervals have exports of 1 and 3 MWh at A$20 and A$100/MWh. Receipts are A$20 + A$300 = A$320. The output-weighted price is A$320/4 = A$80/MWh. The simple price average is A$60/MWh and would underestimate receipts if multiplied by total generation in this example.
Align quantities and prices by interval, location and the appropriate market record. Do not join only by date or displayed clock hour. Price series, meter data and settlement calculations can have different statuses or revisions; apparent precision does not compensate for incorrect keys or boundaries.
03Handle missing values, revisions and losses explicitly
A missing meter value is not evidence of zero energy. Preserve data-quality and substitution flags and follow the documented estimation or correction process for the relevant application. If a revised interval changes from 3 to 3.5 MWh at A$200/MWh, the energy-only movement is A$100; retain both versions and explain the difference.
Apply loss or allocation adjustments only with a verified definition and direction. A teaching formula that multiplies 10 MWh by 0.95 and A$100/MWh yields A$950, but actual arrangements cannot be inferred from that arithmetic alone. Distinguish measured physical losses, defined settlement factors and contractual allocation. Avoid double-adjustment when a provided quantity already includes a factor.
04Reconcile the statement, not just the chart
Build a bridge from raw intervals to energy subtotals, then to each remaining component of the statement. Preserve billing period, run identifier, version, units, price source and component definitions. Investigate a discrepancy rather than forcing a total to match by inserting an unexplained balancing entry.
Before aggregating, test record uniqueness and join cardinality. A duplicated join can double both volumes and money while leaving a smooth-looking chart. Reconcile row counts, interval coverage and independent totals. Separate a corrected settlement result from a forecast or prudential estimate and retain the dates when information became available.
05Prudential exposure is also a cash-timing problem
A participant can have positive expected profit and still lack cash or eligible credit support at a required time. In a toy account, A$1.2m of support against A$0.9m of assessed exposure leaves A$0.3m simple headroom. This arithmetic is not the actual NEM prudential formula or a regulatory action threshold; consult current AEMO materials for those requirements.
Map the dates of market invoices, hedge receipts and payments, collateral changes and available funding. A hedge that pays after an invoice falls due may reduce economic price risk but leave a funding gap. Stress price and volume shocks together with payment timing. Do not extrapolate a smooth daily exposure increase into a guarantee that trading can continue until a simple headroom ratio reaches zero.
06Deliver an auditable settlement pack
Your pack should include an immutable copy or traceable reference for each source, a data dictionary, transformation steps, reconciliation checks, an exceptions register and a component-by-component explanation. Record the person responsible for resolving material differences and the evidence needed before sign-off.
Keep NEM and WEM methods separate and verify the current instrument, participant category and statement definition before asserting an obligation. Online learning examples cannot establish an actual participant's legal liability or prudential compliance. Connect this topic to energy units, dispatch, contract cash flows and market-data quality, then use official guidance for the specific operational task.
Watch the explanation
Key terms in plain English
- MW
- Megawatt: a measure of power, or how quickly energy is transferred. A plant's maximum MW is not its actual output in every interval.
- MWh
- Megawatt-hour: a quantity of energy. A steady 1 MW for one hour delivers 1 MWh.
- Dispatch
- The operational process of determining output and consumption targets, subject to offers, demand and system constraints. A target is not a meter reading.
Supporting diagrams
Keep energy settlement and contracts separate
Reconcile each component instead of treating a spot price as a final customer bill.
- 01 · Physical quantityMetered MWh
Correct interval and connection boundary
- 02 · Market valueApplicable price
Apply relevant settlement and loss treatment
- 03 · Contract cash flowSeparate ledger
Hedges, fees and retail charges as applicable
