Docs · File formats
Utility & Telecom Recovery CSV format
Header names are matched automatically, in any order and any case. Extra columns are ignored.
| Column | Required | Also accepted as | Example |
|---|---|---|---|
| Account | Yes | account, account number, acct, account no | 4471 |
| Provider | Yes | provider, utility, carrier, supplier, vendor | Duke Energy |
| Service | service, utility type, commodity | electric | |
| Site | site, location, store, premises | Store 9 | |
| Period start | Yes | period start, from, service from, bill start | 2026-01-01 |
| Period end | Yes | period end, to, service to, bill end | 2026-01-31 |
| Bill amount | Yes | amount, total, bill amount, total charges | 400.00 |
| Usage | usage, consumption, kwh, therms, units | 4000 | |
| Usage unit | unit, uom | kWh | |
| Tax | tax, sales tax, vat, gst, taxes | 0.00 | |
| Late fee | late fee, late charge, penalty | 0.00 | |
| Read type | read type, read | A | |
| Line / service ID | line, phone number, service id, circuit id | 555-0101 | |
| Tax exempt % | exempt %, tax exempt %, exempt share | 0 | |
| Invoice number | invoice, bill number, invoice no | D-101 |