Columbia Water & Light Data Access Guide
Columbia Water & Light is a municipal electric utility serving over 53,000 customers in Columbia, Missouri. The utility operates without advanced metering infrastructure today—billing data is available through the MyMeter portal but only monthly usage granularity is captured. No Green Button, EDI, or third-party API programs exist, though an AMI deployment is planned.
How to Get Your Columbia Water & Light Data: All Access Methods
| Method | 1st Party | 3rd Party | Customer Types | Data Types | Latency | Format |
|---|---|---|---|---|---|---|
| MyMeter Billing Portal | ✓ | — | Residential, C&I | Billing, monthly usage | Next billing cycle | Web display |
| Manual export / screenshot | ✓ | ✓ | All | Monthly usage | On request | Screenshot / manual |
| Sunshine Law records request | ✓ | ✓ | All | Monthly usage, billing | ~3 business days | Paper / electronic (fee-based) |
| Green Button / API / EDI | — | — | None | None | N/A | Not offered |
Billing Data Access
Billing and monthly usage data are available 24/7 through the MyMeter self-service portal (powered by MyMeter by Accelerated Innovations over a CIS Infinity backend). The portal is web-only with no native CSV/XML/JSON export; customers retrieve data via screenshots, manual transcription, or a fee-based Missouri Sunshine Law records request.
What Data Is on Your Columbia Water & Light Bill
- Current bill and service charges
- Payment history
- Monthly consumption (usage charts)
- Multi-account comparison
- Energy Challenge savings tracking
How to Download Columbia Water & Light Bills (Business & Commercial)
- 01Register each account in MyMeter at https://myutilitybill.como.gov/
- 02Open Detailed Usage Charts; compare multiple accounts where applicable
- 03For structured data, email UCS@CoMo.gov or call 573.874.7380 to request a monthly usage export
- 04For formal records, file a Sunshine Law request at https://cityofcolumbiamo.nextrequest.com/ (fee-based, ~3 business day response)
How to Download Columbia Water & Light Bills (Residential)
- 01Create a MyMeter account at https://myutilitybill.como.gov/ using name on account, account number, and email
- 02Log in and open Billing & Payment Management for bill and payment history
- 03Open Detailed Usage Charts and select a service to view monthly usage
- 04Screenshot charts or request a manual export from Utility Customer Service
Third-Party Access to Columbia Water & Light Billing Data
Customer-mediated sharing
- 01Customer logs into MyMeter
- 02Customer shares screenshots or manual usage data with consultant
- 03No automated/OAuth delegation available
Sunshine Law records request
- 01File request at https://cityofcolumbiamo.nextrequest.com/
- 02Provide account number and data range
- 03Pay statutory fee; receive paper/electronic data in ~3 business days
Want to understand the charges on your bill?
See the Columbia Water & Light Rate Schedules & Tariff Guide →Interval Data & Smart Meters
Columbia Water & Light does NOT operate smart meters. The utility uses an Automated Meter Reading (AMR) system deployed since 1996 that collects monthly consumption only via radio handheld devices. No sub-monthly interval data is available. An AMI deployment (~60,000 electric + ~60,000 water meters) was scoped via a 2023 RFP but has no confirmed go-live as of 2026.
How to Download Columbia Water & Light Interval Data via Green Button
- 01Not available — Green Button requires AMI/interval data the utility does not yet collect
Interval data is essential for rate comparison and TOU analysis.
See which Columbia Water & Light rate schedule is best for your usage pattern →Sources
Third-Party API Access
No public developer portal or API is offered. MyMeter does not expose public APIs and CIS Infinity is not publicly accessible. Energy managers must use customer-mediated portal access or Sunshine Law requests, and inquire with Utility Services management about future programs.
How to Register as a Columbia Water & Light API Vendor
- 01Contact Utility Services Manager / Director of Utilities to discuss potential data access
- 02Outline use case, data types, and frequency
- 03Monitor the utility website for post-AMI program announcements
EDI (Electronic Data Interchange)
How to Enroll in Columbia Water & Light EDI
- 01No formal EDI program is documented
- 02Contact Utility Customer Service (573.874.7380 / UCS@CoMo.gov) to ask whether EDI transactions can be supported for business customers
- 03Request EDI specifications and a test environment if available
Sources
Rate Schedules & Tariff Analysis
Columbia's C&I rates are demand-driven above 25 kW. Summer (June–September) demand charges are materially higher than non-summer, and a 75%-of-summer-peak ratchet means the maximum summer demand sets a floor for billing demand across the following 11 months. The Power Cost Adjustment rider and 7.5268% in-lieu-of-gross-receipts charge add to every bill.
Columbia Water & Light Rate Schedule List
| Schedule | Applicability |
|---|---|
| Small General Electric Service | Commercial ≤25 kW summer demand |
| Large General Electric Service | Commercial 25–750 kW summer demand |
| Industrial Electric Service | Commercial >750 kW summer demand |
Columbia Water & Light Rate Features & TOU Details
- Summer/non-summer seasonal rate split (summer = June–September)
- 75% demand ratchet tied to prior summer peak
- Power Cost Adjustment (fuel) rider on all kWh
- 7.5268% in-lieu-of-gross-receipts charge plus sales tax
- Automatic schedule migration at 25 kW and 750 kW summer thresholds
- Industrial primary-service discount of $0.10 × peak kW; 2% reduction for primary metering
For a deeper analysis including cost optimization strategies and historical rate trends:
Read the full Columbia Water & Light Rate Optimization Guide →Other Data Access Programs
Planned AMI Deployment
The City scoped engineering services in a Feb 2023 RFP to deploy ~60,000 electric and ~60,000 water AMI meters, enabling interval data, outage detection, and advanced rate design. No confirmed go-live as of 2026.
- 01Monitor https://www.como.gov/utilities/electric/ for deployment updates
- 02Expect 15-30 minute interval data and possible Green Button support post-deployment
APPA Smart Energy Provider Designation
Columbia Utilities earned the American Public Power Association Smart Energy Provider designation (Dec 2024–Nov 2027), signaling openness to modernization and data access initiatives.
- 01Reference SEP status when proposing data partnerships
Limitations & Considerations
- ⚠No smart meters / AMI deployed — monthly data only
- ⚠No Green Button (Download or Connect My Data)
- ⚠No public API or developer portal
- ⚠No documented EDI program
- ⚠No native portal data export (CSV/XML/JSON)
- ⚠No formal third-party / aggregator program
- ⚠Sunshine Law requests are fee-based
Columbia Water & Light Data Access FAQ
Can a C&I customer get interval (15-minute) data from Columbia Water & Light?▾
Not today. The utility runs an AMR system that captures only monthly reads. Sub-monthly interval data will not be available until the planned AMI deployment goes live, which has no confirmed date as of 2026.
Does Columbia Water & Light support Green Button or a third-party data API?▾
No. There is no Green Button Download/Connect My Data, no ESPI API, and no public developer portal. Third-party access is limited to customer-mediated portal sharing or a fee-based Sunshine Law records request.
How can an energy consultant obtain a commercial customer's usage history?▾
Either the customer shares MyMeter screenshots/exports, or you file a Missouri Sunshine Law request at the City's NextRequest portal with the customer's account number. Sunshine Law requests are fee-based and typically answered within three business days.
Is there EDI (814/867) support for C&I billing?▾
No EDI program is publicly documented. Businesses needing EDI should contact Utility Customer Service to ask whether transactions can be configured on the CIS Infinity billing system.
What commercial rate will my facility be on?▾
Small commercial loads under 25 kW use the Small General Service rate; loads exceeding 25 kW in summer move to Large General Service; and loads exceeding 750 kW in summer are placed on the Industrial Service Rate. All schedules carry a Power Cost Adjustment rider.
The Best Way to Access Data from Columbia Water & Light
Nectar connects to Columbia Water & Light and 7,000+ utility providers — billing, interval, and rate data delivered automatically. No portals, no forms, no manual downloads.
Nectar for Energy & Sustainability Teams
Managing utility data for commercial or industrial buildings? Nectar offers a free energy data audit — we'll review your current setup and show you where automation can save your team hours every month.
Get a Free AuditNectar for Developers & Consultants
Building energy tools or advising clients on utility data? Nectar works with technology partners and consultants who need reliable data infrastructure.
Partner with Us