Google spreadsheet will calculate for you how much to pay according to the counters

2024 Author: Malcolm Clapton | [email protected]. Last modified: 2023-12-17 03:44

Just enter your rates and meter readings into the table and get the amount you need to pay for utilities.

Previously, my wife and I kept a record of the meter readings in a notebook. Everything had to be counted manually. It takes time, albeit a little. Plus, the human factor appears - you can make a mistake in the calculations.

To eliminate this, we made a table that calculates utility costs itself. You need to enter tariffs and current meter readings into it. She will calculate the rest for you. Save it for yourself and use it to your health.

How to use the table

1. To start using the table, follow the link and select the "Create a copy" item from the "File" menu.
2. Enter your rates for hot and cold water, sanitation, electricity and gas. Tariffs can be registered once and last for all months. If the rates increase in price, just write the new value and drag it across the entire column again.
3. Enter meter readings in the “Fact” columns every month. Example: on the hot water meter we see the number 200 - we enter it into the table. The rest follows the same principle.
4. The wastewater disposal does not have a column "Actual", because this indicator is calculated automatically. Wastewater disposal is the total spent liters of hot and cold water. The table itself adds up this data and multiplies it by the tariff.
5. After you have entered the rates and readings, the table will calculate how much you need to pay according to the meters this month. You will see the amounts for each service and the total amount as a whole.

With the help of the table, you can not count utility costs manually and stop keeping a notebook with meter readings. Surely I was not the first to make such a table. If you can advise in the comments how you can improve this template, I will be very happy to read it.:)