Utility Bills & Usage Tracker in Google Sheets Template

The Utility Bills & Usage Tracker in Google Sheets logs every recurring bill across 11 utility types, drives 4 live charts plus a Total Amount Due card, and calculates 4 columns for you automatically — Bill ID, Change %, Days to Due and Cost / Unit. Setup takes under 10 minutes: replace the 15 sample rows with your own bills and every number on the page rebuilds itself.

🌍 Join 8,400+ teams in 40+ countries using NextGenTemplates to replace paid SaaS tools with one-time-purchase Excel, Google Sheets, Power BI, and HTML templates.

✅ Instant download · One-time payment · No subscription · No per-user fees · Lifetime access

🔑 Key Features of the Utility Bills & Usage Tracker

💡 One card that answers the only question that matters. The Total Amount Due card sums the Current Bill of every row not marked Paid. In the sample data that is $737 across 15 bills. Mark one Paid and the card drops the moment you change the cell — no refresh, no recalculation button.

⚡ Eleven utility types, one sheet. The tracker ships ready for Electricity, Water, Gas, Internet, Mobile Phone, Cable TV, Trash / Waste, Sewer, Landline, Streaming and Heating Oil. Each type carries its own colour so the table reads like a legend, and you can add your own type on the List tab in seconds.

📅 Due dates that chase you. The Days to Due column counts down from today’s date, shows a red Overdue label once a bill passes its due date, and collapses to a dash once you set Payment Status to Paid. Four statuses are supported: Unpaid, Paid, Overdue and Partial — so a half-paid internet bill does not sit in the same bucket as an untouched one.

📈 Change % catches the price hikes. Every row compares Current Bill against Previous Bill and prints the percentage difference, shaded red when it rises and green when it falls. In the sample month that surfaces a 31.5% jump on garden water and a 29.1% drop on summer natural gas — the kind of movement that hides in a bank statement.

🧮 Cost / Unit turns usage into a rate. Enter 620 kWh and $158.30 and the tracker returns $0.26 per kWh. Do the same for gallons, therms, GB or minutes and you finally have a like-for-like number to take to a provider or a comparison site.

🔗 Dropdowns that never need re-setup. Utility Type, Provider, Unit and Payment Status all validate against the hidden List tab across rows 2-500. Add “Solar Feed-in” or a new provider there once and it appears in the dropdown on every row automatically.

📦 What’s Inside the Utility Bills & Usage Tracker

The workbook is deliberately a one-pager: dashboard on top, data underneath, so you never scroll between a chart and the row that feeds it. Three visible tabs plus a List tab for the dropdowns.

Page 1: Tracker Dashboard and Bills Table

The main sheet. A Total Amount Due card sits on the left, four charts run across the top — Bill Count by Utility Type, Bill Count by Payment Status, Current Bill by Utility, and Previous vs Current Bill — and a 16-column data table fills the rest: Bill ID, Utility / Service, Utility Type, Provider, Billing Month, Usage, Unit, Previous Bill, Current Bill, Change %, Due Date, Payment Status, Days to Due, Cost / Unit, Paid Date and Notes.

Page 2: How to Use

A built-in instruction sheet covering the four setup steps, which columns are formulas and must not be typed over, how to switch the dropdowns to Google’s coloured “Chip” display style, and where the colour palette lives if you want to rebrand the tracker. It also shows how to change the currency from $ to ₹, € or £.

Page 3: Explore More Templates

A curated list of recommended NextGenTemplates trackers and dashboards with live product links, popular category shortcuts, and a WELCOME15 coupon worth 15% off your next purchase.

📊 Utility Bills & Usage Tracker vs. Microsoft Excel Dashboard vs. Rocket Money / YNAB — Where This Fits

For households and small offices that want a clear picture of what they owe without handing bank credentials to an app or paying monthly forever, the Utility Bills & Usage Tracker sits in the sweet spot.

👥 Who This Template Is For — and Who It’s Not For

✅ This template is built for:

• Households juggling 6-20 recurring bills across several providers and due dates
• Remote workers and freelancers splitting home-office utilities for tax or reimbursement
• Landlords and property managers tracking utilities across a handful of units
• Small offices, clinics and studios that pay their own electricity, water and internet
• Anyone who wants usage data — kWh, gallons, GB — alongside the money, not just the money

❌ This template is NOT for:

• People who want bills imported automatically — this is a manual-entry tracker by design, which is exactly why it needs no bank access
• Utility companies analysing thousands of customer meters; that is a Power BI job, not a spreadsheet one
• Teams needing approval workflows, audit logs or invoice attachments — look at a dedicated AP system

⚙️ How to Use the Utility Bills & Usage Tracker

1. Open the PDF in your download and click the “Make a copy” link to create your own Google Sheets copy.
2. Replace the 15 sample rows (rows 16-30) with your own bills. Fill Utility / Service, Utility Type, Provider, Billing Month, Usage, Unit, Previous Bill, Current Bill, Due Date and Payment Status.
3. Leave Bill ID, Change %, Days to Due and Cost / Unit alone — those four columns are formulas and fill themselves.
4. Optional, 10 seconds: select column C, then D, G and L, and set Data > Data validation > Advanced > Display style to “Chip” for the coloured pills you see in the screenshots.
5. Each cycle, add a row for the new bill or update Current Bill and Due Date on the existing one.
6. When you pay, set Payment Status to Paid and enter the Paid Date. The card, the countdown and all four charts update instantly.

💼 Real-World Use Cases

Maria runs a three-bedroom household with a partner who travels. She logs electricity, water, gas, internet, two mobile plans and a streaming bundle in the Utility Bills & Usage Tracker, shares the sheet with her partner by link, and checks the Total Amount Due card every Sunday. When the Change % column flagged an 11.1% electricity rise, she traced it to summer air-conditioning rather than a tariff change.

Dev is a freelance developer who claims part of his home as an office. He tags the office electricity and backup internet rows separately in the Notes column, so at tax time he filters the table and has a defensible utility figure in under a minute — with Cost / Unit proving the rate he actually paid.

Priya manages four rental units. She uses Provider and Billing Month as her grouping fields, watches the Days to Due countdown so no tenant-billed utility slips into a late fee, and uses Previous vs Current Bill to spot the one unit whose water usage doubled — a leak, found in a chart instead of a plumber’s invoice.

❓ Frequently Asked Questions

What does the Utility Bills & Usage Tracker actually track?

The Utility Bills & Usage Tracker records 16 fields per bill across 11 utility types, and calculates Total Amount Due, Change % versus the previous bill, Days to Due and Cost / Unit automatically. Four charts summarise bill counts, payment status and current versus previous spend.

How long does setup take?

Under 10 minutes. Copy the sheet from the PDF link, overwrite the 15 sample rows with your own bills, and the Utility Bills & Usage Tracker dashboard rebuilds itself. The optional chip-style dropdown formatting adds about 10 seconds per column.

Do I have to connect my bank account?

No. The Utility Bills & Usage Tracker never asks for bank or provider credentials — you type the bill amounts yourself. That is the trade-off versus apps like Rocket Money: a little manual entry in exchange for zero credential sharing and no monthly fee.

How does this compare to YNAB or Quicken?

YNAB and Quicken cost $6-15 per month and budget your whole financial life. The Utility Bills & Usage Tracker costs $6.99 once, focuses only on recurring utilities, and adds something they mostly skip: usage tracking in kWh, gallons, therms or GB with a calculated cost per unit.

Can I add utility types or providers that are not in the list?

Yes. Every dropdown in the Utility Bills & Usage Tracker reads the List tab across rows 2-500. Type your new utility type, provider or unit there and it appears in the dropdown on every row immediately — no formula editing and no re-setup.

Will the charts include bills I add later?

Yes. All four charts in the Utility Bills & Usage Tracker read the data columns directly across rows 16-1000 using the built-in Aggregate option. New bills appear in the charts automatically, with no hidden helper tables to maintain.

Can I change the currency from dollars?

Yes. Select the money columns in the Utility Bills & Usage Tracker and use Format > Number to switch to ₹, €, £ or any other currency. The colour palette is equally editable from the theme block at the top of the script.

👤 About the Author

Built by PK — Microsoft Certified Professional with 15+ years of Excel, Google Sheets, and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels (@PK-AnExcelExpert, @NextGenTemplates, @NeoTechNavigators). Every template is hand-built and tested before release.

🔗 Explore Related Templates

Utilities are only part of the monthly picture. Pair this with the Bill Payment Tracker in Google Sheets for non-utility bills, the Subscription and Membership Tracker in Google Sheets for the recurring charges that creep up unnoticed, and the Personal Cash Flow Tracker in Google Sheets to see how it all lands against income. Homeowners planning bigger work should also look at the Home Renovation Budget Tracker in Google Sheets.

Browse the full Google Sheets Dashboards collection, or the wider Dashboard Templates library if you would rather work in Excel or Power BI.

💎 Save more: the Tracker Toolkit — 12 Premium Templates bundles this style of tracker a dozen times over for far less than buying them one by one.

📖 Click here to read the Detailed Blog

Watch the step-by-step video Demo:

🎥 Visit our YouTube channel for step-by-step video tutorials

👉 YouTube.com/@NextGenTemplates

📅 Last updated: August 2026