Utilities Chart of Accounts: Track Generation, Transmission, and Distribution Costs Separately
A guide to setting up a chart of accounts for electric, water, and gas utilities in QuickBooks. Learn why generation, transmission, and distribution costs need separate accounts, and how to book unbilled revenue and customer deposits correctly.
If you run an electric co-op, a small municipal water system, or a gas distribution company, your chart of accounts probably has one "Cost of Goods Sold" line and one "Operating Expenses" line. That tells you your total cost to serve customers went up. It doesn't tell you whether the increase came from a fuel price spike, a bad year for line losses, or a treatment plant that needs new equipment.
This guide walks through setting up a utilities chart of accounts that separates cost by function — generation and treatment, transmission and distribution — plus two accrual details, unbilled revenue and customer deposits, that trip up most first-time utility bookkeepers.
Why a Generic Chart of Accounts Doesn't Work for Utilities
Large, investor-owned electric utilities keep their books under a rule called the Uniform System of Accounts, set by the Federal Energy Regulatory Commission. That rule doesn't apply to a small water co-op or a rural gas distributor — it's a regulatory filing requirement for utilities under FERC's jurisdiction, not a GAAP (Generally Accepted Accounting Principles) standard every utility has to follow. But the idea behind it is worth borrowing even if you never file a rate case: FERC requires plant investment and operating expense to be tracked separately by function — generation, transmission, distribution — because those are three different businesses stapled together, and each one has its own cost drivers.
A small utility doesn't need FERC's several hundred sub-accounts. It does need the same three-way split, because it answers the same question a regulator would ask: is the money you're losing coming from what you generate, what you move over the wires or pipes, or what leaks out before it reaches the meter?
Cost of Service by Function
Instead of one COGS account, the utilities template splits direct delivery cost into generation and treatment, then transmission and distribution:
| Account | Number | Purpose |
|---|---|---|
| Fuel Costs - Natural Gas | 5000 | Natural gas fuel burned for power generation |
| Fuel Costs - Coal | 5010 | Coal fuel burned for power generation |
| Purchased Power | 5020 | Power bought from other utilities or the regional grid |
| Water Source Costs | 5030 | Raw water acquisition and pumping costs |
| Treatment Chemicals | 5040 | Water treatment chemicals and materials |
| Generation Plant Operations | 5050 | Direct labor and costs for power plant operations |
| Treatment Plant Operations | 5060 | Direct labor and costs for treatment facility operations |
| Transmission Costs | 5200 | Power transmission and wheeling charges |
| Distribution Operations | 5210 | Direct labor for distribution system operations |
| Line Loss & Unaccounted Water | 5220 | Power line losses and water system leakage |
Once these are separated, you can see whether it's the fuel bill or the distribution labor line that's moving your margin, instead of guessing from one lump COGS number.
Booking Unbilled Revenue
Utility billing runs on meter-read cycles, not calendar months. If your meter readers cover a route between the 10th and the 25th, the customers on that route have used and paid for service through the read date — but the days between the read date and month-end have been consumed and not yet billed.
The template has an account built for exactly this: Unbilled Revenue Receivable (1210), described in the template as utility services provided but not yet billed. At month-end, you estimate the unbilled portion of consumption for the customers still mid-cycle and book it as a debit to Unbilled Revenue Receivable and a credit to the matching revenue account — Residential Service Revenue (4000), Commercial Service Revenue (4100), or Industrial Service Revenue (4200), depending on the customer class. When the next bill goes out, the receivable clears and ordinary Accounts Receivable takes over.
Skip this accrual and your monthly financials understate revenue by roughly half a billing cycle, every single month — a distortion that never looks like an error because it repeats identically each period.
Booking a Customer Deposit
Most utilities require new customers, especially ones without an established payment history, to post a refundable security deposit before service starts. That deposit is not revenue. It's a liability: you're holding the customer's money, and you owe it back — net of any unpaid final bill — when the account closes or the customer qualifies to have it released.
The template books this to Customer Deposits (2220), described as security deposits from utility customers. When a new residential customer pays a $150 deposit, the entry is a debit to the bank account and a credit to Customer Deposits — nothing touches a revenue account. If the customer later leaves owing a final bill, you net that balance against the deposit and refund or write off the difference; if they leave in good standing, the deposit is refunded and the liability zeroes out.
Book a deposit to revenue by mistake and you overstate income in the month you collected it, then have no liability on the books when it's time to refund the money.
Get Started
Our utilities chart of accounts template includes generation, treatment, transmission, and distribution cost accounts, unbilled revenue tracking, and customer deposit liabilities pre-configured and ready to import into QuickBooks.