The report only appears for users with access to the Brokerage module, because it shows received brokerage revenue.
What the report shows
Each row is one connection (NMI). The report includes connections that are:- Top-level, active, NEM electricity connections
- Classified as large customers, or not yet classified
- On an active electricity or energy retail agreement that has a brokerage record. Contracts with no brokerage record, such as a customer’s direct contract, are left out unless you turn off Brokered retail contracts only.
Other columns include the account, site, NMI, state, classification, annual consumption, retailer, retail agreement, and the retail account number with its status (for example
ACTIVE or INACTIVE). They also include the metering provider and agreement, onboarding stage, metering start and in-service dates, revenue received and the last paid period.
Running the report
1
Open Reports
Go to Reports and find Metering Coverage.
2
Click Run and choose filters
Filter by Coverage status (one or more), Customer (sub-accounts are included), Metering provider, or Active retail account only. Leave the filters empty to see every row.
3
Download the result
Choose Excel, CSV or JSON. You’ll get a notification when it’s ready.
Scheduling it
Click Schedule on the report to receive it weekly. Create one schedule per audience, for example:- Sales: coverage status
no_metering - Operations: coverage statuses
started_not_liveandstopped, filtered by metering provider if you forward each provider its own list - Management: all statuses
Keeping the report accurate
The report is only as good as the data behind it. When you set up a new contract:- Create the brokerage record on the retail agreement. Without one, the connection is left out of the report.
- Set the agreement’s segment (large market, small market or embedded network).
- Set the NMI classification (large or small customer) on each connection. Without it, UMS estimates size from annual consumption against the state’s large-customer threshold. With no consumption data either, a connection on a small-market contract is treated as a small customer, unless it has a metering agreement or a large-market contract. Anything else appears as
unclassified.
Related
- Brokerage: brokerage records, calculations and revenue
- Brokerage revenue and invoicing: supplier statements (RCTIs) and month-end workflow
- Running reports: running and scheduling reports