Engineering · Utility data · Tariff validation

Utility Bill Studio

An interactive tool for understanding electricity costs, comparing usage across service points, and checking billed charges against the rates and readings behind them. Explore the workflow with fictional tariffs and sample bills.

The preloaded workspace matches 203 lines. Each calculation can be traced to its billing basis and rate source.
Diagram in text
Retrieve sources
10 fictional source documents
Build catalogue
122 dated rate records
Import bills
12 generated statements
Create accounts
Three service-point profiles
Validate charges
209 printed lines checked
  1. Retrieve sources10 fictional documents
  2. Build catalogue122 dated rates
  3. Import bills12 sample invoices
  4. Create accounts3 service points
  5. Validate charges209 lines checked
Follow a sample bill from the applicable source rates to the charge-by-charge check.

Interactive tools

  • Utility Bill Studio

    Build a dated rate catalogue from bundled fictional sources, review 12 sample invoices, and reconcile delivery, supply, and taxes and fees.

Approach and contribution

30-second case brief

Trace electricity charges back to their source rates.

Problem
Reconcile charges across utility and supplier statements while counting shared meter readings once.
Contribution
The workspace builds a rate catalogue from 10 bundled fictional documents and creates service-point profiles from printed invoice fields.
Result
The sample audit compares 209 printed charge lines across 12 fictional invoices. The preloaded workspace shows 203 matches and flags three invoices for review.

ApproachBuild 122 dated rate records for 39 charge types, then compare calculated and printed amounts by charge group.

Project scope and responsibility

Sample sources
10 fictional documents, 122 dated rate records, and 39 charge types
Invoice records
12 generated PDFs, three service-point profiles, and 209 printed charge lines
Outputs
Separate delivery, supply, and tax and fee comparisons, with source references in the audit export

What the Studio is for

Utility Bill Studio is an AI-assisted utility tariff modeling and invoice-analysis tool that translates complex electricity rate structures into reviewable calculations, supporting energy consultants in evaluating utility charges. It applies electricity tariff and supply contract rules to invoice data which helps energy consultants, utility-rate analysts, energy managers, and engineers understand what drives electricity costs for commercial and institutional facilities. Using fictional invoices, the Studio shows how billing determinants such as metered energy use (kWh) and demand (kW) translate into delivery, supply, tax, and fee charges. Analysts can trace the applicable rates to their source documents, compare calculated charges with billed amounts, and flag discrepancies or missing inputs for review.

Delivery covers the utility’s charges for bringing electricity to the meter. Supply covers the electricity and related charges under the supplier’s contract. Taxes and fees can apply to either group, depending on the sample rules. The Studio keeps these amounts separate, including when the utility and supplier bill the same meter for the same dates.

Try the preloaded fictional bills below, or replay the five steps with the bundled sources and generated statements. The walkthrough follows the same controls you see in the Studio.

Guide to the tabs

The sidebar on desktop and the Studio tab menu on phones offer the same views. Start in Overview to spot a pattern, then use the tabs below to investigate it.

Overview
Follow the five workflow buttons, compare recorded delivery, supply, and tax costs, or switch the monthly chart to electricity use. Open a month or an item in the review queue to see the bills behind it.
Invoice history
Filter bills by service point or search by invoice, site, or date. Open an invoice to inspect its statement scope, linked bills, charge breakdown, and source references.
Add invoice
Use an existing service-point profile to enter a test bill. Enter its scope, dates, and readings, then preview the applicable charges before saving.
Import & review
Load one generated statement, a utility and supplier pair, or all 12. Check the extracted fields against the statement preview, then approve the selected pages.
Source retrieval
Inspect or download the bundled fictional sources. Choose which documents to retrieve and build the catalogue from that selection.
Tariff catalogue
Search and filter the dated rates by charge family. Compare quoted and normalized units, see the billing basis, and open the source record.
Tariff lookup
Start from an invoice and change its dates to see how the applicable rate and calculated subtotal respond. This view leaves the saved invoice intact.
Service-point roster
See how the approved statements identify accounts, meters, delivery classes, supply contracts, and tax regions. Follow each profile back to the statements that use it.
Validation
Compare calculated and printed charges line by line and review subtotal and balance checks. Switch between all invoices and those that need attention.
Missing data
Find the meter readings, schedule assignments, or rate evidence that prevent calculation. Recover a reading when the matching sample statement contains it.
Export
Preview an invoice summary or detailed charge audit, filter it by service point, and download CSV or Excel. The charge audit carries formulas or review notes and rate source references.
Guide & backups
Follow worked exercises, save or restore your edits as a JSON backup, or reset the demo to the opening sample.

1. Retrieve sources

Open Source retrieval and choose which of the 10 bundled fictional documents to retrieve. Delivery tariffs establish the utility rates, supply contracts establish supplier rates, and the local rules define taxes and fees. A separate monthly settlement index supplies the market price used by the indexed contract.

Retrieval reads the selected files inside the demo. Choose Build catalogue to apply them. Try leaving out the settlement index and rebuilding. Indexed supply lines that need it will show a gap in rate evidence, even though the supply contract itself is available.

Select and retrieve fictional sources before building the catalogue.

2. Build catalogue

With all sources selected, the Studio builds 122 dated rate records for 39 supported charge types. Each record retains the schedule, effective dates, quoted unit, normalized value, and the document and row or rule that supplied it. For example, cents per kWh and dollars per MWh are converted to dollars per kWh for calculation. Demand and capacity charges keep their own bases, such as dollars per kW or per kW-day.

Most rates use the bill-end date and the relevant delivery class, supply contract, or tax region. The sample revenue reconciliation rider uses a different rule. SIM-2507 spans a July 1 rate change, so the Studio allocates its 31,800 kWh by inclusive service days, using 11 of 30 days at the earlier rate and 19 of 30 at the later rate. Tariff lookup shows the two source records and the resulting formula.

The full catalogue contains 122 dated records for 39 supported charge types.

3. Import bills

Open Import & review to load one generated PDF, a delivery and supply pair, or the full batch. The parser reads the generated text layout and extracts the printed identifiers, bill dates, statement scope, meter readings, and charge lines. Compare the extracted fields with the sample statement before approving the selected pages.

The scan exercise simulates a missing coincident-demand reading. Check the printed value and copy it into the review fields before approving. To follow the complete workflow, use Replay from an empty workspace, which clears the demo’s saved invoices and profiles in that tab, then loads all 12 generated statements for approval.

Review the extracted fields before approving the fictional statements.

4. Create accounts

Approval creates three service-point profiles from the printed account, service-point and meter identifiers and the delivery, supply, and tax assignments. Later statements can reuse a profile when the account and service-point identifiers agree. Conflicting printed profile fields are flagged during approval.

A delivery-only statement and a supply-only statement can cover the same service point and dates. The Studio links them, keeps each statement’s charges in its own scope, and counts the shared metered electricity use once in the usage chart. The 12 statements cover 10 distinct service periods. If linked bills show different meter readings, the invoice detail flags the difference.

Approved statements establish the Library, Workshop, and Solar facility profiles.

5. Validate charges

The Studio calculates each applicable charge using its billing basis and effective rate, then compares the rounded amount with the printed line. It also checks whether printed lines tie to their charge-group subtotals, whether the subtotals tie to current charges, and whether account activity such as prior balances and payments reconciles to the amount due.

The preloaded workspace shows 203 matching lines out of 209 printed lines. Three invoices need review. The SIM-2508 capacity charge calculates to $474.74 against $482.09 printed. On SIM-2510, one delivery rider is $2.20 higher and another is $2.20 lower than printed, so the current-charge total still agrees. On SIM-2511, missing coincident demand prevents calculation of the transmission charge and two fees or taxes that depend on the delivery subtotal.

Reimporting all 12 generated statements restores the missing reading in SIM-2511 and brings the result to 206 of 209 lines matching. The two invoices with recorded discrepancies remain in the review queue.

The opening audit distinguishes recorded discrepancies from charges awaiting evidence.

Export and save a review

Choose Invoice summary for one row per statement with service point, dates, scope, usage, and charge-group totals. Choose Charge audit for the calculation basis, printed and calculated amounts, difference, status, and rate sources for each checked line.

The invoice summary keeps separate utility and supplier rows. Use the Overview usage chart to see metered electricity use counted once per service period. To resume an edited exercise in another tab, save the JSON backup from Guide & backups.

Summary

Use the Studio to explain what drove an electricity bill, reproduce its charges from the source rates and meter readings, and document any differences. The sample workflow takes 10 fictional source documents and 12 generated statements through to a traceable audit of 209 printed charge lines.

For a short walkthrough, follow SIM-2507 through the July rate change, open its linked supplier statement SIM-2508, then inspect SIM-2510 to see how matching totals can conceal line-level differences.

Contact

Do you have a question or want to chat?

Analytics preferences

Optional Google Analytics uses cookies to measure page visits and engagement. You can browse the entire portfolio with analytics off.

Analytics is off in this browser.

Privacy details. Change your choice here at any time. Your preference is remembered for up to 180 days.