{"id":2136,"date":"2023-08-30T13:01:43","date_gmt":"2023-08-30T13:01:43","guid":{"rendered":"https:\/\/www.creatingsmarthome.com\/?p=2136"},"modified":"2025-09-05T05:57:46","modified_gmt":"2025-09-05T05:57:46","slug":"home-assistant-hourly-imported-exported-energy-balance-in-solar-automations","status":"publish","type":"post","link":"https:\/\/www.creatingsmarthome.com\/index.php\/2023\/08\/30\/home-assistant-hourly-imported-exported-energy-balance-in-solar-automations\/","title":{"rendered":"Home Assistant: Hourly Imported\/Exported Energy Balance in Solar Automations"},"content":{"rendered":"\n

In Finland we have this so called energy balance (“tuntinetotus<\/em>“) meaning that sold and bought energy are being summed up every hour (or 15 minutes, depending of the electrical company) before adding up to the electricity bill. So, if you are consuming much less energy than producing in a one hour, the rest of the energy will be sold to the energy company. However, to get most use of the self produced energy, as much as possible ‘should<\/em>‘ be consumed yourself.*<\/strong><\/em><\/p>\n\n\n\n

An example<\/strong>: you are producing 1kWh of energy in the first 30 minutes and not consuming any. Then using 1kWh in the next 30min within the same hour and not producing any, total cost of the energy will be 0\u20ac. Without energy balance<\/strong>, you would first selling 1kWh and then buying back 1kWh and thus paying the transfer costs of the bought back energy.<\/p>\n\n\n\n

This got me thinking that I would like to get realtime information of the energy balance of the current hour so I could run automations or manually trigger devices with excess balanced energy. E.g. every half an hour I check the current balance and run water heater the rest of the hour, if the balance is negative enough<\/em>. Target is always to have 0 kWh balance at the end of each hour.<\/p>\n\n\n\n

* Of course sometimes it’s better to sell product electricity instead of using yourself for a better profit, but this automation does not take that into consideration<\/sup><\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Requirements<\/h2>\n\n\n\n

For this helper a local energy production<\/strong> is required (obviously) and a Home Assistant integrated device that can read your consumed and sold energy<\/strong> in real time. <\/p>\n\n\n\n

In my house I got 8.6kWp Solar system with Growatt Inverter and EM340 ModBus energy meter*<\/em> where I can get realtime data of imported and exported energy. <\/p>\n\n\n\n

* Guide coming later up, how to integrate WallBox Pulsar Plus + EM340 PowerBoost to Home Assistant for realtime energy information. <\/sup><\/p>\n\n\n\n

Setting up the Home Assistant utility meters<\/h2>\n\n\n\n

So, for starters we are going to create two utility meters that cycles every hour: one for import and one for export.<\/p>\n\n\n\n

utility_meter:\n  hourly_energy_in_kwh:\n    name: Hourly Energy In\n    source: sensor.energy_total_in\n    cycle: hourly\n  hourly_energy_out_kwh:\n    name: Hourly Energy Out\n    source: sensor.energy_total_out\n    cycle: hourly<\/code><\/pre>\n\n\n\n
Those two entities can now be used to check how much energy were imported and exported every hour.<\/p>\n\n\n\n
Creating template energy balance entity<\/h2>\n\n\n\n
Next step is just to sum those up so we get the total balance that is updated realtime.<\/p>\n\n\n\n
template:\n  - sensor:\n    - name: \"Energy balance current hour\"\n      unique_id: energy_balance_current_hour\n      device_class: energy\n      unit_of_measurement: kWh\n      state: >\n        {{ ((states('sensor.hourly_energy_in') | float) - (states('sensor.hourly_energy_out') | float)) | round(2) }}<\/code><\/pre>\n\n\n\n
That’s it! The energy balance is now visible!<\/p>\n\n\n\n
\"\"<\/figure>\n\n\n\n
The automation<\/h2>\n\n\n\n
Here’s an example automation how I turn on my water heater for 30 minutes, if I have enough excess solar energy from the first half an hour. My water heater is using 3000 watts of power while heating, so 30 minute heating requires 1500kWh of energy. So when ever I have 1.5 kWh of excess energy on 30 minute mark, I can turn on water heater for next 30 minutes for ‘free’. Here’s an example automation how I’m currently using it:<\/p>\n\n\n\n
alias: \"Energy: Water Boiler on excess solar balance\"\ndescription: >-\n  Turns on water boiler for 30 minutes when solar balance exceeds 1.5kwh on 30th\n  minute\ntrigger:\n  - platform: time_pattern\n    minutes: \"30\"\ncondition:\n  - condition: numeric_state\n    entity_id: sensor.energy_balance_current_hour\n    above: 1.5\naction:\n  - service: switch.turn_on\n    data: {}\n    target:\n      entity_id: switch.water_boiler\n  - delay:\n      hours: 0\n      minutes: 30\n      seconds: 0\n      milliseconds: 0\n  - service: switch.turn_off\n    data: {}\n    target:\n      entity_id: switch.water_boiler\nmode: single<\/code><\/pre>\n\n\n\n
Conclusion<\/h2>\n\n\n\n
Of course this automation is not perfect, since I’m still getting more and more energy if the sun is shining so I still end up more energy sold than used within an hour hour. Once I manage to automate my water heater system fully I’m going to change this automation to use something else..<\/p>\n\n\n\n
Anyhow, simple combination of utility meters and a template sensor to do the full job. Now we are able to get realtime information of current energy balance and run automations regarding it. Should improve my total energy management by an inch at least if nothing else \ud83d\ude42<\/p>\n\n\n\n
\n\n\n
\n
Did you find this guide helpful? You can keep the blog going by bidding me a coffee!<\/h5>\r\n
\r\n