Split Bill Calculator

For a shared electric bill, divide the usage-based charge in proportion to each person's measured kilowatt-hours; handle fixed customer fees separately under an agreed rule. For a shared room charge, divide by person-nights when everyone has agreed that nights occupied are the basis. The calculations below show exactly what is assumed and what comes from published sources.

Download a blank shared-bill ledger

Use one row for each participant and expense allocation. Record the bill date and item, then compare each person's amount paid with the amount owed. This file is an empty template; it contains no example transactions.

Download blank CSV ledger

Compare dated U.S. residential electricity prices

The U.S. Energy Information Administration's Electric Power Annual reports these national average residential prices. They are historical U.S. averages, not a quote for a specific utility or household. Each row is labeled with its data year; the report release and this page's check date are shown below.

Example assumption: allocate electricity by kWh

Example assumption: this is a constructed calculation, not a real household or customer bill. The source figures below come from an official sample bill and an EIA national average; combining them does not recreate an actual utility tariff.

The Orlando Utilities Commission sample bill is dated July 3, 2017. It shows 1,500 kWh over 30 service days, an $8.00 electric service charge, and $173.15 for OUC electric service. The document is labeled “SAMPLE BILL — DO NOT PAY.” Its publication date is not shown in the PDF; checked November 5, 2026. Its total service amount includes bill-specific components, so do not treat it as a current OUC rate.

Example assumption: three roommates' measured-use entries are 300 kWh, 500 kWh, and 700 kWh. These assumed readings add to the sample bill's published 1,500 kWh. For an easy benchmark calculation, apply the EIA's 2025 national average residential price of 17.23 cents per kWh to those assumed readings; this is illustrative arithmetic, not the roommates' actual tariff.

Example assumption: the roommates agree to divide the sample's $8.00 fixed service charge equally. $8.00 ÷ 3 = $2.666… per person, rounded to cents as $2.67, $2.67, and $2.66 so the shares reconcile to $8.00. Under these stated assumptions, the benchmark totals are $54.36, $88.82, and $123.27. They add to $266.45, which is the $258.45 benchmark usage amount plus the $8.00 fixed fee. This is not a reconstruction of the sample bill's $173.15 charge.

Example assumption: allocate a shared room charge by nights

Example assumption: the dates, rent, payer, and occupancy below are invented solely to demonstrate the formula; they are not a real reservation, rent record, market price, or legal rule.

Example assumption: a shared room costs $2,400 for the assumed stay from May 1, 2026, through checkout on May 31, 2026, covering 30 nights. Alex stays all 30 nights, Blair stays from May 1 through checkout on May 21 for 20 nights, and Casey stays from May 21 through checkout on May 31 for 10 nights. Alex pays the full assumed charge.

Under this example assumption, Alex's own share is $1,200. Blair pays Alex $800 and Casey pays Alex $400. The transfers total $1,200, and all three shares total the assumed $2,400 room charge. If a booking charges per room or assigns a different price to a night, replace the assumed flat total with the actual bill lines before using this formula.

State electricity averages are not local bill rates

The EIA's 2025 state figures let roommates compare the scale of a usage-based charge across states, but they are statewide average revenue per kilowatt-hour, not a quote for a household, utility, city, tariff, or lease. The table reports every state. The report was released October 21, 2026; the figures were checked November 5, 2026.

The state spread is a budget comparison, not a reason to change roommates' shares arbitrarily. Example assumption: compare 500 kWh at the 2025 California average of 31.35 cents per kWh with the same usage at Idaho's 11.83 cents. The benchmark amounts are 500 × $0.3135 = $156.75 and 500 × $0.1183 = $59.15, a $97.60 difference. These are arithmetic from statewide averages, not actual bills. Example assumption: if two roommates use 350 and 150 kWh in the same home, applying one state average preserves the 70/30 usage proportions; changing the state average changes the dollar total, not that split ratio. A real reconciliation should start with the provider bill and the meter readings or another rule the household agreed to.

A statewide average can compare benchmark costs across places, but it cannot produce a household allocation rule. If roommates share one meter and apply the same per-kWh price to each person's measured use, the state average scales each usage amount uniformly; it does not change each person's proportion of the home's total kilowatt-hours. A provider's actual tariff and bill adjustments can change the total due.

Who is on the utility account can limit a roommate split

New York’s statute also separates the utility’s shared-meter investigation from a roommate’s later reimbursement math: it calls for an investigation that can include meter or wiring inspection, estimates of use inside and outside the dwelling, and a review of billing records. The written determination identifies the areas served and the proportional amount used inside and outside the apartment. Keep that documented utility allocation as its own bill entry before applying any separate roommate agreement; an equal split among occupants does not establish the utility’s outside-use share.

For a calculator, keep two ledgers separate: who the provider bills and what roommates agreed to reimburse one another. A calculator can reconcile amounts that participants enter; it cannot establish that a lease clause is valid, identify who legally owes a utility, or convert a shared-meter charge into a lawful roommate debt. Before settling a disputed common-area, basement, or landlord-billed amount, identify the meter, bill account holder, lease terms, and applicable state rule. If the charge includes service outside a tenant's dwelling, do not treat an equal split as proof that the allocation is legally permitted.

When these splits do not fit

Fixed monthly fees: a customer or meter charge does not rise with each roommate's kWh. Keep it separate from the usage-based portion and use a rule everyone accepted, such as equal shares or occupancy days; do not silently fold it into the kWh rate.

Separate meters or submeter readings: use each person's actual meter readings and the applicable bill period. A national average price is only a comparison benchmark; it cannot replace the provider's tariff, tier rules, taxes, or adjustments.

Different arrival or departure dates: count only the nights each person occupied the shared room. Person-night allocation is unsuitable for a private room, a per-person charge, or a contract that assigns rent differently. Agree on how to handle common areas, deposits, cleaning, taxes, and empty nights before settling.

Missing individual readings: a single household meter shows household use, not each person's consumption. Do not present a guessed kWh split as measured; agree on another allocation rule or leave that component unresolved.

Sources and scope

EIA, Electric Power Annual: Residential Average Revenue per Kilowatthour (2025 state data; released October 21, 2026; checked November 5, 2026), and Table 2.4 (2024–2025 national comparison). California Department of Real Estate, California Tenants, 2026 Edition (RE 26, revised January 1, 2026; checked November 5, 2026). New York State Public Service Law § 52 and New York Public Service Commission, Shared Meter Case #213767 determination (June 28, 2022; checked November 5, 2026). Orlando Utilities Commission, Understanding Your New Utility Bill sample (sample bill date July 3, 2017; marked “SAMPLE BILL — DO NOT PAY”). Calculated amounts are derived from the stated source values and clearly labeled example assumptions; they are not consumer records, local rate quotes, or advice about a lease.

Open the bill split calculator · Reconcile a corrected estimated utility bill · Compare equal, itemized, and income-based methods · Settle multiple payers