Utility Bill & Energy Usage Tracker | Excel Electric, Gas & Water Bill Tracker

See exactly where your utility money goes - and spot price rises before they hurt.

Log each electricity, gas, water, internet and phone bill once. The Excel sheet works out the cost per unit, totals every month by utility, compares it with your budget and flags unpaid bills.

WHAT'S INCLUDED

• Bill Log: 200 rows - bill month, utility, provider, usage, unit, amount, cost per unit, due date, paid?, paid on, notes

• Settings: tracking year, 6 renamable utilities with monthly budget and usage unit

• Monthly Summary: 12 months x 6 utilities, monthly total, budget, over/under and electricity cost per kWh

• Dashboard: spent this year, months with bills, average month vs budget, unpaid bills and amount, priciest month, electricity and heating year-to-date + stacked 12-month chart

• Works in any currency (USD, GBP, CAD, EUR) - amounts are plain numbers

• Start Here guide and sample data

BEST FOR

Households watching winter energy costs in the USA, UK and Canada, renters and homeowners, roommates splitting bills, anyone comparing tariffs or providers.

HOW IT WORKS

1. Download and open in Microsoft Excel.

2. Type in the yellow cells (sample data shows the format).

3. The Dashboard updates automatically.

PAIRS WELL WITH

Paycheck Budget Planner, Subscription Audit & Cancellation Tracker, 2027 Annual Budget & Sinking Funds Planner (LaunchKit Labs)

FORMAT / DELIVERY

Microsoft Excel (.xlsx), Excel 2010 or later, Windows and Mac; also opens in Google Sheets. Instant digital download - no physical item.

FAQ

What exactly do I get?

Excel utility bill tracker: electric, gas, water & internet bills, cost per unit, monthly totals vs budget, unpaid bills and a 12-month chart.

What do I need to use it?

Microsoft Excel on Windows or Mac (Excel 2016 or newer, or Microsoft 365). It also opens in free Google Sheets, though Excel is recommended.

How do I get it?

It is an instant digital download: right after payment you get the file on the page and by email. No physical item is shipped.

What if it is not right for me?

Contact me through my Payhip store within 30 days and I will refund you - no hard feelings.

I have a question

Use the contact link on my Payhip store page and I will help.