Data Quality · Verified
EFL Reconciliation Audit of Third-Party Plan Listings, Sep to Nov 2026
How many records in two third-party plan listing files carry Electricity Facts Label components, how many are EFL-verified, and how many reproduce the published prices when recalculated.
80 of 94
distinct EFL records verified and reconciled
Key findings
- Of 94 distinct EFL records with full components, 80 were marked EFL-verified and reproduced all three published prices; every record with components reproduced within label rounding under some reading.
- 5 distinct EFL records reproduce only if a credit described as applying above 1,000 kWh is applied at exactly 1,000 kWh. They are held for document review.
- Most listing records carry no EFL components (208 of 300 in the plan pull file's third-party section and 1,860 of 1,980 in the statewide file); those records are not used for any finding.
Data
| Input file | Verification class | Outcome | Records | Used |
|---|---|---|---|---|
| Plan pull file, third-party listing section (records dated Oct 29 to Nov 2, 2026) | CARRIED / STALE EFL | RECONCILES ONLY WITH AN UNSTATED MONTHLY AMOUNT | 29 | no |
| Plan pull file, third-party listing section (records dated Oct 29 to Nov 2, 2026) | CARRIED / STALE EFL | RECONCILES WITH STATED COMPONENTS | 8 | no |
| Plan pull file, third-party listing section (records dated Oct 29 to Nov 2, 2026) | EFL VERIFIED (per file flag) | RECONCILES ONLY WITH AN UNSTATED MONTHLY AMOUNT | 37 | yes |
| Plan pull file, third-party listing section (records dated Oct 29 to Nov 2, 2026) | EFL VERIFIED (per file flag) | RECONCILES WITH STATED COMPONENTS | 18 | yes |
| Statewide listing file (records dated Sep 20 to Oct 29, 2026) | CARRIED / STALE EFL | RECONCILES ONLY IF CREDIT THRESHOLD WORDING IS READ DIFFERENTLY | 9 | no |
| Statewide listing file (records dated Sep 20 to Oct 29, 2026) | CARRIED / STALE EFL | RECONCILES WITH STATED COMPONENTS | 44 | no |
| Statewide listing file (records dated Sep 20 to Oct 29, 2026) | EFL VERIFIED (per file flag) | RECONCILES ONLY IF CREDIT THRESHOLD WORDING IS READ DIFFERENTLY | 2 | no |
| Statewide listing file (records dated Sep 20 to Oct 29, 2026) | EFL VERIFIED (per file flag) | RECONCILES WITH STATED COMPONENTS | 60 | yes |
| Statewide listing file (records dated Sep 20 to Oct 29, 2026) | UNVERIFIED OR FAILED | RECONCILES ONLY IF CREDIT THRESHOLD WORDING IS READ DIFFERENTLY | 1 | no |
| Statewide listing file (records dated Sep 20 to Oct 29, 2026) | UNVERIFIED OR FAILED | RECONCILES WITH STATED COMPONENTS | 4 | no |
| Plan pull file, third-party listing section (records dated Oct 29 to Nov 2, 2026) | NO EFL COMPONENTS IN RECORD | NOT RECONCILABLE | 208 | no |
| Statewide listing file (records dated Sep 20 to Oct 29, 2026) | NO EFL COMPONENTS IN RECORD | NOT RECONCILABLE | 1860 | no |
| Plan pull file, user-supplied Power to Choose CSV section (not independently downloaded) | NOT APPLICABLE (Power to Choose CSV rows) | USED ONLY AS A CROSS-CHECK | 1813 | no |
| Verification class | Outcome | Distinct EFL records |
|---|---|---|
| CARRIED / STALE EFL | RECONCILES ONLY IF CREDIT THRESHOLD WORDING IS READ DIFFERENTLY | 3 |
| CARRIED / STALE EFL | RECONCILES WITH STATED COMPONENTS | 9 |
| EFL VERIFIED (per file flag) | RECONCILES ONLY IF CREDIT THRESHOLD WORDING IS READ DIFFERENTLY | 2 |
| EFL VERIFIED (per file flag) | RECONCILES ONLY WITH AN UNSTATED MONTHLY AMOUNT | 30 |
| EFL VERIFIED (per file flag) | RECONCILES WITH STATED COMPONENTS | 50 |
Input file hashes (SHA-256): plan pull file 14a7b3fd7cbc197c78334036d929dc00b07cb91f3b9a7461dc75fbc7e25f95e8; statewide listing file fdd16d32dc8ae1b158e1cdf593d13088647f696ceb76ce4e745dc5f626f5702f. The files themselves are not republished.
Chart
Data Quality · Records dated Sep 20 to Nov 2, 2026
80 of 94 distinct EFL records were verified and reconciled for use in findings
Distinct EFL records with full components in two third-party listing files, by the file's verification flag and how each reproduces its three published prices.
- Stated components
- Unstated monthly amount
- Threshold wording conflict
Distinct EFL records (count)
Source: Power Hopper audit of two supplied third-party listing files (records dated Sep 20 to Nov 2, 2026); audit run Nov 10, 2026. Findings use EFL-verified records only; threshold-wording conflicts are held for document review.
Download PNG of EFL records by verification class and reconciliation outcome WebP of EFL records by verification class and reconciliation outcome SVG of EFL records by verification class and reconciliation outcome
Cite this chart
Power Hopper Research Team. "EFL records by verification class and reconciliation outcome." Chart. EFL Reconciliation Audit of Third-Party Plan Listings, Sep to Nov 2026 dataset. Power Hopper Media Data Room, published November 10, 2026. https://powerhopper.energy/media/charts#chart-efl-reconciliation-audit-distinct-records. Accessed [date accessed].
Data table
| Verification class | Stated components | Unstated monthly amount | Threshold wording conflict |
|---|---|---|---|
| EFL-verified | 50 | 30 | 2 |
| Carried or stale | 9 | 0 | 3 |
Methodology
- Power Hopper analysis of plan data compiled from Power to Choose-derived third-party listings and REP Electricity Facts Labels. The listing files are secondary sources (third-party mirrors of Power to Choose); they are not official Power to Choose data and are not republished. Only aggregated statistics derived from Electricity Facts Label (EFL) components are published.
- Each EFL record gives the provider's average price at 500, 1,000 and 2,000 kWh plus its components: the utility's per-kWh and monthly delivery charges, any recurring provider base charge, and any bill credit with its usage threshold.
- Reconciliation: Power Hopper solves for the energy charge (and, where no base charge is stated, one constant monthly amount) that reproduces all three published averages, then checks every level to within the label's 0.1-cent rounding (±0.05¢). Records that do not reproduce are flagged, not used.
- Only records the source file marks as EFL-verified are eligible. Records marked unverified, failed, carried forward or not re-checked are excluded from findings. Each distinct EFL is counted once per utility (latest issue date).
- Monthly bills at 999 and 1,000 kWh are recalculated from the reconciled components: energy charge plus delivery charges times usage, plus monthly charges, minus the bill credit where usage meets the threshold.
- Verification classes follow each record's own verification field: EFL VERIFIED (read or verified on a stated date), CARRIED / STALE (carried forward or not re-checked), UNVERIFIED OR FAILED, or no EFL components.
Limitations
- The audit checks internal consistency of EFL figures; it does not re-download the EFL documents.
- Counts are of records; one EFL can appear on several listing dates.
Data dictionary
| Field | Description |
|---|---|
input_file | Which supplied file (described, not named) |
input_file_sha256 | SHA-256 of the supplied file |
records_in_file | Records in the file |
third_party_listing_records | Records in the file's third-party listing section |
efl_verification_class | Verification class from the record's own verification field |
reconciliation_outcome | Result of recalculating the three published prices from components |
records | Records in this class and outcome |
eligible_for_findings | Whether these records may be used in published findings |