How to Keep Utility Account Numbers in One Place (4 Systems)

TL;DR: Store utility account numbers in a dedicated property management app, a spreadsheet with filters, a physical folder with labeled dividers, or a password manager with structured notes. A single source of truth saves hours during tenant turnover and prevents late fees when autopay breaks.

_Last reviewed: July 2026 · 5 min read_

You need the gas account number—right now—because the tenant just called about a shutoff notice, and you're staring at a stack of unopened mail from three different addresses. The average landlord manages 8-12 utility accounts per property, and most store the numbers in a mix of email threads, photos of bills, and one spreadsheet from 2019 that's "somewhere on the desktop."

Okoniq Property Hub keeps utility account numbers alongside service histories and maintenance logs in one app, so you never hunt through old emails when a tenant moves or a bill needs updating.

Where should you store utility account numbers to find them fast?

Use a system that's searchable, backed up automatically, and accessible from your phone—because you'll need it while standing in line at the utility office or on a call with customer service.

Four systems work well for independent landlords:

Property management app — Store account numbers in a dedicated "Utilities" section under each property. Tag them with provider name, service type, and last-update date. Apps like Okoniq let you attach a photo of the physical bill and set reminders for seasonal read dates or annual rate reviews. This is the fastest option if you already track maintenance in the same app.

Spreadsheet with filters — Create columns for Property Address, Utility Type (electric, gas, water, sewer, trash), Provider Name, Account Number, Login URL, and Last Updated. Use Excel or Google Sheets with filters so you can pull up "all electric accounts" or "all accounts for 123 Oak Street" in one click. Save it in a cloud folder that syncs to your phone. Update it every time a tenant moves or you change providers.

Physical folder with labeled dividers — Keep a binder with one section per property. Inside each section, use sub-dividers for Electric, Gas, Water, Sewer, Trash. File the most recent bill behind each divider, with the account number highlighted in yellow. This works if you prefer paper and don't need remote access, but you'll still want a backup photo on your phone.

Password manager with structured notes — Tools like 1Password, Bitwarden, or LastPass let you create "secure notes" with custom fields. Tag each utility account with the property address, then add fields for Account Number, Service Address, Phone Number, and Login Credentials. The search function is fast, and everything syncs across devices. This is the best option if you already use a password manager for other landlord accounts.

What information should you record beyond just the account number?

Store five data points for each utility account to avoid repeat calls to customer service:

1. Account number — The 10-15 digit string that identifies the account.
2. Service address — The exact address on file (may differ from the property address if the utility uses a different street suffix or unit format).
3. Billing address — Where the paper bill goes (often your home address, not the rental).
4. Customer service phone number — The direct line to reach the provider, saved so you don't hunt for it on a website.
5. Online login credentials — Username and password if you manage accounts online. Store these in a password manager even if the rest of your system is a spreadsheet.

Add a sixth field for "Last Verified" — the date you last confirmed the account was active and linked to the correct property. Update this every time a tenant moves in or out. If the date is more than 12 months old, call the utility to confirm the account is still tied to your name and not automatically transferred to a tenant who moved.

How do you keep utility records updated when tenants move?

Set a checklist trigger for every lease turnover: within 48 hours of a tenant moving out, log into each utility account (or call the provider) to confirm the account is back in the landlord's name and autopay is re-enabled if you use it. Document the final meter read in your system—this prevents disputes if the tenant claims they were billed for extra days.

When a new tenant moves in, record the initial meter read and the date service transfers to their name. If the tenant will pay utilities directly, remove your payment method from the account online and confirm the billing address switches to the property address. Take a screenshot of the confirmation and attach it to the property record in your app or folder.

Track tenant move-in and move-out dates alongside utility transfers so you can match up bills with occupancy periods when tax time arrives.

What's the fastest way to look up an account number during an emergency?

Use a searchable system with offline access. If your utility records live in a cloud spreadsheet, download a copy to your phone's Files app so you can open it without cell service. If you use a property management app, confirm it caches recent data for offline viewing—most do, but test it by turning on airplane mode and checking whether you can still pull up account numbers.

For landlords who manage more than three properties, add a quick-reference card to your wallet: a folded index card with just the account numbers and provider phone numbers for your most critical utilities (electric, gas, water). No addresses, no login info—just enough to call the provider and authorize a reconnect if a tenant triggers a shutoff. Update it twice a year, in spring and fall, when you check seasonal maintenance items.

How do you protect utility account numbers from identity theft?

Treat utility account numbers like semi-sensitive data—not as restricted as a Social Security number, but still worth encrypting. If you use a spreadsheet, store it in a password-protected folder on a cloud service with two-factor authentication enabled. Never email account numbers in plain text; if you need to share them with a property manager or co-owner, use a secure link that expires after 48 hours (tools like Dropbox and Google Drive support this).

If you print a physical list, keep it in a locked file cabinet, not taped to the inside of a kitchen drawer at the rental property. Tenants and contractors don't need access to your full account numbers—only the customer service phone number if they report an outage.

Review your utility statements quarterly for unexpected charges or service addresses you don't recognize—a common red flag for account fraud or a provider error after a tenant moves.

FAQ

How many utility accounts does the average landlord need to track per property?

Between 4 and 6: electric, gas, water, sewer, trash, and sometimes a separate stormwater or recycling account. Multi-unit properties may have shared meters with one account or individual meters requiring separate accounts for each unit.

Should I store utility account numbers in the same place as tenant lease documents?

No—keep utility records in a separate system or folder so you can access them without digging through lease files. Utility account numbers are operational data you'll reference monthly; lease documents are legal records you rarely need after signing.

What happens if I lose a utility account number and the property is vacant?

Call the utility provider with the service address and your name as the account holder. They'll look it up using those two pieces of information. If the account was closed, you'll need to open a new one, which can take 3-5 business days for reconnection—plan ahead when scheduling turnovers.

Can I use a shared spreadsheet if I co-own a property?

Yes, but restrict edit permissions to one person and give the co-owner view-only access. Use version history (available in Google Sheets and Excel Online) to track who changed an account number or login credential. Never store passwords in a shared spreadsheet unless it's in a password-protected cell.

This is educational information, not legal or financial advice. Consult your accountant about recordkeeping requirements for rental property expenses and utility deductions.