Utilities Expense Tracker Spreadsheet

The Utilities Expense Tracker is a Google Sheets template that helps you monitor and budget electricity, gas, water, and other utility costs using your Tiller transaction data.

About the Utilities Expense Tracker Spreadsheet

Utilities — electricity, gas, water — can quietly take up a large chunk of your budget, and the costs aren’t always easy to see at a glance. The Utilities Expense Tracker gives you a dedicated place to understand what you’re spending, why, and how it’s changing over time.

It tracks consumption and cost for up to five utilities across up to five years, pulls payment data directly from your Tiller transactions, and visualizes both in graphs so you can spot seasonal patterns and year-over-year trends. It also generates monthly budget estimates based on your past usage — last year’s actuals, averages, or maximums — so your utility budget reflects how you actually use energy, not a rough guess.

Built by Tiller Community member @jpfieber.

Best for: Homeowners and renters who want to track, visualize, and budget utility costs based on actual consumption and transaction history.

Support & Documentation

Install the Utilities Expense Tracker through the Tiller Community Solutions add-on. Search for “Utilities” in the Explore tab.

For setup details, customization tips, and community discussion, visit the Utilities Expense Tracker thread in the Tiller Community.

If you run into an issue, search the community first and if your question hasn’t been answered, post it in the Get Help > Spreadsheet Templates category.

FAQ

Unless otherwise noted above, this is a free template built by a member of the Tiller Community. Some community templates may only be accessible via the Tiller Money Feeds add-on, which requires a Tiller free trial or subscription to use. Additionally, it’s recommended for use within the Foundation Template.

Tiller is the only automated personal finance service for Google Sheets and Microsoft Excel. Tiller automatically imports your daily spending, income, and balances in your spreadsheets, so you can see all your finances in one place and manage your money, your way. Learn more →

Unless otherwise noted above, this free template is installed with the Tiller Community Solutions add-on for Google Sheets. It's an easy way to browse and install dozens of free, prebuilt sheets for tracking budgets, debt payoff goals, net worth, savings, and more, all from the Google Sheets sidebar. Some community templates can be installed using Tiller Money Feeds. See Installation details above.

This template for Excel works best when installed in Tiller’s Foundation Template.

Review the Support and Documentation section in the template details above to learn how to get support for this template in the Tiller Community.

Leave a Reply