Wrong energy export calculation

Energy
1

Fault only today:

My export (read from P1) is 0,19 kWh (not very sunny today, I know).
I have dynamic tariffs…appr. 0,24 per kW for an hour today

(sensors are good, checked it in DB Browser)

Still the cost calculation says: € 50,06

image

Can I fix this?

2

I narrowed it down:

Export to Excel and the manual math gives: 0,0506€ (factor 1000). How to correct?

3

AI helped:

To add a one-time cost to a specific day in the past (e.g., two days ago), you cannot rely on Home Assistant’s automatic “static price” calculation because it only runs when new energy data is recorded. Modifying the energy (kWh) in the past does not trigger a recalculation of cost.

Since “cost” is not a visible sensor in your standard entity list when using a static price, you must find and edit its hidden Long-Term Statistics record.

  1. Locate the Hidden Cost Sensor

Even when you use a “static price,” Home Assistant creates a hidden internal statistic to store the dollars/euros calculated.

  • Go to Developer Tools > Statistics.
  • Search for a statistic named similarly to your energy sensor but ending in _cost (e.g., sensor.your_energy_meter_cost).
  • If you don’t see it, check for a sensor starting with energy_.

  1. Manually Inject the Money

  2. In the Developer Tools > Statistics list, find that _cost entity.

  3. Click the Adjust Statistic icon (the ramp with an arrow) on the far right.

  4. In the dialog, use the date picker to navigate to two days ago. Pick any hour (e.g., 12:00 PM).

  5. Enter the exact amount of money you want to add to that day in the Adjustment field.

  • Example: Enter 5.00 to add $5.00 to that day’s total.

  1. Click Adjust.

  2. Verify on the Dashboard

Go back to your Energy Dashboard and select the specific date from two days ago. The cost column should now show your manual adjustment alongside any existing calculated costs.

Why this is the only way:
Home Assistant stores cost data in a separate database table (statistics) as a running “sum”. Changing the price in the settings only affects future data. The only way to change what appears on a past day is to manually edit the “sum” value for that specific historical timestamp.

AI-reacties kunnen fout