What it does
Upload a utility billing export (from a property management platform, utility portal, or spreadsheet). Get back a normalized file with consistent date formats, amounts as plain numbers, account numbers formatted uniformly, and usage quantities cleaned of unit suffixes — ready for expense reporting or accounting import.
The problem it solves
Utility bills across multiple properties or accounts come from different portals with different export formats. Bill dates in different formats, amounts with $ and commas, usage quantities with "kWh" or "therms" suffixes embedded in the cell. Aggregating these for monthly expense reports requires manual cleanup every cycle.
What it handles automatically
- Date normalization — Converts bill date, due date, and service period start/end to ISO 8601
- Amount cleaning — Strips
$, commas, and "USD" from charges; converts to plain decimals - Usage quantity cleaning — Removes unit suffixes (kWh, CCF, therms, gallons) from numeric fields
- Account number formatting — Standardizes leading zeros and common account number formats
- Service type normalization — Maps Electric/Electricity/ELEC to a consistent label; same for Gas, Water, etc.
FAQ
Does it work with data from any utility provider? Yes — as long as you can export a CSV or XLSX. The column mapping step lets you match your export's column names to the standard fields.
Can I process multiple utility types (electric, gas, water) in one file? Yes. Use the service type normalization to tag each row by utility type.
Does it store my data? No. All processing is in your browser.