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.
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.
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.
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.
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.
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.
