Home Lighting Energy Audit Worksheet: Find Waste, Estimate Costs, and Prioritize LED Upgrades
energy efficiencyLED upgradeselectricity costshome energy auditlighting worksheetenergy savings

Home Lighting Energy Audit Worksheet: Find Waste, Estimate Costs, and Prioritize LED Upgrades

LLumen Link Editorial Team
2026-11-17
7 min read

Use a room-by-room worksheet to calculate lighting costs, find waste, and prioritize compatible LED and control upgrades.

A home lighting energy audit shows which fixtures use the most electricity, what they cost to operate, and which upgrades deserve attention first. This worksheet walks you through a room-by-room inventory, a repeatable lighting energy cost calculator, and practical LED upgrade priorities without assuming that every fixture must be replaced.

Overview

Lighting is usually a straightforward load to measure because each fixture has a known wattage and a reasonably observable operating schedule. The challenge is finding the lights that combine high power, long runtime, and poor control. A rarely used incandescent bulb may matter less than a lower-wattage outdoor light that runs from dusk to dawn every night.

A useful audit answers four questions:

  • How many fixtures or bulbs are in each room and outside area?
  • How much power does each one use?
  • How many hours per day or year does it operate?
  • Would a more efficient bulb, fixture, timer, sensor, or switch reduce consumption?

Begin with lights that are always on, operate for several hours each day, or use incandescent and halogen lamps. Then check enclosed fixtures, high ceilings, exterior lighting, and locations where a control upgrade could prevent unnecessary runtime. Before buying replacements, confirm the bulb base, shape, lumens, color temperature, enclosure rating, and dimmer compatibility. The LED Bulb Replacement Guide can help with that match.

How to estimate lighting energy costs

Use this basic formula for each fixture or group of identical bulbs:

Annual energy use (kWh) = watts × quantity × hours per day × days per year ÷ 1,000

Then estimate operating cost:

Annual lighting cost = annual kWh × electricity rate

Your electricity rate should be expressed in currency per kilowatt-hour. Use the supply rate shown on your bill, or use the total energy charge when that better reflects what you pay for additional consumption. If your bill includes time-of-use pricing, calculate separate estimates for the relevant periods instead of using one average rate.

For a fixture with two 60-watt incandescent bulbs used for four hours per day, the calculation is:

120 watts × 4 hours × 365 days ÷ 1,000 = 175.2 kWh per year

If the electricity rate in your worksheet is an illustrative $0.18 per kWh, the estimated annual operating cost is 175.2 × $0.18 = $31.54. This is an example, not a current price recommendation. Replace the rate with the figure from your own bill.

To compare an upgrade, repeat the calculation with the replacement wattage. If two LED bulbs provide similar useful brightness at 10 watts each, the replacement load is 20 watts:

20 watts × 4 hours × 365 days ÷ 1,000 = 29.2 kWh per year

At the same illustrative rate, that load would cost about $5.26 per year. The estimated annual energy-cost difference is therefore about $26.28 before purchase, installation, and maintenance costs. For a simple payback estimate, divide the upgrade cost by the annual savings. Treat payback as one decision factor; light quality, reliability, safety, and compatibility also matter.

Inputs and assumptions: printable room-by-room worksheet

Copy this worksheet into a document or spreadsheet. Record one row for each fixture type, or separate rows when bulbs in the same fixture have different wattages or schedules.

Room or areaFixture and bulb typeQuantityWatts eachHours/dayDays/yearControlAnnual kWhPriority
Example: kitchenCeiling fixture, incandescent3603365Wall switch197.1High

For each row, note whether the wattage is for one bulb or the entire integrated fixture. Check the label on the bulb, fixture, driver, or control documentation rather than relying only on brightness. Watts measure energy use; lumens describe light output. A lower-wattage replacement should still provide suitable lumens for the task.

Use reasonable estimates for runtime, but mark uncertain entries. You can observe frequently used rooms for a week, check timer schedules, or use an occupancy pattern such as “two hours on weekdays and four hours on weekends.” For exterior lights, distinguish dusk-to-dawn operation from motion-triggered operation. A motion light may have a low average runtime but still be a poor candidate if its sensitivity or timer is misconfigured.

Also record the control type: manual switch, dimmer, timer, photocell, motion sensor, smart switch, or smart bulb. Controls affect energy use by changing runtime, not by making a bulb’s rated wattage lower. A smart bulb that remains powered for app or voice control may still draw a small standby load, so evaluate the whole setup when precision matters.

Typical comparison assumptions

The table below uses representative wattage ranges for comparison only. Actual products vary, and brightness is not necessarily equivalent across technologies.

Light sourceRepresentative use patternWhat to verify
IncandescentOften higher wattage for general-purpose lightActual label wattage and replacement brightness
HalogenOften similar operating pattern to incandescentWattage, heat, enclosure, and dimmer behavior
CFLLower wattage than incandescent for some comparable applicationsWarm-up, dimming, enclosed-fixture suitability, and disposal guidance
LEDOften lower wattage for comparable useful brightnessLumens, color, dimming, base, enclosure, and rated life

Worked examples and upgrade priorities

Example 1: frequently used kitchen lighting. Suppose three 60-watt bulbs run for three hours daily. At 365 days, the load is 197.1 kWh per year. Replacing them with three 9-watt LED bulbs changes the load to 29.565 kWh per year. At an illustrative $0.18 per kWh, the estimated annual difference is about $30.16. Confirm that the LEDs provide adequate lumens and work with the existing dimmer, if one is installed. The Home Lighting Upgrade Planner can help organize those specifications.

Example 2: an exterior light that runs overnight. A 40-watt light operating for 12 hours per night uses about 175.2 kWh per year. A 10-watt replacement used for the same schedule uses about 43.8 kWh. Before changing the bulb, check whether the fixture is rated for LED use, whether the lamp is enclosed, and whether the photocell or timer is functioning correctly. For outdoor fixtures, wet-location requirements and mounting details matter; see the Outdoor Wall Light Replacement Guide.

Prioritize upgrades using this order:

  1. High wattage and long runtime: frequently used incandescent, halogen, and exterior lights usually deserve early attention.
  2. Always-on or poorly controlled fixtures: add a timer, photocell, occupancy sensor, or scheduling feature where appropriate.
  3. Easy bulb replacements: start where the socket, fixture, and dimmer are compatible so installation remains simple.
  4. Problem fixtures: address flicker, overheating, failed controls, or unsuitable lamps before optimizing small energy differences.
  5. Low-use decorative lights: replace them when they fail or during a renovation unless their wattage or runtime is unusually high.

You may not need to replace an entire fixture. A compatible LED bulb can often deliver the desired reduction without changing wiring or the housing. Integrated LED fixtures, smart controls, and new wiring require a closer evaluation of installation cost, repairability, control compatibility, and future replacement options. For electrical work, follow the fixture instructions and local safety requirements; turn off power at the breaker and use a qualified professional when wiring, box support, or circuit conditions are uncertain.

When to recalculate your lighting costs

Revisit the worksheet whenever your electricity rate changes, a utility bill rises unexpectedly, or you alter a room’s use. Recalculate after replacing bulbs, installing a dimmer or smart switch, changing an outdoor timer, adding landscape lighting, or converting a light from manual control to motion activation.

Review the audit at least when you replace failed lamps or begin a renovation. Update wattage from the new product label rather than carrying forward an old estimate. For smart lighting, include the devices that remain energized and check whether schedules actually match household routines. For seasonal lights, record operating days separately from year-round fixtures; the Holiday Outdoor Lighting Setup Guide covers load planning and weatherproof connections.

Finally, compare estimated savings with your bills without expecting a perfect match. Whole-home consumption includes heating, cooling, appliances, electronics, and other loads, while billing periods and rates vary. The audit is most useful as a decision tool: update the inputs, identify the largest avoidable loads, make one change at a time, and record the result. That process keeps your LED upgrade checklist practical as prices, fixtures, and household routines change.

Related Topics

#energy efficiency#LED upgrades#electricity costs#home energy audit#lighting worksheet#energy savings
L

Lumen Link Editorial Team

Lighting Editors

Senior editor and content strategist. Writing about technology, design, and the future of digital media. Follow along for deep dives into the industry's moving parts.