{"product_id":"utility-bill-energy-usage-tracker","title":"Utility Bill and Energy Use Tracker Spreadsheet","description":"\u003cp\u003eThis utility bill tracker is for households that want to see what they actually use, not only what they are charged. You type each meter reading, and the workbook works out the usage between that reading and the last one from the same meter.\u003c\/p\u003e\u003cp\u003eA single reading tells you very little. The useful number is the difference between two of them, and that is what this file is built around.\u003c\/p\u003e\u003cp\u003e\u003cstrong\u003ePlease read:\u003c\/strong\u003e This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).\u003c\/p\u003e\u003ch2\u003eWhat the readings tab does\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eUsage between readings:\u003c\/strong\u003e each reading is matched to the previous one from the same meter and subtracted, using formulas that open in Excel 2016 and in Google Sheets\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eUnit rate and standing charge per reading:\u003c\/strong\u003e when the price changes mid-year, older rows still show what you were paying at the time\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eElectricity and gas split:\u003c\/strong\u003e two meters on one list, totaled separately, because they move in opposite directions over a year\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eThe bill and the date you paid it\u003c\/strong\u003e on every row\u003c\/li\u003e\n\u003cli\u003eRoom for 300 readings across five fuel types\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eA countdown to the end of your fixed rate\u003c\/h2\u003e\u003cp\u003ePut your tariff end date on Setup and the summary strip counts down the days, turning amber inside sixty days. A fixed deal rolling onto the standard rate is one of the most expensive things that can happen to household energy bills, so this fixed rate reminder is there to give you time to compare and switch.\u003c\/p\u003e\u003ch2\u003eSix connected tabs\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003e\n\u003cstrong\u003eStart Here and Setup:\u003c\/strong\u003e a guided start, your meters and your tariff end date\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eReadings:\u003c\/strong\u003e the meter reading log, with usage worked out\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eBills:\u003c\/strong\u003e the household bills beyond the meters\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eTasks:\u003c\/strong\u003e switching, submitting a reading or chasing a credit\u003c\/li\u003e\n\u003cli\u003e\n\u003cstrong\u003eDashboard:\u003c\/strong\u003e reads every tab, including electricity usage and gas over time\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eTwo years filled in\u003c\/h2\u003e\u003cp\u003eThe worked example holds 48 monthly readings from an electricity meter and a gas meter over two years, with the unit rate and standing charge on every row, the totals split by fuel, and a fixed tariff that ends in 55 days. A blank copy is ready for your own home.\u003c\/p\u003e\u003ch2\u003eWorks with\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eMicrosoft Excel 2016, 2019, 2021 and Microsoft 365, on Windows and Mac, and LibreOffice\u003c\/li\u003e\n\u003cli\u003eGoogle Sheets with a free Google account. The Google Sheets version is a real workbook you make your own copy of, not a PDF with a link in it.\u003c\/li\u003e\n\u003cli\u003eNo dynamic arrays, no macros, no add-ins and no subscription\u003c\/li\u003e\n\u003c\/ul\u003e\u003ch2\u003eWhat you download\u003c\/h2\u003e\u003cul\u003e\n\u003cli\u003eThe Excel workbook filled with a worked example\u003c\/li\u003e\n\u003cli\u003eA blank Excel workbook ready for your own entries\u003c\/li\u003e\n\u003cli\u003eThe instruction guide, which has one-click links to the Google Sheets versions (filled and blank)\u003c\/li\u003e\n\u003cli\u003eThe terms of use as a PDF\u003c\/li\u003e\n\u003c\/ul\u003e\u003cp\u003eYour files are ready to download as soon as payment clears, and the Start Here tab walks you through setup in a few minutes. The template is for personal and business use on your own devices, so please do not share or resell the files. Questions before or after you buy? Use our contact page and we will help.\u003c\/p\u003e\u003ch2\u003eFrequently asked questions\u003c\/h2\u003e\u003ch3\u003eDo I need Excel, or can I use Google Sheets?\u003c\/h3\u003e\u003cp\u003eEither. You download Excel workbooks for Excel 2016 or later on Windows and Mac, and the instruction guide has one-click links to make your own copy in Google Sheets with a free Google account.\u003c\/p\u003e\u003ch3\u003eCan I track electricity and gas together?\u003c\/h3\u003e\u003cp\u003eYes. Both meters go on one list, each reading is matched to the last one from the same meter, and the totals are kept separately.\u003c\/p\u003e\u003ch3\u003eWhat happens when my unit rate changes?\u003c\/h3\u003e\u003cp\u003eThe unit rate and standing charge are recorded on each reading, so older rows keep the price you paid at the time.\u003c\/p\u003e\u003ch3\u003eHow does the tariff reminder work?\u003c\/h3\u003e\u003cp\u003eYou enter the date your fixed tariff ends. The strip counts down the days and turns amber inside sixty days.\u003c\/p\u003e\u003ch3\u003eHow many readings does it hold?\u003c\/h3\u003e\u003cp\u003eThe Readings tab has room for 300 readings across five fuel types.\u003c\/p\u003e","brand":"OPXVIA","offers":[{"title":"Default Title","offer_id":67597870989406,"sku":"OPX-194","price":22.0,"currency_code":"CAD","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0769\/2094\/6782\/files\/utility-bill-energy-usage-tracker-01.jpg?v=1790833033","url":"https:\/\/opxviashop.com\/products\/utility-bill-energy-usage-tracker","provider":"OPXVIA","version":"1.0","type":"link"}