Home Energy Bills Tracker Spreadsheet - Utilities & Meter Readings for UK

Know what your home truly costs to run with this comprehensive Home Energy & Household Bills Tracker Spreadsheet. Designed for UK households, this all-in-one workbook helps you manage utility usage, meter readings, tariffs, recurring household bills, renewals, and savings comparisons in one connected Excel and Google Sheets file. Stop tracking electricity in one place and subscriptions somewhere else – this workbook provides a single, visual control centre for your home utilities and expenses. **WHO IT'S FOR:** This tracker is ideal for homeowners, renters, and families who want to understand their energy consumption, manage recurring household costs, review utility tariffs, and track home efficiency projects. It supports various setups including solar panels, EV charging, and time-of-use tariffs. **WHAT'S INCLUDED:** - Premium XLSX workbook (compatible with Microsoft Excel and Google Sheets) - 7 connected worksheets - Quick Start Guide (PDF) - Read Me file - Personal Use Licence **MAIN FEATURES:** **HOME DASHBOARD:** See your total home cost, net utilities, true daily running cost, potential annual savings, meter-data status, bills due soon, upcoming renewals, and monthly spending trends at a glance. **UTILITY & METER LOG:** Track electricity, gas, water, solar generation/export, EV off-peak charging, and other utilities. Opening and closing meter readings automatically calculate usage. Compare expected costs with actual supplier bills. **HOUSEHOLD BILLS:** Track mortgage/rent, Council Tax, broadband, mobile phones, insurance, subscriptions, and other recurring costs. Monthly and annual equivalents are calculated automatically. **TARIFFS & RENEWALS:** Keep track of provider details, tariff rates, standing charges, contract start/end dates, and renewal warnings. **COMPARE & SAVE:** Use your annualised consumption to compare current tariffs with proposed ones, estimating potential annual savings and monthly differences. Also track home-efficiency projects with cost, savings, and payback estimates. **ANNUAL REVIEW:** Review annual and seasonal trends for electricity, gas, water, EV charging, solar, net utility cost, and recurring household bills. **HOW IT WORKS:** Simply input your meter readings, tariff details, and household bill information into the spreadsheet. The interconnected worksheets will automatically calculate usage, costs, and provide visual insights into your spending patterns. **DIGITAL DOWNLOAD:** This is a digital product. No physical item will be shipped. Files are provided in XLSX format for use with Excel or imported into Google Sheets. No macros, VBA, or Power Query are required. **IMPORTANT NOTES:** - This spreadsheet does not automatically connect to smart meters, energy suppliers, banking apps, or utility APIs. All data must be entered manually. - Supplier names, tariff rates, and sample bills shown are for demonstration purposes only. - For personal use by the original purchaser only. Files may not be resold, redistributed, shared, or uploaded to template libraries. - This workbook is an organisational and budgeting tool. It does not provide financial, energy, or tariff advice and does not guarantee savings. Always check current supplier terms before making changes.