Skip to content
Utility Bill Tracker cover: a sample sheet with total billed, average bill and highest bill and a bar chart, beside the Dashboard and Bills tabs

Utility Bill Tracker

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
4
Difficulty
Beginner
Updated
November 13, 2026

Every slide (4)

Overview

The Utility Bill Tracker suits a household or small office that wants to see what power, heating, water, internet and trash collection cost over time. The Bills tab records each bill's start and end dates, provider, usage and unit, and the amount due, then works out the days in the period, the cost per day and the cost per unit. The Dashboard shows the total billed, average and highest bill, kilowatt-hours and therms used, and a breakdown by utility.

The sample covers July to October 2026 with fourteen bills across five utilities. Swap in your real providers and amounts, and enter each bill as soon as it arrives. Compare the cost per unit from month to month: a rising rate with steady usage points to a price change, while rising usage points to a change in how the home is used.

Useful for

  • Comparing electricity and gas bills across the seasons
  • Checking whether a new rate has raised the cost per unit
  • Keeping a record of water and trash costs for a rental

What's included

  • 3 tabs: Dashboard, Bills, How to use
  • Dashboard: a dashboard with 5 summary figures
  • Bills: a table
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Bills tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

Where do I find the billing period on a bill?

Most bills print the start and end dates of the service period near the amount due. Use those dates rather than the date the bill arrived. If the period is unclear, check the statement or ask the provider.

Why does the cost per day differ from the bill?

Cost per day divides the amount due by the days the bill covers, so bills of different lengths can be compared. It is an average, and it includes fixed charges that do not change with usage.

How do I track more than one property?

Duplicate the workbook for every property so bills and totals stay separate. Keep the utility names the same in each copy, so the Dashboard breakdowns line up when you compare them.

  • #bill-tracker
  • #utility-bill-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More bill tracker templates

See all 8

Also in Finance

All finance templates
Get this template

Preparing your template…